Hi Robert, Quick question, does the test connection button on the WebSphere GUI work for the Derby and MS SQL datasources?
If test connection works, then OpenJPA should have no trouble getting a connection.. --mike On Wed, Oct 29, 2008 at 2:29 PM, Kevin Sutter <[EMAIL PROTECTED]> wrote: > RJack, > From what you are telling me, things should be working... :-) > > It sounds like you are creating an appropriate j2c component authentication > alias. I verified that this should be used even with a global jndi lookup > of the datasource. Setting custom properties on the datasource is another > alternative, but should not be required. > > Maybe a trace of the failure would help? Or, even to start with, the > SystemOut.log that shows the error. > > Also, what did you do to get SQLServer to work? > > Thank you for your patience, > Kevin > > On Wed, Oct 29, 2008 at 11:31 AM, rjack <[EMAIL PROTECTED]> wrote: > > > > > Kevin, > > > > I'm attaching the EAR I'm using in WebSphere. I am defining a datasource > > with that name, "JavaTranDerby". > > > > In both cases of Derby and Oracle, I"m creating a login/password using > J2C > > Authentication data and setting the login for XA Recovery and > > authentication > > for component management. I wonder if I need to set custom properties for > > Derby. In networked mode it seems to want a userId and Password even if > > they > > are fake. > > > > I can access Derby on the WebSphere server remotely using DBvisualizer > > with > > no problem. I tried the jars that come with WAS 7 and also the 10.4 Derby > > jars. > > > > Robert > > > > > > http://n2.nabble.com/file/n1394204/Transaction.ear Transaction.ear > > > > Kevin Sutter wrote: > > > > > > RJack, > > > According to your persistence.xml file, you are attempting to use a > > > jta-data-source: > > > > > > - <#> <persistence-unit name="*TransactionEJBPU*" > > > transaction-type="*JTA*" > > >> > > > <jta-data-source>JavaTranDerby</jta-data-source> > > > </persistence-unit> > > > > > > This indicates that you need to have a DataSource configured at the > jndi > > > name of "JavaTranDerby". Do you? Normally, customers would preface > the > > > global Datasource jndi names with "jdbc/", but that's not a hard > > > requirement. If you have configured this datasource in WebSphere with > > > that > > > jndi name, then OpenJPA should be able to find it. And, if you do have > > it > > > configured in WebSphere, then all of the login information should be > > > configured on that datasource. If you use the <jta-data-source> > element, > > > then no additional datasource configuration properties will be used. > > > > > > If you do not plan to or want to configure a datasource in WebSphere > for > > > the > > > jndi look, then you will need to configure datasource configuration > > > properties in your persistence.xml file. I am very surprised that this > > > same > > > configuration worked just fine with WegLogic. Did you have the jndi > name > > > for the datasource configured in WebLogic? Or, did you have to provide > > > some > > > configuration parameters to get around the datasource access? > > > > > > Now, a few other observations. The TransactionEAR.jar is not a normal > > > .ear > > > file. It looks to be an Eclipse project (or possibly some other IDE). > > > Correct? It only contains source files. And, it doesn't seem to > follow > > > normal .ear file formatting. For example, the META-INF directory is > > > located > > > in a src directory. This would not be a normal location to search for > a > > > persistence.xml file. > > > > > > Can you provide the actual .ear file that you are attempting to install > > > and > > > use? > > > > > > I also see the jpa.reveng.xml file which seems to indicate that maybe > > this > > > project started with Hibernate and you are now moving to OpenJPA? Is > > that > > > the case? Just curious since OpenJPA is always interested in learning > > > about > > > Hibernate migration lessons. > > > > > > And, finally, you mentioned that you got this to work with Oracle 10g. > > > What > > > did you do to get that configuration to work for you? > > > > > > More questions than answers at this point... > > > > > > Thanks, > > > Kevin > > > > > > > > > On Tue, Oct 28, 2008 at 2:08 PM, rjack <[EMAIL PROTECTED]> wrote: > > > > > >> > > >> Kevin, > > >> > > >> Thanks for your interest. I would like to have this working because it > > >> would > > >> be a great way to deploy prototypes which I do often. > > >> > > >> The server I'm using is Running WebSphere 7 GA on Windows 2003 Server, > > >> Service Pack 2. > > >> > > >> I'm using container managed transactions. I'm uploading the source > that > > >> is > > >> working in Weblogic 10.3. > > >> > > >> I wonder if I need to add userId and password at connection > properties. > > >> Right now I have them added as a J2C logins. > > >> > > >> Robert > > >> > > >> > http://n2.nabble.com/file/n1390062/TransactionEAR.jarTransactionEAR.jar > > >> > > >> Kevin Sutter wrote: > > >> > > > >> > RJack, > > >> > Can you provide a bit more information on what your operating > > >> environment > > >> > is? Are you using application-managed persistence contexts? Or, > > >> > container-managed? Are you using base WebSphere v6.1, v6.1 + EJB3 > > >> Feature > > >> > Pack, or v7? > > >> > > > >> > > > >> > You should not require any additional properties to get this > running. > > >> > Except maybe for some Connection-related properties. Since JPA is > > >> > optimistic by default, you should not set the LockManager to > > >> pessimistic > > >> > -- > > >> > unless your application requires this extension. > > >> > > > >> > Being both an OpenJPA and WebSphere advocate, I would be interested > in > > >> > understanding why you are having difficulties getting this > combination > > >> to > > >> > run. It should not be this difficult. Thanks for your help in > making > > >> > these > > >> > products better. > > >> > > > >> > Kevin > > >> > > > >> > On Tue, Oct 28, 2008 at 12:43 PM, rjack <[EMAIL PROTECTED]> wrote: > > >> > > > >> >> > > >> >> Folks, > > >> >> > > >> >> I got it to work using Oracle 10g. > > >> >> > > >> >> Robert Jackson > > >> >> > > >> >> rjack wrote: > > >> >> > > > >> >> > Folks, > > >> >> > > > >> >> > > > >> >> > I've been trying to get JPA to work with WebSphere. I'm not > having > > >> any > > >> >> > success. > > >> >> > > > >> >> > Derby - 5 minutes to get going in Weblogic > > >> >> > MS SQL Server - 10 minutes to get going in Weblogic > > >> >> > > > >> >> > I spent 2 days trying to get either working in WebSphere with no > > >> >> success. > > >> >> > > > >> >> > Openjpa keeps complaining about pessimsitic locking and other > > stuff. > > >> >> > > > >> >> > I tried adding these lines to my persistence.xml file: > > >> >> > > > >> >> > <properties> > > >> >> > <property name="openjpa.Optimistic" > > >> >> value="false"/> > > >> >> > <property name="openjpa.LockManager" > > >> >> value="pessimistic"/> > > >> >> > </properties> > > >> >> > > > >> >> > > > >> >> > I would love to get it working with a Derby Server. > > >> >> > > > >> >> > Any ideas... > > >> >> > > > >> >> > Robert Jackson > > >> >> > > > >> >> > > >> >> -- > > >> >> View this message in context: > > >> >> http://n2.nabble.com/OpenJPA-on-WebSphere-tp1387725p1389637.html > > >> >> Sent from the OpenJPA Users mailing list archive at Nabble.com. > > >> >> > > >> >> > > >> > > > >> > > > >> > > >> -- > > >> View this message in context: > > >> http://n2.nabble.com/OpenJPA-on-WebSphere-tp1387725p1390062.html > > >> Sent from the OpenJPA Users mailing list archive at Nabble.com. > > >> > > >> > > > > > > > > > > -- > > View this message in context: > > http://n2.nabble.com/OpenJPA-on-WebSphere-tp1387725p1394204.html > > Sent from the OpenJPA Users mailing list archive at Nabble.com. > > > > >