Hi
I have used the H2 console against a Firebird database and the queries
worked well.
I have now ported the database to H2 (because it is much much
faster).
When I now do the (any) simple selects like "Select * from weblogdata"
I get an error:
Column CONSTRAINT_NAME not found; SQL statement:
SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME,
COLUMN_NAME, ORDINAL_POSITION KEY_SEQ, IFNULL(CONSTRAINT_NAME,
INDEX_NAME) PK_NAME FROM INFORMATION_SCHEMA.INDEXES WHERE
TABLE_CATALOG LIKE ? AND TABLE_SCHEMA LIKE ? AND TABLE_NAME = ? AND
PRIMARY_KEY = TRUE ORDER BY COLUMN_NAME [42122-108] 42S22/42122 (Help)
org.h2.jdbc.JdbcSQLException: Column CONSTRAINT_NAME not found; SQL
statement:
SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME,
COLUMN_NAME, ORDINAL_POSITION KEY_SEQ, IFNULL(CONSTRAINT_NAME,
INDEX_NAME) PK_NAME FROM INFORMATION_SCHEMA.INDEXES WHERE
TABLE_CATALOG LIKE ? AND TABLE_SCHEMA LIKE ? AND TABLE_NAME = ? AND
PRIMARY_KEY = TRUE ORDER BY COLUMN_NAME [42122-79]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.getSQLException(Message.java:114)
at org.h2.message.Message.getSQLException(Message.java:77)
at org.h2.expression.ExpressionColumn.optimize
(ExpressionColumn.java:130)
at org.h2.expression.Function.optimize(Function.java:1568)
at org.h2.expression.Alias.optimize(Alias.java:48)
at org.h2.command.dml.Select.prepare(Select.java:710)
at org.h2.command.Parser.prepareCommand(Parser.java:233)
at org.h2.engine.Session.prepareLocal(Session.java:285)
at org.h2.server.TcpServerThread.process(TcpServerThread.java:211)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:127)
at java.lang.Thread.run(Unknown Source)
at org.h2.engine.SessionRemote.done(SessionRemote.java:525)
at org.h2.command.CommandRemote.prepare(CommandRemote.java:70)
at org.h2.command.CommandRemote.<init>(CommandRemote.java:48)
at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:
420)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:
1045)
at org.h2.jdbc.JdbcPreparedStatement.<init>
(JdbcPreparedStatement.java:72)
at org.h2.jdbc.JdbcConnection.prepareAutoCloseStatement
(JdbcConnection.java:238)
at org.h2.jdbc.JdbcDatabaseMetaData.getPrimaryKeys
(JdbcDatabaseMetaData.java:355)
at org.h2.result.UpdatableRow.<init>(UpdatableRow.java:84)
at org.h2.jdbc.JdbcResultSet.getConcurrency(JdbcResultSet.java:
2396)
at org.h2.server.web.WebThread.getResultSet(WebThread.java:2008)
at org.h2.server.web.WebThread.getResult(WebThread.java:1744)
at org.h2.server.web.WebThread.query(WebThread.java:1286)
at org.h2.server.web.WebThread.process(WebThread.java:444)
at org.h2.server.web.WebThread.processRequest(WebThread.java:186)
at org.h2.server.web.WebThread.process(WebThread.java:241)
at org.h2.server.web.WebThread.run(WebThread.java:196)
I am not sure why I get this error since. Any help?
brgds Jesper Kiaer
http://nevermind.dk
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
