Emmanuel,
I gave it a go.
String[] types = {"TABLE", "VIEW"};
ResultSet resultSet = metaData.getTables(null, null, "%", types);
But resultset is still empty.
Thanks though,
- Ole
Emmanuel Cecchet wrote:
Ole,
It might be that Derby does not like it when the types are set to null.
In Sequoia, I use something like that and it works:
String[] types = {"TABLE", "VIEW"};
rs = connectionMetaData.getTables(null, null, "%", types);
Let me know if that works for you,
Emmanuel
I'm trying to use DatabaseMetaData.getTables() to get a list of tables
contained in a derby database. I run the statement like this (I made
sure tables are present by browsing using the eclipse Data Source
explorer first):
ResultSet resultSet = metaData.getTables(null, null, "%", null);
But resultSet is empty. I also tried it like this:
ResultSet resultSet = metaData.getTables(null, null,
"EXISTING_TABLE_NAME", null);
Still no love. Anyone have any ideas on what I could be doing better?
Thanks,
- Ole
