Re: Duplicate Query - where none exists

2007-04-05 Thread Hans Prueller
perhaps this can help out: I just started using OpenJPA and I have ONLY A SINGLE CLASS WITHOUT ANY RELATIONS where I get this duplicate-query warning. So I can't believe that its related to that somehow... Hans Original-Nachricht Datum: Wed, 4 Apr 2007 23:42:01 -0700 Von:

[jira] Created: (OPENJPA-203) Pessimistic Lock Manager not locking the rows

2007-04-05 Thread Srinivasa (JIRA)
Pessimistic Lock Manager not locking the rows -- Key: OPENJPA-203 URL: https://issues.apache.org/jira/browse/OPENJPA-203 Project: OpenJPA Issue Type: Bug Components: kernel Affects

RE: Duplicate Query - where none exists

2007-04-05 Thread Phill Moran
It is actually called categoryTypeFK and is char(45) related to ID, char(45) in categoryType table. I like the less is more but I remember getting some complaints in eclipse. I'll try again -Original Message- From: Marc Prud'hommeaux [mailto:[EMAIL PROTECTED] On Behalf Of Marc

Re: why not an EntityExistsException was thrown?

2007-04-05 Thread Craig L Russell
Hi Wanyna, Whenever you query for entities, the result entities are put into your persistence context. So when you then try to persist another entity with the same identity the provider finds the query result in the persistence context and throws EntityExistsException. Craig On Apr 4,

[jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Abe White (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486987 ] Abe White commented on OPENJPA-182: --- What is setting the isolation level this way actually doing? For anything

[jira] Commented: (OPENJPA-203) Pessimistic Lock Manager not locking the rows

2007-04-05 Thread Abe White (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486999 ] Abe White commented on OPENJPA-203: --- Looks good. Although I think I'd prefer to make lockInternal() responsible

Re: [jira] Commented: (OPENJPA-168) sql optimize n rows query hint

2007-04-05 Thread Ritika Maheshwari
It has not been documented in the OPENJPA documentation. On 4/4/07, Patrick Linskey (JIRA) [EMAIL PROTECTED] wrote: [ https://issues.apache.org/jira/browse/OPENJPA-168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486820] Patrick Linskey commented on

[jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487046 ] Patrick Linskey commented on OPENJPA-182: - Hopefully, this will be useful for applications where there

[jira] Commented: (OPENJPA-203) Pessimistic Lock Manager not locking the rows

2007-04-05 Thread Srinivasa (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487070 ] Srinivasa commented on OPENJPA-203: --- My initial approach was the same that we could move the responsibility of

Re: Duplicate Query - where none exists

2007-04-05 Thread Marc Prud'hommeaux
Hans- I just did a query test with the examples/hellojpa/Message.java class in the latest openjpa-0.9.7-incubating-SNAPSHOT, and when I add: @NamedQueries({ @NamedQuery(name=q1, query=select x from Message x), @NamedQuery(name=q1, query=select x from Message x) }) I get the

Re: Duplicate Query - where none exists

2007-04-05 Thread Marc Prud'hommeaux
Hmm. I don't see anything wrong with that mapping. How is the @OneToOne on the other side of the @ManyToOne defined (if you have one)? It might be good to see the output of the mappingtool's validate action on your classes. E.g.: java org.apache.openjpa.jdbc.meta.MappingTool -action

[jira] Commented: (OPENJPA-203) Pessimistic Lock Manager not locking the rows

2007-04-05 Thread Abe White (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487078 ] Abe White commented on OPENJPA-203: --- If we don't want the subclasses to have to unset the lock value in case of

RE: [jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Patrick Linskey
We were unaware that fetch plan properties could be set as Hints. Now that we look at the code we see this, but we did not find this when we read the OpenJPA documentation. Yeah, it seems like we should probably do some documentation of some of these newer configuration options. The only

[jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Craig Russell (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487082 ] Craig Russell commented on OPENJPA-182: --- I know that Oracle allows you to add a FOR UPDATE clause to a query,

[jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Abe White (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487085 ] Abe White commented on OPENJPA-182: --- I know that Oracle allows you to add a FOR UPDATE clause to a query, and

[jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487086 ] Patrick Linskey commented on OPENJPA-182: - I know that Oracle allows you to add a FOR UPDATE clause to

[jira] Resolved: (OPENJPA-204) Nesting of Emebedded in Embeddable element

2007-04-05 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Patrick Linskey resolved OPENJPA-204. - Resolution: Won't Fix This is a limitation of the JPA spec. From section 9.1.34:

RE: [jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Patrick Linskey
But both of those settings are per-transaction things, not per-query things. The DB2 isolation level syntax differs in that it is part of the SQL statement issued, rather than a separate configuration for the transaction-wide isolation level. Theoretically, the JDBC transaction-level isolation

annotations / tags in JIRA?

2007-04-05 Thread Patrick Linskey
Hi, Is it possible to annotate issues in JIRA with some sort of structured or semi-structured tag? I'd like to be able to mark OPENJPA-204 so that we can come back to it later when working on the next JPA specification version. I guess I could clone the issue and either make a new issue type or a

[jira] Created: (OPENJPA-205) JPA2 Follow-Up

2007-04-05 Thread Patrick Linskey (JIRA)
JPA2 Follow-Up -- Key: OPENJPA-205 URL: https://issues.apache.org/jira/browse/OPENJPA-205 Project: OpenJPA Issue Type: Improvement Components: jpa Reporter: Patrick Linskey This is an umbrella issue for

Re: Using query hints for mapping extensions in orm.xml

2007-04-05 Thread Russell Parry
Has there been any progress on this issue? I just came across a case today where I'd like this functionality and some searching turned up this thread. I don't see anything on this subject that is more recent than the email below, but I'm not sure that I'm not just looking in the wrong

[jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Michael Dick (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487098 ] Michael Dick commented on OPENJPA-182: -- I have no practical experience with Sybase, but I did find this in

Re: [jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Ritika Maheshwari
I think I mentioned the wrong place but in SQLServer the isolation level can be specified as a table hint. The Table hint specifies that the query optimizer use a table scan, one or more indexes, or a locking method with this table or view and for this SELECT, INSERT, UPDATE, or DELETE statement.

[jira] Commented: (OPENJPA-182) db2 update lock syntax WITH isolation USE AND KEEP UPDATE LOCKS

2007-04-05 Thread Patrick Linskey (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-182?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487099 ] Patrick Linskey commented on OPENJPA-182: - Between Ritika's SQLServer email on the dev list and Mike's

Re: Query returning 2 entities w/1-1 relationship gets either openjpa.persistence.ArgumentException: Address with the same id already exists in the L1 cache. or returns [Address, Address] instead of [

2007-04-05 Thread Marc Prud'hommeaux
George- I'm not sure the exact problem (your model looks OK to me at first glance), but FTR, I just tried a simple test with a query that returns ob, ob.someOneToOne, and it returned the expected values (in this case, a org.apache.openjpa.persistence.models.company.basic.Customer and

Re: why not an EntityExistsException was thrown?

2007-04-05 Thread wanyna
Surely you are right. The object to persist is just in the result of query. I'v made a mistake in my test case 2, I did not notice some relations. Thanks. Craig L Russell wrote: Hi Wanyna, Whenever you query for entities, the result entities are put into your persistence context. So