ok, solved issue, as I said, noob question. My code was "normalizing" names to lower letters and H2 expects capital letters... noted for next time :)
On Jun 26, 11:01 pm, "[email protected]" <[email protected]> wrote: > 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.
