encounter issue on ignite 2.0

classic Classic list List threaded Threaded
2 messages Options
minisoft_rm minisoft_rm
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

encounter issue on ignite 2.0

This post was updated on .
dear experts, I got the following error when start up my ignite 2.0 with exported cluster project:

Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX PRIMARY[*] ON ""CartentriesCache_62_20_v1"".CARTENTRIES (""PK"" ASC, ""_KEY"" ASC) "; expected "identifier"; SQL statement:
CREATE INDEX PRIMARY ON "CartentriesCache_62_20_v1".Cartentries ("PK" ASC, "_KEY" ASC) [42001-195]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
        at org.h2.message.DbException.getSyntaxError(DbException.java:205)
        at org.h2.command.Parser.readIdentifierWithSchema(Parser.java:3197)
        at org.h2.command.Parser.parseCreate(Parser.java:4374)
        at org.h2.command.Parser.parsePrepared(Parser.java:365)
        at org.h2.command.Parser.parse(Parser.java:320)
        at org.h2.command.Parser.parse(Parser.java:292)
        at org.h2.command.Parser.prepareCommand(Parser.java:257)
        at org.h2.engine.Session.prepareLocal(Session.java:573)
        at org.h2.engine.Session.prepareCommand(Session.java:514)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1204)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:482)
        at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.executeSql(IgniteH2Indexing.java:870)
        ... 16 more

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
seems the internal h2 want to create index with name of "primary"?!

please advise, thanks.

now more evidence got: in mysql  ... this table has the following lines:

...............
  `p_deliverypointofservice` bigint(20) DEFAULT NULL,
  `aCLTS` bigint(20) DEFAULT '0',
  `propTS` bigint(20) DEFAULT '0',
  PRIMARY KEY (`PK`),
  KEY `oeProd_44` (`p_product`),
  KEY `oeOrd_44` (`p_order`)
..................

you see, the primary key here ! so ...mysql feels cool. but h2 think the "primary" is a reserved word? how to make this issue?
dkarachentsev dkarachentsev
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: encounter issue on ignite 2.0

Hi,

Could you please share your configurations?

Thanks!
-Dmitry.
Loading...