Skip to Content
Former Member
Jul 02, 2013 at 06:40 AM

JDBC Receiver Prepared Statement (sqlBindMode): how to convert date ?



I try to use PreparedStatement in JDBC receiver adapter (sqlBindMode) for performance improvement (see SAP note 1404778) in SAP PI 7.11 EHP 6.

I`v faced with problem: I can`t use Oracle function TO_DATE to convert date format. The JDBC driver returned "ORA-01858: a non-numeric character was found where a numeric was expected" for fields type DATE.

I guess the cause is that values of SQL statement are filled by setString function while Oracle are expecting DATE type. And there is no way to typify elements in JDBC INSERT statement.

Does anyone know how to use PreparedStatement mode with DATE type fields?

Regards, Sergey.