Return-Path: Delivered-To: apmail-db-ojb-dev-archive@www.apache.org Received: (qmail 17456 invoked from network); 4 Feb 2006 17:27:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Feb 2006 17:27:14 -0000 Received: (qmail 85820 invoked by uid 500); 4 Feb 2006 17:27:13 -0000 Delivered-To: apmail-db-ojb-dev-archive@db.apache.org Received: (qmail 85800 invoked by uid 500); 4 Feb 2006 17:27:13 -0000 Mailing-List: contact ojb-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "OJB Developers List" Reply-To: "OJB Developers List" Delivered-To: mailing list ojb-dev@db.apache.org Received: (qmail 62739 invoked by uid 99); 3 Feb 2006 21:25:25 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UPPERCASE_25_50 X-Spam-Check-By: apache.org Message-ID: <2060937961.1139001904552.JavaMail.jira@ajax.apache.org> Date: Fri, 3 Feb 2006 22:25:04 +0100 (CET) From: "Jakob Braeuchi (JIRA)" To: ojb-dev@db.apache.org Subject: [jira] Commented: (OJB-94) NPE when execute query (join via 1:n reference) on objects using "table-per-subclass"-inheritance In-Reply-To: <1620543793.1138925223906.JavaMail.jira@ajax.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/OJB-94?page=comments#action_12365132 ] Jakob Braeuchi commented on OJB-94: ----------------------------------- fixed npe but sql looks weird and name cannot be resolved SELECT A0.OBJ_ID,A0.NAME FROM INHERITANCE_CONSORTIUM A0 INNER JOIN INHERITANCE_MANAGER A1 ON A0.OBJ_ID=A1.FK_CONSORTIUM INNER JOIN INHERITANCE_EXECUTIVE A2 ON A1.OBJ_ID=A2.OBJ_ID AND A1.OBJ_ID_2=A2.OBJ_ID_2 INNER JOIN INHERITANCE_EMPLOYEE A3 ON A2.OBJ_ID=A3.OBJ_ID AND A2.OBJ_ID_2=A3.OBJ_ID_2 INNER JOIN INHERITANCE_ADDRESS A6 ON A3.FK_ADDRESS=A6.OBJ_ID INNER JOIN INHERITANCE_EXECUTIVE A4 ON A1.OBJ_ID=A4.MANAGER_ID AND A1.OBJ_ID_2=A4.MANAGER_ID_2 INNER JOIN INHERITANCE_EMPLOYEE A5 ON A4.OBJ_ID=A5.OBJ_ID AND A4.OBJ_ID_2=A5.OBJ_ID_2 WHERE ((A0.NAME = 'testInheritedReferences_1139000708750') AND A6.STREET = 'testInheritedReferences_1139000708750_street_12') AND name = 'testInheritedReferences_1139000708750_Manager' > NPE when execute query (join via 1:n reference) on objects using "table-per-subclass"-inheritance > -------------------------------------------------------------------------------------------------- > > Key: OJB-94 > URL: http://issues.apache.org/jira/browse/OJB-94 > Project: OJB > Type: Bug > Versions: 1.0.4 > Reporter: Armin Waibel > > The NPE is caused by SqlQueryStatement.buildSuperJoinTree > Criteria crit = new Criteria() > .addEqualTo("name", consortium.getName()) > .addEqualTo("managers.executives.address", name + "_street_12") > .addEqualTo("managers.name", name + "_Manager"); > Query q = QueryFactory.newQuery(Consortium.class, crit); > Caused by: java.lang.NullPointerException > at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.buildSuperJoinTree(SqlQueryStatement.java:1798) > at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.getTableAlias(SqlQueryStatement.java:1210) > at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.buildJoinTreeForColumn(SqlQueryStatement.java:1774) > at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.buildJoinTree(SqlQueryStatement.java:1751) > at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.splitCriteria(SqlQueryStatement.java:1855) > at org.apache.ojb.broker.accesslayer.sql.SqlQueryStatement.(SqlQueryStatement.java:154) -- 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 --------------------------------------------------------------------- To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org For additional commands, e-mail: ojb-dev-help@db.apache.org