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)
