openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jake Breindel (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (OPENJPA-2469) OpenJPA MappingTool gives encountered ENGINE
Date Tue, 18 Feb 2014 16:44:27 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-2469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13904227#comment-13904227
] 

Jake Breindel commented on OPENJPA-2469:
----------------------------------------

So when I tried to manually create the tables using the command line client, it gave me an
error when I tried to use the TYPE keyword. 

That is about as far as I can troubleshoot with this issue because I am using Glassfish 4
which doesn't allow OpenJPA as the persistence provider. I guess my suggestion to anyone else
who is in the same boat as me with maybe an earlier version of Glassfish would be to use the
provided persistence provider, have it manually generate your schema for you and switch to
OpenJPA. But that does not solve the issue.

> 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)

Mime
View raw message