public boolean isStoresMixedCaseQuotedIdentifiers() { return execute(new IConnectionCallback<Boolean>() { public Boolean execute(Connection con) throws SQLException { return con.getMetaData().storesMixedCaseQuotedIdentifiers(); } }); }
public void testConnection() { execute(new IConnectionCallback<Boolean>() { public Boolean execute(Connection con) throws SQLException { return true; } }); }
public boolean isStoresUpperCaseIdentifiers() { return execute(new IConnectionCallback<Boolean>() { public Boolean execute(Connection con) throws SQLException { return con.getMetaData().storesUpperCaseIdentifiers(); } }); }
public boolean isStoresLowerCaseIdentifiers() { return execute(new IConnectionCallback<Boolean>() { public Boolean execute(Connection con) throws SQLException { return con.getMetaData().storesLowerCaseIdentifiers(); } }); }
public long insertWithGeneratedKey(final String sql, final String column, final String sequenceName, final Object[] args, final int[] types) { return execute(new IConnectionCallback<Long>() { public Long execute(Connection conn) throws SQLException { return insertWithGeneratedKey(conn, sql, column, sequenceName, args, types); } }); }
public String getDatabaseProductName() { return execute(new IConnectionCallback<String>() { public String execute(Connection con) throws SQLException { return con.getMetaData().getDatabaseProductName(); } }); }
public String getDatabaseProductVersion() { return execute(new IConnectionCallback<String>() { public String execute(Connection con) throws SQLException { return con.getMetaData().getDatabaseProductVersion(); } }); }
public String getDriverName() { return execute(new IConnectionCallback<String>() { public String execute(Connection con) throws SQLException { return con.getMetaData().getDriverName(); } }); }
public int getDatabaseMajorVersion() { return execute(new IConnectionCallback<Integer>() { public Integer execute(Connection con) throws SQLException { return con.getMetaData().getDatabaseMajorVersion(); } }); }
public int getDatabaseMinorVersion() { return execute(new IConnectionCallback<Integer>() { public Integer execute(Connection con) throws SQLException { return con.getMetaData().getDatabaseMinorVersion(); } }); }
public String getDriverVersion() { return execute(new IConnectionCallback<String>() { public String execute(Connection con) throws SQLException { return con.getMetaData().getDriverVersion(); } }); }
public Set<String> getSqlKeywords() { return execute(new IConnectionCallback<Set<String>>() { public Set<String> execute(Connection con) throws SQLException { DatabaseMetaData sqlTemplateData = con.getMetaData(); return new HashSet<String>(Arrays.asList(sqlTemplateData.getSQLKeywords() .split(","))); } }); }
public boolean supportsGetGeneratedKeys() { if (supportsGetGeneratedKeys == null) { supportsGetGeneratedKeys = execute(new IConnectionCallback<Boolean>() { public Boolean execute(Connection con) throws SQLException { return con.getMetaData().supportsGetGeneratedKeys(); } }); } return supportsGetGeneratedKeys; }
public List<String> getCatalogNames() { JdbcSqlTemplate sqlTemplate = (JdbcSqlTemplate) platform.getSqlTemplate(); return sqlTemplate.execute(new IConnectionCallback<List<String>>() { public List<String> execute(Connection connection) throws SQLException { ArrayList<String> catalogs = new ArrayList<String>(); DatabaseMetaData meta = connection.getMetaData(); ResultSet rs = null; try { rs = meta.getCatalogs(); while (rs.next()) { catalogs.add(rs.getString(1)); } return catalogs; } finally { JdbcSqlTemplate.close(rs); } } }); }
public String queryForClob(final String sql, final Object... args) { logSql(sql, args); return execute(new IConnectionCallback<String>() { public String execute(Connection con) throws SQLException { String result = null; PreparedStatement ps = null; ResultSet rs = null; try { ps = con.prepareStatement(sql); ps.setQueryTimeout(settings.getQueryTimeout()); setValues(ps, args); rs = ps.executeQuery(); if (rs.next()) { result = lobHandler.getClobAsString(rs, 1); } } finally { close(rs); close(ps); } return result; } }); }
public List<String> getTableTypes() { JdbcSqlTemplate sqlTemplate = (JdbcSqlTemplate) platform.getSqlTemplate(); return sqlTemplate.execute(new IConnectionCallback<List<String>>() { public List<String> execute(Connection connection) throws SQLException { ArrayList<String> types = new ArrayList<String>(); DatabaseMetaData meta = connection.getMetaData(); ResultSet rs = null; try { rs = meta.getTableTypes(); while (rs.next()) { types.add(rs.getString(1)); } return types; } finally { JdbcSqlTemplate.close(rs); } } }); }
public <T> T queryForObject(final String sql, final Class<T> clazz, final Object... args) { logSql(sql, args); return execute(new IConnectionCallback<T>() { public T execute(Connection con) throws SQLException { T result = null; PreparedStatement ps = null; ResultSet rs = null; try { ps = con.prepareStatement(expandSql(sql, args)); ps.setQueryTimeout(settings.getQueryTimeout()); setValues(ps, expandArgs(sql, args)); rs = ps.executeQuery(); if (rs.next()) { result = getObjectFromResultSet(rs, clazz); } } finally { close(rs); close(ps); } return result; } }); }
public List<String> getTableNames(final String catalog, final String schema, final String[] tableTypes) { JdbcSqlTemplate sqlTemplate = (JdbcSqlTemplate) platform.getSqlTemplate(); return sqlTemplate.execute(new IConnectionCallback<List<String>>() { public List<String> execute(Connection connection) throws SQLException { ArrayList<String> list = new ArrayList<String>(); DatabaseMetaData meta = connection.getMetaData(); ResultSet rs = null; try { rs = meta.getTables(catalog, schema, null, tableTypes); while (rs.next()) { String tableName = rs.getString("TABLE_NAME"); list.add(tableName); } return list; } finally { close(rs); } } }); }
public List<String> getColumnNames(final String catalog, final String schema, final String tableName) { JdbcSqlTemplate sqlTemplate = (JdbcSqlTemplate) platform.getSqlTemplate(); return sqlTemplate.execute(new IConnectionCallback<List<String>>() { public List<String> execute(Connection connection) throws SQLException { ArrayList<String> list = new ArrayList<String>(); DatabaseMetaData meta = connection.getMetaData(); ResultSet rs = null; try { rs = meta.getColumns(catalog, schema, tableName, null); while (rs.next()) { String tableName = rs.getString("COLUMN_NAME"); list.add(tableName); } return list; } finally { close(rs); } } }); }
public Database readTables(final String catalog, final String schema, final String[] tableTypes) { JdbcSqlTemplate sqlTemplate = (JdbcSqlTemplate) platform.getSqlTemplate(); return postprocessModelFromDatabase(sqlTemplate .execute(new IConnectionCallback<Database>() { public Database execute(Connection connection) throws SQLException { Database db = new Database(); db.setName(Table.getQualifiedTablePrefix(catalog, schema)); db.addTables(readTables(connection, catalog, schema, tableTypes)); db.initialize(); return db; } })); }