/* Copyright (c) 2001-2011, 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.
*/
package org.hsqldb.util;
import java.sql.
ResultSet;
import java.sql.
ResultSetMetaData;
import java.sql.
SQLException;
// brian.porter@siteforce.de 20020703 - make sure date is loaded in the required format
// Stephan Frind 20040508 - improvements
/**
* Conversions from Oracle databases
*
* @author Nichola Bazin
* @version 1.7.0
*/
class
OracleTransferHelper extends
TransferHelper {
private final int
ORACLE = 0;
private final int
HSQLDB = 1;
String[][]
Funcs = {
{
"now()", "\'now\'"
}
};
OracleTransferHelper() {
super();
System.
out.
println("simple init of OracleTransferHelper");
}
OracleTransferHelper(
TransferDb database,
Traceable t,
String q) {
super(
database,
t,
q);
}
void set(
TransferDb database,
Traceable t,
String q) {
super.
set(
database,
t,
q);
// set the Dateformat for our connection
String dateFormatStmnt =
"ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'";
System.
out.
println("dateFormatStmnt: " +
dateFormatStmnt);
try {
tracer.
trace("Executing " +
dateFormatStmnt);
database.
execute(
dateFormatStmnt);
} catch (
Exception e) {
tracer.
trace("Ignoring error " +
e.
getMessage());
System.
out.
println("Ignoring error " +
e.
getMessage());
}
}
String fixupColumnDefRead(
TransferTable t,
ResultSetMetaData meta,
String columnType,
ResultSet columnDesc,
int
columnIndex) throws
SQLException {
return
fixupColumnDefRead(
t.
Stmts.
sDestTable,
meta,
columnType,
columnDesc,
columnIndex);
}
String fixupColumnDefWrite(
TransferTable t,
ResultSetMetaData meta,
String columnType,
ResultSet columnDesc,
int
columnIndex) throws
SQLException {
if (
columnType.
equals("SERIAL")) {
String SeqName = new
String("_" +
columnDesc.
getString(4)
+ "_seq");
int
spaceleft = 31 -
SeqName.
length();
if (
t.
Stmts.
sDestTable.
length() >
spaceleft) {
SeqName =
t.
Stmts.
sDestTable.
substring(0,
spaceleft)
+
SeqName;
} else {
SeqName =
t.
Stmts.
sDestTable +
SeqName;
}
String DropSequence = "DROP SEQUENCE " +
SeqName + ";";
t.
Stmts.
sDestDrop +=
DropSequence;
}
for (int
Idx = 0;
Idx <
Funcs.length;
Idx++) {
String HSQLDB_func =
Funcs[
Idx][
HSQLDB];
int
iStartPos =
columnType.
indexOf(
HSQLDB_func);
if (
iStartPos >= 0) {
String NewColumnType =
columnType.
substring(0,
iStartPos);
NewColumnType +=
Funcs[
Idx][
ORACLE];
NewColumnType +=
columnType.
substring(
iStartPos
+
HSQLDB_func.
length());
columnType =
NewColumnType;
}
}
return (
columnType);
}
void
beginDataTransfer() {
try {
db.
setAutoCommit(false);
} catch (
Exception e) {}
}
void
endDataTransfer() {
try {
db.
commit();
} catch (
Exception e) {}
}
String fixupColumnDefRead(
String aTableName,
ResultSetMetaData meta,
String columnType,
ResultSet columnDesc,
int
columnIndex) throws
SQLException {
String SeqName = new
String("_" +
columnDesc.
getString(4) + "_seq");
int
spaceleft = 31 -
SeqName.
length();
if (
aTableName.
length() >
spaceleft) {
SeqName =
aTableName.
substring(0,
spaceleft) +
SeqName;
} else {
SeqName =
aTableName +
SeqName;
}
String CompareString = "nextval(\'\"" +
SeqName + "\"\'";
if (
columnType.
indexOf(
CompareString) >= 0) {
// We just found a increment
columnType = "SERIAL";
}
for (int
Idx = 0;
Idx <
Funcs.length;
Idx++) {
String ORACLE_func =
Funcs[
Idx][
ORACLE];
int
iStartPos =
columnType.
indexOf(
ORACLE_func);
if (
iStartPos >= 0) {
String NewColumnType =
columnType.
substring(0,
iStartPos);
NewColumnType +=
Funcs[
Idx][
HSQLDB];
NewColumnType +=
columnType.
substring(
iStartPos
+
ORACLE_func.
length());
columnType =
NewColumnType;
}
}
return (
columnType);
}
}