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
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
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,
[
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
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
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
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
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
Enhanced pcNewInstance redundantly clears fields
-
Key: OPENJPA-99
URL: https://issues.apache.org/jira/browse/OPENJPA-99
Project: OpenJPA
Issue Type: Bug
Components: kernel
[
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
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
[
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
12 matches
Mail list logo