Hi,
new to H2 here, sorry if this is an obvious question :) I'm using an
in-memory instance of H2 but when I query for metadata, I get a an
empty ResultSet.
With this code:
[...]
Connection connection = getConnection();
DatabaseMetaData metadata = connection.getMetaData();
ResultSet pkcolumns = metadata.getPrimaryKeys(catalog,
schema, table);
[...]
pkcolumns is empty, it has no rows.
My settings are:
db.url = jdbc:h2:mem:test;MODE=PostgreSQL
db.driver = org.h2.Driver (H2 1.2.137)
db.username = sa
db.password = sa
and I'm using DBCP with the connection, via:
DriverManager.getConnection("jdbc:apache:commons:dbcp:" + poolName);
I couldn't find any information in the group or by Google, although
probably I'm searching for th wrong error. Any hint to put me in the
proper track?
Best regards,
Pere Villega
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
