MQSeries.net :: View topic

voyager · Posted: Mon Oct 03, 2005 7:39 pm Post subject:

Friends,
Lately, I have come across a problem with JDBC connector in ICS.

I am trying to write a time stamp value (with milliseconds)
format
MM/dd/yyyy HH:mm:ss.SSS into a SQL table using JDBC connector.

There is already a connector specific property existing on JDBC connector
for DateFormat - MM/dd/yyyy HH:mm:ss.

When MM/dd/yyyy HH:mm:ss.SSS formatted value in BO is supplied to JDBC Connector
to write to SQL Table, JDBC connector throws exception
com.crossworlds.cwconnectorapi.exceptions.
VerbProcessingFailedException[Type: Error] [MsgID: 90012]
[Mesg: ParseException java.text.ParseException: Unparseable date: "2005-09-23 14:14:00.428"]

But, if I change the DateFormat property in Connector Specific properties of JDBC Connector to MM/dd/yyyy HH:mm:ss.SSS, then the rest of attributes in BOs whose date-formats such as MM/dd/yyyy HH:mm:ss would fail.

I am not sure if in any way, I can give this information in Application Specific Information for Attribute in BO because there is only one
attribute with this date format (MM/dd/yyyy HH:mm:ss.SSS).

I would appreciate very much, if anyone could give me suggestions to overcome this error.

Thank you very much in advance.
_________________
voyager