Catalina Wei/Silicon Valley/IBM is out of the office.

I will be out of the office starting 09/01/2006 and will not return until 09/07/2006. I will respond to your message when I return.

Catalina Wei/Silicon Valley/IBM is out of the office.

I will be out of the office starting 11/13/2006 and will not return until 12/04/2006. I will respond to your message when I return.

Re: JOIN in subselect problems

Roger, There is a similar problem already reported under bug OPENJPA-51. Catalina On 3/13/07, roger.keays <[EMAIL PROTECTED]> wrote: Is there anything wrong with the following query? UPDATE Email e SET e.totalDeliveries = e.totalDeliveries + 1 WHERE e.email IN ( SELECT m.emai

Catalina Wei/Silicon Valley/IBM is out of the office.

I will be out of the office starting 03/30/2007 and will not return until 04/11/2007. I will respond to your message when I return.

Re: [jira] Resolved: (OPENJPA-134) Extra unneeded SQL joins for OneToMany relationship with fetch type EAGER

ip with fetch type EAGER > - > > Key: OPENJPA-134 > URL: https://issues.apache.org/jira/browse/OPENJPA-134 > Project: OpenJPA > Issue Type: Bug > Components: sql >Rep

[DISCUSS] Mapping persistent field to Database back-end XML columns

[DISCUSS 1]: Many database systems now have support for XML types which includes DB2 v9.1, DB2 zOS v9, Oracle 10g, and SQLServer 2005. Tables may contain XML columns where you can store XML documents. What is OpenJPA's position of supporting the XML columns ? The current mapping choices for XML co

Re: xml store help?

Anh, I have created issue OPENJPA-238 for keeping track of this problem. The patch that I sent to you is also attached under OPENJPA-238. Catalina On 5/8/07, Ngo, Anh (ISS Southfield) <[EMAIL PROTECTED]> wrote: Hello, I am evaluating openJPA to use for our current project. It works fine f

[jira] Updated: (OPENJPA-15) EJBQL grammar needs to be updated to relfect JPA specification

[ http://issues.apache.org/jira/browse/OPENJPA-15?page=all ] Catalina Wei updated OPENJPA-15: Attachment: JPQL.txt JPQLExpressionBuilder.txt JPQL.txt -- patch file for JPQL grammar fixes JPQLExpressionBuilder.txt -- path file to support

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

OPENJPA-25 URL: http://issues.apache.org/jira/browse/OPENJPA-25 Project: OpenJPA Issue Type: Bug Components: query Reporter: Catalina Wei select e, d from EmpBean e, DeptBean d generates following SQL where t2 is undefined:

[jira] Created: (OPENJPA-26) JPQL parser failed to handle unary operations in arithmetic comparisons, eg. where -(e.salary+10) > -10

ira/browse/OPENJPA-26 Project: OpenJPA Issue Type: Bug Components: query Reporter: Catalina Wei Negation only works for numeric literals, should be generalized to arithmetic expressions. -- This message is automatically generated by JIRA. - If you think

[jira] Created: (OPENJPA-27) SQL Parameter markers generated for literals causes DB2 SQL error SQLCODE -417(SQLSTATE 42609), 418(SQLSTATE 42610)

://issues.apache.org/jira/browse/OPENJPA-27 Project: OpenJPA Issue Type: Bug Components: query Reporter: Catalina Wei over usage of parameter markers for LITERALS causes DB2 SQL errors. Literals in the JP query if generated 'as is' in the pushdow

[jira] Created: (OPENJPA-28) groupby clause of a subquery incorrectly duplicated in the main query in the generated SQL

Project: OpenJPA Issue Type: Bug Components: query Reporter: Catalina Wei JPquery: 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 generated pushdown SQL: SELECT t0.name, t0.salary, t1

[jira] Updated: (OPENJPA-15) EJBQL grammar needs to be updated to relfect JPA specification

[ http://issues.apache.org/jira/browse/OPENJPA-15?page=all ] Catalina Wei updated OPENJPA-15: Attachment: JPQL.txt > EJBQL grammar needs to be updated to relfect JPA specificat

[jira] Commented: (OPENJPA-27) SQL Parameter markers generated for literals causes DB2 SQL error SQLCODE -417(SQLSTATE 42609), 418(SQLSTATE 42610)

[ http://issues.apache.org/jira/browse/OPENJPA-27?page=comments#action_12429507 ] Catalina Wei commented on OPENJPA-27: - JP query: select e from EmpBean e where subString(e.name,1,5) = 'Harry' failed. <

[jira] Updated: (OPENJPA-15) EJBQL grammar needs to be updated to relfect JPA specification

[ http://issues.apache.org/jira/browse/OPENJPA-15?page=all ] Catalina Wei updated OPENJPA-15: Attachment: OPENJPA-15.txt attaching patch for OPENJPA-15. > EJBQL grammar needs to be updated to relfect JPA specificat

[jira] Updated: (OPENJPA-15) EJBQL grammar needs to be updated to relfect JPA specification

[ http://issues.apache.org/jira/browse/OPENJPA-15?page=all ] Catalina Wei updated OPENJPA-15: Attachment: OPENJPA-15.openjpa-kernel.txt This patch is applied successfully against openjpa-kenel. please ignore the previous attachments. > EJBQL gram

[jira] Updated: (OPENJPA-15) EJBQL grammar needs to be updated to relfect JPA specification

[ http://issues.apache.org/jira/browse/OPENJPA-15?page=all ] Catalina Wei updated OPENJPA-15: Attachment: openjpa-15.openjpa-kernel.txt fixed JPQL.jjt grammar for conforming EJB3.0 spec. queries such as the following used to fail with SYNTAX errors

[jira] Updated: (OPENJPA-15) EJBQL grammar needs to be updated to relfect JPA specification

[ http://issues.apache.org/jira/browse/OPENJPA-15?page=all ] Catalina Wei updated OPENJPA-15: Attachment: openjpa-15.openjpa-kernel.patch The attached patch fixes java source coding/comment styles. > EJBQL grammar needs to be updated to relfect

[jira] Updated: (OPENJPA-15) EJBQL grammar needs to be updated to relfect JPA specification

[ http://issues.apache.org/jira/browse/OPENJPA-15?page=all ] Catalina Wei updated OPENJPA-15: Attachment: openjpa-15.openjpa-kernel.patch attched patch in sync with latest code in svn > EJBQL grammar needs to be updated to relfect JPA specificat

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

Project: OpenJPA Issue Type: Bug Components: jdbc Reporter: Catalina Wei There are following problems: 1. the default storeCharsAsNumbers = true, does not work well in DB2. Preferable default setting should be false. 2. nextSequenceSQL() generates DB2 UDB

[jira] Created: (OPENJPA-134) Extra unneeded SQL joins for OneToMany relationship with fetch type EAGER

Issue Type: Bug Components: sql Reporter: Catalina Wei Running JPAConfiguration default setting for EagerFetchMode (FetchModeValue.EAGER_PARALLEL), the SQL generated is sub-optimal. Consider the following entities: lineitems( OneToMany

[jira] Created: (OPENJPA-135) join fetch not returning duplicate references which not conforming to ejb3.0 spec

: OpenJPA Issue Type: Bug Components: jpa Reporter: Catalina Wei In the description in EJB 3.0 JPA spec, section 4.4.5.3, the following query example SELECT d FROM Department d LEFT JOIN FETCH d.employees WHERE d.deptno = 1 The spec says this query returns 5 references

[jira] Created: (OPENJPA-215) unneeded left join SQL for queries with inner join fetch, related to issue OPENJPA-134

Project: OpenJPA Issue Type: Bug Components: sql Affects Versions: 0.9.6, 0.9.7, 0.9.8 Reporter: Catalina Wei In verifying fixes for issue OPEN-134, found an outstanding problem. Extra unneeded join generated for the following query with inner join fetch

[jira] Commented: (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:comment-tabpanel#action_12491902 ] Catalina Wei commented on OPENJPA-51: - Abe, I am working on issue OPENJPA-51 for David Wisneski. I need some

[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 ] Catalina Wei updated OPENJPA-51: Attachment: openjpa-51.patch Abe, Could you please verify and comment on the patch I am providing

[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 ] Catalina Wei updated OPENJPA-51: Attachment: SelectImpl.java.patch Abe, Based on your comment, I have revised my patch. Please

[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 ] Catalina Wei updated OPENJPA-51: Attachment: SelectImpl.java.patch Abe, I make some mistake in my previous patch, attaching a

[jira] Commented: (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:comment-tabpanel#action_12493764 ] Catalina Wei commented on OPENJPA-51: - Abe, Is it really a regression? I replaced the copy of SelectImpl with

[jira] Commented: (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:comment-tabpanel#action_12494138 ] Catalina Wei commented on OPENJPA-51: - Abe, You are right, the code before theispatch (SelectImpl.java revision

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

-238 Project: OpenJPA Issue Type: Bug Components: xml store Reporter: Catalina Wei Problem reported by Ngo, Anh (full description with attachments can be found in openjpa-dev mails, subject title: xml store help? In evaluating openJPA to use for our

[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 ] Catalina Wei updated OPENJPA-238: - Attachment: XMLFileHandler.patch The attached patch has been sent to Anh Ngo, and it resolved

[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 ] Catalina Wei updated OPENJPA-238: - Attachment: XMLFileHandler.patch New patch for OPENJPA-238. The previous patch won't co

[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 ] Catalina Wei updated OPENJPA-51: Attachment: SelectImpl.java.patch Abe, Could you please verify if this patch regress your tests

[jira] Created: (OPENJPA-240) Persistent field mappings to database supported XML columns

Components: jdbc Reporter: Catalina Wei Many database systems such as DB2 version 9, Oracle 10g, and SQLServer 2005 have support for XML column types. XML documents can be stored natively in the XML columns in the database. What is OpenJPA's position of supporting the XML co