[
https://issues.apache.org/jira/browse/OPENJPA-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13872207#comment-13872207
]
Jake Breindel edited comment on OPENJPA-2469 at 1/15/14 3:53 PM:
-----------------------------------------------------------------
When I was looking into starting development I did do some research on MySQL
cluster having never used it before. It turns out there were many improvements
in the cluster technology that brings it closer to the InnoDB storage engine. I
am using MySQL cluster 7.3.3 GPL edition which is the newest version.
In these versions of MySQL Cluster do support transactions, forieign keys and
joins. See some of these references:
http://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
http://www.clusterdb.com/mysql-cluster/foreign-keys-in-mysql-cluster
was (Author: j.breindel2):
When I was looking into starting development I did do some research on MySQL
cluster having never used it before. It turns out there were many improvements
in the cluster technology that brings it closer to the InnoDB storage engine.
The new versions of MySQL Cluster do support transactions, forieign keys and
joins. See some of these references:
http://dev.mysql.com/doc/refman/5.7/en/storage-engines.html
http://www.clusterdb.com/mysql-cluster/foreign-keys-in-mysql-cluster
> 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)
