Unable to execute statement for table or stored procedure. Table name(Structure StatementName) due to java.text.ParseException: Unparseable date: "08.04.2016"

[Former Member]

Hi Experts,

could you please look in to this issue and provide me the solution.

working on SAP PO and IDOC to JDBC.

source : yymmdd and target i need to get  dd.mm.yy

And i have used TRANSFORMDATE function and i kept source date: yymmdd and target date : dd.mm.yy

in channel level i kept the timestamp as:  dd.MM.yyyy HH:mm:ss

ERROR:

Unable to execute statement for table or stored procedure. TABLE NAME(Structure StatementName) due to java.text.ParseException: Unparseable date: "08.04.2016"

Thanks ,

Abhilash.

[bhavesh_kantilal]

• MS SQL Server represents date as YYYY-MM-DD
• Please change to this format if you are using MS SQL Server as your database format.

Regards

Bhavesh

[former_member186851]

Hello Abhilash,

It is clearly because of Date format.

The data format should match the date format of the JDBC table field.

We had the same issue then changed the date format then it worked.

Which database your trying to hit?

[Former Member]

hi Raghuraman,

database: sql

and we have changed data format is like the date format of the JDBC table field only still we are facing the same issue.

[former_member186851]

Hello Abhilash,

Execute the same query in the DB side and check once.

[iaki_vila]

Hi Abhilash,

Like suggestion i always do a dummy scenario with two mapping XSLT. The first one i set a SELECT with all the fields that i know the table has them, for the response you can do a simply XSLT to copy all the message (xsl:copy-of-select "/"). In this way you can check the table formats, like the date format and to do in your real scenario the insert/updater/update_insert correctly.

Regards.