String getMetadataSchema(JDBCDataStore store) { if (tableSchema != null) return tableSchema; return store.getDatabaseSchema(); } }
@Override public boolean includeTable(String schemaName, String tableName, Connection cx) throws SQLException { if (tableName.equalsIgnoreCase("geometry_columns")) { return false; } else if (tableName.toLowerCase().startsWith("spatial_ref_sys")) { return false; } else if (tableName.equalsIgnoreCase("geography_columns")) { return false; } else if (tableName.equalsIgnoreCase("tessellation")) { return false; } else if (tableName.endsWith("_idx")) { return false; } // others? return dataStore.getDatabaseSchema() == null || dataStore.getDatabaseSchema().equals(schemaName); }
String schema = dataStore.getDatabaseSchema(); String sql = "SELECT SRID FROM " ? "" : "F_TABLE_SCHEMA = '" + dataStore.getDatabaseSchema() + "' AND ") + "F_TABLE_NAME = '"
String schema = dataStore.getDatabaseSchema(); String sql = "SELECT COORD_DIMENSION FROM " ? "" : "F_TABLE_SCHEMA = '" + dataStore.getDatabaseSchema() + "' AND ") + "F_TABLE_NAME = '"
ResultSet result = null; try { String schema = dataStore.getDatabaseSchema(); String sqlStatement = "SELECT TYPE FROM " ? "" : "F_TABLE_SCHEMA = '" + dataStore.getDatabaseSchema() + "' AND ") + "F_TABLE_NAME = '"
String schema = dataStore.getDatabaseSchema(); if (schema == null) { fromStatement = "FROM \"" + typeName + "\"";
@Override public Class<?> getMapping(ResultSet columnMetaData, Connection cx) throws SQLException { final int TABLE_NAME = 3; final int COLUMN_NAME = 4; final int TYPE_NAME = 6; String typeName = columnMetaData.getString(TYPE_NAME); if (typeName.equals("SDO_GEOMETRY")) { String tableName = columnMetaData.getString(TABLE_NAME); String columnName = columnMetaData.getString(COLUMN_NAME); String schema = dataStore.getDatabaseSchema(); Class geometryClass = lookupGeometryOnMetadataTable(cx, tableName, columnName, schema); if (geometryClass == null) { lookupGeometryClassOnUserIndex(cx, tableName, columnName, schema); } if (geometryClass == null) { geometryClass = lookupGeometryClassOnAllIndex(cx, tableName, columnName, schema); } if (geometryClass == null) { geometryClass = Geometry.class; } return geometryClass; } else { // if we know, return non null value, otherwise returning // null will force the datatore to figure it out using // jdbc metadata return TYPES_TO_CLASSES.get(typeName); } }
/** Helper method that encode a column name. */ private void encodeColumnName(StringBuffer sql, String tableName, String columnName) { JDBCDataStore dataStore = getDataStore(); SQLDialect dialect = dataStore.getSQLDialect(); String schema = dataStore.getDatabaseSchema(); if (schema != null) { dialect.encodeSchemaName(schema, sql); sql.append("."); } dialect.encodeColumnName(tableName, columnName, sql); }
@Override public Object getLastValue(Connection cx, Statement st) throws SQLException { return ds.getSQLDialect() .getLastAutoGeneratedValue( ds.getDatabaseSchema(), key.getTableName(), col.getName(), cx, st); }
@Override public Object getNext(Connection cx) throws IOException, SQLException { if (isPostInsert()) { return NOT_SET_BEFORE_INSERT; } else { String sequenceName = ((SequencedPrimaryKeyColumn) col).getSequenceName(); return ds.getSQLDialect() .getNextSequenceValue(ds.getDatabaseSchema(), sequenceName, cx); } } }
@Override public Object getNext(Connection cx) throws IOException, SQLException { if (isPostInsert()) { return NOT_SET_BEFORE_INSERT; } else { return ds.getSQLDialect() .getNextAutoGeneratedValue( ds.getDatabaseSchema(), key.getTableName(), col.getName(), cx); } }
ps.close(); if (dataStore.getDatabaseSchema() == null) { ps = con.prepareStatement(GetCurrentSchema); rs = ps.executeQuery();
if (dataStore.getDatabaseSchema() != null) { dataStore.setDatabaseSchema(dataStore.getDatabaseSchema().toUpperCase());
String getMetadataSchema(JDBCDataStore store) { if(tableSchema != null) return tableSchema; return store.getDatabaseSchema(); }
sql.append("SELECT * FROM "); if (dataStore.getDatabaseSchema() != null) { dataStore.getSQLDialect().encodeSchemaName(dataStore.getDatabaseSchema(), sql); sql.append(".");
String databaseSchema = getDataStore().getDatabaseSchema();
public Integer getGeometrySRIDfromMetadataTable(String schemaName, String tableName, String columnName, Connection cx) throws SQLException { if(geometryMetadataTable == null) { return null; } Statement statement = null; ResultSet result = null; try { String schema = dataStore.getDatabaseSchema(); String sql = "SELECT SRID FROM " + geometryMetadataTable + " WHERE " // + (schema == null ? "" : "F_TABLE_SCHEMA = '" + dataStore.getDatabaseSchema() + "' AND ") + "F_TABLE_NAME = '" + tableName + "' ";// LOGGER.log(Level.FINE, "Geometry type check; {0} ", sql); statement = cx.createStatement(); result = statement.executeQuery(sql); if (result.next()) { return result.getInt(1); } } finally { dataStore.closeSafe(result); dataStore.closeSafe(statement); } return null; }
ResultSet result = null; try { String schema = dataStore.getDatabaseSchema(); String sqlStatement = "SELECT TYPE FROM " + gTableName + " WHERE " // + (schema == null ? "" : "F_TABLE_SCHEMA = '" + dataStore.getDatabaseSchema() + "' AND ") + "F_TABLE_NAME = '" + tableName + "' " // + "AND " + gColumnName + " = '" + columnName + "'";
di.setProductName(md.getDatabaseProductName()); di.setProductVersion(md.getDatabaseProductVersion()); if (dataStore.getDatabaseSchema()==null) { PreparedStatement ps = con.prepareStatement(GetCurrentSchema); ResultSet rs = ps.executeQuery();
final String dbSchema = delegate.getDatabaseSchema();