JDBC:GETPRIMARYKEYS DOES NOT RETURN ANY DATA NO SQLEXCEPTION EITHER |
Product: JDBC Report Number: 650919 Last Updated: 02-APR-98 Component: JDBC Version: 7.3.4 RDBMS Version: 7.3.4 Operating System: Sun SPARC Solaris Version 2.51 Affects: All supported platforms.
-* private static void DescPK(DatabaseMetaData dbmd, String pk){ //Primary Key Definitions try { ResultSet rs = dbmd.getPrimaryKeys(null,null,"PK_SALES"); System.out.println("Primary Key Info:" + pk ); while (rs.next()) { String name = rs.getString("TABLE_NAME"); String colName = rs.getString("COLUMN_NAME"); String keySeq = rs.getString("KEY_SEQ"); String pkName = rs.getString("PK_NAME"); System.out.println("column name : " + colName ); System.out.println("sequence in key : " + keySeq ); System.out.println("primary key name: " + name ); } // pk while } catch (SQLException e) { System.out.println("Error: Error Displaying PK info on SALES Table."); System.out.println(e); } -* references tar # 10664126.6 -* Status: Open. More information may be available at a later date.
Copyright © 1998 Oracle Corporation. All Rights Reserved. Courtesy of the Oracle Technology Network |