openjpa NativeQuery and NamedNativeQuery only allow select sql statements

It seems that openjpa NativeQuery and NamedNativeQuery only allow "select" sql statements. When I try to insert, delete, update, create table, alter table, drop table, or call a stored procedure, I get <4|false|0.9.6-incubating-SNAPSHOT> org.apache.openjpa.persistence.InvalidStateException: Ca

RE: openjpa NativeQuery and NamedNativeQuery only allow select sql statements

jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) "Patrick Linskey" <[EMAIL PROTECTED]> 12/04/2006 10:21 AM To , George Hongell/Santa Teresa/[EMAIL PROT

Fwd: has @SqlResultSetMapping been tested

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 @SqlResultSetMapp

Re: has @SqlResultSetMapping been tested

nce 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 Hongell [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 10, 2007 9:49 AM To: open-jpa-dev@i

has @SqlResultSetMapping been tested

When I recreated your example it worked. But when I moved persisting the entity from the test method to another method (in this case setup()) I get the failure that I have been experiencing. I am enclosing the entity, the test, the persistence.xml and the stack trace. http://java.sun.com/xml/ns

[jira] Created: (OPENJPA-199) bulk update gets parsing exception trying to update an attribute of an embedded class

Project: OpenJPA Issue Type: Bug Components: query Affects Versions: 0.9.7 Environment: 0.9.7-incubating-SNAPSHOT Reporter: George Hongell Attachments: embeddedBugWineryTest.zip <4|false|0.9.7-incubating-SNAPS

[jira] Updated: (OPENJPA-199) bulk update gets parsing exception trying to update an attribute of an embedded class

[ https://issues.apache.org/jira/browse/OPENJPA-199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] George Hongell updated OPENJPA-199: --- Attachment: embeddedBugWineryTest.zip > bulk update gets parsing exception trying to upd

[jira] Created: (OPENJPA-200) cannot use enum type as input parameter for a query, and you cannot specify an Enum type as a literal, this also means that there is no way to update an enum type using j

Environment: 0.9.7-incubating-SNAPSHOT Reporter: George Hongell Attachments: enumBugWineryTest.zip cannot use enum as input parameter for a query, Enum cannot be used as argument in setParm, since you also cannot specify an Enum type as a literal, this means that there

[jira] Updated: (OPENJPA-200) cannot use enum type as input parameter for a query, and you cannot specify an Enum type as a literal, this also means that there is no way to update an enum type using j

[ https://issues.apache.org/jira/browse/OPENJPA-200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] George Hongell updated OPENJPA-200: --- Attachment: enumBugWineryTest.zip run main to get error > cannot use enum type as in

[jira] Created: (OPENJPA-201) Mapping Tool ignores the @JoinColumn annotation in a @ManyToOne mapping if the table argument is used

/browse/OPENJPA-201 Project: OpenJPA Issue Type: Bug Environment: 0.9.7-incubating-SNAPSHOT Reporter: George Hongell @Entity @Table(name="CxWine") public class Wine { @Id private Integer wineid; ... @ManyToOne() @JoinC

[jira] Updated: (OPENJPA-201) Mapping Tool ignores the @JoinColumn annotation in a @ManyToOne mapping if the table argument is used

[ https://issues.apache.org/jira/browse/OPENJPA-201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] George Hongell updated OPENJPA-201: --- Priority: Minor (was: Major) > Mapping Tool ignores the @JoinColumn annotation i

[jira] Created: (OPENJPA-202) after invoking LRS processing in a client by calling an @LRS annotated relationship, the next em.clear()/em.close() gets org.apache.openjpa.persistence.InvalidStateExcept

/jira/browse/OPENJPA-202 Project: OpenJPA Issue Type: Bug Components: kernel Affects Versions: 0.9.7 Environment: 0.9.7-incubating-SNAPSHOT Reporter: George Hongell after invoking LRS processing in a client by calling an @LRS annotated

[jira] Updated: (OPENJPA-202) after invoking LRS processing in a client by calling an @LRS annotated relationship, the next em.clear()/em.close() gets org.apache.openjpa.persistence.InvalidStateExcept

[ https://issues.apache.org/jira/browse/OPENJPA-202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] George Hongell updated OPENJPA-202: --- Attachment: lrsBugWineryTest.zip run main method to get error > after invoking

[jira] Created: (OPENJPA-209) Query returning 2 entities w/unidir 1-1 relationship gets openjpa.persistence.ArgumentException: Address with the same id already exists in the L1 cache.

. - Key: OPENJPA-209 URL: https://issues.apache.org/jira/browse/OPENJPA-209 Project: OpenJPA Issue Type: Bug Affects Versions: 0.9.7 Environment: 0.9.7-incubating-SNAPSHOT, windows, db2 Reporter: George

[jira] Updated: (OPENJPA-209) Query returning 2 entities w/unidir 1-1 relationship gets openjpa.persistence.ArgumentException: Address with the same id already exists in the L1 cache.

[ https://issues.apache.org/jira/browse/OPENJPA-209?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] George Hongell updated OPENJPA-209: --- Attachment: 1_1CacheBugWineryTest.zip run main method of BugSmallWineryTest in attached

[jira] Created: (OPENJPA-210) Query returning 2 entities w/1-1 relationship returns wrong types in the result list

: OpenJPA Issue Type: Bug Environment: 0.9.7-incubating-SNAPSHOT, windows, db2 Reporter: George Hongell Query returning 2 entities w/1-1 relationship returns [Address, Address] instead of [Winery, Address] "SELECT r,r.address from Winery r" return

[jira] Updated: (OPENJPA-210) Query returning 2 entities w/1-1 relationship returns wrong types in the result list

[ https://issues.apache.org/jira/browse/OPENJPA-210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] George Hongell updated OPENJPA-210: --- Attachment: 1_1WrongReturnTypesBugWineryTest.zip run main method of BugSmallWineryTest in

[jira] Commented: (OPENJPA-201) Mapping Tool ignores the @JoinColumn annotation in a @ManyToOne mapping if the table argument is used

[ https://issues.apache.org/jira/browse/OPENJPA-201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487361 ] George Hongell commented on OPENJPA-201: In this case, the named table is the primary table for the entity

[jira] Commented: (OPENJPA-210) Query returning 2 entities w/1-1 relationship returns wrong types in the result list

[ https://issues.apache.org/jira/browse/OPENJPA-210?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487362 ] George Hongell commented on OPENJPA-210: The same test on a similar application fails with

[jira] Updated: (OPENJPA-201) Mapping Tool ignores the @JoinColumn annotation in a @ManyToOne mapping if the table argument is used

[ https://issues.apache.org/jira/browse/OPENJPA-201?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] George Hongell updated OPENJPA-201: --- Attachment: Winery.java Wine.java I am attaching the Wine and Winery files

[jira] Created: (OPENJPA-45) pushdown sql uses outer join when it should use inner join

: query Environment: windows xp, derby, db2 Reporter: George Hongell 13 - uses outer join not inner join TEST13; select $ from EmpBean $, DeptBean _a 5859 TRACE [main] openjpa.jdbc.SQL - [0 ms] executing prepstmnt 612246654 SELECT t0.empid, t0.bonus, t1.deptno, t1.budget

[jira] Created: (OPENJPA-46) true, false not case insensitive, gets null pointer exception

Components: query Environment: windows xp, derby, db2 Reporter: George Hongell 140 - true,false should be case insensitive - gets npe [ FAILED 140- bucket = fvtfull, query = select e from EmpBean e where (e.isManager = True) : EXPECTED( TEST140; select e from EmpBean e

[jira] Created: (OPENJPA-47) 143 arithmetic unary operator (+,-) gives parsing error

: query Environment: windows xp, derby, db2 Reporter: George Hongell 143 unary operator (+,-) gives parsing error select e from EmpBean e where -(e.salary) >-10; select e from EmpBean e where -e.salary >-10; select e, -e.salary , +e.salary from EmpBean e where +e.salar

[jira] Created: (OPENJPA-48) parsing error - cast of subselect does not work

Environment: Windows xp, derby and db2 Reporter: George Hongell 163 - parsing error - cast of subselect does not work TEST163; select e from EmpBean e where e.salary + 100 > all (select e1.salary from EmpBean e1 left join e1.dept d where d.no = 20) Syntax error: Encountered "

[jira] Created: (OPENJPA-49) bad sql pushdown, should use inner joins but has no joins, just uses first entity

Issue Type: Bug Components: query Environment: Windows xp, db2, derby Reporter: George Hongell 182 bad pushdown, should use inner joins but has no joins, just uses first entity TEST182; select count(e) from EmpBean e, DeptBean d, EmpBean e1 15469 TRACE

[jira] Created: (OPENJPA-50) bad sql pushdown, cast changes datatype

xp, db2, derby Reporter: George Hongell 444 - bad sql pushdown, cast changes datatype TEST444; select e from EmpBean e where e.salary > 5 and abs(e.salary) > 12 28203 TRACE [main] openjpa.jdbc.SQL - [0 ms] executing prepstmnt 1712481810 SELECT t0.empid, t0.bonus, t1.dept

[jira] Created: (OPENJPA-51) bad sql pushdown, sub select is missing from clause

Environment: Windows xp, db2, derby Reporter: George Hongell 451 - bad sql pushdown sub select is missing from clause TEST451; select e from EmpBean e where e.empid > any (select e1.empid from DeptBean d, in(d.emps) e1 where d.no = 200) 28344 TRACE [main] openjpa.jdbc.

[jira] Created: (OPENJPA-52) bad sql pushdown, puts group by in outer select

Environment: Windows xp, derby, db2 Reporter: George Hongell 457 bad sql pushdown, puts group by in outer select TEST457; select e.name, e.salary from EmpBean e where (e.name = Any(select e1.name from EmpBean e1 group by e1.name )) order by e.name Column reference 'T0.NAME'

[jira] Created: (OPENJPA-53) bad sql pushdown for nested subselects, missing nested subselect

Components: query Environment: Windows xp, derby, db2 Reporter: George Hongell 536 bad sql pushdown for nested subselects TEST536; select e from EmpBean e where (e.salary = (select max(e.salary) from EmpBean e where e.salary > some (select f.salary from EmpBean f wh

[jira] Created: (OPENJPA-54) bad sql pushdown, should use all syntax

xp, derby, db2 Reporter: George Hongell 454 bad sql pushdown, should use all syntax TEST454; select e from EmpBean e where e.empid not in (select e.no from DeptBean e) Scalar subquery is only allowed to return a single row. {prepstmnt 241176160 SELECT t0.empid, t0.bonus, t2.deptno

[jira] Commented: (OPENJPA-45) pushdown sql uses outer join when it should use inner join

[ http://issues.apache.org/jira/browse/OPENJPA-45?page=comments#action_12436032 ] George Hongell commented on OPENJPA-45: --- EJBQL: select $ from EmpBean $, DeptBean _a OPENJPA ERROR OR SQL PUSHDOWN: returns 10 entities not 9 5859 TRACE

[jira] Updated: (OPENJPA-45) pushdown sql uses outer join when it should use inner join

[ http://issues.apache.org/jira/browse/OPENJPA-45?page=all ] George Hongell updated OPENJPA-45: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this problem > pushdown sql uses outer join when it should

[jira] Commented: (OPENJPA-46) true, false not case insensitive, gets null pointer exception

[ http://issues.apache.org/jira/browse/OPENJPA-46?page=comments#action_12436040 ] George Hongell commented on OPENJPA-46: --- removed testcase references. EJBQL: select e from EmpBean e where (e.isManager = True) OPENJPA ERROR OR SQL

[jira] Updated: (OPENJPA-46) true, false not case insensitive, gets null pointer exception

[ http://issues.apache.org/jira/browse/OPENJPA-46?page=all ] George Hongell updated OPENJPA-46: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > true, false not case insensitive, gets null poin

[jira] Commented: (OPENJPA-47) 143 arithmetic unary operator (+,-) gives parsing error

[ http://issues.apache.org/jira/browse/OPENJPA-47?page=comments#action_12436044 ] George Hongell commented on OPENJPA-47: --- removed testcase references. EJBQL: select e from EmpBean e where -(e.salary+10) > -10 OPENJPA ERROR OR

[jira] Updated: (OPENJPA-47) 143 arithmetic unary operator (+,-) gives parsing error

[ http://issues.apache.org/jira/browse/OPENJPA-47?page=all ] George Hongell updated OPENJPA-47: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > 143 arithmetic unary operator (+,-) gives pars

[jira] Updated: (OPENJPA-48) parsing error - cast of subselect does not work

[ http://issues.apache.org/jira/browse/OPENJPA-48?page=all ] George Hongell updated OPENJPA-48: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > parsing error - cast of subselect does not w

[jira] Commented: (OPENJPA-48) parsing error - cast of subselect does not work

[ http://issues.apache.org/jira/browse/OPENJPA-48?page=comments#action_12436052 ] George Hongell commented on OPENJPA-48: --- removed testcase references. run on version 443432. EJBQL: select e from EmpBean e where e.salary + 100 >

[jira] Commented: (OPENJPA-49) bad sql pushdown, should use inner joins but has no joins, just uses first entity

[ http://issues.apache.org/jira/browse/OPENJPA-49?page=comments#action_12436054 ] George Hongell commented on OPENJPA-49: --- removed testcase references. run on version 443432. EJBQL: select count(e) from EmpBean e, DeptBean d, EmpBean e1

[jira] Updated: (OPENJPA-49) bad sql pushdown, should use inner joins but has no joins, just uses first entity

[ http://issues.apache.org/jira/browse/OPENJPA-49?page=all ] George Hongell updated OPENJPA-49: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > bad sql pushdown, should use inner joins but has

[jira] Commented: (OPENJPA-50) bad sql pushdown, cast changes datatype

[ http://issues.apache.org/jira/browse/OPENJPA-50?page=comments#action_12436062 ] George Hongell commented on OPENJPA-50: --- removed testcase references. run on version 443432. EJBQL: select e from EmpBean e where e.salary > 5 and

[jira] Updated: (OPENJPA-50) bad sql pushdown, cast changes datatype

[ http://issues.apache.org/jira/browse/OPENJPA-50?page=all ] George Hongell updated OPENJPA-50: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > bad sql pushdown, cast changes datat

[jira] Updated: (OPENJPA-51) bad sql pushdown, sub select is missing from clause

[ http://issues.apache.org/jira/browse/OPENJPA-51?page=all ] George Hongell updated OPENJPA-51: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > bad sql pushdown, sub select is missing from cla

[jira] Commented: (OPENJPA-51) bad sql pushdown, sub select is missing from clause

[ http://issues.apache.org/jira/browse/OPENJPA-51?page=comments#action_12436071 ] George Hongell commented on OPENJPA-51: --- removed testcase references. run on version 443432. EJBQL: select e from EmpBean e where e.empid > any (select

[jira] Commented: (OPENJPA-52) bad sql pushdown, puts group by in outer select

[ http://issues.apache.org/jira/browse/OPENJPA-52?page=comments#action_12436079 ] George Hongell commented on OPENJPA-52: --- removed testcase references. run on version 443432. EJBQL: select e.name, e.salary from EmpBean e where (e.name

[jira] Updated: (OPENJPA-52) bad sql pushdown, puts group by in outer select

[ http://issues.apache.org/jira/browse/OPENJPA-52?page=all ] George Hongell updated OPENJPA-52: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > bad sql pushdown, puts group by in outer sel

[jira] Commented: (OPENJPA-54) bad sql pushdown, should use all syntax

[ http://issues.apache.org/jira/browse/OPENJPA-54?page=comments#action_12436081 ] George Hongell commented on OPENJPA-54: --- removed testcase references. run on version 443432. EJBQL: select e from EmpBean e where e.empid not in (select

[jira] Updated: (OPENJPA-54) bad sql pushdown, should use all syntax

[ http://issues.apache.org/jira/browse/OPENJPA-54?page=all ] George Hongell updated OPENJPA-54: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > bad sql pushdown, should use all syn

[jira] Updated: (OPENJPA-53) bad sql pushdown for nested subselects, missing nested subselect

[ http://issues.apache.org/jira/browse/OPENJPA-53?page=all ] George Hongell updated OPENJPA-53: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > bad sql pushdown for nested subselects, miss

[jira] Commented: (OPENJPA-53) bad sql pushdown for nested subselects, missing nested subselect

[ http://issues.apache.org/jira/browse/OPENJPA-53?page=comments#action_12436087 ] George Hongell commented on OPENJPA-53: --- removed testcase references. run on version 443432. EJBQL: select e from EmpBean e where (e.salary = (select max

[jira] Created: (OPENJPA-56) in derby concat with input parameter needs a cast, otherwise becomes long varchar and some operations do not work

://issues.apache.org/jira/browse/OPENJPA-56 Project: OpenJPA Issue Type: Bug Components: query Environment: Windows xp, derby, openjpa version 443432. Reporter: George Hongell Attachments: failureEntities.jar run on version 443432. in derby

[jira] Updated: (OPENJPA-56) in derby concat with input parameter needs a cast, otherwise becomes long varchar and some operations do not work

[ http://issues.apache.org/jira/browse/OPENJPA-56?page=all ] George Hongell updated OPENJPA-56: -- Attachment: failureEntities.jar entity java files and derby ddl script to use to recreate this issue > in derby concat with input parameter needs a c

[jira] Created: (OPENJPA-62) Ejbql join queries show invalid null Entities when run in a new persistence context where no entity instances exist.

://issues.apache.org/jira/browse/OPENJPA-62 Project: OpenJPA Issue Type: Bug Components: query Environment: openjpa version 443432, derby, db2 Reporter: George Hongell Each of the following queries, when run by itself in a new persistence

[jira] Updated: (OPENJPA-62) Ejbql join queries show invalid null Entities when run in a new persistence context where no entity instances exist.

[ http://issues.apache.org/jira/browse/OPENJPA-62?page=all ] George Hongell updated OPENJPA-62: -- Attachment: failureEntities.zip attachment included to help recreate issue > Ejbql join queries show invalid null Entities when run in a new persiste

[jira] Created: (OPENJPA-107) @SqlResultSetMappings fails in mapping tool with java.lang.ArrayStoreException

Issue Type: Bug Environment: windows xp, openjpa_097_incubating Reporter: George Hongell @SqlResultSetMappings fails in mapping tool with java.lang.ArrayStoreException 7361 mdd INFO [main] openjpa.MetaData - Parsing class

[jira] Created: (OPENJPA-108) @AttributeOverrides fails in mapping tool with java.lang.ArrayStoreException

Issue Type: Bug Environment: windows xp, openjpa_097_incubating Reporter: George Hongell @AttributeOverrides fails in mapping tool with java.lang.ArrayStoreException @AttributeOverrides({ @AttributeOverride(name="charityName", [EMAIL PROTE

[jira] Created: (OPENJPA-109) every NativeQuery using SqlResultSetMapping fails at runtime with There is no query result mapping for "null" with name "xxx" when the entity is persisted in a different

Issue Type: Bug Environment: windows xp, openjpa_097_incubating Reporter: George Hongell every NativeQuery using SqlResultSetMapping fails at runtime with There is no query result mapping for "null" with name "xxx" when the entity is persisted in a differen

[jira] Created: (OPENJPA-110) Every NamedNativeQuery using ResultSetMapping fails at runtime with class cast exception when try to iterate over list

URL: https://issues.apache.org/jira/browse/OPENJPA-110 Project: OpenJPA Issue Type: Bug Environment: windows xp, openjpa_097_incubating Reporter: George Hongell Every NamedNativeQuery using ResultSetMapping fails at runtime with class cast

[jira] Created: (OPENJPA-111) native queries fail when use named parameters

, openjpa_097_incubating Reporter: George Hongell native queries fail when use named parameters int parm3 = 100; String sql = "SELECT deptno,budget,NAME,MGR_EMPID,REPORTSTO_DEPTNO FROM DeptBean WHERE deptno >= :deptno "; Query getDept = _em.createNativeQuery(sql,D

[jira] Created: (OPENJPA-113) when you specify columm table="empbean" in the xml file entity id or basic type when empbean is the default table name, the mapping tool generates extra foreign key fiel

Type: Bug Environment: windows xp, openjpa_097_incubating Reporter: George Hongell when you specify columm table="empbean" in the xml file entity id or basic type when empbean is the default table name, the mapping tool generates extra foreign key field (eg.EmpBean

[jira] Commented: (OPENJPA-107) @SqlResultSetMappings fails in mapping tool with java.lang.ArrayStoreException

[ https://issues.apache.org/jira/browse/OPENJPA-107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12467499 ] George Hongell commented on OPENJPA-107: I agree. This problem goes away when I use jdk 1.5 SR3. I was

[jira] Commented: (OPENJPA-108) @AttributeOverrides fails in mapping tool with java.lang.ArrayStoreException

[ https://issues.apache.org/jira/browse/OPENJPA-108?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12467500 ] George Hongell commented on OPENJPA-108: This also goes away when I move from SR2 to SR3

[jira] Created: (OPENJPA-120) For Multi Table Entity subselect with field in second table gets DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601

://issues.apache.org/jira/browse/OPENJPA-120 Project: OpenJPA Issue Type: Bug Components: query Environment: incubator 097 Reporter: George Hongell For Multi Table Entity subselect with field in second table gets DB2 SQL error: SQLCODE: -104, SQLSTATE