Oracle database 'dateTime' type is not accepting 'NULL' values from ESB
654432Jun 3 2009 — edited Jun 5 2009Hi,
We are trying to pass 'NULL' values from Oracle ESB for 'dateTime' field in Oracle Database. We are getting the following exception:
The invocation resulted in an error: com.bea.wli.sb.transports.TransportException: com.bea.ld.QueryException:
Even we have done the following work around suggested by Bea-forum to solve it.
1. If user is not entering any values for 'dateTime' field, we are passing this date *(0001-01-01T00:00:00)* by default from Service Bus console.
2. In DSP console we are checking for the above date and if it matches we are passing NULL to Oracle Database.
The above solution works fine from DSP console and it returns proper response. When we try to run Business Service from ESB console its throwing the above exception.
Please assist !!
Thanks in advance.
Regards,
Leela