openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Wisneski (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-18) bulk update to Entity with secondary table mapping produces BAD SQL
Date Wed, 16 Aug 2006 23:09:13 GMT
bulk update to Entity with secondary table mapping produces BAD SQL
-------------------------------------------------------------------

                 Key: OPENJPA-18
                 URL: http://issues.apache.org/jira/browse/OPENJPA-18
             Project: OpenJPA
          Issue Type: Bug
          Components: query
            Reporter: David Wisneski


EJBQL:   	update TwoTable t set  t.k1 = t.j2+1, t.j2= t.k1+1

TwoTable is mapped to primary and secondary table,  tj1, tj2 are fields in primary table,
 tk1, tk2 are fields in secondary table.  

Generated SQL from the trace shows: 

DB2 SQL error: SQLCODE: -206, SQLSTATE: 42703, SQLERRMC: J2 {prepstmnt 238685754 UPDATE ttk
SET k1 = (j2 + ?), j2 = (k1 + ?) WHERE id IN (SELECT DISTINCT t0.id FROM ttk t0  INNER JOIN
ttj t1 ON t0.id = t1.TwoTable_id) [params=(long) 1, (long) 1]} [code=-206, state=42703]


Note that  column j2 is not a column of take ttk which is the secondary table.  


-- 
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/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message