You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Catalina Wei (JIRA)" <ji...@apache.org> on 2010/08/17 02:13:15 UTC
[jira] Commented: (OPENJPA-1748) delete error when using constant
joins with fetchtype lazy
[ https://issues.apache.org/jira/browse/OPENJPA-1748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12899198#action_12899198 ]
Catalina Wei commented on OPENJPA-1748:
---------------------------------------
Michel,
To reproduce the problem, could you provide the jave source code for Table1 and Table2 classes ?
Thanks.
> delete error when using constant joins with fetchtype lazy
> ----------------------------------------------------------
>
> Key: OPENJPA-1748
> URL: https://issues.apache.org/jira/browse/OPENJPA-1748
> Project: OpenJPA
> Issue Type: Bug
> Affects Versions: 1.2.1
> Environment: - windows glassfish/mysql
> - linux glassfish/mysql
> - linux weblogic/oracle
> Reporter: Michel Ganguin
> Priority: Critical
>
> Entity (fetch lazy, without cascade):
> @Entity
> @Table(name="Table1")
> public class Table1 {
> @ManyToOne(optional = true, fetch = FetchType.LAZY)
> @JoinColumns({
> @JoinColumn(name="FK" referencedColumnName="PK1"),
> @JoinColumn(name="Table2.PK2" referencedColumnName="'a'")
> });
> private Table2 table2;
> }
> I want to remove an entry:
> Table1 t1 = entityManager.find(Table1.class, "table1Key");
> entityManager.remove(t1);
> but this raises an exception because the parameter 'a' (from referencedColumnName) is missing.
> org.apache.openjpa.persistence.PersistenceException: No value specified for parameter 2. {prepstmnt 1615708154 SELECT t1.* FROM Table1 t0 INNER JOIN Table2 t1 ON t0.FK = t1.PK1 AND ? = t1.PK2 WHERE t0.PK = ? [params=(String) table1Key]} [code=0, state=22023]
> as workaround it works without errors if I change fetchtype to eager, but in my case this could have a great performance overhead.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.