webMethods String to java.sql.Date/Time issue.

, ,
1

Hello,

I have been having a problem with insertion of a date/time string in the format dd-MM-yyyy HH:mm (java format) into an Oracle 10g database.
Generating the insert adaptor service using webMethods developer, I have the Oracle date field mapped to jdbc date field. The input to the service is a string of the above format.

Whilst the date is inserted, the time is not.

What am I missing?

Thanks.

Cheers
G

2

I remember battling with similar issues. Some considerations:

  • Are you certain of your oracle table data type?
  • What data type do you tell the adapter to use? In the insert tab, the following works for us:JDBC type (top): TIMESTAMP, Input field type (bottom): java.util.date (changed from default java.sql.timestamp if I remember correctly)

HTH

Loic

3

Did you select jdbc filed type java.lang.String…
Also try this format dd-MMM-yyyy HH:mm:ss if not ask your ORA team in what format are they expecting and change it accordingly using via date Format service.

HTH,
RMG

4

Hi Kasinath,
I have faced to similar issues recently, If you are using mapping String to Date type(String to Date) we have service available in WMPublic folder. If you are mapping to a timestamp type try using this format: dd-MMM-yy hh.mm.ss.SSSSSS a. Oracle understands this format.

If you need more information, i will help you.
thanks & regards,
vijay

1 Like
5

Hi

I am recently facing this issue of inserting dat time to OracleDb.

I tried the above mentioned ways but no luck.

Can anyone help on this?

6

Hi Preethika,

please provide some more details as well as some version informations.

  • wM Version
  • JDBC Adapter Version
  • Oracle Version
  • Driver Jar Version.

Are there any messages in the server.log or error log which might be helpful for analysis?

Regards,
Holger

7

Hi,

i have the same issue

com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service dao:callROCreateSimul.
ClassCast Exception for field: V_MATURITY. Error: java.lang.ClassCastException: java.lang.String cannot be cast to java.util.Date

Regards

8

Hi Olivier,

can you provide some Screenshots of your adapter service showing the columns and inputs/outputs definition?

Usually you should the inputs/outputs to java.lang.String when the column is defined as TIMESTAMP.
ART will do the conversion in background.

Regards.
Holger

9

Hi,

here screen shot

regards

adapter.gif
adapter.gif1204×451 31.5 KB

flow screen shot 2.gif
flow screen shot 1.gif
flow screen shot 1.gif1015×838 29.2 KB

10

Hi Olivier,

please set the Input field type to either java.util.Date or java.lang.String instead of java.sql.Date.

The Adapter and the Driver will handle the conversion in Background for you.

Regards,
Holger

11

Hi Holger,

thanks for the update.
The fields to change the type is not available this is an adapter type Store Procedure with signature, i don’t know if it is normal.

Regards

12

Hi Olivier,

can you try to convert the java.lang.String to a java.util.Date and then assign this date to the adapter?
Hopefully the java.util.Date can be converted to the java.sql.Date.

Regards,
Holger