How can I generate tables from entities?
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
How can I generate tables from entities?
by Gerhard Kratz
::
Rate this Message:
|
|
|
Re: How can I generate tables from entities?
by James Sutherland
::
Rate this Message:
|
|
|
Re: How can I generate tables from entities?
by mobrien
::
Rate this Message:
|
|
|
Re: How can I generate tables from entities?
by Gerhard Kratz
::
Rate this Message:
|
|
|
Re: How can I generate tables from entities?
by mobrien
::
Rate this Message:
Gerhard,
Hi, some observations for... 1) The example DDL generation program I use that is in our SVN repository is a standalone SE JPA application outside of the EAR. Note that DDL generation will not function on databases when run from a JEE application server if the persistence unit is using JTA because the implicit auto-commit function during a drop or create table is not valid in an atomic container managed transaction - therefore use DDL generation only in SE apps. The package name [org.eclipse.persistence.example.jpa.server.common.ddlgen] is misleading - the main() run target is DDLGenerationClient.java For the property warning messages, to verify that your persistence.xml is being modified - try to "break" it first by removing a key property or using an invalid provider string - sometimes the bin directory does not match src changes (in Eclipse if the project | build automatically flag is unset) For example, I switched to using the EclipseLink 1.1.2 distribution jars where we only support the older property names and got an expected exception using the following classpath if I didn't revert to "eclipselink.jdbc" <classpathentry kind="src" path="src"/> <classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/> <classpathentry kind="var" path="ORACLE_JDBC_LIB"/> <classpathentry kind="lib" path="C:/_transfer/eclipselink-1.1.2.v20090606-r4436/eclipselink/jlib/eclipselink.jar"/> <classpathentry kind="lib" path="C:/_transfer/eclipselink-1.1.2.v20090606-r4436/eclipselink/jlib/jpa/javax.persistence_1.0.0.v200905011740.jar"/> <classpathentry kind="output" path="bin"/> Caused by: Exception [EclipseLink-4021] (Eclipse Persistence Services - 1.1.2.v20090606-r4436): org.eclipse.persistence.exceptions.DatabaseException Exception Description: Unable to acquire a connection from driver [null], user [null] and URL [null]. Verify that you have set the expected driver class and URL. Check your login, persistence.xml or sessions.xml resource. The jdbc.driver property should be set to a class that is compatible with your database platform Bottom line, you can ignore the deprecation warnings for now. 2) Lack of DDL generation files Experiment 1: If I leave out eclipselink.application-location, the ddl files will be written to the runtime directory - in my case this is to the project root in my Eclipse workspace <?xml version="1.0" encoding="UTF-8"?> <persistence version="1.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_1_0.xsd"> <persistence-unit name="dao.create.tables.oracle" transaction-type="RESOURCE_LOCAL"> <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> <class>org.eclipse.persistence.example.jpa.server.business.Cell</class> <properties> <property name="javax.persistence.jdbc.driver" value="oracle.jdbc.driver.OracleDriver"/> <property name="eclipselink.target-database" value="org.eclipse.persistence.platform.database.oracle.OraclePlatform"/> <property name="javax.persistence.jdbc.url" value=jdbc:oracle:thin:@.../> <property name="javax.persistence.jdbc.user" value="user"/> <property name="javax.persistence.jdbc.password" value="password"/> <property name="eclipselink.logging.level" value="ALL"/> <property name="eclipselink.ddl-generation" value="drop-and-create-tables"/> <property name="eclipselink.ddl-generation.output-mode" value="both"/> <property name="eclipselink.create-ddl-jdbc-file-name" value="ddl.txt"/> <!-- property name="eclipselink.application-location" value="C:/opt"/--> </properties> </persistence-unit> </persistence> generates to the following instead of c:/opt C:\view_w342e\examples\org.eclipse.persistence.example.jpa.server.common.ddlgen>dir 2009-06-11 09:35 678 ddl.txt 2009-06-11 09:35 274 dropDDL.jdbc I also run fine with the following changes because of auto-detection <!--property name="javax.persistence.jdbc.driver" value="oracle.jdbc.driver.OracleDriver"/--> <!--property name="eclipselink.target-database" value="org.eclipse.persistence.platform.database.oracle.OraclePlatform"/--> <property name="eclipselink.ddl-generation" value="create-tables"/> To assist you, I have included a zip of the SE JPA DDL generation project, the output files and the log on the root for your comparison. Differences are the fact that I am running off trunk projects from the Eclipse IDE and using an Oracle DB. We both are running EclipseLink 2.0 I will try on MySQL instead of Oracle and advise later. thank you /michael Gerhard Kratz wrote:
_______________________________________________ eclipselink-users mailing list eclipselink-users@... https://dev.eclipse.org/mailman/listinfo/eclipselink-users |
org.eclipse.persistence.example.jpa.server.common.zipp (32K) | Free embeddable forum powered by Nabble | Forum Help |
