Hi I think you may have to send me all ;). I tried from the beginning with a clean tomcat and axis 2 install, and configured like you said, but still the same problem, so if you could send me what you think I need for getting it to work I would appreciate it
cheers, Håkon 2008/11/3 Jeremy Bauer <[EMAIL PROTECTED]> > Are you running a packaged service within the Axis2 app (an .aar archive) > or > is your service deployed as part of a separate web application? I was able > to get an OpenJPA-based Axis2 service to work deployed within a standalone > web application. I used Tomcat 5.5, Axis 2-1.4.1 and OpenJPA 1.2.0. > I simply added this entry to my <tomcat_home>/conf/context.xml: > > <Resource name="jdbc/TestDB" auth="Container" > type="javax.sql.DataSource" > maxActive="20" maxIdle="10" maxWait="10000" > username="yourusername" password="yourpassword" > driverClassName="com.mysql.jdbc.Driver" > url="jdbc:mysql://localhost:3306/testdb?autoReconnect=true"/> > > And referenced the data source in my persistence.xml: > > <persistence-unit name="Tomcat"> > <jta-data-source>java:comp/env/jdbc/TestDB</jta-data-source> > <class>entities.TestData</class> > </persistence-unit> > > I also added the OpenJPA jar and necessary supporting jars > to <tomcat_home>/common/lib. > > If you'd like a copy of my .war with source please let me know. The .war > contains Axis2 binaries, which are quite large, so I won't post it to the > forum. I'd guess using a .aar should work as well (if you happen to be > doing that), but the configuration may be different. > > -Jeremy > > On Mon, Nov 3, 2008 at 12:20 PM, Jeremy Bauer <[EMAIL PROTECTED]> wrote: > > > I found this: > > > http://www.experts-exchange.com/Software/Server_Software/Application_Servers/Java/Apache_Tomcat/Q_23207819.htmlwhich > > indicated that you need to create a resource link between the data source > > you defined in the service.xml and resource ref in the web.xml, by > defining > > this in the context.xml: > > > > <ResourceLink global="jdbc/workflowdb" name="jdbc/workflowdb" > > auth="Container" > > type="javax.sql.DataSource"/> > > > > -Jeremy > > > > > > On Mon, Nov 3, 2008 at 11:37 AM, Håkon Sagehaug < > > [EMAIL PROTECTED]> wrote: > > > Hi > > > > > > when I try to do this programmatically like this > > > > > > Context initCtx = null; > > > Context envCtx; > > > DataSource ds = null; > > > try { > > > initCtx = new InitialContext(); > > > // envCtx = (Context) initCtx.lookup("java:/comp/env"); > > > ds = (DataSource) > initCtx.lookup("java:comp/env/jdbc/workflowdb"); > > > } catch (NamingException e) { > > > // TODO Auto-generated catch block > > > e.printStackTrace(); > > > } > > > > > > propMap.put("openjpa.ConnectionFactory", ds); > > > propMap.put("openjpa.ConnectionFactoryMode", "managed"); > > > propMap.put("openjpa.FlushBeforeQueries", "false"); > > > > > > EntityManagerFactory emf = Persistence.createEntityManagerFactory( > > > "MyOpenJPa", propMap); > > > > > > I always get > > > > > > javax.naming.NameNotFoundException: Name java:comp is not bound in this > > > Context > > > > > > So I guess this is related, but followed the tomcat doc so I can't > > > understand why this does not work. > > > 2008/11/3 Håkon Sagehaug <[EMAIL PROTECTED]> > > > > > >> 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) > > >> > > > > > > > > > > > > -- > > > 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)