JDBC insert problem

[Former Member]

Hi,

We are facing a peculiar issue in our zero date conversion. I do a date transformation of u201C00000000u201D to a constant date using the date trans function. During run time when the zero date is encountered it maps the correct constant date. But when we check the sql server DB, the date is created with an extra day. Eg: If we had set the constant date to 12/30/2005, the date in the sql server is 12/31/2005. But the XI mapping contains only 12/30/2005. Any ideas.

Teresa

[Former Member · Accepted solution]

HI

Why are you using a Date Transformation function, do one thng try using fixed value map and map if input is 00000000 to the date u want it to be.

Try this out.Also check if the Payload after mapping is has the right format and date which u want

In the JDBC reciver channel monitoring u can find it...

Rgds

Aditya

[Former Member · Accepted solution]

Hi,

The XI mapping has the right value and the communication channel has a correct value too. But once I look into the sql server DB, it has added an extra day. Not sure. Please advise.

Teresa

[Shabarish_Nair · Accepted solution]

this is not an issue with XI for sure.

Check with the DB admin of the database you are writing to if the DB has any settings defined.

[Former Member · Accepted solution]

try using date format function a the time of insert on DB side,

like :--To_date or To_char

[Former Member · Accepted solution]

Check the URL,it can help you:

Reward points if helpful

regards

yu ming

[Former Member]

Hi

Not an XI issue. Check with the DB properties. Also try making an entry directly into the DB without XI. See if the problem persists.

Regards

Monika

[Former Member]

Any ideas..

Teresa