1 Reply Latest reply on Apr 20, 2005 10:20 AM by Hideki Mae

    Why the multiple sql select  for findByPrimaryKey JBoss 4.01

    Joost Kraaijeveld Newbie

      Why does JBoss generate multiple select statements (see log below) for a single findByPrimaryKey finder?

      As I suspected that it is had something to do with the read-ahead-strategy I have tried to use the XDoclet tag @jboss.read-ahead strategy = "none" but that did not change anything

      TIA

      Joost

      logs:

      2005-04-16 11:20:44,666 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCFindByPrimaryKeyQuery.Customer#findByPrimaryKey] Executing SQL: SELECT t0_Customer.objectId FROM customer t0_Customer WHERE t0_Customer.objectId=?
      2005-04-16 11:20:44,979 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Customer] Executing SQL: SELECT contractingParty, contractingPartyType, contractType, customerAlias, customerNumber, ipAddress, macAddress, contactPerson, address FROM customer WHERE (objectId=?)
      2005-04-16 11:20:45,041 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Customer] Executing SQL: SELECT contractingParty, contractingPartyType, contractType, customerAlias, customerNumber, ipAddress, macAddress, contactPerson, address FROM customer WHERE (objectId=?)
      2005-04-16 11:20:45,104 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Customer] Executing SQL: SELECT contractingParty, contractingPartyType, contractType, customerAlias, customerNumber, ipAddress, macAddress, contactPerson, address FROM customer WHERE (objectId=?)
      2005-04-16 11:20:45,151 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.Customer] Executing SQL: SELECT contractingParty, contractingPartyType, contractType, customerAlias, customerNumber, ipAddress, macAddress, contactPerson, address FROM customer WHERE (objectId=?)