From user-return-8767-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org Wed Jan 09 18:41:07 2008 Return-Path: Delivered-To: apmail-geronimo-user-archive@www.apache.org Received: (qmail 43150 invoked from network); 9 Jan 2008 18:41:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Jan 2008 18:41:07 -0000 Received: (qmail 34581 invoked by uid 500); 9 Jan 2008 18:40:55 -0000 Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org Received: (qmail 34559 invoked by uid 500); 9 Jan 2008 18:40:55 -0000 Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: user@geronimo.apache.org List-Id: Delivered-To: mailing list user@geronimo.apache.org Received: (qmail 34547 invoked by uid 99); 9 Jan 2008 18:40:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jan 2008 10:40:54 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [69.147.95.76] (HELO smtp113.plus.mail.sp1.yahoo.com) (69.147.95.76) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 09 Jan 2008 18:40:30 +0000 Received: (qmail 13965 invoked from network); 9 Jan 2008 18:40:35 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-YMail-OSG:Mime-Version:In-Reply-To:References:Content-Type:Message-Id:Content-Transfer-Encoding:From:Subject:Date:To:X-Mailer; b=6wuBeM1jGEqdq7GT+I+/jelPkN3z1REWCmG6Q4Z0ND9Qkif0A5Hwwk3hr7/zUHyhnboZg1xV7/gHyxNoBOUX690rfPs8aEpRHtbhZVnIjMzfOXVg78fSBw2/ypLJMoXqEdZDQ6rmsYPUXZQbgzDGthOuTZbXs/HvpiBteh6WNoE= ; Received: from unknown (HELO ?192.168.1.101?) (david_jencks@67.102.173.8 with plain) by smtp113.plus.mail.sp1.yahoo.com with SMTP; 9 Jan 2008 18:40:34 -0000 X-YMail-OSG: 7RuvdvQVM1mIj255pD6hj3TX.9n2.WDJX9rlQFIV.MSs4sF4bJhEVbXC.gHMAwMnxZH6G.gQAxNLCmIRswWl3eUgWlEt23Qrrkfazs6jK2skiuViSf6qmxMKot8w Mime-Version: 1.0 (Apple Message framework v752.3) In-Reply-To: <4784B246.6000403@gmail.com> References: <4784B246.6000403@gmail.com> Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: 7bit From: David Jencks Subject: Re: Geronimo 2.0/openejb/postgresql Date: Wed, 9 Jan 2008 10:40:33 -0800 To: user@geronimo.apache.org X-Mailer: Apple Mail (2.752.3) X-Virus-Checked: Checked by ClamAV on apache.org I recommend you set up a second postgres datasource with no tx support, say DefaultNoTxDS (pointing to the same postgres db as DefaultDS) Then in persistence.xml DefaultDS DefaultNoTxDS and leave out and tell us what problems if any you get. thanks david jencks On Jan 9, 2008, at 3:38 AM, Mario Kofler wrote: > hello, > > i searched the web for the solution but i did not find :( > > my setup: > > i want to get my application running on Geronimo 2.0 with openejb > as entity manager and postgresql as underlying database. > > things i already did: > > i did create a new database pool called "DefaultDS" through the > admin-console > > then for my application i modified the persistence.xml file > according to mails i found in the web: > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/ > persistence_1_0.xsd" > version="1.0"> > > videothek > > org.apache.openjpa.persistence.PersistenceProviderImpl provider> > > videothek.jar > > > > > value="org.postgresql.Driver" /> > > > value="jdbc:postgresql://localhost:5432/video" /> > > > > > > my geronimo-web.xml file: > > > xmlns="http://geronimo.apache.org/xml/ns/j2ee/web-1.1" > xmlns:nam="http://geronimo.apache.org/xml/ns/naming-1.1" > xmlns:sec="http://geronimo.apache.org/xml/ns/security-1.1" > xmlns:sys="http://geronimo.apache.org/xml/ns/deployment-1.1"> > > > videothek > war > > > > > console.dbpool > DefaultDS > > > > /valhalla > > > > > jdbc/valhalla > DefaultDS > > > > then it is possible to deploy the application to the geronimo server. > > the problem is as soon as i want to create an entity manager in my > application: > > /*code snippet*/ > @PersistenceUnit(unitName="valhalla") > private EntityManagerFactory emf; > private EntityManager em; em = emf.createEntityManager(); > /*code snippet*/ > > i get the following error: > > [exec] Caused by: java.lang.Exception: > java.lang.RuntimeException: There were errors initializing your > configuration: <1.0.0-r561970-r561970 fatal store error> > org.apache.openjpa.util.StoreException: org.postgresql.Driver in > classloader org.apache.geronimo.configs/openjpa/2.0.1/car > > root cause: > > javax.ejb.NoSuchEJBException: reference is invalid > org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke > (BaseEjbProxyHandler.java:208) > org.apache.openejb.util.proxy.Jdk13InvocationHandler.invoke > (Jdk13InvocationHandler.java:49) > $Proxy68.getNewData(Unknown Source) > org.apache.jsp.addTool_jsp._jspService(addTool_jsp.java:165) > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) > javax.servlet.http.HttpServlet.service(HttpServlet.java:806) > org.apache.jasper.servlet.JspServletWrapper.service > (JspServletWrapper.java:388) > org.apache.jasper.servlet.JspServlet.serviceJspFile > (JspServlet.java:320) > org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) > javax.servlet.http.HttpServlet.service(HttpServlet.java:806) > > > please help me, i am stuck for days now with this problem and i > dont find nothing new anymore on the net. i tried mayn different > kinds of deployment descriptors. this error is the farthest i get. > > thank you very much for your help, > > greetings, > > mario