executing xml sql using jdbc adapter for date conversion

[Former Member]

Hi experts,

I am following the fllowing blog for date format conversion for a jdbc receiver.

/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

I constructed my graphical mapping to generate the following query

DateField in receiver structure = TO_DATE('2008-03-24','DD-MON-YY')

attribute hasQuot = No

The result that i want is 24-MAR-08

I am getting the error in communication channel monitoring as does not match string format.

The database gets successfully updated without this date conversion. But when i try to use this, it give the above error.

Is there any other configuration to be done to make the adapter execute this statement?

Regards,

Shamly

[Former Member]

The issue is solved.

The SQL statement was wrong.

The correct version is,( as was specified in the blog ) :-

DateField in receiver structure = TO_DATE('2008-03-24','YYYY-MM-DD')

Automatically in the database it is converted to 24-MAR-2008

Edited by: Shamly MM on Mar 27, 2008 8:01 AM