Hi I added resource configuration to the web.xml of axis2, and tried also to make a web.xml for the web service but neither of this worked. Any onther tips, it world be realy nice to get this to work for me
cheers, Håkon 2008/11/3 Jeremy Bauer <[EMAIL PROTECTED]> > 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) > >> > > > -- Håkon Sagehaug, Software Developer Parallab, Bergen Center for Computational Science (BCCS) UNIFOB AS (University of Bergen Research Company)
