Connection.getMetaData().getTables(…) Fails

[Jason Osgood]

Hi Thomas Mueller, All.


I'm having trouble with the Connection.getMetaData().getTables(…)
method.

It works if the database is embedded (e.g. jdbc:h2:data/test/
metaData).

It does not work if the database is remote (e.g. jdbc:h2:tcp://
localhost/metaData).

It throws an exception (below) stating the TYPE_NAME column is
missing.

I did SELECT * FROM INFORMATION_SCHEMA.TABLES against both the
embedded and remote connections. The remote database is missing the
TYPE_NAME and TABLE_CLASS columns.

This bug probably wasn't caught because TestMetaData only works
against an embedded database.

That's as far as I got. I tried to figure out why remote and embedded
databases have different schemes. But my kung fu is weak.

Thanks for your help!


Cheers, Jason


---

Exception in thread "main" org.h2.jdbc.JdbcSQLException: Column
TYPE_NAME not found; SQL statement:
SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME,
TABLE_TYPE, REMARKS, TYPE_NAME TYPE_CAT, TYPE_NAME TYPE_SCHEM,
TYPE_NAME, TYPE_NAME SELF_REFERENCING_COL_NAME, TYPE_NAME
REF_GENERATION, SQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_CATALOG
LIKE ? ESCAPE '\' AND TABLE_SCHEMA LIKE ? ESCAPE '\' AND TABLE_NAME
LIKE ? ESCAPE '\' AND (TRUE) ORDER BY TABLE_TYPE, TABLE_SCHEMA,
TABLE_NAME [42122-112]
at org.h2.message.Message.getSQLException(Message.java:107)
at org.h2.message.Message.getSQLException(Message.java:118)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:
130)
at org.h2.expression.Alias.optimize(Alias.java:49)
at org.h2.command.dml.Select.prepare(Select.java:725)
at org.h2.command.Parser.prepareCommand(Parser.java:233)
at org.h2.engine.Session.prepareLocal(Session.java:410)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:221)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:136)
at java.lang.Thread.run(Thread.java:680)

at org.h2.engine.SessionRemote.done(SessionRemote.java:543)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:68)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:47)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:421)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
1056)
at
org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:
71)
at
org.h2.jdbc.JdbcConnection.prepareAutoCloseStatement(JdbcConnection.java:
254)
at
org.h2.jdbc.JdbcDatabaseMetaData.getTables(JdbcDatabaseMetaData.java:
146)

[Rami Ojares]

All I can say is that I have used that method without problems and I am
using h2 through tcp.
Maybe some version issue?

- rami

On 9.12.2010 0:58, Jason Osgood wrote:
> Hi Thomas Mueller, All.
>
>

> I'm having trouble with the Connection.getMetaData().getTables(�)

[Jason Osgood]

Hi Rami.


Thanks for the quick reply!

> Maybe some version issue?

Yup. That's it.

I checked again. My client and server were using two different
versions. Oops.

Would a version check be a good idea?


Cheers, Jason

[Thomas Mueller]

Hi,

> Would a version check be a good idea?

There is a version check... but I was not working correctly in
previous versions, specially not in the version you are using (version
1.1.112 from 2009-05-01).

Regards,
Thomas