| 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 |