You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Peter Petersson <pe...@pmb.mine.nu> on 2007/06/15 19:25:45 UTC
Web app with jpa -- configuration help needed
Hi
Need help on resolving the following configuration problem.
I am trying to find out how to get a geronimo database pool (mysql) used
in a webapp, JPA managed in G v2.0 M6 (this is just a WAR not a EAR).
I end up stuck at deployment with the following error message.
13:42:42,291 ERROR [Deployer] Deployment failed due to
org.apache.geronimo.common.DeploymentException: At least one deployment
problem:[org.apache.geronimo.common.DeploymentException: Could not
resolve reference at deploy time for query
?name=jbasicDB#org.apache.geronimo.persistence.PersistenceUnitGBean. No
GBean references found.]
at
org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder.buildNaming(PersistenceUnitRefBuilder.java:154)
at
org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder$$FastClassByCGLIB$$9679ec9.invoke(<generated>)
I have looked around for G/JPA configuration information but the ones I
have found aether deals with G:s derby db (examples working fine) or is
a fully fledged EAR application which is a bit of an overkill as this
app is meant to be used as a educational "stepping stone" app for some
colleagues ( and me as it seems ;) ).
I'm trying to get hold of the entity manager with the following JNDI
context lookup name "java:comp/env/jdbc/jbasicDB"
Here is relevant (or not so) parts of the current incarnation of the
configuration:
persistency.xml (in webapp/WEB-INF)
------------------------------------------------
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
version="1.0"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="jbasicDB" transaction-type="JTA">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<jta-data-source>jdbc/jbasicDB</jta-data-source>
<class>nu.m4u.jbasic.control.jpa.Users</class>
<exclude-unlisted-classes/>
<properties>
<property name="openjpa.jdbc.DBDictionary"
value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>
<property name="openjpa.ConnectionURL"
value="jdbc:mysql://localhost:3306/jbasic"/>
<property name="openjpa.ConnectionDriverName"
value="com.mysql.jdbc.Driver"/>
<property name="openjpa.ConnectionUserName" value="xxxxx"/>
<property name="openjpa.ConnectionPassword" value="xxxxx"/>
<property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
</properties>
</persistence-unit>
</persistence>
------------------------------------------------
geronimo-web.xml
------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
<sys:environment>
<sys:moduleId>
<sys:groupId>jbasic</sys:groupId>
<sys:artifactId>jbasic2</sys:artifactId>
<sys:type>war</sys:type>
</sys:moduleId>
<sys:dependencies>
<sys:dependency>
<sys:groupId>console.dbpool</sys:groupId>
<sys:artifactId>jbasicDB</sys:artifactId>
<sys:version>1.0</sys:version>
<sys:type>rar</sys:type>
</sys:dependency>
<sys:dependency>
<sys:groupId>mysql</sys:groupId>
<sys:artifactId>mysql-connector-java</sys:artifactId>
<sys:version>3.1.12</sys:version>
<sys:type>jar</sys:type>
</sys:dependency>
<!--
<sys:dependency>
<sys:groupId>org.apache.geronimo.configs</sys:groupId>
<sys:artifactId>openjpa</sys:artifactId>
<sys:type>car</sys:type>
</sys:dependency>
-->
</sys:dependencies>
</sys:environment>
<context-root>/jbasic2</context-root>
<persistence-unit-ref>
<persistence-unit-ref-name>jdbc/jbasicDB</persistence-unit-ref-name>
<persistence-unit-name>jbasicDB</persistence-unit-name>
</persistence-unit-ref>
<!--
<sys:resource-ref>
<sys:ref-name>jdbc/jbasicDB</sys:ref-name>
<sys:resource-link>jbasicDB</sys:resource-link>
</sys:resource-ref>
-->
</web-app>
------------------------------------------------
web.xml
------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
xmlns="http://java.sun.com/xml/ns/j2ee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<!-- Nothing much here yet -->
<!--
<resource-ref>
<res-ref-name>jdbc/jbasicDB</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
-->
</web-app>
------------------------------------------------
database pool plan
------------------------------------------------
<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
<dep:environment
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
<dep:moduleId>
<dep:groupId>console.dbpool</dep:groupId>
<dep:artifactId>jbasicDB</dep:artifactId>
<dep:version>1.0</dep:version>
<dep:type>rar</dep:type>
</dep:moduleId>
<dep:dependencies>
<dep:dependency>
<dep:groupId>mysql</dep:groupId>
<dep:artifactId>mysql-connector-java</dep:artifactId>
<dep:version>3.1.12</dep:version>
<dep:type>jar</dep:type>
</dep:dependency>
</dep:dependencies>
</dep:environment>
<resourceadapter>
<outbound-resourceadapter>
<connection-definition>
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
<connectiondefinition-instance>
<name>jbasicDB</name>
<config-property-setting
name="Password">xxxx</config-property-setting>
<config-property-setting
name="Driver">com.mysql.jdbc.Driver</config-property-setting>
<config-property-setting
name="UserName">xxxx</config-property-setting>
<config-property-setting
name="ConnectionURL">jdbc:mysql://localhost:3306/jbasic</config-property-setting>
<connectionmanager>
<local-transaction/>
<single-pool>
<max-size>10</max-size>
<min-size>0</min-size>
<match-one/>
</single-pool>
</connectionmanager>
</connectiondefinition-instance>
</connection-definition>
</outbound-resourceadapter>
</resourceadapter>
</connector>
------------------------------------------------
Anny help is appreciated !
/Peter Petersson
Re: Web app with jpa -- configuration help needed
Posted by "Jay D. McHugh" <ja...@joyfulnoisewebdesign.com>.
Peter,
I just noticed one (hopefully) final thing.
The location of your persistence.xml file needs to be:
WEB-INF/classes/META-INF/persistence.xml
At least that is where I had to put mine to get it working. There has
been a lot of work on getting persistence units to deploy since I put
together my setup - so it may work with the persistence.xml where you
already have it - check the persistence unit view to see.
Jay
Jay D. McHugh wrote:
> Peter,
>
> I just realized - if you are doing resource_local access, you don't
> actually need the database pool.
>
> OpenJPA will create connections as it needs them.
>
> I would leave the database pool there though - it doesn't hurt anyone
> having it there.
>
> Once you manage to get your app deployed, take a look in the jmx
> viewer of the admin console under J2EE Managed Objects/Persistence
> Unit to make sure it got deployed correctly. Also, when you deploy,
> there will be a message dumped to the log about a property being
> unrecognized - you can ignore it. It is an issue with OpenJPA that
> already has a JIRA filed for it.
>
> Make sure you have the synchronizeMappings property set in your
> persistence.xml - otherwise the Geronimo default will kick in and try
> to recreate your tables and destroy all of your data.
>
> If I have time to try fixing my app to use the jta datasource - I'll
> let you know what needs to change.
>
>
> Jay
>
> Jay D. McHugh wrote:
>> Hi Peter,
>>
>> In a webapp, you are not allowed to directly get an EntityManager
>> (they aren't threadsafe). Instead, you need to get an
>> EntityManagerFactory.
>>
>> I was originally not able to get access to a jta-datasource, I had to
>> go with resource-local. I never went back to try accessing a
>> database pool - so I'm going to tell you how I got things working in
>> my current setup (using your values).
>>
>> _persistence.xml
>>
>> _<?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" version="1.0"
>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>> <persistence-unit transaction-type="RESOURCE_LOCAL" name="jbasicDB">
>>
>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>>
>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>> <exclude-unlisted-classes />
>> <properties>
>> <property name="openjpa.ConnectionURL"
>> value="jdbc:mysql://localhost:3306/jbasic"/>
>> <property name="openjpa.ConnectionDriverName"
>> value="com.mysql.jdbc.Driver"/>
>> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
>> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>> Tool=INFO"/>
>> <property name="openjpa.jdbc.DBDictionary"
>> value="mysql(SupportsSubselect=true)" />
>> <property name="openjpa.Log" value="DefaultLevel=INFO" />
>> <property name="openjpa.AutoDetach" value="close" />
>> <property name="openjpa.DetachState" value="all" />
>> <property name="openjpa.DataCache" value="false" />
>> <property name="openjpa.Optimistic" value="true" />
>> <property name="openjpa.Multithreaded" value="true" />
>> <property name="openjpa.TransactionMode" value="local" />
>> <property name="openjpa.NontransactionalRead" value="true" />
>> <property name="openjpa.RestoreState" value="all" />
>> <property name="openjpa.jdbc.SynchronizeMappings"
>> value="false" />
>> </properties>
>> </persistence-unit>
>> </persistence>
>>
>> _geronimo-web.xml:_
>>
>> Remove all of the persistence unit info ->
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>> <sys:environment>
>> <sys:moduleId>
>> <sys:groupId>jbasic</sys:groupId>
>> <sys:artifactId>jbasic2</sys:artifactId>
>> <sys:type>war</sys:type>
>> </sys:moduleId>
>> <sys:dependencies>
>> <sys:dependency>
>> <sys:groupId>console.dbpool</sys:groupId>
>> <sys:artifactId>jbasicDB</sys:artifactId>
>> <sys:version>1.0</sys:version>
>> <sys:type>rar</sys:type>
>> </sys:dependency> <sys:dependency>
>> <sys:groupId>mysql</sys:groupId>
>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>> <sys:version>3.1.12</sys:version>
>> <sys:type>jar</sys:type>
>> </sys:dependency>
>> </sys:dependencies>
>> </sys:environment>
>> <context-root>/jbasic2</context-root>
>> </web-app>
>>
>> _web.xml:_
>>
>> Remove the peristence info.
>>
>> _database pool plan:_
>>
>> looks fine
>>
>>
>> Then, in order to get an EntityManagerFactory in your servlets use
>> resource injection to create a class variable:
>>
>> @PersistenceUnit(unitName="jbasicDB") private EntityManagerFactory
>> emf;
>>
>> And finally, wherever you need access to an EntityManager:
>>
>> EntityManager em = emf.createEntityManager();
>>
>> em.getTransaction().begin();
>>
>> // do stuff
>>
>> em.getTransaction().commit();
>>
>> em.close();
>>
>> If you are only reading from your database, you can leave off the
>> 'em.getTransaction()' stuff. But if you are modifying data - you
>> will need these otherwise, when you close your EntityManager
>> instances all of your changes go away.
>>
>> Hope this helps,
>>
>>
>> Jay
>>
>> Peter Petersson wrote:
>>> Hi
>>>
>>> Need help on resolving the following configuration problem.
>>> I am trying to find out how to get a geronimo database pool (mysql)
>>> used in a webapp, JPA managed in G v2.0 M6 (this is just a WAR not a
>>> EAR).
>>>
>>> I end up stuck at deployment with the following error message.
>>>
>>> 13:42:42,291 ERROR [Deployer] Deployment failed due to
>>> org.apache.geronimo.common.DeploymentException: At least one
>>> deployment problem:[org.apache.geronimo.common.DeploymentException:
>>> Could not resolve reference at deploy time for query
>>> ?name=jbasicDB#org.apache.geronimo.persistence.PersistenceUnitGBean.
>>> No GBean references found.]
>>> at
>>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder.buildNaming(PersistenceUnitRefBuilder.java:154)
>>>
>>> at
>>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder$$FastClassByCGLIB$$9679ec9.invoke(<generated>)
>>>
>>>
>>> I have looked around for G/JPA configuration information but the
>>> ones I have found aether deals with G:s derby db (examples working
>>> fine) or is a fully fledged EAR application which is a bit of an
>>> overkill as this app is meant to be used as a educational "stepping
>>> stone" app for some colleagues ( and me as it seems ;) ).
>>>
>>> I'm trying to get hold of the entity manager with the following JNDI
>>> context lookup name "java:comp/env/jdbc/jbasicDB"
>>>
>>> Here is relevant (or not so) parts of the current incarnation of the
>>> configuration:
>>>
>>> persistency.xml (in webapp/WEB-INF)
>>> ------------------------------------------------
>>> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>> version="1.0"
>>>
>>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>>> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>>>
>>> <persistence-unit name="jbasicDB" transaction-type="JTA">
>>>
>>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>>>
>>> <jta-data-source>jdbc/jbasicDB</jta-data-source>
>>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>>> <exclude-unlisted-classes/>
>>> <properties>
>>> <property name="openjpa.jdbc.DBDictionary"
>>> value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>
>>> <property name="openjpa.ConnectionURL"
>>> value="jdbc:mysql://localhost:3306/jbasic"/>
>>> <property name="openjpa.ConnectionDriverName"
>>> value="com.mysql.jdbc.Driver"/>
>>> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
>>> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
>>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>>> Tool=INFO"/>
>>> </properties> </persistence-unit>
>>> </persistence>
>>> ------------------------------------------------
>>>
>>> geronimo-web.xml
>>> ------------------------------------------------
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>>> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>>> <sys:environment>
>>> <sys:moduleId>
>>> <sys:groupId>jbasic</sys:groupId>
>>> <sys:artifactId>jbasic2</sys:artifactId>
>>> <sys:type>war</sys:type>
>>> </sys:moduleId>
>>> <sys:dependencies>
>>> <sys:dependency>
>>> <sys:groupId>console.dbpool</sys:groupId>
>>> <sys:artifactId>jbasicDB</sys:artifactId>
>>> <sys:version>1.0</sys:version>
>>> <sys:type>rar</sys:type>
>>> </sys:dependency> <sys:dependency>
>>> <sys:groupId>mysql</sys:groupId>
>>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>>> <sys:version>3.1.12</sys:version>
>>> <sys:type>jar</sys:type> </sys:dependency>
>>> <!-- <sys:dependency>
>>> <sys:groupId>org.apache.geronimo.configs</sys:groupId>
>>> <sys:artifactId>openjpa</sys:artifactId>
>>> <sys:type>car</sys:type>
>>> </sys:dependency>
>>> --> </sys:dependencies> </sys:environment>
>>>
>>> <context-root>/jbasic2</context-root>
>>>
>>> <persistence-unit-ref>
>>>
>>> <persistence-unit-ref-name>jdbc/jbasicDB</persistence-unit-ref-name>
>>> <persistence-unit-name>jbasicDB</persistence-unit-name>
>>> </persistence-unit-ref>
>>>
>>> <!-- <sys:resource-ref>
>>> <sys:ref-name>jdbc/jbasicDB</sys:ref-name>
>>> <sys:resource-link>jbasicDB</sys:resource-link>
>>> </sys:resource-ref>
>>> --> </web-app> ------------------------------------------------
>>>
>>> web.xml
>>> ------------------------------------------------
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <web-app id="WebApp_ID" version="2.4"
>>> xmlns="http://java.sun.com/xml/ns/j2ee"
>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
>>> http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
>>> <!-- Nothing much here yet --> <!-- <resource-ref>
>>> <res-ref-name>jdbc/jbasicDB</res-ref-name>
>>> <res-type>javax.sql.DataSource</res-type>
>>> <res-auth>Container</res-auth>
>>> <res-sharing-scope>Shareable</res-sharing-scope>
>>> </resource-ref> --> </web-app>
>>> ------------------------------------------------
>>>
>>> database pool plan
>>> ------------------------------------------------
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <connector
>>> xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
>>> <dep:environment
>>> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
>>> <dep:moduleId>
>>> <dep:groupId>console.dbpool</dep:groupId>
>>> <dep:artifactId>jbasicDB</dep:artifactId>
>>> <dep:version>1.0</dep:version>
>>> <dep:type>rar</dep:type>
>>> </dep:moduleId>
>>> <dep:dependencies>
>>> <dep:dependency>
>>> <dep:groupId>mysql</dep:groupId>
>>> <dep:artifactId>mysql-connector-java</dep:artifactId>
>>> <dep:version>3.1.12</dep:version>
>>> <dep:type>jar</dep:type>
>>> </dep:dependency>
>>> </dep:dependencies>
>>> </dep:environment>
>>> <resourceadapter>
>>> <outbound-resourceadapter>
>>> <connection-definition>
>>>
>>> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
>>>
>>> <connectiondefinition-instance>
>>> <name>jbasicDB</name>
>>> <config-property-setting
>>> name="Password">xxxx</config-property-setting>
>>> <config-property-setting
>>> name="Driver">com.mysql.jdbc.Driver</config-property-setting>
>>> <config-property-setting
>>> name="UserName">xxxx</config-property-setting>
>>> <config-property-setting
>>> name="ConnectionURL">jdbc:mysql://localhost:3306/jbasic</config-property-setting>
>>>
>>> <connectionmanager>
>>> <local-transaction/>
>>> <single-pool>
>>> <max-size>10</max-size>
>>> <min-size>0</min-size>
>>> <match-one/>
>>> </single-pool>
>>> </connectionmanager>
>>> </connectiondefinition-instance>
>>> </connection-definition>
>>> </outbound-resourceadapter>
>>> </resourceadapter>
>>> </connector>
>>> ------------------------------------------------
>>>
>>> Anny help is appreciated !
>>> /Peter Petersson
>>>
>>>
>>>
>>
>>
>>
>
>
>
Re: Web app with jpa -- configuration help needed
Posted by Peter Petersson <pe...@pmb.mine.nu>.
Thank you both!
I was actually looking up the EMF to try to create the EM but could not
get throw the configuration although I have tried a lot of stuff . I
have not been able to look in to your suggestions yet but it looks
promising and getting rid of some of the configuration would be nice ;).
I will probably get back to you, btw what about the location of the
persistence.xlm file should I drop it in
webapp/WEB-INF/classes/META-INF/ instead of webapp/META-INF/ ?
Yes I have been looking at the jpa sample in the testsuite
(enterprise-testsuite/jpa-tests/...) but that is a EAR configuration and
the jpa-war part is looking up things via a ejb context so I am not sure
it helps configuration vise (?)
/Peter Petersson
Jay D. McHugh wrote:
> David is correct about being able to look up an EntityManager in JNDI.
>
> As long as you do not try to cache the EntityManager in an instance
> variable, you should not have a problem.
>
> There was an earlier problem with injecting UserTransactions that also
> made it so that I was not able to directly use EntityManagers - it has
> been fixed (today is the first time that I have tried it so I don't
> know how long it has been fixed).
>
> I have been working with the setup I described previously - but it
> looks like all of the problems that prevented me from setting this up
> 'correctly' have been fixed.
>
> (You will need to inject a UserTransaction resource to be able to
> commit database changes)
>
> I have begun reworking my app to use my configured database pool and
> JNDI to lookup the EntityManager.
>
> If you need/want further help, let me know - I should have my whole
> app converted by some time Monday.
>
> Thanks David,
>
>
> Jay
>
> David Jencks wrote:
>> I'm not sure jays' info is correct.
>>
>> You can get an EntityManager in a servlet as long as you look it up
>> in jndi, just don't inject it using annotations or cache it in a
>> field in your servlet.
>>
>> I think the problem is that you are looking up
>> java:comp/env/jdbc/jBasicDB which is where the datasource is expected
>> to be, not the EntityManager. Also in your geronimo plan you have a
>> persistence-unit-ref specified but you want a persistence-context-ref
>> since you are looking for an EntityManager, not an EntityManagerFactory.
>>
>> I would suggest that you look up java:comp/env/jBasicDB in your
>> servlet, and include this in your web.xml and then you won't need
>> anything in your geronimo-web plan:
>>
>> <persistence-context-ref>
>>
>> <persistence-context-ref-name>jBasicDB</persistence-context-ref-name>
>> <!-- I can't remember if anything else is required -->
>> </persistence-context-ref>
>>
>> Also I strongly recommend including a non-jta-datasource in the
>> persistence.xml, I haven't been able to get anything to work with
>> derby without that. mysql may be more forgiving/less prone to weird
>> deadlocks. Leave out all the connect-to-mysql parameters in
>> persistence.xml and use the datasource.
>>
>> You don't need a resource-ref anywhere if you aren't using the db
>> directly from your servlet.
>>
>> I assume you've found the jpa sample under testsuite/.....? It uses
>> derby but does show a (usually) working configuration.
>>
>> Hope this helps
>> david jencks
>>
>> On Jun 15, 2007, at 12:20 PM, Jay D. McHugh wrote:
>>
>>> Peter,
>>>
>>> I just realized - if you are doing resource_local access, you don't
>>> actually need the database pool.
>>>
>>> OpenJPA will create connections as it needs them.
>>>
>>> I would leave the database pool there though - it doesn't hurt
>>> anyone having it there.
>>>
>>> Once you manage to get your app deployed, take a look in the jmx
>>> viewer of the admin console under J2EE Managed Objects/Persistence
>>> Unit to make sure it got deployed correctly. Also, when you deploy,
>>> there will be a message dumped to the log about a property being
>>> unrecognized - you can ignore it. It is an issue with OpenJPA that
>>> already has a JIRA filed for it.
>>>
>>> Make sure you have the synchronizeMappings property set in your
>>> persistence.xml - otherwise the Geronimo default will kick in and
>>> try to recreate your tables and destroy all of your data.
>>>
>>> If I have time to try fixing my app to use the jta datasource - I'll
>>> let you know what needs to change.
>>>
>>>
>>> Jay
>>>
>>> Jay D. McHugh wrote:
>>>> Hi Peter,
>>>>
>>>> In a webapp, you are not allowed to directly get an EntityManager
>>>> (they aren't threadsafe). Instead, you need to get an
>>>> EntityManagerFactory.
>>>>
>>>> I was originally not able to get access to a jta-datasource, I had
>>>> to go with resource-local. I never went back to try accessing a
>>>> database pool - so I'm going to tell you how I got things working
>>>> in my current setup (using your values).
>>>>
>>>> _persistence.xml
>>>>
>>>> _<?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" version="1.0"
>>>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>>>> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>>>> <persistence-unit transaction-type="RESOURCE_LOCAL"
>>>> name="jbasicDB">
>>>>
>>>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>>>>
>>>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>>>> <exclude-unlisted-classes />
>>>> <properties>
>>>> <property name="openjpa.ConnectionURL"
>>>> value="jdbc:mysql://localhost:3306/jbasic"/>
>>>> <property name="openjpa.ConnectionDriverName"
>>>> value="com.mysql.jdbc.Driver"/>
>>>> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
>>>> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
>>>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>>>> Tool=INFO"/>
>>>> <property name="openjpa.jdbc.DBDictionary"
>>>> value="mysql(SupportsSubselect=true)" />
>>>> <property name="openjpa.Log" value="DefaultLevel=INFO" />
>>>> <property name="openjpa.AutoDetach" value="close" />
>>>> <property name="openjpa.DetachState" value="all" />
>>>> <property name="openjpa.DataCache" value="false" />
>>>> <property name="openjpa.Optimistic" value="true" />
>>>> <property name="openjpa.Multithreaded" value="true" />
>>>> <property name="openjpa.TransactionMode" value="local" />
>>>> <property name="openjpa.NontransactionalRead"
>>>> value="true" />
>>>> <property name="openjpa.RestoreState" value="all" />
>>>> <property name="openjpa.jdbc.SynchronizeMappings"
>>>> value="false" />
>>>> </properties>
>>>> </persistence-unit>
>>>> </persistence>
>>>>
>>>> _geronimo-web.xml:_
>>>>
>>>> Remove all of the persistence unit info ->
>>>>
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>>>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>>>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>>>> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>>>> <sys:environment>
>>>> <sys:moduleId>
>>>> <sys:groupId>jbasic</sys:groupId>
>>>> <sys:artifactId>jbasic2</sys:artifactId>
>>>> <sys:type>war</sys:type>
>>>> </sys:moduleId>
>>>> <sys:dependencies>
>>>> <sys:dependency>
>>>> <sys:groupId>console.dbpool</sys:groupId>
>>>> <sys:artifactId>jbasicDB</sys:artifactId>
>>>> <sys:version>1.0</sys:version>
>>>> <sys:type>rar</sys:type>
>>>> </sys:dependency> <sys:dependency>
>>>> <sys:groupId>mysql</sys:groupId>
>>>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>>>> <sys:version>3.1.12</sys:version>
>>>> <sys:type>jar</sys:type>
>>>> </sys:dependency>
>>>> </sys:dependencies>
>>>> </sys:environment>
>>>> <context-root>/jbasic2</context-root>
>>>> </web-app>
>>>>
>>>> _web.xml:_
>>>>
>>>> Remove the peristence info.
>>>>
>>>> _database pool plan:_
>>>>
>>>> looks fine
>>>>
>>>>
>>>> Then, in order to get an EntityManagerFactory in your servlets use
>>>> resource injection to create a class variable:
>>>>
>>>> @PersistenceUnit(unitName="jbasicDB") private
>>>> EntityManagerFactory emf;
>>>>
>>>> And finally, wherever you need access to an EntityManager:
>>>>
>>>> EntityManager em = emf.createEntityManager();
>>>>
>>>> em.getTransaction().begin();
>>>>
>>>> // do stuff
>>>>
>>>> em.getTransaction().commit();
>>>>
>>>> em.close();
>>>>
>>>> If you are only reading from your database, you can leave off the
>>>> 'em.getTransaction()' stuff. But if you are modifying data - you
>>>> will need these otherwise, when you close your EntityManager
>>>> instances all of your changes go away.
>>>>
>>>> Hope this helps,
>>>>
>>>>
>>>> Jay
>>>>
>>>> Peter Petersson wrote:
>>>>> Hi
>>>>>
>>>>> Need help on resolving the following configuration problem.
>>>>> I am trying to find out how to get a geronimo database pool
>>>>> (mysql) used in a webapp, JPA managed in G v2.0 M6 (this is just a
>>>>> WAR not a EAR).
>>>>>
>>>>> I end up stuck at deployment with the following error message.
>>>>>
>>>>> 13:42:42,291 ERROR [Deployer] Deployment failed due to
>>>>> org.apache.geronimo.common.DeploymentException: At least one
>>>>> deployment
>>>>> problem:[org.apache.geronimo.common.DeploymentException: Could not
>>>>> resolve reference at deploy time for query
>>>>> ?name=jbasicDB#org.apache.geronimo.persistence.PersistenceUnitGBean.
>>>>> No GBean references found.]
>>>>> at
>>>>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder.buildNaming(PersistenceUnitRefBuilder.java:154)
>>>>>
>>>>> at
>>>>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder$$FastClassByCGLIB$$9679ec9.invoke(<generated>)
>>>>>
>>>>>
>>>>> I have looked around for G/JPA configuration information but the
>>>>> ones I have found aether deals with G:s derby db (examples working
>>>>> fine) or is a fully fledged EAR application which is a bit of an
>>>>> overkill as this app is meant to be used as a educational
>>>>> "stepping stone" app for some colleagues ( and me as it seems ;) ).
>>>>>
>>>>> I'm trying to get hold of the entity manager with the following
>>>>> JNDI context lookup name "java:comp/env/jdbc/jbasicDB"
>>>>>
>>>>> Here is relevant (or not so) parts of the current incarnation of
>>>>> the configuration:
>>>>>
>>>>> persistency.xml (in webapp/WEB-INF)
>>>>> ------------------------------------------------
>>>>> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
>>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>>> version="1.0"
>>>>>
>>>>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>>>>> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>>>>>
>>>>> <persistence-unit name="jbasicDB" transaction-type="JTA">
>>>>>
>>>>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>>>>>
>>>>> <jta-data-source>jdbc/jbasicDB</jta-data-source>
>>>>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>>>>> <exclude-unlisted-classes/>
>>>>> <properties>
>>>>> <property name="openjpa.jdbc.DBDictionary"
>>>>> value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>
>>>>> <property name="openjpa.ConnectionURL"
>>>>> value="jdbc:mysql://localhost:3306/jbasic"/>
>>>>> <property name="openjpa.ConnectionDriverName"
>>>>> value="com.mysql.jdbc.Driver"/>
>>>>> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
>>>>> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
>>>>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>>>>> Tool=INFO"/>
>>>>> </properties> </persistence-unit>
>>>>> </persistence>
>>>>> ------------------------------------------------
>>>>>
>>>>> geronimo-web.xml
>>>>> ------------------------------------------------
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>>>>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>>>>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>>>>> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>>>>> <sys:environment>
>>>>> <sys:moduleId>
>>>>> <sys:groupId>jbasic</sys:groupId>
>>>>> <sys:artifactId>jbasic2</sys:artifactId>
>>>>> <sys:type>war</sys:type>
>>>>> </sys:moduleId>
>>>>> <sys:dependencies>
>>>>> <sys:dependency>
>>>>> <sys:groupId>console.dbpool</sys:groupId>
>>>>> <sys:artifactId>jbasicDB</sys:artifactId>
>>>>> <sys:version>1.0</sys:version>
>>>>> <sys:type>rar</sys:type>
>>>>> </sys:dependency> <sys:dependency>
>>>>> <sys:groupId>mysql</sys:groupId>
>>>>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>>>>> <sys:version>3.1.12</sys:version>
>>>>> <sys:type>jar</sys:type> </sys:dependency>
>>>>> <!-- <sys:dependency>
>>>>> <sys:groupId>org.apache.geronimo.configs</sys:groupId>
>>>>> <sys:artifactId>openjpa</sys:artifactId>
>>>>> <sys:type>car</sys:type>
>>>>> </sys:dependency>
>>>>> --> </sys:dependencies> </sys:environment>
>>>>>
>>>>> <context-root>/jbasic2</context-root>
>>>>>
>>>>> <persistence-unit-ref>
>>>>>
>>>>> <persistence-unit-ref-name>jdbc/jbasicDB</persistence-unit-ref-name>
>>>>> <persistence-unit-name>jbasicDB</persistence-unit-name>
>>>>> </persistence-unit-ref>
>>>>>
>>>>> <!-- <sys:resource-ref>
>>>>> <sys:ref-name>jdbc/jbasicDB</sys:ref-name>
>>>>> <sys:resource-link>jbasicDB</sys:resource-link>
>>>>> </sys:resource-ref>
>>>>> --> </web-app> ------------------------------------------------
>>>>>
>>>>> web.xml
>>>>> ------------------------------------------------
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <web-app id="WebApp_ID" version="2.4"
>>>>> xmlns="http://java.sun.com/xml/ns/j2ee"
>>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>>> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
>>>>> http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
>>>>> <!-- Nothing much here yet --> <!-- <resource-ref>
>>>>> <res-ref-name>jdbc/jbasicDB</res-ref-name>
>>>>> <res-type>javax.sql.DataSource</res-type>
>>>>> <res-auth>Container</res-auth>
>>>>> <res-sharing-scope>Shareable</res-sharing-scope>
>>>>> </resource-ref> --> </web-app>
>>>>> ------------------------------------------------
>>>>>
>>>>> database pool plan
>>>>> ------------------------------------------------
>>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>>> <connector
>>>>> xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
>>>>> <dep:environment
>>>>> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
>>>>> <dep:moduleId>
>>>>> <dep:groupId>console.dbpool</dep:groupId>
>>>>> <dep:artifactId>jbasicDB</dep:artifactId>
>>>>> <dep:version>1.0</dep:version>
>>>>> <dep:type>rar</dep:type>
>>>>> </dep:moduleId>
>>>>> <dep:dependencies>
>>>>> <dep:dependency>
>>>>> <dep:groupId>mysql</dep:groupId>
>>>>> <dep:artifactId>mysql-connector-java</dep:artifactId>
>>>>> <dep:version>3.1.12</dep:version>
>>>>> <dep:type>jar</dep:type>
>>>>> </dep:dependency>
>>>>> </dep:dependencies>
>>>>> </dep:environment>
>>>>> <resourceadapter>
>>>>> <outbound-resourceadapter>
>>>>> <connection-definition>
>>>>>
>>>>> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
>>>>>
>>>>> <connectiondefinition-instance>
>>>>> <name>jbasicDB</name>
>>>>> <config-property-setting
>>>>> name="Password">xxxx</config-property-setting>
>>>>> <config-property-setting
>>>>> name="Driver">com.mysql.jdbc.Driver</config-property-setting>
>>>>> <config-property-setting
>>>>> name="UserName">xxxx</config-property-setting>
>>>>> <config-property-setting
>>>>> name="ConnectionURL">jdbc:mysql://localhost:3306/jbasic</config-property-setting>
>>>>>
>>>>> <connectionmanager>
>>>>> <local-transaction/>
>>>>> <single-pool>
>>>>> <max-size>10</max-size>
>>>>> <min-size>0</min-size>
>>>>> <match-one/>
>>>>> </single-pool>
>>>>> </connectionmanager>
>>>>> </connectiondefinition-instance>
>>>>> </connection-definition>
>>>>> </outbound-resourceadapter>
>>>>> </resourceadapter>
>>>>> </connector>
>>>>> ------------------------------------------------
>>>>>
>>>>> Anny help is appreciated !
>>>>> /Peter Petersson
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>
>>
>>
>>
Re: Web app with jpa -- configuration help needed
Posted by "Jay D. McHugh" <ja...@joyfulnoisewebdesign.com>.
David is correct about being able to look up an EntityManager in JNDI.
As long as you do not try to cache the EntityManager in an instance
variable, you should not have a problem.
There was an earlier problem with injecting UserTransactions that also
made it so that I was not able to directly use EntityManagers - it has
been fixed (today is the first time that I have tried it so I don't know
how long it has been fixed).
I have been working with the setup I described previously - but it looks
like all of the problems that prevented me from setting this up
'correctly' have been fixed.
(You will need to inject a UserTransaction resource to be able to commit
database changes)
I have begun reworking my app to use my configured database pool and
JNDI to lookup the EntityManager.
If you need/want further help, let me know - I should have my whole app
converted by some time Monday.
Thanks David,
Jay
David Jencks wrote:
> I'm not sure jays' info is correct.
>
> You can get an EntityManager in a servlet as long as you look it up in
> jndi, just don't inject it using annotations or cache it in a field in
> your servlet.
>
> I think the problem is that you are looking up
> java:comp/env/jdbc/jBasicDB which is where the datasource is expected
> to be, not the EntityManager. Also in your geronimo plan you have a
> persistence-unit-ref specified but you want a persistence-context-ref
> since you are looking for an EntityManager, not an EntityManagerFactory.
>
> I would suggest that you look up java:comp/env/jBasicDB in your
> servlet, and include this in your web.xml and then you won't need
> anything in your geronimo-web plan:
>
> <persistence-context-ref>
> <persistence-context-ref-name>jBasicDB</persistence-context-ref-name>
> <!-- I can't remember if anything else is required -->
> </persistence-context-ref>
>
> Also I strongly recommend including a non-jta-datasource in the
> persistence.xml, I haven't been able to get anything to work with
> derby without that. mysql may be more forgiving/less prone to weird
> deadlocks. Leave out all the connect-to-mysql parameters in
> persistence.xml and use the datasource.
>
> You don't need a resource-ref anywhere if you aren't using the db
> directly from your servlet.
>
> I assume you've found the jpa sample under testsuite/.....? It uses
> derby but does show a (usually) working configuration.
>
> Hope this helps
> david jencks
>
> On Jun 15, 2007, at 12:20 PM, Jay D. McHugh wrote:
>
>> Peter,
>>
>> I just realized - if you are doing resource_local access, you don't
>> actually need the database pool.
>>
>> OpenJPA will create connections as it needs them.
>>
>> I would leave the database pool there though - it doesn't hurt anyone
>> having it there.
>>
>> Once you manage to get your app deployed, take a look in the jmx
>> viewer of the admin console under J2EE Managed Objects/Persistence
>> Unit to make sure it got deployed correctly. Also, when you deploy,
>> there will be a message dumped to the log about a property being
>> unrecognized - you can ignore it. It is an issue with OpenJPA that
>> already has a JIRA filed for it.
>>
>> Make sure you have the synchronizeMappings property set in your
>> persistence.xml - otherwise the Geronimo default will kick in and try
>> to recreate your tables and destroy all of your data.
>>
>> If I have time to try fixing my app to use the jta datasource - I'll
>> let you know what needs to change.
>>
>>
>> Jay
>>
>> Jay D. McHugh wrote:
>>> Hi Peter,
>>>
>>> In a webapp, you are not allowed to directly get an EntityManager
>>> (they aren't threadsafe). Instead, you need to get an
>>> EntityManagerFactory.
>>>
>>> I was originally not able to get access to a jta-datasource, I had
>>> to go with resource-local. I never went back to try accessing a
>>> database pool - so I'm going to tell you how I got things working in
>>> my current setup (using your values).
>>>
>>> _persistence.xml
>>>
>>> _<?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" version="1.0"
>>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>>> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>>> <persistence-unit transaction-type="RESOURCE_LOCAL" name="jbasicDB">
>>>
>>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>>>
>>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>>> <exclude-unlisted-classes />
>>> <properties>
>>> <property name="openjpa.ConnectionURL"
>>> value="jdbc:mysql://localhost:3306/jbasic"/>
>>> <property name="openjpa.ConnectionDriverName"
>>> value="com.mysql.jdbc.Driver"/>
>>> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
>>> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
>>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>>> Tool=INFO"/>
>>> <property name="openjpa.jdbc.DBDictionary"
>>> value="mysql(SupportsSubselect=true)" />
>>> <property name="openjpa.Log" value="DefaultLevel=INFO" />
>>> <property name="openjpa.AutoDetach" value="close" />
>>> <property name="openjpa.DetachState" value="all" />
>>> <property name="openjpa.DataCache" value="false" />
>>> <property name="openjpa.Optimistic" value="true" />
>>> <property name="openjpa.Multithreaded" value="true" />
>>> <property name="openjpa.TransactionMode" value="local" />
>>> <property name="openjpa.NontransactionalRead"
>>> value="true" />
>>> <property name="openjpa.RestoreState" value="all" />
>>> <property name="openjpa.jdbc.SynchronizeMappings"
>>> value="false" />
>>> </properties>
>>> </persistence-unit>
>>> </persistence>
>>>
>>> _geronimo-web.xml:_
>>>
>>> Remove all of the persistence unit info ->
>>>
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>>> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>>> <sys:environment>
>>> <sys:moduleId>
>>> <sys:groupId>jbasic</sys:groupId>
>>> <sys:artifactId>jbasic2</sys:artifactId>
>>> <sys:type>war</sys:type>
>>> </sys:moduleId>
>>> <sys:dependencies>
>>> <sys:dependency>
>>> <sys:groupId>console.dbpool</sys:groupId>
>>> <sys:artifactId>jbasicDB</sys:artifactId>
>>> <sys:version>1.0</sys:version>
>>> <sys:type>rar</sys:type>
>>> </sys:dependency> <sys:dependency>
>>> <sys:groupId>mysql</sys:groupId>
>>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>>> <sys:version>3.1.12</sys:version>
>>> <sys:type>jar</sys:type>
>>> </sys:dependency>
>>> </sys:dependencies>
>>> </sys:environment>
>>> <context-root>/jbasic2</context-root>
>>> </web-app>
>>>
>>> _web.xml:_
>>>
>>> Remove the peristence info.
>>>
>>> _database pool plan:_
>>>
>>> looks fine
>>>
>>>
>>> Then, in order to get an EntityManagerFactory in your servlets use
>>> resource injection to create a class variable:
>>>
>>> @PersistenceUnit(unitName="jbasicDB") private
>>> EntityManagerFactory emf;
>>>
>>> And finally, wherever you need access to an EntityManager:
>>>
>>> EntityManager em = emf.createEntityManager();
>>>
>>> em.getTransaction().begin();
>>>
>>> // do stuff
>>>
>>> em.getTransaction().commit();
>>>
>>> em.close();
>>>
>>> If you are only reading from your database, you can leave off the
>>> 'em.getTransaction()' stuff. But if you are modifying data - you
>>> will need these otherwise, when you close your EntityManager
>>> instances all of your changes go away.
>>>
>>> Hope this helps,
>>>
>>>
>>> Jay
>>>
>>> Peter Petersson wrote:
>>>> Hi
>>>>
>>>> Need help on resolving the following configuration problem.
>>>> I am trying to find out how to get a geronimo database pool (mysql)
>>>> used in a webapp, JPA managed in G v2.0 M6 (this is just a WAR not
>>>> a EAR).
>>>>
>>>> I end up stuck at deployment with the following error message.
>>>>
>>>> 13:42:42,291 ERROR [Deployer] Deployment failed due to
>>>> org.apache.geronimo.common.DeploymentException: At least one
>>>> deployment problem:[org.apache.geronimo.common.DeploymentException:
>>>> Could not resolve reference at deploy time for query
>>>> ?name=jbasicDB#org.apache.geronimo.persistence.PersistenceUnitGBean.
>>>> No GBean references found.]
>>>> at
>>>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder.buildNaming(PersistenceUnitRefBuilder.java:154)
>>>>
>>>> at
>>>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder$$FastClassByCGLIB$$9679ec9.invoke(<generated>)
>>>>
>>>>
>>>> I have looked around for G/JPA configuration information but the
>>>> ones I have found aether deals with G:s derby db (examples working
>>>> fine) or is a fully fledged EAR application which is a bit of an
>>>> overkill as this app is meant to be used as a educational "stepping
>>>> stone" app for some colleagues ( and me as it seems ;) ).
>>>>
>>>> I'm trying to get hold of the entity manager with the following
>>>> JNDI context lookup name "java:comp/env/jdbc/jbasicDB"
>>>>
>>>> Here is relevant (or not so) parts of the current incarnation of
>>>> the configuration:
>>>>
>>>> persistency.xml (in webapp/WEB-INF)
>>>> ------------------------------------------------
>>>> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>> version="1.0"
>>>>
>>>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>>>> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>>>>
>>>> <persistence-unit name="jbasicDB" transaction-type="JTA">
>>>>
>>>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>>>>
>>>> <jta-data-source>jdbc/jbasicDB</jta-data-source>
>>>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>>>> <exclude-unlisted-classes/>
>>>> <properties>
>>>> <property name="openjpa.jdbc.DBDictionary"
>>>> value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>
>>>> <property name="openjpa.ConnectionURL"
>>>> value="jdbc:mysql://localhost:3306/jbasic"/>
>>>> <property name="openjpa.ConnectionDriverName"
>>>> value="com.mysql.jdbc.Driver"/>
>>>> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
>>>> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
>>>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>>>> Tool=INFO"/>
>>>> </properties> </persistence-unit>
>>>> </persistence>
>>>> ------------------------------------------------
>>>>
>>>> geronimo-web.xml
>>>> ------------------------------------------------
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>>>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>>>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>>>> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>>>> <sys:environment>
>>>> <sys:moduleId>
>>>> <sys:groupId>jbasic</sys:groupId>
>>>> <sys:artifactId>jbasic2</sys:artifactId>
>>>> <sys:type>war</sys:type>
>>>> </sys:moduleId>
>>>> <sys:dependencies>
>>>> <sys:dependency>
>>>> <sys:groupId>console.dbpool</sys:groupId>
>>>> <sys:artifactId>jbasicDB</sys:artifactId>
>>>> <sys:version>1.0</sys:version>
>>>> <sys:type>rar</sys:type>
>>>> </sys:dependency> <sys:dependency>
>>>> <sys:groupId>mysql</sys:groupId>
>>>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>>>> <sys:version>3.1.12</sys:version>
>>>> <sys:type>jar</sys:type> </sys:dependency>
>>>> <!-- <sys:dependency>
>>>> <sys:groupId>org.apache.geronimo.configs</sys:groupId>
>>>> <sys:artifactId>openjpa</sys:artifactId>
>>>> <sys:type>car</sys:type>
>>>> </sys:dependency>
>>>> --> </sys:dependencies> </sys:environment>
>>>>
>>>> <context-root>/jbasic2</context-root>
>>>>
>>>> <persistence-unit-ref>
>>>>
>>>> <persistence-unit-ref-name>jdbc/jbasicDB</persistence-unit-ref-name>
>>>> <persistence-unit-name>jbasicDB</persistence-unit-name>
>>>> </persistence-unit-ref>
>>>>
>>>> <!-- <sys:resource-ref>
>>>> <sys:ref-name>jdbc/jbasicDB</sys:ref-name>
>>>> <sys:resource-link>jbasicDB</sys:resource-link>
>>>> </sys:resource-ref>
>>>> --> </web-app> ------------------------------------------------
>>>>
>>>> web.xml
>>>> ------------------------------------------------
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <web-app id="WebApp_ID" version="2.4"
>>>> xmlns="http://java.sun.com/xml/ns/j2ee"
>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
>>>> http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
>>>> <!-- Nothing much here yet --> <!-- <resource-ref>
>>>> <res-ref-name>jdbc/jbasicDB</res-ref-name>
>>>> <res-type>javax.sql.DataSource</res-type>
>>>> <res-auth>Container</res-auth>
>>>> <res-sharing-scope>Shareable</res-sharing-scope>
>>>> </resource-ref> --> </web-app>
>>>> ------------------------------------------------
>>>>
>>>> database pool plan
>>>> ------------------------------------------------
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <connector
>>>> xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
>>>> <dep:environment
>>>> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
>>>> <dep:moduleId>
>>>> <dep:groupId>console.dbpool</dep:groupId>
>>>> <dep:artifactId>jbasicDB</dep:artifactId>
>>>> <dep:version>1.0</dep:version>
>>>> <dep:type>rar</dep:type>
>>>> </dep:moduleId>
>>>> <dep:dependencies>
>>>> <dep:dependency>
>>>> <dep:groupId>mysql</dep:groupId>
>>>> <dep:artifactId>mysql-connector-java</dep:artifactId>
>>>> <dep:version>3.1.12</dep:version>
>>>> <dep:type>jar</dep:type>
>>>> </dep:dependency>
>>>> </dep:dependencies>
>>>> </dep:environment>
>>>> <resourceadapter>
>>>> <outbound-resourceadapter>
>>>> <connection-definition>
>>>>
>>>> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
>>>>
>>>> <connectiondefinition-instance>
>>>> <name>jbasicDB</name>
>>>> <config-property-setting
>>>> name="Password">xxxx</config-property-setting>
>>>> <config-property-setting
>>>> name="Driver">com.mysql.jdbc.Driver</config-property-setting>
>>>> <config-property-setting
>>>> name="UserName">xxxx</config-property-setting>
>>>> <config-property-setting
>>>> name="ConnectionURL">jdbc:mysql://localhost:3306/jbasic</config-property-setting>
>>>>
>>>> <connectionmanager>
>>>> <local-transaction/>
>>>> <single-pool>
>>>> <max-size>10</max-size>
>>>> <min-size>0</min-size>
>>>> <match-one/>
>>>> </single-pool>
>>>> </connectionmanager>
>>>> </connectiondefinition-instance>
>>>> </connection-definition>
>>>> </outbound-resourceadapter>
>>>> </resourceadapter>
>>>> </connector>
>>>> ------------------------------------------------
>>>>
>>>> Anny help is appreciated !
>>>> /Peter Petersson
>>>>
>>>>
>>>>
>>>
>>>
>>>
>
>
>
>
Re: Web app with jpa -- configuration help needed
Posted by David Jencks <da...@yahoo.com>.
I'm not sure jays' info is correct.
You can get an EntityManager in a servlet as long as you look it up
in jndi, just don't inject it using annotations or cache it in a
field in your servlet.
I think the problem is that you are looking up java:comp/env/jdbc/
jBasicDB which is where the datasource is expected to be, not the
EntityManager. Also in your geronimo plan you have a persistence-
unit-ref specified but you want a persistence-context-ref since you
are looking for an EntityManager, not an EntityManagerFactory.
I would suggest that you look up java:comp/env/jBasicDB in your
servlet, and include this in your web.xml and then you won't need
anything in your geronimo-web plan:
<persistence-context-ref>
<persistence-context-ref-name>jBasicDB</persistence-context-ref-
name>
<!-- I can't remember if anything else is required -->
</persistence-context-ref>
Also I strongly recommend including a non-jta-datasource in the
persistence.xml, I haven't been able to get anything to work with
derby without that. mysql may be more forgiving/less prone to weird
deadlocks. Leave out all the connect-to-mysql parameters in
persistence.xml and use the datasource.
You don't need a resource-ref anywhere if you aren't using the db
directly from your servlet.
I assume you've found the jpa sample under testsuite/.....? It uses
derby but does show a (usually) working configuration.
Hope this helps
david jencks
On Jun 15, 2007, at 12:20 PM, Jay D. McHugh wrote:
> Peter,
>
> I just realized - if you are doing resource_local access, you don't
> actually need the database pool.
>
> OpenJPA will create connections as it needs them.
>
> I would leave the database pool there though - it doesn't hurt
> anyone having it there.
>
> Once you manage to get your app deployed, take a look in the jmx
> viewer of the admin console under J2EE Managed Objects/Persistence
> Unit to make sure it got deployed correctly. Also, when you
> deploy, there will be a message dumped to the log about a property
> being unrecognized - you can ignore it. It is an issue with
> OpenJPA that already has a JIRA filed for it.
>
> Make sure you have the synchronizeMappings property set in your
> persistence.xml - otherwise the Geronimo default will kick in and
> try to recreate your tables and destroy all of your data.
>
> If I have time to try fixing my app to use the jta datasource -
> I'll let you know what needs to change.
>
>
> Jay
>
> Jay D. McHugh wrote:
>> Hi Peter,
>>
>> In a webapp, you are not allowed to directly get an EntityManager
>> (they aren't threadsafe). Instead, you need to get an
>> EntityManagerFactory.
>>
>> I was originally not able to get access to a jta-datasource, I had
>> to go with resource-local. I never went back to try accessing a
>> database pool - so I'm going to tell you how I got things working
>> in my current setup (using your values).
>>
>> _persistence.xml
>>
>> _<?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"
>> version="1.0"
>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>> <persistence-unit transaction-type="RESOURCE_LOCAL"
>> name="jbasicDB">
>>
>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</
>> provider>
>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>> <exclude-unlisted-classes />
>> <properties>
>> <property name="openjpa.ConnectionURL"
>> value="jdbc:mysql://localhost:3306/jbasic"/>
>> <property name="openjpa.ConnectionDriverName"
>> value="com.mysql.jdbc.Driver"/>
>> <property name="openjpa.ConnectionUserName"
>> value="xxxxx"/>
>> <property name="openjpa.ConnectionPassword"
>> value="xxxxx"/>
>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>> Tool=INFO"/>
>> <property name="openjpa.jdbc.DBDictionary" value="mysql
>> (SupportsSubselect=true)" />
>> <property name="openjpa.Log" value="DefaultLevel=INFO" />
>> <property name="openjpa.AutoDetach" value="close" />
>> <property name="openjpa.DetachState" value="all" />
>> <property name="openjpa.DataCache" value="false" />
>> <property name="openjpa.Optimistic" value="true" />
>> <property name="openjpa.Multithreaded" value="true" />
>> <property name="openjpa.TransactionMode" value="local" />
>> <property name="openjpa.NontransactionalRead"
>> value="true" />
>> <property name="openjpa.RestoreState" value="all" />
>> <property name="openjpa.jdbc.SynchronizeMappings"
>> value="false" />
>> </properties>
>> </persistence-unit>
>> </persistence>
>>
>> _geronimo-web.xml:_
>>
>> Remove all of the persistence unit info ->
>>
>> <?xml version="1.0" encoding="UTF-8"?>
>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>> <sys:environment>
>> <sys:moduleId>
>> <sys:groupId>jbasic</sys:groupId>
>> <sys:artifactId>jbasic2</sys:artifactId>
>> <sys:type>war</sys:type>
>> </sys:moduleId>
>> <sys:dependencies>
>> <sys:dependency>
>> <sys:groupId>console.dbpool</sys:groupId>
>> <sys:artifactId>jbasicDB</sys:artifactId>
>> <sys:version>1.0</sys:version>
>> <sys:type>rar</sys:type>
>> </sys:dependency> <sys:dependency>
>> <sys:groupId>mysql</sys:groupId>
>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>> <sys:version>3.1.12</sys:version>
>> <sys:type>jar</sys:type>
>> </sys:dependency>
>> </sys:dependencies>
>> </sys:environment>
>> <context-root>/jbasic2</context-root>
>> </web-app>
>>
>> _web.xml:_
>>
>> Remove the peristence info.
>>
>> _database pool plan:_
>>
>> looks fine
>>
>>
>> Then, in order to get an EntityManagerFactory in your servlets use
>> resource injection to create a class variable:
>>
>> @PersistenceUnit(unitName="jbasicDB") private
>> EntityManagerFactory emf;
>>
>> And finally, wherever you need access to an EntityManager:
>>
>> EntityManager em = emf.createEntityManager();
>>
>> em.getTransaction().begin();
>>
>> // do stuff
>>
>> em.getTransaction().commit();
>>
>> em.close();
>>
>> If you are only reading from your database, you can leave off the
>> 'em.getTransaction()' stuff. But if you are modifying data - you
>> will need these otherwise, when you close your EntityManager
>> instances all of your changes go away.
>>
>> Hope this helps,
>>
>>
>> Jay
>>
>> Peter Petersson wrote:
>>> Hi
>>>
>>> Need help on resolving the following configuration problem.
>>> I am trying to find out how to get a geronimo database pool
>>> (mysql) used in a webapp, JPA managed in G v2.0 M6 (this is just
>>> a WAR not a EAR).
>>>
>>> I end up stuck at deployment with the following error message.
>>>
>>> 13:42:42,291 ERROR [Deployer] Deployment failed due to
>>> org.apache.geronimo.common.DeploymentException: At least one
>>> deployment problem:
>>> [org.apache.geronimo.common.DeploymentException: Could not
>>> resolve reference at deploy time for query ?
>>> name=jbasicDB#org.apache.geronimo.persistence.PersistenceUnitGBean.
>>> No GBean references found.]
>>> at
>>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder.bu
>>> ildNaming(PersistenceUnitRefBuilder.java:154)
>>> at
>>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder$
>>> $FastClassByCGLIB$$9679ec9.invoke(<generated>)
>>>
>>> I have looked around for G/JPA configuration information but the
>>> ones I have found aether deals with G:s derby db (examples
>>> working fine) or is a fully fledged EAR application which is a
>>> bit of an overkill as this app is meant to be used as a
>>> educational "stepping stone" app for some colleagues ( and me as
>>> it seems ;) ).
>>>
>>> I'm trying to get hold of the entity manager with the following
>>> JNDI context lookup name "java:comp/env/jdbc/jbasicDB"
>>>
>>> Here is relevant (or not so) parts of the current incarnation of
>>> the configuration:
>>>
>>> persistency.xml (in webapp/WEB-INF)
>>> ------------------------------------------------
>>> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>> version="1.0"
>>> xsi:schemaLocation="http://java.sun.com/xml/ns/
>>> persistence http://java.sun.com/xml/ns/persistence/
>>> persistence_1_0.xsd">
>>>
>>> <persistence-unit name="jbasicDB" transaction-type="JTA">
>>>
>>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</
>>> provider>
>>> <jta-data-source>jdbc/jbasicDB</jta-data-source>
>>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>>> <exclude-unlisted-classes/>
>>> <properties>
>>> <property name="openjpa.jdbc.DBDictionary"
>>> value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>
>>> <property name="openjpa.ConnectionURL" value="jdbc:mysql://
>>> localhost:3306/jbasic"/>
>>> <property name="openjpa.ConnectionDriverName"
>>> value="com.mysql.jdbc.Driver"/>
>>> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
>>> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
>>> <property name="openjpa.Log" value="DefaultLevel=WARN,
>>> Tool=INFO"/>
>>> </properties> </persistence-unit>
>>> </persistence>
>>> ------------------------------------------------
>>>
>>> geronimo-web.xml
>>> ------------------------------------------------
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>>> xmlns:sys="http://geronimo.apache.org/xml/ns/
>>> deployment-1.1">
>>> <sys:environment>
>>> <sys:moduleId>
>>> <sys:groupId>jbasic</sys:groupId>
>>> <sys:artifactId>jbasic2</sys:artifactId>
>>> <sys:type>war</sys:type>
>>> </sys:moduleId>
>>> <sys:dependencies>
>>> <sys:dependency>
>>> <sys:groupId>console.dbpool</sys:groupId>
>>> <sys:artifactId>jbasicDB</sys:artifactId>
>>> <sys:version>1.0</sys:version>
>>> <sys:type>rar</sys:type>
>>> </sys:dependency> <sys:dependency>
>>> <sys:groupId>mysql</sys:groupId>
>>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>>> <sys:version>3.1.12</sys:version>
>>> <sys:type>jar</sys:type> </sys:dependency>
>>> <!-- <sys:dependency>
>>> <sys:groupId>org.apache.geronimo.configs</sys:groupId>
>>> <sys:artifactId>openjpa</sys:artifactId>
>>> <sys:type>car</sys:type>
>>> </sys:dependency>
>>> --> </sys:dependencies> </sys:environment>
>>>
>>> <context-root>/jbasic2</context-root>
>>>
>>> <persistence-unit-ref>
>>> <persistence-unit-ref-name>jdbc/jbasicDB</persistence-unit-
>>> ref-name>
>>> <persistence-unit-name>jbasicDB</persistence-unit-name>
>>> </persistence-unit-ref>
>>>
>>> <!-- <sys:resource-ref>
>>> <sys:ref-name>jdbc/jbasicDB</sys:ref-name>
>>> <sys:resource-link>jbasicDB</sys:resource-link>
>>> </sys:resource-ref>
>>> --> </web-app> ------------------------------------------------
>>>
>>> web.xml
>>> ------------------------------------------------
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <web-app id="WebApp_ID" version="2.4"
>>> xmlns="http://java.sun.com/xml/ns/j2ee"
>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://
>>> java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
>>> <!-- Nothing much here yet --> <!-- <resource-ref>
>>> <res-ref-name>jdbc/jbasicDB</res-ref-name>
>>> <res-type>javax.sql.DataSource</res-type>
>>> <res-auth>Container</res-auth>
>>> <res-sharing-scope>Shareable</res-sharing-scope>
>>> </resource-ref> --> </web-app>
>>> ------------------------------------------------
>>>
>>> database pool plan
>>> ------------------------------------------------
>>> <?xml version="1.0" encoding="UTF-8"?>
>>> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/
>>> connector-1.2">
>>> <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/
>>> deployment-1.2">
>>> <dep:moduleId>
>>> <dep:groupId>console.dbpool</dep:groupId>
>>> <dep:artifactId>jbasicDB</dep:artifactId>
>>> <dep:version>1.0</dep:version>
>>> <dep:type>rar</dep:type>
>>> </dep:moduleId>
>>> <dep:dependencies>
>>> <dep:dependency>
>>> <dep:groupId>mysql</dep:groupId>
>>> <dep:artifactId>mysql-connector-java</dep:artifactId>
>>> <dep:version>3.1.12</dep:version>
>>> <dep:type>jar</dep:type>
>>> </dep:dependency>
>>> </dep:dependencies>
>>> </dep:environment>
>>> <resourceadapter>
>>> <outbound-resourceadapter>
>>> <connection-definition>
>>> <connectionfactory-interface>javax.sql.DataSource</
>>> connectionfactory-interface>
>>> <connectiondefinition-instance>
>>> <name>jbasicDB</name>
>>> <config-property-setting name="Password">xxxx</
>>> config-property-setting>
>>> <config-property-setting
>>> name="Driver">com.mysql.jdbc.Driver</config-property-setting>
>>> <config-property-setting name="UserName">xxxx</
>>> config-property-setting>
>>> <config-property-setting
>>> name="ConnectionURL">jdbc:mysql://localhost:3306/jbasic</config-
>>> property-setting>
>>> <connectionmanager>
>>> <local-transaction/>
>>> <single-pool>
>>> <max-size>10</max-size>
>>> <min-size>0</min-size>
>>> <match-one/>
>>> </single-pool>
>>> </connectionmanager>
>>> </connectiondefinition-instance>
>>> </connection-definition>
>>> </outbound-resourceadapter>
>>> </resourceadapter>
>>> </connector>
>>> ------------------------------------------------
>>>
>>> Anny help is appreciated !
>>> /Peter Petersson
>>>
>>>
>>>
>>
>>
>>
Re: Web app with jpa -- configuration help needed
Posted by "Jay D. McHugh" <ja...@joyfulnoisewebdesign.com>.
Peter,
I just realized - if you are doing resource_local access, you don't
actually need the database pool.
OpenJPA will create connections as it needs them.
I would leave the database pool there though - it doesn't hurt anyone
having it there.
Once you manage to get your app deployed, take a look in the jmx viewer
of the admin console under J2EE Managed Objects/Persistence Unit to make
sure it got deployed correctly. Also, when you deploy, there will be a
message dumped to the log about a property being unrecognized - you can
ignore it. It is an issue with OpenJPA that already has a JIRA filed
for it.
Make sure you have the synchronizeMappings property set in your
persistence.xml - otherwise the Geronimo default will kick in and try to
recreate your tables and destroy all of your data.
If I have time to try fixing my app to use the jta datasource - I'll let
you know what needs to change.
Jay
Jay D. McHugh wrote:
> Hi Peter,
>
> In a webapp, you are not allowed to directly get an EntityManager
> (they aren't threadsafe). Instead, you need to get an
> EntityManagerFactory.
>
> I was originally not able to get access to a jta-datasource, I had to
> go with resource-local. I never went back to try accessing a database
> pool - so I'm going to tell you how I got things working in my current
> setup (using your values).
>
> _persistence.xml
>
> _<?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" version="1.0"
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
> <persistence-unit transaction-type="RESOURCE_LOCAL" name="jbasicDB">
>
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>
> <class>nu.m4u.jbasic.control.jpa.Users</class>
> <exclude-unlisted-classes />
> <properties>
> <property name="openjpa.ConnectionURL"
> value="jdbc:mysql://localhost:3306/jbasic"/>
> <property name="openjpa.ConnectionDriverName"
> value="com.mysql.jdbc.Driver"/>
> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
> <property name="openjpa.Log" value="DefaultLevel=WARN,
> Tool=INFO"/>
> <property name="openjpa.jdbc.DBDictionary"
> value="mysql(SupportsSubselect=true)" />
> <property name="openjpa.Log" value="DefaultLevel=INFO" />
> <property name="openjpa.AutoDetach" value="close" />
> <property name="openjpa.DetachState" value="all" />
> <property name="openjpa.DataCache" value="false" />
> <property name="openjpa.Optimistic" value="true" />
> <property name="openjpa.Multithreaded" value="true" />
> <property name="openjpa.TransactionMode" value="local" />
> <property name="openjpa.NontransactionalRead" value="true" />
> <property name="openjpa.RestoreState" value="all" />
> <property name="openjpa.jdbc.SynchronizeMappings"
> value="false" />
> </properties>
> </persistence-unit>
> </persistence>
>
> _geronimo-web.xml:_
>
> Remove all of the persistence unit info ->
>
> <?xml version="1.0" encoding="UTF-8"?>
> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
> <sys:environment>
> <sys:moduleId>
> <sys:groupId>jbasic</sys:groupId>
> <sys:artifactId>jbasic2</sys:artifactId>
> <sys:type>war</sys:type>
> </sys:moduleId>
> <sys:dependencies>
> <sys:dependency>
> <sys:groupId>console.dbpool</sys:groupId>
> <sys:artifactId>jbasicDB</sys:artifactId>
> <sys:version>1.0</sys:version>
> <sys:type>rar</sys:type>
> </sys:dependency> <sys:dependency>
> <sys:groupId>mysql</sys:groupId>
> <sys:artifactId>mysql-connector-java</sys:artifactId>
> <sys:version>3.1.12</sys:version>
> <sys:type>jar</sys:type>
> </sys:dependency>
> </sys:dependencies>
> </sys:environment>
> <context-root>/jbasic2</context-root>
> </web-app>
>
> _web.xml:_
>
> Remove the peristence info.
>
> _database pool plan:_
>
> looks fine
>
>
> Then, in order to get an EntityManagerFactory in your servlets use
> resource injection to create a class variable:
>
> @PersistenceUnit(unitName="jbasicDB") private EntityManagerFactory
> emf;
>
> And finally, wherever you need access to an EntityManager:
>
> EntityManager em = emf.createEntityManager();
>
> em.getTransaction().begin();
>
> // do stuff
>
> em.getTransaction().commit();
>
> em.close();
>
> If you are only reading from your database, you can leave off the
> 'em.getTransaction()' stuff. But if you are modifying data - you will
> need these otherwise, when you close your EntityManager instances all
> of your changes go away.
>
> Hope this helps,
>
>
> Jay
>
> Peter Petersson wrote:
>> Hi
>>
>> Need help on resolving the following configuration problem.
>> I am trying to find out how to get a geronimo database pool (mysql)
>> used in a webapp, JPA managed in G v2.0 M6 (this is just a WAR not a
>> EAR).
>>
>> I end up stuck at deployment with the following error message.
>>
>> 13:42:42,291 ERROR [Deployer] Deployment failed due to
>> org.apache.geronimo.common.DeploymentException: At least one
>> deployment problem:[org.apache.geronimo.common.DeploymentException:
>> Could not resolve reference at deploy time for query
>> ?name=jbasicDB#org.apache.geronimo.persistence.PersistenceUnitGBean.
>> No GBean references found.]
>> at
>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder.buildNaming(PersistenceUnitRefBuilder.java:154)
>>
>> at
>> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder$$FastClassByCGLIB$$9679ec9.invoke(<generated>)
>>
>>
>> I have looked around for G/JPA configuration information but the ones
>> I have found aether deals with G:s derby db (examples working fine)
>> or is a fully fledged EAR application which is a bit of an overkill
>> as this app is meant to be used as a educational "stepping stone" app
>> for some colleagues ( and me as it seems ;) ).
>>
>> I'm trying to get hold of the entity manager with the following JNDI
>> context lookup name "java:comp/env/jdbc/jbasicDB"
>>
>> Here is relevant (or not so) parts of the current incarnation of the
>> configuration:
>>
>> persistency.xml (in webapp/WEB-INF)
>> ------------------------------------------------
>> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> version="1.0"
>>
>> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
>> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>>
>> <persistence-unit name="jbasicDB" transaction-type="JTA">
>>
>> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>>
>> <jta-data-source>jdbc/jbasicDB</jta-data-source>
>> <class>nu.m4u.jbasic.control.jpa.Users</class>
>> <exclude-unlisted-classes/>
>> <properties>
>> <property name="openjpa.jdbc.DBDictionary"
>> value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>
>> <property name="openjpa.ConnectionURL"
>> value="jdbc:mysql://localhost:3306/jbasic"/>
>> <property name="openjpa.ConnectionDriverName"
>> value="com.mysql.jdbc.Driver"/>
>> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
>> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
>> <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
>> </properties> </persistence-unit>
>> </persistence>
>> ------------------------------------------------
>>
>> geronimo-web.xml
>> ------------------------------------------------
>> <?xml version="1.0" encoding="UTF-8"?>
>> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
>> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
>> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
>> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
>> <sys:environment>
>> <sys:moduleId>
>> <sys:groupId>jbasic</sys:groupId>
>> <sys:artifactId>jbasic2</sys:artifactId>
>> <sys:type>war</sys:type>
>> </sys:moduleId>
>> <sys:dependencies>
>> <sys:dependency>
>> <sys:groupId>console.dbpool</sys:groupId>
>> <sys:artifactId>jbasicDB</sys:artifactId>
>> <sys:version>1.0</sys:version>
>> <sys:type>rar</sys:type>
>> </sys:dependency> <sys:dependency>
>> <sys:groupId>mysql</sys:groupId>
>> <sys:artifactId>mysql-connector-java</sys:artifactId>
>> <sys:version>3.1.12</sys:version>
>> <sys:type>jar</sys:type> </sys:dependency>
>> <!-- <sys:dependency>
>> <sys:groupId>org.apache.geronimo.configs</sys:groupId>
>> <sys:artifactId>openjpa</sys:artifactId>
>> <sys:type>car</sys:type>
>> </sys:dependency>
>> --> </sys:dependencies> </sys:environment>
>>
>> <context-root>/jbasic2</context-root>
>>
>> <persistence-unit-ref>
>> <persistence-unit-ref-name>jdbc/jbasicDB</persistence-unit-ref-name>
>> <persistence-unit-name>jbasicDB</persistence-unit-name>
>> </persistence-unit-ref>
>>
>> <!-- <sys:resource-ref>
>> <sys:ref-name>jdbc/jbasicDB</sys:ref-name>
>> <sys:resource-link>jbasicDB</sys:resource-link>
>> </sys:resource-ref>
>> --> </web-app> ------------------------------------------------
>>
>> web.xml
>> ------------------------------------------------
>> <?xml version="1.0" encoding="UTF-8"?>
>> <web-app id="WebApp_ID" version="2.4"
>> xmlns="http://java.sun.com/xml/ns/j2ee"
>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
>> http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
>> <!-- Nothing much here yet --> <!-- <resource-ref>
>> <res-ref-name>jdbc/jbasicDB</res-ref-name>
>> <res-type>javax.sql.DataSource</res-type>
>> <res-auth>Container</res-auth>
>> <res-sharing-scope>Shareable</res-sharing-scope>
>> </resource-ref> --> </web-app>
>> ------------------------------------------------
>>
>> database pool plan
>> ------------------------------------------------
>> <?xml version="1.0" encoding="UTF-8"?>
>> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
>> <dep:environment
>> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
>> <dep:moduleId>
>> <dep:groupId>console.dbpool</dep:groupId>
>> <dep:artifactId>jbasicDB</dep:artifactId>
>> <dep:version>1.0</dep:version>
>> <dep:type>rar</dep:type>
>> </dep:moduleId>
>> <dep:dependencies>
>> <dep:dependency>
>> <dep:groupId>mysql</dep:groupId>
>> <dep:artifactId>mysql-connector-java</dep:artifactId>
>> <dep:version>3.1.12</dep:version>
>> <dep:type>jar</dep:type>
>> </dep:dependency>
>> </dep:dependencies>
>> </dep:environment>
>> <resourceadapter>
>> <outbound-resourceadapter>
>> <connection-definition>
>>
>> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
>>
>> <connectiondefinition-instance>
>> <name>jbasicDB</name>
>> <config-property-setting
>> name="Password">xxxx</config-property-setting>
>> <config-property-setting
>> name="Driver">com.mysql.jdbc.Driver</config-property-setting>
>> <config-property-setting
>> name="UserName">xxxx</config-property-setting>
>> <config-property-setting
>> name="ConnectionURL">jdbc:mysql://localhost:3306/jbasic</config-property-setting>
>>
>> <connectionmanager>
>> <local-transaction/>
>> <single-pool>
>> <max-size>10</max-size>
>> <min-size>0</min-size>
>> <match-one/>
>> </single-pool>
>> </connectionmanager>
>> </connectiondefinition-instance>
>> </connection-definition>
>> </outbound-resourceadapter>
>> </resourceadapter>
>> </connector>
>> ------------------------------------------------
>>
>> Anny help is appreciated !
>> /Peter Petersson
>>
>>
>>
>
>
>
Re: Web app with jpa -- configuration help needed
Posted by "Jay D. McHugh" <ja...@joyfulnoisewebdesign.com>.
Hi Peter,
In a webapp, you are not allowed to directly get an EntityManager (they
aren't threadsafe). Instead, you need to get an EntityManagerFactory.
I was originally not able to get access to a jta-datasource, I had to go
with resource-local. I never went back to try accessing a database pool
- so I'm going to tell you how I got things working in my current setup
(using your values).
_persistence.xml
_<?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" version="1.0"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit transaction-type="RESOURCE_LOCAL" name="jbasicDB">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<class>nu.m4u.jbasic.control.jpa.Users</class>
<exclude-unlisted-classes />
<properties>
<property name="openjpa.ConnectionURL"
value="jdbc:mysql://localhost:3306/jbasic"/>
<property name="openjpa.ConnectionDriverName"
value="com.mysql.jdbc.Driver"/>
<property name="openjpa.ConnectionUserName" value="xxxxx"/>
<property name="openjpa.ConnectionPassword" value="xxxxx"/>
<property name="openjpa.Log" value="DefaultLevel=WARN,
Tool=INFO"/>
<property name="openjpa.jdbc.DBDictionary"
value="mysql(SupportsSubselect=true)" />
<property name="openjpa.Log" value="DefaultLevel=INFO" />
<property name="openjpa.AutoDetach" value="close" />
<property name="openjpa.DetachState" value="all" />
<property name="openjpa.DataCache" value="false" />
<property name="openjpa.Optimistic" value="true" />
<property name="openjpa.Multithreaded" value="true" />
<property name="openjpa.TransactionMode" value="local" />
<property name="openjpa.NontransactionalRead" value="true" />
<property name="openjpa.RestoreState" value="all" />
<property name="openjpa.jdbc.SynchronizeMappings"
value="false" />
</properties>
</persistence-unit>
</persistence>
_geronimo-web.xml:_
Remove all of the persistence unit info ->
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
<sys:environment>
<sys:moduleId>
<sys:groupId>jbasic</sys:groupId>
<sys:artifactId>jbasic2</sys:artifactId>
<sys:type>war</sys:type>
</sys:moduleId>
<sys:dependencies>
<sys:dependency>
<sys:groupId>console.dbpool</sys:groupId>
<sys:artifactId>jbasicDB</sys:artifactId>
<sys:version>1.0</sys:version>
<sys:type>rar</sys:type>
</sys:dependency> <sys:dependency>
<sys:groupId>mysql</sys:groupId>
<sys:artifactId>mysql-connector-java</sys:artifactId>
<sys:version>3.1.12</sys:version>
<sys:type>jar</sys:type>
</sys:dependency>
</sys:dependencies>
</sys:environment>
<context-root>/jbasic2</context-root>
</web-app>
_web.xml:_
Remove the peristence info.
_database pool plan:_
looks fine
Then, in order to get an EntityManagerFactory in your servlets use
resource injection to create a class variable:
@PersistenceUnit(unitName="jbasicDB") private EntityManagerFactory emf;
And finally, wherever you need access to an EntityManager:
EntityManager em = emf.createEntityManager();
em.getTransaction().begin();
// do stuff
em.getTransaction().commit();
em.close();
If you are only reading from your database, you can leave off the
'em.getTransaction()' stuff. But if you are modifying data - you will
need these otherwise, when you close your EntityManager instances all of
your changes go away.
Hope this helps,
Jay
Peter Petersson wrote:
> Hi
>
> Need help on resolving the following configuration problem.
> I am trying to find out how to get a geronimo database pool (mysql)
> used in a webapp, JPA managed in G v2.0 M6 (this is just a WAR not a
> EAR).
>
> I end up stuck at deployment with the following error message.
>
> 13:42:42,291 ERROR [Deployer] Deployment failed due to
> org.apache.geronimo.common.DeploymentException: At least one
> deployment problem:[org.apache.geronimo.common.DeploymentException:
> Could not resolve reference at deploy time for query
> ?name=jbasicDB#org.apache.geronimo.persistence.PersistenceUnitGBean.
> No GBean references found.]
> at
> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder.buildNaming(PersistenceUnitRefBuilder.java:154)
>
> at
> org.apache.geronimo.persistence.builder.PersistenceUnitRefBuilder$$FastClassByCGLIB$$9679ec9.invoke(<generated>)
>
>
> I have looked around for G/JPA configuration information but the ones
> I have found aether deals with G:s derby db (examples working fine) or
> is a fully fledged EAR application which is a bit of an overkill as
> this app is meant to be used as a educational "stepping stone" app for
> some colleagues ( and me as it seems ;) ).
>
> I'm trying to get hold of the entity manager with the following JNDI
> context lookup name "java:comp/env/jdbc/jbasicDB"
>
> Here is relevant (or not so) parts of the current incarnation of the
> configuration:
>
> persistency.xml (in webapp/WEB-INF)
> ------------------------------------------------
> <persistence xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> version="1.0"
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
>
> <persistence-unit name="jbasicDB" transaction-type="JTA">
>
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
>
> <jta-data-source>jdbc/jbasicDB</jta-data-source>
> <class>nu.m4u.jbasic.control.jpa.Users</class>
> <exclude-unlisted-classes/>
> <properties>
> <property name="openjpa.jdbc.DBDictionary"
> value="org.apache.openjpa.jdbc.sql.MySQLDictionary"/>
> <property name="openjpa.ConnectionURL"
> value="jdbc:mysql://localhost:3306/jbasic"/>
> <property name="openjpa.ConnectionDriverName"
> value="com.mysql.jdbc.Driver"/>
> <property name="openjpa.ConnectionUserName" value="xxxxx"/>
> <property name="openjpa.ConnectionPassword" value="xxxxx"/>
> <property name="openjpa.Log" value="DefaultLevel=WARN, Tool=INFO"/>
> </properties> </persistence-unit>
> </persistence>
> ------------------------------------------------
>
> geronimo-web.xml
> ------------------------------------------------
> <?xml version="1.0" encoding="UTF-8"?>
> <web-app xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.2"
> xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1"
> xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1"
> xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1">
> <sys:environment>
> <sys:moduleId>
> <sys:groupId>jbasic</sys:groupId>
> <sys:artifactId>jbasic2</sys:artifactId>
> <sys:type>war</sys:type>
> </sys:moduleId>
> <sys:dependencies>
> <sys:dependency>
> <sys:groupId>console.dbpool</sys:groupId>
> <sys:artifactId>jbasicDB</sys:artifactId>
> <sys:version>1.0</sys:version>
> <sys:type>rar</sys:type>
> </sys:dependency> <sys:dependency>
> <sys:groupId>mysql</sys:groupId>
> <sys:artifactId>mysql-connector-java</sys:artifactId>
> <sys:version>3.1.12</sys:version>
> <sys:type>jar</sys:type> </sys:dependency>
> <!-- <sys:dependency>
> <sys:groupId>org.apache.geronimo.configs</sys:groupId>
> <sys:artifactId>openjpa</sys:artifactId>
> <sys:type>car</sys:type>
> </sys:dependency>
> --> </sys:dependencies> </sys:environment>
>
> <context-root>/jbasic2</context-root>
>
> <persistence-unit-ref>
> <persistence-unit-ref-name>jdbc/jbasicDB</persistence-unit-ref-name>
> <persistence-unit-name>jbasicDB</persistence-unit-name>
> </persistence-unit-ref>
>
> <!-- <sys:resource-ref>
> <sys:ref-name>jdbc/jbasicDB</sys:ref-name>
> <sys:resource-link>jbasicDB</sys:resource-link>
> </sys:resource-ref>
> -->
> </web-app> ------------------------------------------------
>
> web.xml
> ------------------------------------------------
> <?xml version="1.0" encoding="UTF-8"?>
> <web-app id="WebApp_ID" version="2.4"
> xmlns="http://java.sun.com/xml/ns/j2ee"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
> http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
> <!-- Nothing much here yet --> <!-- <resource-ref>
> <res-ref-name>jdbc/jbasicDB</res-ref-name>
> <res-type>javax.sql.DataSource</res-type>
> <res-auth>Container</res-auth>
> <res-sharing-scope>Shareable</res-sharing-scope>
> </resource-ref> --> </web-app>
> ------------------------------------------------
>
> database pool plan
> ------------------------------------------------
> <?xml version="1.0" encoding="UTF-8"?>
> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
> <dep:environment
> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
> <dep:moduleId>
> <dep:groupId>console.dbpool</dep:groupId>
> <dep:artifactId>jbasicDB</dep:artifactId>
> <dep:version>1.0</dep:version>
> <dep:type>rar</dep:type>
> </dep:moduleId>
> <dep:dependencies>
> <dep:dependency>
> <dep:groupId>mysql</dep:groupId>
> <dep:artifactId>mysql-connector-java</dep:artifactId>
> <dep:version>3.1.12</dep:version>
> <dep:type>jar</dep:type>
> </dep:dependency>
> </dep:dependencies>
> </dep:environment>
> <resourceadapter>
> <outbound-resourceadapter>
> <connection-definition>
>
> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
>
> <connectiondefinition-instance>
> <name>jbasicDB</name>
> <config-property-setting
> name="Password">xxxx</config-property-setting>
> <config-property-setting
> name="Driver">com.mysql.jdbc.Driver</config-property-setting>
> <config-property-setting
> name="UserName">xxxx</config-property-setting>
> <config-property-setting
> name="ConnectionURL">jdbc:mysql://localhost:3306/jbasic</config-property-setting>
>
> <connectionmanager>
> <local-transaction/>
> <single-pool>
> <max-size>10</max-size>
> <min-size>0</min-size>
> <match-one/>
> </single-pool>
> </connectionmanager>
> </connectiondefinition-instance>
> </connection-definition>
> </outbound-resourceadapter>
> </resourceadapter>
> </connector>
> ------------------------------------------------
>
> Anny help is appreciated !
> /Peter Petersson
>
>
>