hi Some more information
Since the ws is running inside axis2 i used this context tag configuration in server.xml <Context path="/axis2" docBase="axis2" debug="5" reloadable="true" crossContext="true"> <Resource name="jdbc/workflowdb" auth="Container" type="javax.sql.DataSource" maxActive="5" maxIdle="5" maxWait="10000" username="user" password="password" driverClassName="org.postgresql.Driver" url="jdbc:postgresql://hostname/Workflows"/> </Context> 2008/11/3 Håkon Sagehaug <[EMAIL PROTECTED]> > Hi > > Yes I've tried this, but still gets the same message, any other hints ?? > > I use openjpa 1.2.0 , tomcat 5.5.26 and axis2 1.3 if this is of use > > cheers, Håkon > > 2008/11/3 Michael Dick <[EMAIL PROTECTED]> > > 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) >> > >> > > > > -- > Håkon Sagehaug, Software Developer > Parallab, Bergen Center for Computational Science (BCCS) > UNIFOB AS (University of Bergen Research Company) > -- Håkon Sagehaug, Software Developer Parallab, Bergen Center for Computational Science (BCCS) UNIFOB AS (University of Bergen Research Company)