List of usage examples for java.sql Connection getCatalog
String getCatalog() throws SQLException;
Connection object's current catalog name. From source file:Main.java
public static void main(String[] argv) throws Exception { InitialContext init = new InitialContext(); DataSource source = (DataSource) init.lookup("dsn"); Connection connection = source.getConnection(); System.out.println("Connect to " + connection.getCatalog() + " a success!"); }
From source file:Main.java
public static void main(String[] argv) throws Exception { String url = "jdbc:odbc:datasource"; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection connection = DriverManager.getConnection(url); System.out.println("Connect to " + connection.getCatalog() + " a success!"); }
From source file:com.weibo.datasys.parser.sql.DBConnectionFactory.java
public static void main(String[] args) throws SQLException { ConfigFactory.init("conf/config.xml"); init();// w ww .j a va 2 s . co m Connection conn = getConnection(); System.out.println(conn.getCatalog()); }
From source file:Main.java
public static void main(String[] args) throws Exception { String url = "jdbc:odbc:yourDBName"; System.out.println("Attempting to connect to " + url); try {// w ww . j ava2s. c om System.out.println("Loading the driver..."); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); System.out.println("Establishing a connection..."); Connection connection = DriverManager.getConnection(url); System.out.println("Connect to " + connection.getCatalog() + " a success!"); } catch (Exception e) { e.printStackTrace(); } }
From source file:Main.java
public static void main(String[] args) throws Exception { String dsn = args[0];/*from w w w. ja va 2 s .c o m*/ System.out.println("Attempting to connect to " + dsn); try { System.out.println("Initializing the naming context..."); InitialContext init = new InitialContext(); System.out.println("Looking up " + dsn); DataSource source = (DataSource) init.lookup(dsn); System.out.println("Establishing a connection..."); Connection connection = source.getConnection(); System.out.println("Connect to " + connection.getCatalog() + " a success!"); } catch (Exception e) { e.printStackTrace(); } }
From source file:GetColumnPrivilegesOracle.java
public static void main(String[] args) throws Exception { Connection conn = null; conn = getConnection();/*from www .j av a 2 s .c om*/ String catalogPattern = conn.getCatalog(); String schemaPattern = "SYSTEM"; String tableNamePattern = "HELP"; ResultSet privileges = null; DatabaseMetaData meta = conn.getMetaData(); // The '_' character represents any single character. // The '%' character represents any sequence of zero or more characters. privileges = meta.getTablePrivileges(catalogPattern, schemaPattern, tableNamePattern); while (privileges.next()) { String catalog = privileges.getString("TABLE_CAT"); String schema = privileges.getString("TABLE_SCHEM"); String tableName = privileges.getString("TABLE_NAME"); String privilege = privileges.getString("PRIVILEGE"); String grantor = privileges.getString("GRANTOR"); String grantee = privileges.getString("GRANTEE"); String isGrantable = privileges.getString("IS_GRANTABLE"); System.out.println("table name:" + tableName); System.out.println("catalog:" + catalog); System.out.println("schema:" + schema); System.out.println("privilege:" + privilege); System.out.println("grantor:" + grantor); System.out.println("isGrantable:" + isGrantable); System.out.println("grantee:" + grantee); conn.close(); } }
From source file:Main.java
public static void main(String[] args) throws Exception { Connection conn = getConnection(); DatabaseMetaData mtdt = conn.getMetaData(); ResultSet rs = mtdt.getTables(conn.getCatalog(), "%", "%", null); ResultSetMetaData rsmd = rs.getMetaData(); int numCols = rsmd.getColumnCount(); for (int i = 1; i <= numCols; i++) { if (i > 1) System.out.print(", "); System.out.print(rsmd.getColumnLabel(i)); }//from w ww . j av a 2s. c o m System.out.println(""); while (rs.next()) { for (int i = 1; i <= numCols; i++) { if (i > 1) System.out.print(", "); System.out.print(rs.getString(i)); } System.out.println(""); } conn.close(); }
From source file:Main.java
public static void main(String[] args) throws Exception { Connection conn = getConnection(); DatabaseMetaData mtdt = conn.getMetaData(); System.out.println(mtdt.getProcedureTerm()); ResultSet rs = mtdt.getProcedures(conn.getCatalog(), "%", "%"); ResultSetMetaData rsmd = rs.getMetaData(); int numCols = rsmd.getColumnCount(); for (int i = 1; i <= numCols; i++) { if (i > 1) System.out.print(", "); System.out.print(rsmd.getColumnLabel(i)); }//from ww w .j a va 2 s .co m System.out.println(""); while (rs.next()) { for (int i = 1; i <= numCols; i++) { if (i > 1) System.out.print(", "); System.out.print(rs.getString(i)); } System.out.println(""); } conn.close(); }
From source file:com.alifi.jgenerator.spring.SpringGeneratorFactory.java
public static void main(String[] args) { @SuppressWarnings("unused") ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("META-INF/SpringContext.xml"); for (DataSourceMap m : DataSourceUtil.getDataSourceMap()) { DataSource ds = m.getDataSource(); try {/*from ww w. j a va 2 s . co m*/ Connection con = ds.getConnection(); DatabaseMetaData dmd = con.getMetaData(); String catalog = con.getCatalog(); String schemaPattern = dmd.getSchemaTerm(); System.out.println("Catalog:" + con.getCatalog() + " schemaPattern:" + schemaPattern); ResultSet rs = dmd.getTables(catalog, schemaPattern, "time_zone_transition", null); Statement s = null; ResultSet xrs = null; try { s = con.createStatement(); xrs = s.executeQuery("select * from time_zone_transition"); if (xrs.next()) { p("xxxxxxxxxxxxxxxxxxxxxxxx:" + xrs.getString(1)); } } catch (SQLException e) { e.printStackTrace(); } finally { } while (rs.next()) { p("-----------------------"); p("TABLE_CAT :" + rs.getString("TABLE_CAT")); p("TABLE_SCHEM:" + rs.getString("TABLE_SCHEM")); p("TABLE_NAME :" + rs.getString("TABLE_NAME")); p("TABLE_TYPE :" + rs.getString("TABLE_TYPE")); p("REMARKS: " + rs.getString("REMARKS")); p("11111111111111111:" + rs.getMetaData().getColumnClassName(1)); // ResultSet pkeyRs = dmd.getPrimaryKeys(catalog, schemaPattern, rs.getString("TABLE_NAME")); while (pkeyRs.next()) { p("M-------------M"); p("------COLUMN_NAME:" + pkeyRs.getString("COLUMN_NAME")); p("------KEY_SEQ:" + pkeyRs.getString("KEY_SEQ")); p("------PK_NAME:" + pkeyRs.getString("PK_NAME")); } // ResultSet rss = dmd.getColumns(catalog, schemaPattern, rs.getString("TABLE_NAME"), null); int cCount = rss.getMetaData().getColumnCount(); for (int i = 1; i <= cCount; i++) { p("-=-=-=-=-=-=-=-=-=-=-=-=-=-=-="); p(" getColumnClassName:" + rss.getMetaData().getColumnClassName(i)); p(" getColumnLabel:" + rss.getMetaData().getColumnLabel(i)); p(" getColumnName:" + rss.getMetaData().getColumnName(i)); p(" getColumnTypeName:" + rss.getMetaData().getColumnTypeName(i)); p(" getColumnType:" + ColumnTypes.getType(rss.getMetaData().getColumnType(i))); } } rs = dmd.getTableTypes(); while (rs.next()) { p("========================="); p("TABLE_TYPE: " + rs.getString("TABLE_TYPE")); } // ResultSetMetaData rsmd = rs.getMetaData(); // int numberOfColumns = rsmd.getColumnCount(); // for (int i = 1; i <= numberOfColumns; i++) // p(rsmd.getColumnName(i)); } catch (SQLException e) { e.printStackTrace(); } p(m.toString()); } }
From source file:Main.java
public static void main(String[] args) throws Exception { Connection conn = getMySqlConnection(); Statement st = conn.createStatement(); st.executeUpdate("drop table survey;"); st.executeUpdate("create table survey (id int,name varchar(30));"); st.executeUpdate("insert into survey (id,name ) values (1,'nameValue')"); DatabaseMetaData meta = conn.getMetaData(); ResultSet rs = meta.getExportedKeys(conn.getCatalog(), null, "survey"); while (rs.next()) { String fkTableName = rs.getString("FKTABLE_NAME"); String fkColumnName = rs.getString("FKCOLUMN_NAME"); int fkSequence = rs.getInt("KEY_SEQ"); System.out.println("getExportedKeys(): fkTableName=" + fkTableName); System.out.println("getExportedKeys(): fkColumnName=" + fkColumnName); System.out.println("getExportedKeys(): fkSequence=" + fkSequence); }/*from www . j a v a 2 s . c o m*/ st.close(); conn.close(); }