Re: Openjpa + MySQL + Tomcat datasource issue

Mon, 21 Sep 2009 16:28:47 -0700

Yup that was it :). We had a second file (conf/Catalina/localhost/juddiv3.xml) with the datasource info. Going to remove that file so it won't cause any more confusion! 

Thx!

--Kurt

Miłosz Tylenda wrote:

Kurt,

Are you sure you are connecting to a MySQL database? The error message looks to 
me more like coming from Derby than MySQL. I would say you are still connecting 
to a Derby data source while having your OpenJPA properties set up for MySQL.

Cheers,
Milosz



Hi guys,
I'm working on the Apache jUDDI project and we use the JPA API for persistence. One of the JPA implementations we use is OpenJPA. We've been using Derby as our default database, which is working fine. However when switching it to MySQL I'm getting the following error when OpenJPA tries to create the juddiv3 tables: 

SEVERE: StandardWrapper.Throwable
<openjpa-1.2.1-r752877:753278 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Syntax error: Encountered "TYPE" at line 1, column 163. {stmnt 7117250 CREATE TABLE j3_address (id BIGINT NOT NULL, sort_code VARCHAR(10), tmodel_key VARCHAR(255), use_type VARCHAR(255), address_id BIGINT NOT NULL, PRIMARY KEY (id)) TYPE = InnoDB} [code=30000, state=42X01] 
    at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:553)
    at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:453)
at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:159) at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:119) at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:189) at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:142) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:192) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:145) at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:56) at org.apache.juddi.config.PersistenceManager.getEntityManager(PersistenceManager.java:45) at org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:101) 


The datasource (webapps/juddiv3/META-INF/context.xml) looks like:

<Context>
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
    <!--
    <Resource name="jdbc/JuddiDS" auth="Container"
            type="javax.sql.DataSource" username="" password=""
            driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
            url="jdbc:derby:juddi-derby-test-db;create=true"
            maxActive="8"
            />
    -->

    <!-- mysql -->
    <Resource name="jdbc/JuddiDS" auth="Container"
            type="javax.sql.DataSource" username="root" password=""
            driverClassName="com.mysql.jdbc.Driver"
            url="jdbc:mysql://localhost:3306/juddiv3"
            maxActive="8"
            />
</Context>
The persistence.xml (webapps/juddiv3/WEB-INF/classes/META-INF/persistence.xml) looks like 

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence";
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"; 
             version="1.0">
  <persistence-unit name="juddiDatabase" transaction-type="RESOURCE_LOCAL">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> 
    <non-jta-data-source>java:comp/env/jdbc/JuddiDS</non-jta-data-source>
    <!-- entity classes -->
    <class>org.apache.juddi.model.Address</class>
    <class>org.apache.juddi.model.AddressLine</class>
 snip
 <class>org.apache.juddi.model.UddiEntityPublisher</class>
    <properties>
<property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema(SchemaAction='add')"/> 
      <property name="openjpa.Log" value="DefaultLevel=TRACE, Tool=INFO"/>
      <property name="openjpa.jdbc.UpdateManager" value="operation-order"/>
<property name="openjpa.jdbc.DBDictionary" value="org.apache.openjpa.jdbc.sql.MySQLDictionary" /> 
    </properties>
  </persistence-unit>
Why would it not be liking the "TYPE = InnoDB" at the end of the create statement (I want to use innodb)? The SQL looks fine to me. I'm using MySQL5 and mysql-connector-java-5.1.6.jar. OpenJPA version 2.1.3, Tomcat 6.0.20.
Note that if reconfigure the persistence.xml to *not* use the tomcat datasource, but rather connect to MySQL directly like so: 

<!--  mysql connection properties -->
<property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/juddiv3"/> <property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/> 
      <property name="openjpa.ConnectionUserName" value="root"/>
      <property name="openjpa.ConnectionPassword" value=""/>

then things work fine!
Any help would be greatly appreciated! Does anyone have a working example of how to use a tomcat datasource? 

Thx,

--Kurt

Reply via email to