Turn the log level up to TRACE and you will see the exact parameter set and the results loaded. Also, are you using the 3.0 final release?
-dain Craven, Jason wrote: > I have a many to many relationship defined that is not working correctly. > When I try to get the collection object from one of the entities it returns > a collection with a size of 0. I've checked the relation table and there is > data that is returned when I query it with the same select statement I find > in the server.log file. Any ideas? > > Here's an excerpt from the server.log: > 2002-06-12 09:55:23,208 ERROR [STDERR] Getting items > 2002-06-12 09:55:23,228 DEBUG > [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadRelationCommand.JobEJB] Executing > SQL: SELECT JOBITEM FROM JOB_JOBITEMS WHERE (JOB=?) > 2002-06-12 09:55:23,248 ERROR [STDERR] jobitems count 0 > > Here's the relationship in the ejb-jar.xml: > > <ejb-relation> > <ejb-relation-name>Job-JobItem</ejb-relation-name> > <ejb-relationship-role> > > <ejb-relationship-role-name>job-has-jobitems</ejb-relationship-role-name> > <multiplicity>Many</multiplicity> > <relationship-role-source> > <ejb-name>JobEJB</ejb-name> > </relationship-role-source> > <cmr-field> > <cmr-field-name>jobItems</cmr-field-name> > > <cmr-field-type>java.util.Collection</cmr-field-type> > </cmr-field> > </ejb-relationship-role> > <ejb-relationship-role> > > <ejb-relationship-role-name>jobitem-iscomponentof-job</ejb-relationship-role > -name> > <multiplicity>Many</multiplicity> > <relationship-role-source> > <ejb-name>JobItemEJB</ejb-name> > </relationship-role-source> > </ejb-relationship-role> > </ejb-relation> > > > Here's the definition in the jbosscmp-jdbc.xml file: > <ejb-relation> > <ejb-relation-name>Job-JobItem</ejb-relation-name> > <relation-table-mapping> > <table-name>JOB_JOBITEMS</table-name> > </relation-table-mapping> > <ejb-relationship-role> > > <ejb-relationship-role-name>job-has-jobitems</ejb-relationship-role-name> > <key-fields> > <key-field> > <field-name>jobID</field-name> > <column-name>JOB</column-name> > </key-field> > </key-fields> > </ejb-relationship-role> > <ejb-relationship-role> > > <ejb-relationship-role-name>jobitem-iscomponentof-job</ejb-relationship-role > -name> > <key-fields> > <key-field> > <field-name>jobItemID</field-name> > <column-name>JOBITEM</column-name> > </key-field> > </key-fields> > </ejb-relationship-role> > </ejb-relation> > -- > Jason Craven <[EMAIL PROTECTED]> > Sr. Developer, Application Development & Integration > Nextel Communications, Inc. > 678.878.1655 > > _______________________________________________________________ > > Sponsored by: > ThinkGeek at http://www.ThinkGeek.com/ > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________________________ Sponsored by: ThinkGeek at http://www.ThinkGeek.com/ _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
