Use prepared statement - problem - ibm.software.network.directory-integrator

Message from discussion Use prepared statement - problem

Zbigniew Szmigiero

View profile

More options 1 July, 20:46

Newsgroups: ibm.software.network.directory-integrator

From: Zbigniew Szmigiero <zszmigi...@gmail.com>

Date: Wed, 1 Jul 2009 12:46:34 -0700 (PDT)

Local: Wed 1 July 2009 20:46

Subject: Use prepared statement - problem

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

I would like to use own SQL statement in the lookup to restrict output
to part of record
SELECT emp_number, code FROM `hs_hr_emp_jobtitle_history` WHERE
end_date IS NULL;

The output contains 3 different records but Assembly Line returns
"Multiple Line Entries" error:

21:39:45,530 INFO - [JDBCConnector_3] CTGDIS495I handleException ,
lookup, java.lang.Exception: [JDBCConnector_3] CTGDIS048E Multiple
entries found and no 'On Multiple Entries' Hook defined.
21:39:45,530 ERROR - [JDBCConnector_3] CTGDIS810E handleException -
cannot handle exception , lookup java.lang.Exception:
[JDBCConnector_3] CTGDIS048E Multiple entries found and no 'On
Multiple Entries' Hook defined.
21:39:45,546 ERROR - CTGDIS266E Error in NextConnectorOperation.
Exception occurred: java.lang.Exception: [JDBCConnector_3] CTGDIS048E
Multiple entries found and no 'On Multiple Entries' Hook defined.
java.lang.Exception: [JDBCConnector_3] CTGDIS048E Multiple entries
found and no 'On Multiple Entries' Hook defined.
21:39:45,577 INFO - [FileSystemConnector] CTGDIS525I Closing Parser
on output stream.

If I use prepared statement assembly line doesn't recognize
possibility to manage this hook

Any idea????

Reply to author Forward