[
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
[
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
[
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
[
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
: 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
[
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
.
-
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
[
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/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
[
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
/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
[
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
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
[
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
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
://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
[
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
[
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
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
, 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
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
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
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
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
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
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
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
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
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
[ 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
://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
://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
[ 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
[ 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
[
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
[
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
[ 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
[ 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
[
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
[
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
[ 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
[ 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
[
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
[ 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
[
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
[ 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
[
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 >
[ 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
[
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
[ 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
[
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
[ 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
[
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
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
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
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'
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.
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
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
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 "
: 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
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
: 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
63 matches
Mail list logo