openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Håkon Sagehaug" <Hakon.Sageh...@bccs.uib.no>
Subject Re: Using datasource from tomcat with openjpa
Date Mon, 03 Nov 2008 15:40:58 GMT
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 <Hakon.Sagehaug@bccs.uib.no>

> 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 <michael.d.dick@gmail.com>
>
> 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
>> <Hakon.Sagehaug@bccs.uib.no>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)

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message