[TORQUE-318] retrieveByPK throws TorqueException instead of NoRowsException when it can't find a primary key.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0
• Fix Version/s: 5.0
• Assignee: Thomas Fox
• Reporter: Martin Tilsted
• Created: 05/Jun/14 15:40
• Updated: 03/Sep/14 19:36
• Resolved: 03/Sep/14 19:36

Description

I have the following in my schema.xml:
<table name="read" idMethod="none">
<column name="userRef" primaryKey="true" required="true" type="INTEGER" />
<column name="entryId" primaryKey="true" required="true" type="INTEGER" />
<column name="entryType" primaryKey="true" required="true" type="INTEGER" />
<column name="readTime" type="TIMESTAMP" required="true" />
</table>

Which then generate the following code in my Peer class.
/**

• retrieve object using using pk values.
  *
• @param juusuuserref int
• @param entryid int
• @param entrytype int
• @param con Connection
  */
  public static Juusuread retrieveByPK(
  int juusuuserref,
  int entryid,
  int entrytype,
  Connection con) throws TorqueException
  {
  ....
  }

But this retrieveByPK will throw a
TorqueException("Failed to select one and only one row.")
instead of a NoRowsException as expected if it can't find a entry in the database.