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.email

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

- Key: OPENJPA-134 URL: https://issues.apache.org/jira/browse/OPENJPA-134 Project: OpenJPA Issue Type: Bug Components: sql Reporter: Catalina Wei Fix

[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

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

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

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: SELECT t1

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

/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 pushdown SQL, can

[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 grammar

[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

[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

[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 compile

[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 columns