Hi,
I get the following syntax error for a statement that might be
issued by hibernate (My program does not have such a statement).
However, I check the trace stack and find that this error happens just
when hibernate starts to get a connection from h2. Just wonder why
getting a connection makes a statement executed. This is the method
for hibernate to get a connection, then follows is h2 driver's code
org.hibernate.connection.DriverManagerConnectionProvider.getConnection
(DriverManagerConnectionProvider.java:133)
The following is the trace stack:
org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement CREATE
PRIMARY KEY PUBLIC[*].PRIMARY_KEY_D ON PUBLIC.BUREAUCRATSHIP(OID);
expected ON; SQL statement:
CREATE PRIMARY KEY PUBLIC.PRIMARY_KEY_D ON PUBLIC.BUREAUCRATSHIP(OID)
[42001-112]
at org.h2.message.Message.getSQLException(Message.java:107)
at org.h2.message.Message.getSQLException(Message.java:118)
at org.h2.message.Message.getSyntaxError(Message.java:143)
at org.h2.command.Parser.read(Parser.java:2522)
at org.h2.command.Parser.parseCreate(Parser.java:3506)
at org.h2.command.Parser.parsePrepared(Parser.java:321)
at org.h2.command.Parser.parse(Parser.java:288)
at org.h2.command.Parser.parse(Parser.java:260)
at org.h2.command.Parser.prepare(Parser.java:202)
at org.h2.engine.Session.prepare(Session.java:395)
at org.h2.engine.Session.prepare(Session.java:382)
at org.h2.engine.MetaRecord.execute(MetaRecord.java:81)
at org.h2.engine.Database.open(Database.java:652)
at org.h2.engine.Database.openDatabase(Database.java:221)
at org.h2.engine.Database.<init>(Database.java:216)
at org.h2.engine.Engine.openSession(Engine.java:57)
at org.h2.engine.Engine.openSession(Engine.java:139)
at org.h2.engine.Engine.getSession(Engine.java:119)
at org.h2.engine.SessionFactoryEmbedded.createSession
(SessionFactoryEmbedded.java:17)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer
(SessionRemote.java:248)
at org.h2.engine.SessionRemote.createSession(SessionRemote.java:226)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:106)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:90)
at org.h2.Driver.connect(Driver.java:58)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection
(DriverManagerConnectionProvider.java:133)
at org.hibernate.cfg.SettingsFactory.buildSettings
(SettingsFactory.java:111)
at org.hibernate.cfg.Configuration.buildSettingsInternal
(Configuration.java:2119)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:
2115)
at org.hibernate.cfg.Configuration.buildSessionFactory
(Configuration.java:1339)
--
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.
