[jira] Updated: (OPENJPA-238) Error in XMLFileHandler, failed to load field element with type org.apace.openjpa.util.StringId.

[ https://issues.apache.org/jira/browse/OPENJPA-238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski updated OPENJPA-238: --- Attachment: XMLFileHandler.java.patch Re-attach patch for OPENJPA-238 Error

[jira] Updated: (OPENJPA-238) Error in XMLFileHandler, failed to load field element with type org.apace.openjpa.util.StringId.

[ https://issues.apache.org/jira/browse/OPENJPA-238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski updated OPENJPA-238: --- Attachment: (was: XMLFileHandler.patch) Error in XMLFileHandler, failed to load field

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

[ https://issues.apache.org/jira/browse/OPENJPA-51?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski updated OPENJPA-51: -- Attachment: (was: openjpa-51.patch) bad sql pushdown, sub select is missing from clause

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

[ https://issues.apache.org/jira/browse/OPENJPA-51?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski updated OPENJPA-51: -- Attachment: (was: SelectImpl.java.patch) bad sql pushdown, sub select is missing from

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

[ https://issues.apache.org/jira/browse/OPENJPA-51?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski resolved OPENJPA-51. --- Resolution: Fixed fixed in r534623 bad sql pushdown, sub select is missing from clause

[jira] Resolved: (OPENJPA-173) JOIN in subselect generates bad SQL

[ https://issues.apache.org/jira/browse/OPENJPA-173?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski resolved OPENJPA-173. Resolution: Fixed This issue should be fixed by r534623, a similar issue OPENJPA-51

[jira] Resolved: (OPENJPA-83) Bad SQL for Subselect BETWEEN

[ https://issues.apache.org/jira/browse/OPENJPA-83?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski resolved OPENJPA-83. --- Resolution: Fixed fixed by r534623 Bad SQL for Subselect BETWEEN

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

[ https://issues.apache.org/jira/browse/OPENJPA-51?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski reassigned OPENJPA-51: - Assignee: David Wisneski bad sql pushdown, sub select is missing from clause

Re: svn commit: r525252 - in /incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql: AbstractDB2Dictionary.java DB2Dictionary.java

SQL provides capabilities for tuning of locking. In the case of DB2 this involves setting the isolation level, update lock, result set optimize set, etc. JPA spec does not provide support for these concepts but does provide a rather open ended setHint api. It is our intent to make use this api

Re: svn commit: r525252 - in /incubator/openjpa/trunk/openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql: AbstractDB2Dictionary.java DB2Dictionary.java

are not the intended recipient, and have received this message in error, please immediately return this by email and then delete it. -Original Message- From: David Wisneski [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 03, 2007 1:24 PM To: open-jpa-dev@incubator.apache.org Subject: Re: svn

[jira] Created: (OPENJPA-184) use DB2 Diagnostic interface to report extended error diagnostics on SQL Exception

: OpenJPA Issue Type: New Feature Environment: DB2 database Reporter: David Wisneski When using DB2 database and the SQLException occurs if the SQLException instance supports the DB2Diagnosable interface, extended error information from the SQLCA will be written

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

Feature Components: jdbc Environment: db2 database driver for zOS, AS400, Unix, Windows, Linux Reporter: David Wisneski Assigned To: David Wisneski A while back we changed the syntax of update locking from FOR UPDATE OF to WITH RS USE AND KEEP UPDATE LOCKS

Re: svn commit: r510281 - in /incubator/openjpa/trunk: openjpa-jdbc/src/main/java/org/apache/openjpa/jdbc/sql/ openjpa-kernel/src/main/java/org/apache/openjpa/kernel/ openjpa-persistence/src/main/java

I opened a JIRA feature openjpa-168 to discuss how to improve this. On 2/27/07, Patrick Linskey [EMAIL PROTECTED] wrote: Hi, What's the word on this issue? -Patrick -- Patrick Linskey BEA Systems, Inc. ___ Notice: This

[jira] Resolved: (OPENJPA-22) locate substring queries fail both db2 derby, cannot use parameter markers in expression ?-?

[ https://issues.apache.org/jira/browse/OPENJPA-22?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski resolved OPENJPA-22. --- Resolution: Fixed Assignee: David Wisneski fixed in r516624 locate substring

extraneous joins OPENJPA-134

Hi Patrick or Abe, I was wondering if any of you have noticed the following problem. ( this is written up as OPENJPA-134). This shows up as a performance problem in applications when we compare with Hibernate. If I have a M:1 relationship and I make both sides of the relationship EAGER in

[jira] Closed: (OPENJPA-16) NPE in createQuery for EJB QL with nested correlated subqueries

[ https://issues.apache.org/jira/browse/OPENJPA-16?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-16. - Resolution: Fixed This problem has been fixed NPE in createQuery for EJB QL with nested

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

[ https://issues.apache.org/jira/browse/OPENJPA-47?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-47. - Resolution: Duplicate duplicate of OPENJPA-26 143 arithmetic unary operator (+,-) gives

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

[ https://issues.apache.org/jira/browse/OPENJPA-54?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-54. - Resolution: Fixed already fixed bad sql pushdown, should use all syntax

[jira] Closed: (OPENJPA-25) Incorrect SQL generated for queries involving more than one AbstractSchemaNames, generated SQL FROM clause is missing 'Table alias'

[ https://issues.apache.org/jira/browse/OPENJPA-25?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-25. - Resolution: Fixed not a problem anymore Incorrect SQL generated for queries involving more

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

[ https://issues.apache.org/jira/browse/OPENJPA-50?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-50. - Resolution: Fixed fixed in recent code bad sql pushdown, cast changes datatype

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

[ https://issues.apache.org/jira/browse/OPENJPA-62?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-62. - Resolution: Fixed fixed in recent code Ejbql join queries show invalid null Entities when run

[jira] Work started: (OPENJPA-77) Problems in default setting in DB2Dictionary , also missing support for DB2 z/OS platforms

[ http://issues.apache.org/jira/browse/OPENJPA-77?page=all ] Work on OPENJPA-77 started by David Wisneski. Problems in default setting in DB2Dictionary , also missing support for DB2 z/OS platforms

question on configuring multiple DataCaches

If there are multiple named DataCaches, what is the syntax for configuring sizes? I tried the following and a few other combinations but could not get it to work. I could not find an example in user guide of configuration multiple caches. property name=openjpa.DataCache

question on OpenJPA FetchGroups

I am trying to use a FetchGroup to retrieve a path of relationships. Can a fetchGroup be defined across multiple Entities? My application has DeptBean, EmpBean, ProjectBean with a relationship from DeptBean to EmpBean named emps and a relationship from EmpBean to ProjectBean named projects.

Re: question on configuring multiple DataCaches

privileged, and is intended solely for the use of the individual or entity named in this message. If you are not the intended recipient, and have received this message in error, please immediately return this by email and then delete it. -Original Message- From: David Wisneski [mailto

Re: [jira] Resolved: (OPENJPA-43) update of a persistent field using a @Lob annotation is not being marked dirty

calling OpenJPAEntityManager.dirty() on the field to make sure the system knows that it has changed. You can always make your setter perform the additional intermediate null setting. On Sep 14, 2006, at 12:29 PM, David Wisneski wrote: that works. Address a = e.getHome(); a.setCity(NewCity

[jira] Created: (OPENJPA-43) update of a persistent field using a @Lob annotation is not being marked dirty

Issue Type: Bug Components: kernel Reporter: David Wisneski An entity has a persistent field which is a serialable class annotated with @Lob. I am able to create and persist instances of this entity and field. But when the entity is retrieved and the field

question on FetchGroup

The preview documentation says that fetch group depth=0 is the default and that depth=0 will recurse until the graph is exhausted. The actual name on the @FetchGroup annotation seems to be recusionDepth not depth. However the behavior seems that it only supports recursionDepth=1 and setting it

[jira] Created: (OPENJPA-16) NPE in createQuery for EJB QL with nested correlated subqueries

Components: query Reporter: David Wisneski EJBQL:select c from Customer c where exists ( select o from Order o where o.cutomer = c and o.delivered=false and exists ( select l1 from LineItem l, in(o.lineitems) as l2 where l1=l2 )) partial stack trace is Caused

[jira] Created: (OPENJPA-17) bad sql with missing subquery produced with query with nested subqueries

Type: Bug Reporter: David Wisneski EJBQL: select c from Customer c where + exists ( select o from Order o where o.delivered=false and + exists ( select c from LineItem c where c.product.backorder 0)); SQL generated : Note that the second EXISTS() subquery

[jira] Created: (OPENJPA-19) 1.5F gets translated to BigDecimal(1.5) when used as literal in EJB QL when run against DB2.

Project: OpenJPA Issue Type: Bug Components: query Reporter: David Wisneski Priority: Minor 1.5F is a EJBQL floating point literal and should be mapped to a floating point parm value. -- This message is automatically generated by JIRA. - If you

[jira] Created: (OPENJPA-20) Query can return embeddable class

Query can return embeddable class - Key: OPENJPA-20 URL: http://issues.apache.org/jira/browse/OPENJPA-20 Project: OpenJPA Issue Type: Bug Components: docs Reporter: David Wisneski

[jira] Created: (OPENJPA-21) Time is missing from list of mutable classes.

Reporter: David Wisneski Priority: Minor section 1.6 java.sql.Time is missing from list of mutable classes. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure

[jira] Created: (OPENJPA-22) locate substring queries fail both db2 derby, cannot use parameter markers in expression ?-?

Project: OpenJPA Issue Type: Bug Components: query Reporter: David Wisneski EJB Q:: SELECT d.name FROM DeptBean d WHERE SUBSTRING(d.name,1,10) = 'Dept

[jira] Created: (OPENJPA-23) -418 sqlexception using DB2 and EJB QL with SQRT or MOD

: David Wisneski generated SQL is missing CAST function to indicate type of ? EJB QL : select e from EmpBean e where mod(e.empid,5)=0 DB2 SQL error: SQLCODE: -418, SQLSTATE: 42610, SQLERRMC: null {prepstmnt 1046232668 SELECT t0.empid, t0.bonus, t1.deptno, t1.budget, t1.name, t0.execLevel, t0