Convert all index

最新推荐文章于 2025-01-19 18:19:48 发布

原创最新推荐文章于 2025-01-19 18:19:48 发布 · 132 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL

本文详细介绍了如何使用特定的脚本将Oracle数据库中的索引转换为HSQL数据库，并同步数据，包括创建索引、数据迁移过程及关键步骤。

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.getTableName(),
allIndex.getString("index_name"), true);
} else {
theSql = getCreateIndexStmt(oraConn, record.getTableName(),
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;
}
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);

}

data.close();
oraStmt.close();

}