Eclipse Community Forums: EclipseLink » eclipselink.ddl-generation and JTA datasources

Home » Eclipse Projects » EclipseLink » eclipselink.ddl-generation and JTA datasources

eclipselink.ddl-generation and JTA datasources [message #987351]

Mon, 26 November 2012 04:19

Eclipse User

Hi,

DDL generation does not work on JTA datasources, so i am wondering how people in general tackle this in their continuous integration environment ? In CI we have the server configured mostly like a production server, with fully configured JTA/XA resources but that means that Eclipselink cannot automatically create the database tables.

What would be needed is EclipseLink to be able to use a non-jta datasource during database creation, and use the 'normal' jta datasource during the runtime of the application. Is there any hack or workaround that would facilitate this ?

Thanks
Jorg

Re: eclipselink.ddl-generation and JTA datasources [message #987363 is a reply to message #987351]

Mon, 26 November 2012 05:01

Eclipse User

one possible solution is just thought of is to during the build generate the ddl from ant script reusing the eclipselink DDL generation classes.

To be seen if Eclipselink is that flexible, can it just be called from the command line to generate DDL for a project ?

Re: eclipselink.ddl-generation and JTA datasources [message #987691 is a reply to message #987363]

Tue, 27 November 2012 10:57

Eclipse User

DDL generation does work with JTA datasources. What JavaEE server and database are you using?

You can also define a non-jta-datasource in your persistence.xml if your datasource has issues, (in addition to the jta one).

Re: eclipselink.ddl-generation and JTA datasources [message #987782 is a reply to message #987691]

Wed, 28 November 2012 02:32

Eclipse User

Hi James,

According to this link it doesn't http://docs.oracle.com/cd/A91202_01/901_doc/java.901/a90188/trans.htm#1271171 and it's also my experience with other tools or libraries that attempt to create their tables automatically over a jta datasource.

We're using weblogic 10.3.4 with oracle 11g. The only way i could get it to work was to setup my application datasource as a non-xa datasource supporting global transactions using LLR optimization. It's kind of a hack but it works.

If you are saying that DDL works over a JTA datasource can you post more specific details ? Our application is Spring based, we don't use persistence.xml but handle everything through LocalEntityManagerFactoryBean and PersistenceUnitPostProcessor.

THanks !

Re: eclipselink.ddl-generation and JTA datasources [message #989095 is a reply to message #987782]

Tue, 04 December 2012 10:25

Eclipse User

All of our tests generate DDL using JTA data sources on multiple different JavaEE servers, and I have not seen any issues with this.

Perhaps you have multiple different databases registered for the same JTA transaction when the DDL is being generated? The database XA may not allow this.

You could also try,

"eclipselink.deploy-on-startup"="true"

This will cause the DDL to be generated at startup, when hopefully there is no active JTA transaction.

Re: eclipselink.ddl-generation and JTA datasources [message #989955 is a reply to message #989095]

Mon, 10 December 2012 04:05

Eclipse User

That's helpful thanks James. I have to adjust my wording then: "DDL statements do work over an XA datasource, but not when that datasource is participating in a JTA transaction". For our case putting the deploy-on-startup made it work.

Thanks

Previous Topic:	Loging SQL to a file
Next Topic:	xsd:Any, marshalling, and escaping

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 16:45:34 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter