Go to Google Groups Home    ibm.software.network.directory-integrator
Use prepared statement - problem

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

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????