How to write it in JPQL

2007-01-10 Thread wanyna
Hi all. I have two questions: 1. Here is my sql string: select 'xxx', TABLE_A.column1 from TABLE_A; there is a string 'xxx' as a constant value, how to translate it to JPQL? 2. Another sql used under oracle: select TABLE_A.column1 from TABLE_A where rownum10; how to limit range of result in

Re: How to write it in JPQL

2007-01-10 Thread Marc Prud'hommeaux
On Jan 10, 2007, at 12:12 AM, wanyna wrote: Hi all. I have two questions: 1. Here is my sql string: select 'xxx', TABLE_A.column1 from TABLE_A; there is a string 'xxx' as a constant value, how to translate it to JPQL? I don't think it is possible. Why would you need to do that? 2. Another

Re: How to write it in JPQL

2007-01-10 Thread wanyna
There are two tables A and B, I need to execute sql like insert into A select ... from B. I use JPQL Constructor Expressions, select new A(...) from B, got A list then persist. But some data of A depends on program context, not from B, for simple example: select new A(B.column1, 'xxx') from B,

[jira] Assigned: (OPENJPA-98) Java deadlock when insert in t1 and find in t2 when using IBM JVM 1.5.0

2007-01-10 Thread Kevin Sutter (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-98?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kevin Sutter reassigned OPENJPA-98: --- Assignee: Kevin Sutter Java deadlock when insert in t1 and find in t2 when using IBM JVM

Fwd: has @SqlResultSetMapping been tested

2007-01-10 Thread George Hongell
I tried using both a native query and it failed, has it ever been tested? also named native query with resultSetMapping fails at runtime, also @SqlResultSetMappings does not seem to be implemented in openjpa and fails in the MappingTool with *java.lang.ArrayStoreException* using

RE: has @SqlResultSetMapping been tested

2007-01-10 Thread Patrick Linskey
What version of OpenJPA are you using? IIRC, there were issues, but they were resolved a little while back. -Patrick -- Patrick Linskey BEA Systems, Inc. ___ Notice: This email message, together with any attachments, may

RE: has @SqlResultSetMapping been tested

2007-01-10 Thread Pinaki Poddar
Query updateDeptName = _em.createNativeQuery(sql,DeptBeanMapping); If any persistence operation using DeptBean.class preceeds this call (e.g. _em.persist(new DeptBean())), then is there any change in behavior? Pinaki Poddar BEA Systems 415.402.7317 -Original Message- From: George

Re: has @SqlResultSetMapping been tested

2007-01-10 Thread George Hongell
Yes several instances of DeptBean were persisted before the createNativequery was issued. I am running 0.9.7-incubating-SNAPSHOT On 1/10/07, Pinaki Poddar [EMAIL PROTECTED] wrote: Query updateDeptName = _em.createNativeQuery(sql,DeptBeanMapping); If any persistence operation using

[jira] Created: (OPENJPA-99) Enhanced pcNewInstance redundantly clears fields

2007-01-10 Thread Craig Russell (JIRA)
Enhanced pcNewInstance redundantly clears fields - Key: OPENJPA-99 URL: https://issues.apache.org/jira/browse/OPENJPA-99 Project: OpenJPA Issue Type: Bug Components: kernel

[jira] Commented: (OPENJPA-98) Java deadlock when insert in t1 and find in t2 when using IBM JVM 1.5.0

2007-01-10 Thread Marc Prud'hommeaux (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-98?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12463713 ] Marc Prud'hommeaux commented on OPENJPA-98: --- I've never seen any problem like this. It is interesting that

[jira] Created: (OPENJPA-100) jar-file entries failing to be processed for persistence unit rooted in an EAR

2007-01-10 Thread Patrick Linskey (JIRA)
jar-file entries failing to be processed for persistence unit rooted in an EAR Key: OPENJPA-100 URL: https://issues.apache.org/jira/browse/OPENJPA-100 Project: OpenJPA

[jira] Commented: (OPENJPA-98) Java deadlock when insert in t1 and find in t2 when using IBM JVM 1.5.0

2007-01-10 Thread Kevin Sutter (JIRA)
[ https://issues.apache.org/jira/browse/OPENJPA-98?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12463755 ] Kevin Sutter commented on OPENJPA-98: - We're thinking along the same lines... The super.loadClass just ends up