Patches item #419426, was updated on 2001-04-27 01:35 You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376687&aid=419426&group_id=22866 Category: JBossCMP Group: v2.2 (stable) Status: Open Resolution: None Priority: 5 Submitted By: KV Vinay Menon (kvvinaymenon) Assigned to: Nobody/Anonymous (nobody) Summary: CMP- Joins - Multiple Primary Keys Initial Comment: The join mechanism fails to work in case the tables being joined have a composite primary key. This is because the sql is constructed by org.jboss.ejb.plugins.jaws.jdbc.JDBCDefinedFinderComman d in the statement if (query.toLowerCase().startsWith(",")) { sql = "SELECT " + jawsEntity.getTableName() +"."+getPkColumnList() + strippedOrder + " FROM " + jawsEntity.getTableName() + " " + query; does not prefix the table name for all the primary key columns leading to ambiguous column references. The file attached has the fix for that. ---------------------------------------------------------------------- You can respond by visiting: http://sourceforge.net/tracker/?func=detail&atid=376687&aid=419426&group_id=22866 _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-development
