I'm trying to insert a row into a SAPDB table using the SAP Business Connector middleware (it's actually made by WebMethods) and it's failing because of a timestamp value I'm passing. The specific error is "com.sap.dbtech.jdbc.translators.ConversionExceptionSapDB:Cannot convert data to type Timestamp."

The value being passed is in the format "yyyy-MM-DD HH:mm:ss" (example: "2003-12-11 11:10:53") and the SAPDB parameter "DATE_TIME_FORMAT" is set to "ISO". The SAP Business Connector is connecting to SAPDB using the JDBC driver and I'm using the "pub.db:execSQL" SAP BC flow service to execute the SQL statement.

Any ideas anyone?

Thanks

Jim Sibley


-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to