Hi, More information. The problem only happens in embedded mode. For server mode, no such problem happens.
Regards, Rice On Nov 30, 4:34 pm, Rice <[email protected]> wrote: > 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.
