responses inline below... > > > On Wed, Jun 5, 2013 at 8:27 PM, Andrew Clarke <[email protected]> wrote: > >> >> persistence.xml: >> >> <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="ExampleEngine"> >> <provider>org.hibernate.ejb.HibernatePersistence</provider> >> <class>com.example.account.Application</class> >> >> <properties> >> <property name="hibernate.show_sql" value="true"/> >> <property name="hibernate.format_sql" value="true"/> >> <property name="hibernate.hbm2ddl.auto" value="update"/> >> </properties> >> </persistence-unit> >> </persistence> >> >> Interesting. According to your persistence.xml, you're using JPA 1.0 instead of JPA 2.0.
> > When I started using TomEE+, I was instructed (or I had) to add > jta-data-source and non-jta-data-source names to persistence.xml, but one > of the later releases of TomEE+, it was no longer necessary to add > non-jta-data-source name. See my persistence.xml below (yes, I'm using > derby and not using hibernate). > > <?xml version="1.0" encoding="UTF-8"?> > <persistence version="2.0" 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_2_0.xsd";> > <persistence-unit name="mcmsPU" transaction-type="JTA"> > <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> > <jta-data-source>jdbc/mcmsJta</jta-data-source> > <class>jpa.entities.PaymentNotes</class> > <class>jpa.entities.Payment</class> > <exclude-unlisted-classes>false</exclude-unlisted-classes> > <properties> > <property name="eclipselink.target-database" > value="org.eclipse.persistence.platform.database.DerbyPlatform"/> > <property name="eclipselink.jdbc.cache-statements" value="true"/> > <property name="eclipselink.jdbc.cache-statements.size" value="128"/> > <property name="eclipselink.logging.parameters" value="false"/> > </properties> > </persistence-unit> > </persistence> > > and below, I see you have 'JtaManaged true', which is all good, so I think > it is necessary for you to add jta db name in your persistence.xml. > > >> >> tomee.xml: >> >> <?xml version="1.0" encoding="UTF-8"?> >> <tomee> >> <Resource id="example_db_prod" type="DataSource"> >> JdbcDriver com.mysql.jdbc.Driver >> JdbcUrl >> jdbc:mysql://localhost:3306/example_db_prod?autoReconnect=true >> UserName myusername >> Password mypassword >> validationQuery = SELECT 1 >> JtaManaged true >> </Resource> >> </tomee> >> >> > >
