RE: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-20 Thread Nitish Kumar
Hi Michael, The connection retain mode property makes the numbers almost same, but I am a little confused. Shouldnt this be the default behavior of Entity Manager? Typically I would have the entity manager tied up to the transaction (JTA or Spring), so I would expect Entity Manager to ho

Fwd: Caused by: org.apache.openjpa.persistence.ArgumentException: ....... cannot be annotated by two persistence strategy annotations.

2009-03-20 Thread David Blevins
Forwarding to the OpenJPA users list, hopefully they might have better insight. -David Begin forwarded message: Resent-From: From: jooocz Date: March 19, 2009 7:37:56 PM PDT To: us...@openejb.apache.org Subject: Caused by: org.apache.openjpa.persistence.ArgumentException: ... cann

hibernate conversion items

2009-03-20 Thread jlawmi
In unit tests (technically integration tests) where I test my mappings, I used to call (in hibernate) Hibernate.isInitialized(someentity.property) to validate things were lazy or to generally check their load status. Also, Hibernate had Hibernate.initialize(sometntity.property) to programmaticall

Re: Using max and size in same query not working with mssql.

2009-03-20 Thread rpalache
Hi, Here is the requested information: MS SQL Version: SQL Server 2000 SP3 JDBC driver : Microsoft SQL Server 2000 Driver for JDBC Regards, Ravi. Donald Woods wrote: > > Which version of MS SQL and which JDBC driver are you using? > > -Donald > > rpalache wrote: >> Hi all, >> >> Using ma

Re: Questions about classpath for OpenJPA

2009-03-20 Thread Michael Dick
Hi Paul, Sorry for the confusion. I thought you were building OpenJPA, not building an OpenJPA application. OpenJPA applications can compile with whatever JDK they like ( so long as it's >= 1.5). Regarding xerces, do you know if that dependency is pulled in because of OpenJPA, or because of commo

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-20 Thread Michael Dick
Hi all, As Paul pointed out privately I didn't indicate which versions of OpenJPA I was using. I've been testing with 1.2.0, 1.2.1 and 2.0.0-SNAPSHOT primarily. I also ran with 1.3.0-SNAPSHOT, and 1.0.3 for comparison - there wasn't much difference though so reduced the scope to 1.2 and trunk. Th

persisting collections of enums as strings

2009-03-20 Thread Tedman Leung
Hi I'm trying to persista a Collection of Enums in string format and I can't seem to find much information on how to do this. There were some things that said it defaults to String but when I generated the tables (using the MappingToolTask) it comes out as a number column. i.e. public

Re: Postgres supported versions

2009-03-20 Thread Paul Copeland
Thanks. Your persistence.xml settings are a great help. I'm using Postgres 8.2.13 because other applications have not yet moved to 8.3. However, I decided to use the most current Postgres JDBC driver that is supposed to be compatible with Postgres versions 7.2 and later - postgresql-8.3-604.

Re: Questions about classpath for OpenJPA

2009-03-20 Thread Paul Copeland
Interesting. Does this Jira bug say that OpenJPA applications can compile and run with Java 1.6 as long as they do not use JDBC 4 methods? Another item for the release notes :-) ... - Paul On 3/19/2009 7:03 PM, Michael Dick wrote: Hi Paul, Sadly 1.6 might not be the best move [1] [1] http

Re: Slow performance with OpenJPA when selecting from a ManyToMany relation.

2009-03-20 Thread Michael Dick
Hi, I took a quick run with the source code from the RAR Shubbis attached earlier (thanks BTW). The SQL we execute for this findBy is SELECT t0.warehouseName FROM Warehouse t0 WHERE t0.warehouseNr = ?. Pretty basic, and I doubt EclipseLink is doing better (certainly not 3x) based solely on the SQL

Re: Postgres supported versions

2009-03-20 Thread Judes Tumuhairwe
I'm using the jdbc driver in the jdbc folder of my postgres 8.2 install [C:\EnterpriseDB\Postgres\8.2\jdbc]. There are 5 but I picked postgresql-8.2-506.jdbc2ee. Yes, I'm using version 1.2. About the DBDictonary, this is my configuration in my tag in persistence.xml in my dev environment

Vedr.: Re: NullPointerException?

2009-03-20 Thread dth
Hi, Unfortunately I'm restricted to using the version in WebLogic server 10.3. I think it's OpenJPA 1.0, but I'm not sure. Could I upgrade the OpenJPA version in WLS in some non-invasive way? Thanks, -dennis Paul Copeland skrev den 19-03-2009 16:36:33: > > Which version of OpenJPA are you