[
https://issues.apache.org/jira/browse/OPENJPA-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13892723#comment-13892723
]
Jake Breindel commented on OPENJPA-2469:
----------------------------------------
No sorry I didn't get back earlier. But I was using:
mysql-connector-java-5.1.25-bin.jar
which was the version of the MySQL driver that was bundled with MySQL cluster
at the time. The latest as of 2/5/2014 is 5.1.28.
> OpenJPA MappingTool gives encountered ENGINE
> --------------------------------------------
>
> Key: OPENJPA-2469
> URL: https://issues.apache.org/jira/browse/OPENJPA-2469
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.2.2
> Environment: Windows 8.1
> Glassfish 4.0 Open Source Edition Build 89
> MySQL Cluster 7.3.3
> ClusterJPA
> ClusterJ
> OpenJPA 2.2.2
> Maven 3
> Reporter: Jake Breindel
> Priority: Blocker
> Labels: mappingtool, schemabuilder
>
> I am trying to have OpenJPA build my schemas from my entity classes. I am
> using MySQL cluster so the engine type needs to be ndb however the mapping
> tool does not seem to like the ENGINE keyword when trying to create the
> tables.
> Here is the stack trace
> SEVERE: 133 core TRACE [admin-listener(2)] openjpa.jdbc.SQL - <t
> 1678323934, conn 634645525> executing stmnt 1903857975 CREATE TABLE
> channelEnvironmentMaps (cid INTEGER, enid INTEGER) ENGINE = ndb
> SEVERE: 134 core TRACE [admin-listener(2)] openjpa.jdbc.SQL - <t
> 1678323934, conn 634645525> [1 ms] spent
> SEVERE: Exception while deploying the app [app]
> SEVERE: Exception during lifecycle processing
> org.glassfish.deployment.common.DeploymentException: Syntax error:
> Encountered "ENGINE" at line 1, column 65. {stmnt 1903857975 CREATE TABLE
> channelEnvironmentMaps (cid INTEGER, enid INTEGER) ENGINE = ndb} [code=20000,
> state=42X01]
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:559)
> at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:455)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:209)
> at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154)
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)
> at
> org.glassfish.persistence.jpa.JPADeployer$2.visitPUD(JPADeployer.java:451)
> at
> org.glassfish.persistence.jpa.JPADeployer$PersistenceUnitDescriptorIterator.iteratePUDs(JPADeployer.java:510)
> at
> org.glassfish.persistence.jpa.JPADeployer.iterateInitializedPUsAtApplicationPrepare(JPADeployer.java:492)
> at org.glassfish.persistence.jpa.JPADeployer.event(JPADeployer.java:395)
> at org.glassfish.kernel.event.EventsImpl.send(EventsImpl.java:131)
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
