private void convertIndex(Connection oraConn, Connection hsqlConn,
SqlRecord record) throws Exception
{
// 创建索引
Statement oraStmt = oraConn.createStatement();
ResultSet allIndex = oraStmt
.executeQuery("select index_name, uniqueness from user_indexes where table_name ='"
+ record.getTableName() + "'");
while (allIndex.next())
{
String theSql = null;
if (allIndex.getString("index_name").equals("UNIQUE"))
{
theSql = getCreateIndexStmt(oraConn, record, allIndex
.getString("index_name"), true);
} else
{
theSql = getCreateIndexStmt(oraConn, record, allIndex
.getString("index_name"), false);
}
Statement hsqlStmt = hsqlConn.createStatement();
if (theSql != null)
{
// System.out.println(user+" :: "+theSql);
System.out.println("index create :" + theSql);
hsqlStmt.execute(theSql);
hsqlStmt.close();
}
// break;
hsqlStmt.close();
}
allIndex.close();
oraStmt.close();
}
private void convertData(Connection oraConn, Connection hsqlConn,
SqlRecord record) throws Exception
{
// System.out.println(record.getSql());
Statement oraStmt = oraConn.createStatement();
ResultSet data = oraStmt.executeQuery(record.getSql());
Statement hsqlStmt = hsqlConn.createStatement();
while (data.next())
{
String insertSql = getDataInsertSql(record.getTableName(), data);
// System.out.println("data transform sql : " + insertSql);
hsqlStmt.execute(insertSql);
}
hsqlStmt.close();
data.close();
oraStmt.close();
}
SqlRecord record) throws Exception
{
// 创建索引
Statement oraStmt = oraConn.createStatement();
ResultSet allIndex = oraStmt
.executeQuery("select index_name, uniqueness from user_indexes where table_name ='"
+ record.getTableName() + "'");
while (allIndex.next())
{
String theSql = null;
if (allIndex.getString("index_name").equals("UNIQUE"))
{
theSql = getCreateIndexStmt(oraConn, record, allIndex
.getString("index_name"), true);
} else
{
theSql = getCreateIndexStmt(oraConn, record, allIndex
.getString("index_name"), false);
}
Statement hsqlStmt = hsqlConn.createStatement();
if (theSql != null)
{
// System.out.println(user+" :: "+theSql);
System.out.println("index create :" + theSql);
hsqlStmt.execute(theSql);
hsqlStmt.close();
}
// break;
hsqlStmt.close();
}
allIndex.close();
oraStmt.close();
}
private void convertData(Connection oraConn, Connection hsqlConn,
SqlRecord record) throws Exception
{
// System.out.println(record.getSql());
Statement oraStmt = oraConn.createStatement();
ResultSet data = oraStmt.executeQuery(record.getSql());
Statement hsqlStmt = hsqlConn.createStatement();
while (data.next())
{
String insertSql = getDataInsertSql(record.getTableName(), data);
// System.out.println("data transform sql : " + insertSql);
hsqlStmt.execute(insertSql);
}
hsqlStmt.close();
data.close();
oraStmt.close();
}