[
https://issues.apache.org/jira/browse/OPENJPA-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13872197#comment-13872197
]
Kevin Sutter commented on OPENJPA-2469:
---------------------------------------
@Jake, It looks like the reference you provided may be "out dated"... This
talks about OpenJPA 1.0.2 and setting the BrokerFactory to "ndb"... Take a
look at Rick's JIRA reference and try configuring for NDB using the
DataDictionary property. This might give better jdbc statement generation.
But, at the same time, you should be aware of the limitations with NDB as
opposed to InnoDB... Per my earlier comment. Can you live with those
restrictions?
> 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)
