| | |
|---|
| | | private void copyConnectivity(OracleConvertPostGISJobContext jobContext) throws SQLException |
|---|
| | | { |
|---|
| | | Connection connection = jobContext.getOracleConnection(); |
|---|
| | | ResultSet rsMeta = connection.getMetaData().getTables(null, "BASEDB", |
|---|
| | | AbstractOracleJobContext.CONNECTIVITY_WEBCHECK_NAME + "%", |
|---|
| | | new String[]{"TABLE"}); |
|---|
| | | |
|---|
| | | boolean found = false; |
|---|
| | | try |
|---|
| | | { |
|---|
| | | while (rsMeta.next()) |
|---|
| | | { |
|---|
| | | String tablename = rsMeta.getString(3); |
|---|
| | | if (AbstractOracleJobContext.CONNECTIVITY_WEBCHECK_NAME.equalsIgnoreCase(tablename)) |
|---|
| | | { |
|---|
| | | found = true; |
|---|
| | | break; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | // } catch (SQLException e) |
|---|
| | | } finally |
|---|
| | | { |
|---|
| | | if (rsMeta != null) |
|---|
| | | { |
|---|
| | | rsMeta.close(); |
|---|
| | | rsMeta = null; |
|---|
| | | } |
|---|
| | | } |
|---|
| | | Statement stmt = connection.createStatement(); |
|---|
| | | if (found) |
|---|
| | | stmt.execute(AbstractOracleJobContext.TRUNCATE_CONNECTIVITY_WEBCHECK); |
|---|
| | | else |
|---|
| | | stmt.execute(AbstractOracleJobContext.CREATE_CONNECTIVITY_WEBCHECK); |
|---|
| | | stmt.execute(AbstractOracleJobContext.COPY_CONNECTIVITY_TO_WEBCHECK); |
|---|
| | | stmt.close(); |
|---|
| | | } |
|---|
