I was attempting to create a database for a new project which just contained entities \u2013 I had imported the entity classes from Enterprise Architect and added the required annotations, getters & setters etc.<\/p>\n
My first attempt used the following persistence.xml<\/em> (I have removed most of the classes for the example)<\/p>\n <?xml version=”1.0″ encoding=”UTF-8″?> \u00a0\u00a0\u00a0\u00a0\u00a0 <non-jta-data-source>jdbc\/TestPool<\/non-jta-data-source> \u00a0Having created the database and validated the connection\/datasource etc., I attempted to create the tables from\u00a0 Eclipse by right clicking the project and selecting JPA Tools\/Create Tables from Entities\u2026<\/em><\/p>\n This resulted in the following error:-<\/p>\n [EL Config]: Connection(5226838)–connecting(DatabaseLogin( The error occurred even though the data source was being used outside the container as a non-jta data source (this worked previously for JPA1\/Glassfish V2, allowing JPA to be used outside the container but still using a datasource defined in Glassfish). A previous post here<\/strong><\/a> (in the section Notes on Persistence.xml)<\/em> also reports that when running outside the container, it is vital to have eclipselink.target-server defaulted or set to none.<\/em> In this case, the setting caused no difference either way. After a fair bit of research\/Googling, I could not find the cause of the problem, so I simply reverted to specifying the connection explicitly in persistence.xml,<\/em>\u00a0 without using the connection defined in Glassfish at all.<\/p>\n This worked correctly. I will not need to create the database very often, and it only involved tweaking a few lines in the file, so I\u2019m happy to live with it. Here is my modified persistence.xml<\/em> which uses a direct connection specified in the file. This version created the database correctly. Note that as detailed <\/strong>in this post here<\/strong><\/a> (near the bottom of the post), the property names for JDBC url, user, password and driver have now been standardised and are no longer eclipslink specific.<\/p>\n <?xml version=”1.0″ encoding=”UTF-8″?> \u00a0\u00a0\u00a0 <persistence-unit name=”Test” transaction-type=”RESOURCE_LOCAL”>\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 <!–<jta-data-source>jdbc\/TestPool<\/jta-data-source>–> I was attempting to create a database for a new project which just contained entities \u2013 I had imported the entity classes from Enterprise Architect and added the required annotations, getters & setters etc. My first attempt used the following persistence.xml (I have removed most of the classes for the example) <?xml version=”1.0″ encoding=”UTF-8″?> <persistence […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[13,9,137,40,182,16],"_links":{"self":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1191"}],"collection":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1191"}],"version-history":[{"count":7,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1191\/revisions"}],"predecessor-version":[{"id":1194,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=\/wp\/v2\/posts\/1191\/revisions\/1194"}],"wp:attachment":[{"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/salientsoft.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n<persistence version=”2.0″ xmlns=http:\/\/java.sun.com\/xml\/ns\/persistence<\/a>
\nxmlns:xsi=http:\/\/www.w3.org\/2001\/XMLSchema-instance<\/a>
\nxsi:schemaLocation=”http:\/\/java.sun.com\/xml\/ns\/persistence<\/a> http:\/\/java.sun.com\/xml\/ns\/persistence\/persistence_2_0.xsd”<\/a>>
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0 <persistence-unit name=”Test” transaction-type=”RESOURCE_LOCAL”>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <provider>org.eclipse.persistence.jpa.PersistenceProvider<\/provider><\/p>\n
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <class>uk.co.salientsoft.Test.domain.Address<\/class>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <class>uk.co.salientsoft.Test.domain.AddressLine<\/class>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <class>uk.co.salientsoft.Test.domain.Campaign<\/class>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <class>uk.co.salientsoft.Test.domain.CampaignText<\/class>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <exclude-unlisted-classes>false<\/exclude-unlisted-classes>\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <properties>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”eclipselink.logging.level” value=”INFO” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”eclipselink.target-server” value=”None” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <!– <property name=”eclipselink.target-server” value=”SunAS9″ \/>–>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”eclipselink.target-database” value=”Oracle” \/>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”eclipselink.ddl-generation.output-mode” value=”database” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <\/properties>
\n\u00a0\u00a0\u00a0\u00a0 <\/persistence-unit>
\n<\/persistence><\/p>\n
\n\u00a0\u00a0\u00a0 platform=>OraclePlatform
\n\u00a0\u00a0\u00a0 user name=> “Test”
\n\u00a0\u00a0\u00a0 connector=>JNDIConnector datasource name=>jdbc\/TestPool
\n))
\n[EL Severe]: Local Exception Stack:
\nException [EclipseLink-7060] (Eclipse Persistence Services – 2.0.1.v20100213-r6600): org.eclipse.persistence.exceptions.ValidationException
\nException Description: Cannot acquire data source [jdbc\/TestPool].
\nInternal Exception: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:\u00a0 java.naming.factory.initial<\/em><\/p>\n
\n<persistence version=”2.0″ xmlns=”http:\/\/java.sun.com\/xml\/ns\/persistence”<\/a> xmlns:xsi=”http:\/\/www.w3.org\/2001\/XMLSchema-instance”<\/a> xsi:schemaLocation=”http:\/\/java.sun.com\/xml\/ns\/persistence<\/a> http:\/\/java.sun.com\/xml\/ns\/persistence\/persistence_2_0.xsd”<\/a>><\/p>\n
\n\u00a0\u00a0\u00a0 <!– <persistence-unit name=”Test” transaction-type=”JTA”>–>
\n\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <provider>org.eclipse.persistence.jpa.PersistenceProvider<\/provider><\/p>\n
\n\u00a0\u00a0\u00a0\u00a0 <!–<non-jta-data-source>jdbc\/TestPool<\/non-jta-data-source>–>
\n\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <class>uk.co.salientsoft.Test.domain.Address<\/class>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <class>uk.co.salientsoft.Test.domain.AddressLine<\/class>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <class>uk.co.salientsoft.Test.domain.Campaign<\/class>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <class>uk.co.salientsoft.Test.domain.CampaignText<\/class>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <exclude-unlisted-classes>false<\/exclude-unlisted-classes>\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <properties>\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<property name=”javax.persistence.jdbc.url” value=”jdbc:oracle:thin:@localhost:1521:xe”\/>\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”javax.persistence.jdbc.user” value=”Test”\/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”javax.persistence.jdbc.password” value=”Test”\/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”javax.persistence.jdbc.driver” value=”oracle.jdbc.OracleDriver”\/>\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”eclipselink.logging.level” value=”INFO” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”eclipselink.target-server” value=”None” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <!– <property name=”eclipselink.target-server” value=”SunAS9″ \/>–>
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”eclipselink.target-database” value=”Oracle” \/>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=”eclipselink.ddl-generation.output-mode” value=”database” \/>
\n\u00a0\u00a0\u00a0\u00a0\u00a0 <\/properties>
\n\u00a0\u00a0\u00a0\u00a0 <\/persistence-unit>
\n<\/persistence><\/p>\n","protected":false},"excerpt":{"rendered":"