You may also need to define a resource reference in your web.xml. This link contains a good example on how to configure and use a data source: http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto.html. The configuration part is what is important for OpenJPA, since it just looks up the data source via the JNDI name provided in the <jta-data-source> element (as Mike pointed out).
-Jeremy On Mon, Nov 3, 2008 at 9:22 AM, Michael Dick <[EMAIL PROTECTED]> wrote: > Have you tried > <jta-data-source>java:comp/env/jdbc/workflowdb</jta-data-source> instead of > the property for openjpa.ConnectionFactoryName? > > -mike > > On Mon, Nov 3, 2008 at 8:22 AM, Håkon Sagehaug > <[EMAIL PROTECTED]>wrote: > >> Hi all, >> >> I've got a axis2 web service that is deployed in tomcat and talk to a >> database using openjpa. This works fine when I just use the persistent xml >> to configure my db connection, but now I want to use tomcat to configure >> the >> datasource. Here is my set-up >> >> persistent.xml >> >> >> <persistence-unit name="MyOpenJPa" transaction-type="RESOURCE_LOCAL"> >> >> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider> >> >> <class>demo.hibernate.MyPerson</class> >> <properties> >> <property name="openjpa.ConnectionFactoryName" >> value="java:comp/env/jdbc/workflowdb" /> >> <property name="openjpa.Log" value="DefaultLevel=INFO, >> Tool=INFO" /> >> <property name="openjpa.Sequence" >> value="table(Table=OPENJPA_SEQUENCE_TABLE, Increment=1)"/> >> >> </properties> >> </persistence-unit> >> >> In tomcat's service xml I've got this >> >> <Resource name="jdbc/workflowdb" auth="Container" >> type="javax.sql.DataSource" >> maxActive="5" maxIdle="5" maxWait="10000" >> username="name" password="password" >> driverClassName="org.postgresql.Driver" >> url="jdbc:postgresql://hostname/Workflows"/> >> >> I tried to put it into the <GlobalNamingResources> tag and inside a >> <Context> tag using the axis2 as path, but I always get this error back >> >> A JDBC Driver or DataSource class name must be specified in the >> ConnectionDriverName property. >> >> Does anyone have a good tip on how to get this to work?? >> >> cheers, Håkon >> >> -- >> Håkon Sagehaug, Software Developer >> Parallab, Bergen Center for Computational Science (BCCS) >> UNIFOB AS (University of Bergen Research Company) >> >
