Re: For oracle11g , setting openjpa.ConnectionUserName and openjpa.ConnectionPassword in java code error.

2009-06-17 Thread wang yu
Hi, Anybody else has tried this? Regards, Yu Wang On Thu, Jun 11, 2009 at 4:54 PM, wang yuwangy...@gmail.com wrote: Hi, I guess it's a bug of OpenJPA 1.2.1. I used ojdbc6.jar to connect oracle11g. If I pass username and password in persistence.xml, everything will be OK. But if I pass them

Re: ID field auto generation issue for multiple databases supporting

2009-06-17 Thread MiƂosz Tylenda
Hi Yu Wang, The error message seems to say Attempt to modify an identity column 'ID'. Probably Derby does not allow you to insert a value to an identity column. I suspect you have created the table when you had GenerationType.IDENTITY in your entity. The table has been created with an identity

[Newbie] Retrieving via Embedded Identifiers

2009-06-17 Thread B.L. Zeebub
Hi I'm working with a set of Entity classes that were generated from an existing database. Where a table in the database has a multiple column primary key, OpenJPA generated an entity class and an entityPK class. So, for example, for the table Ecu with a primary key of modelID and EcuID I end up

Re: For oracle11g , setting openjpa.ConnectionUserName and openjpa.ConnectionPassword in java code error.

2009-06-17 Thread Michael Dick
Hi Yu, Are you setting the properties when you create the EM, or EMFactory? I haven't had a chance to try it but (from memory) it should work on the EMFactory but not with the EM. -mike On Wed, Jun 17, 2009 at 4:21 AM, wang yu wangy...@gmail.com wrote: Hi, Anybody else has tried this?

org.apache.openjpa.persistence.ArgumentException: An error occurred while parsing the query filter

2009-06-17 Thread Patel, Sanjay
It works fine when my query is like this final String query = SELECT T1 from Table1 T1 LEFT JOIN FETCH T1.property1 LEFT JOIN FETCH T1. property2 WHERE T1.property3 LIKE :paramValue; But when I use alias in query it does not work. Following query does not work and give following

Re: JPQL Parser

2009-06-17 Thread Kevin Sutter
Hi Jakob, A formal API does not exist yet... JPA 2.0 is defining the Criteria API which provides a programmatic approach for creating and modifying JPA Queries. We are actively developing this capability in trunk ( http://openjpa.apache.org/jpa-20-roadmap.html), but neither the spec nor the

Re: [Newbie] OPenJPA (1.2.1) Enhancement woes

2009-06-17 Thread B.L. Zeebub
On Wednesday 17 June 2009 16:20:49 Michael Dick (via Nabble) wrote: Looks like someone recompiled your entity. Are there any pre-run hooks in Netbeans that might do that? I think IDEA does a clean rebuild before running anything (by default), maybe NetBeans has a similar config option.. It

mapping question

2009-06-17 Thread Andrew Thompson
I'm in the process of migrating a legacy application ejb application to use openjpa. Most of the usecases have worked quite well so far. But I have a use case I'm not clear on how to approach I have a parent object with the attributes below which map to corresponding columns in the database:

Re: JPQL Parser

2009-06-17 Thread jakob oswald
Thank you Kevin, the criteria API won't help me so I will have a look at the source code as you proposed. Could you give me a little hint where to start? Thank you. Regards Jakob Kevin Sutter wrote: Hi Jakob, A formal API does not exist yet... JPA 2.0 is defining the Criteria API which