org.hsqldb.util.TransferTable Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of hsqldb Show documentation
Show all versions of hsqldb Show documentation
HSQLDB - Lightweight 100% Java SQL Database Engine
/*
* For work developed by the HSQL Development Group:
*
* Copyright (c) 2001-2021, The HSQL Development Group
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* Neither the name of the HSQL Development Group nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
* OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*
*
*
* For work originally developed by the Hypersonic SQL Group:
*
* Copyright (c) 1995-2000, The Hypersonic SQL Group.
* All rights reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are met:
*
* Redistributions of source code must retain the above copyright notice, this
* list of conditions and the following disclaimer.
*
* Redistributions in binary form must reproduce the above copyright notice,
* this list of conditions and the following disclaimer in the documentation
* and/or other materials provided with the distribution.
*
* Neither the name of the Hypersonic SQL Group nor the names of its
* contributors may be used to endorse or promote products derived from this
* software without specific prior written permission.
*
* THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
* AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
* IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
* ARE DISCLAIMED. IN NO EVENT SHALL THE HYPERSONIC SQL GROUP,
* OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
* EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
* PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
* LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
* ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
* (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
* SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*
* This software consists of voluntary contributions made by many individuals
* on behalf of the Hypersonic SQL Group.
*/
package org.hsqldb.util;
import java.io.Serializable;
import java.sql.SQLException;
import java.util.Hashtable;
// fredt@users 20011220 - patch 481239 by xponsard@users - enhancements
// enhancements to support saving and loading of transfer settings,
// transfer of blobs, and catalog and schema names in source db
// changes by fredt to allow saving and loading of transfer settings
// fredt@users 20020215 - patch 516309 by Nicolas Bazin - enhancements
// sqlbob@users 20020325 - patch 1.7.0 - reengineering
// fredt@users 20040508 - patch 1.7.2 - bug fixes
/**
* Transfers data from one database to another
*
* @author Thomas Mueller (Hypersonic SQL Group)
* @version 1.7.2
* @since Hypersonic SQL
*/
class TransferTable implements Serializable {
Hashtable hTypes;
DataAccessPoint sourceDb;
DataAccessPoint destDb;
SQLStatements Stmts = null;
Traceable tracer;
TransferTable(DataAccessPoint src, String name, String schema,
String type, Traceable t) {
Stmts = new SQLStatements();
sourceDb = src;
Stmts.sSchema = "";
if (schema != null && schema.length() > 0) {
Stmts.sSchema = schema;
}
Stmts.sType = type;
Stmts.sDatabaseToConvert = src.databaseToConvert;
Stmts.sSourceTable = Stmts.sDestTable = name;
tracer = t;
if (Stmts.sType.compareTo("TABLE") == 0) {
Stmts.sSourceSelect = "SELECT * FROM "
+ src.helper.formatName(Stmts.sSourceTable);
} else if (Stmts.sType.compareTo("VIEW") == 0) {
Stmts.sSourceSelect = "";
}
}
void setDest(String _Schema, DataAccessPoint dest) {
destDb = dest;
dest.helper.setSchema(_Schema);
}
/**
* extractTableStructure
*/
void extractTableStructure(DataAccessPoint Source,
DataAccessPoint Destination) throws Exception {
initTypes();
Source.getTableStructure(this, Destination);
}
void transferStructure() throws Exception {
String Statement = "";
if (destDb.helper.needTransferTransaction()) {
try {
destDb.setAutoCommit(false);
} catch (Exception e) {}
}
if (Stmts.bTransfer == false) {
tracer.trace("Table " + Stmts.sSourceTable + " not transfered");
return;
}
tracer.trace("Table " + Stmts.sSourceTable + ": start transfer");
try {
if (Stmts.bDropIndex) {
if (Stmts.sDestDropIndex.charAt(Stmts.sDestDropIndex.length()
- 1) != ';') {
Stmts.sDestDropIndex += ";";
}
int lastsemicolon = 0;
int nextsemicolon = Stmts.sDestDropIndex.indexOf(';');
while (nextsemicolon > lastsemicolon) {
Statement = Stmts.sDestDropIndex.substring(lastsemicolon,
nextsemicolon);
while (Statement.charAt(Statement.length() - 1) == ';') {
Statement = Statement.substring(0, Statement.length()
- 1);
}
try {
tracer.trace("Executing " + Statement);
destDb.execute(Statement);
} catch (Exception e) {
tracer.trace("Ignoring error " + e.getMessage());
}
lastsemicolon = nextsemicolon + 1;
nextsemicolon = lastsemicolon
+ Stmts.sDestDropIndex.substring(
lastsemicolon).indexOf(';');
}
}
if (Stmts.bDelete) {
if (Stmts.sDestDelete.charAt(Stmts.sDestDelete.length() - 1)
!= ';') {
Stmts.sDestDelete += ";";
}
int lastsemicolon = 0;
int nextsemicolon = Stmts.sDestDelete.indexOf(';');
while (nextsemicolon > lastsemicolon) {
Statement = Stmts.sDestDelete.substring(lastsemicolon,
nextsemicolon);
while (Statement.charAt(Statement.length() - 1) == ';') {
Statement = Statement.substring(0, Statement.length()
- 1);
}
try {
tracer.trace("Executing " + Statement);
destDb.execute(Statement);
} catch (Exception e) {
tracer.trace("Ignoring error " + e.getMessage());
}
lastsemicolon = nextsemicolon + 1;
nextsemicolon = lastsemicolon
+ Stmts.sDestDelete.substring(
lastsemicolon).indexOf(';');
}
}
if (Stmts.bDrop) {
if (Stmts.sDestDrop.charAt(Stmts.sDestDrop.length() - 1)
!= ';') {
Stmts.sDestDrop += ";";
}
int lastsemicolon = 0;
int nextsemicolon = Stmts.sDestDrop.indexOf(';');
while (nextsemicolon > lastsemicolon) {
Statement = Stmts.sDestDrop.substring(lastsemicolon,
nextsemicolon);
while (Statement.charAt(Statement.length() - 1) == ';') {
Statement = Statement.substring(0, Statement.length()
- 1);
}
try {
tracer.trace("Executing " + Statement);
destDb.execute(Statement);
} catch (Exception e) {
tracer.trace("Ignoring error " + e.getMessage());
}
lastsemicolon = nextsemicolon + 1;
nextsemicolon = lastsemicolon
+ Stmts.sDestDrop.substring(
lastsemicolon).indexOf(';');
}
}
if (Stmts.bCreate) {
if (Stmts.sDestCreate.charAt(Stmts.sDestCreate.length() - 1)
!= ';') {
Stmts.sDestCreate += ";";
}
int lastsemicolon = 0;
int nextsemicolon = Stmts.sDestCreate.indexOf(';');
while (nextsemicolon > lastsemicolon) {
Statement = Stmts.sDestCreate.substring(lastsemicolon,
nextsemicolon);
while (Statement.charAt(Statement.length() - 1) == ';') {
Statement = Statement.substring(0, Statement.length()
- 1);
}
tracer.trace("Executing " + Statement);
destDb.execute(Statement);
lastsemicolon = nextsemicolon + 1;
nextsemicolon = lastsemicolon
+ Stmts.sDestCreate.substring(
lastsemicolon).indexOf(';');
}
}
} catch (Exception e) {
try {
if (!destDb.getAutoCommit()) {
destDb.rollback();
}
} catch (Exception e1) {}
throw (e);
}
if (!destDb.getAutoCommit()) {
destDb.commit();
try {
destDb.setAutoCommit(true);
} catch (Exception e) {}
}
}
void transferData(int iMaxRows) throws Exception {
if (destDb.helper.needTransferTransaction()) {
try {
destDb.setAutoCommit(false);
} catch (Exception e) {}
}
try {
if (Stmts.bInsert) {
if (destDb.helper.needTransferTransaction()) {
try {
destDb.setAutoCommit(false);
} catch (Exception e) {}
}
tracer.trace("Executing " + Stmts.sSourceSelect);
TransferResultSet r = sourceDb.getData(Stmts.sSourceSelect);
tracer.trace("Start transfering data...");
destDb.beginDataTransfer();
tracer.trace("Executing " + Stmts.sDestInsert);
destDb.putData(Stmts.sDestInsert, r, iMaxRows);
destDb.endDataTransfer();
tracer.trace("Finished");
if (!destDb.getAutoCommit()) {
destDb.commit();
try {
destDb.setAutoCommit(true);
} catch (Exception e) {}
}
}
} catch (Exception e) {
try {
if (!destDb.getAutoCommit()) {
destDb.rollback();
}
} catch (Exception e1) {}
throw (e);
}
if (!destDb.getAutoCommit()) {
destDb.commit();
try {
destDb.setAutoCommit(true);
} catch (Exception e) {}
}
}
void transferAlter() throws Exception {
String Statement = "";
if (destDb.helper.needTransferTransaction()) {
try {
destDb.setAutoCommit(false);
} catch (Exception e) {}
}
if (Stmts.bTransfer == false) {
tracer.trace("Table " + Stmts.sSourceTable + " not transfered");
return;
}
tracer.trace("Table " + Stmts.sSourceTable + ": start alter");
try {
if (Stmts.bCreateIndex) {
if (Stmts.sDestCreateIndex.charAt(
Stmts.sDestCreateIndex.length() - 1) != ';') {
Stmts.sDestCreateIndex += ";";
}
int lastsemicolon = 0;
int nextsemicolon = Stmts.sDestCreateIndex.indexOf(';');
while (nextsemicolon > lastsemicolon) {
Statement = Stmts.sDestCreateIndex.substring(lastsemicolon,
nextsemicolon);
while (Statement.charAt(Statement.length() - 1) == ';') {
Statement = Statement.substring(0, Statement.length()
- 1);
}
try {
tracer.trace("Executing " + Stmts.sDestCreateIndex);
destDb.execute(Statement);
} catch (Exception e) {
tracer.trace("Ignoring error " + e.getMessage());
}
lastsemicolon = nextsemicolon + 1;
nextsemicolon = lastsemicolon
+ Stmts.sDestCreateIndex.substring(
lastsemicolon).indexOf(';');
}
}
if (Stmts.bAlter) {
if (Stmts.sDestAlter.charAt(Stmts.sDestAlter.length() - 1)
!= ';') {
Stmts.sDestAlter += ";";
}
int lastsemicolon = 0;
int nextsemicolon = Stmts.sDestAlter.indexOf(';');
while (nextsemicolon > lastsemicolon) {
Statement = Stmts.sDestAlter.substring(lastsemicolon,
nextsemicolon);
while (Statement.charAt(Statement.length() - 1) == ';') {
Statement = Statement.substring(0, Statement.length()
- 1);
}
try {
tracer.trace("Executing " + Statement);
destDb.execute(Statement);
} catch (Exception e) {
tracer.trace("Ignoring error " + e.getMessage());
}
lastsemicolon = nextsemicolon + 1;
nextsemicolon = lastsemicolon
+ Stmts.sDestAlter.substring(
lastsemicolon).indexOf(';');
}
}
} catch (Exception e) {
try {
if (!destDb.getAutoCommit()) {
destDb.rollback();
}
} catch (Exception e1) {}
throw (e);
}
if (!destDb.getAutoCommit()) {
destDb.commit();
try {
destDb.setAutoCommit(true);
} catch (Exception e) {}
}
}
private void initTypes() {
if (hTypes != null) {
return;
}
hTypes = destDb.helper.getSupportedTypes();
}
}
© 2015 - 2024 Weber Informatics LLC | Privacy Policy