-
Aug 26th, 2008, 05:20 PM
#1
Error Getting Metadata With Oracle
Hi Every One,
I'm in really big troubles, I've been programming some metadata accessing classes, they're pretty good but I was using MysQL and Now I change to oracle and the exact same code doesn't work... :S
try {
DatabaseMetaData dbmd = getJdbcTemplate().getDataSource().getConnection(). getMetaData();
ResultSet rs = dbmd.getPrimaryKeys(dbmd.getUserName(), null , getTableName());
while (rs.next()) {
String pkName = rs.getString("COLUMN_NAME");
primaryKeynames.add(pkName);
}
rs.close();
}
I tryed connecting to the database with SYSDBA privilegies ..
<Inside of a org.apache.commons.dbcp.BasicDataSource>..
java.util.Properties info = new java.util.Properties();
info.put ("internal_logon","sysdba");
connectionProperties = info;
...
But nothing seems to work...
Any Ideas, please help
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules