adapter service insertSQL data type different than DB data type

Hi Guys,

I’m having the following problem when trying to create an insertSQL adapter service to an ORACLE DB:

The data type for the field in the DB is TIMESTAMP, however, when using the insertSQL adapter service, its displaying as DATE. Now i’m using the following to get the current date as a TIMESTAMP

[INDENT]getCurrentDateString with pattern yyyy-MM-dd HH:mm:ss.SSSS
[/INDENT]I then try to insert that value using the adapter service, but this ofcourse fails.[/i]

[INDENT]Now, I have the code in my local IS instance and this is displaying as TIMESTAMP, but when i access the clients IS using Developer, it is showing DATE. The client has 3 environments - DEV, QA and PRD[/i]

[INDENT]I’ve set the adapter service as ..tablename

The version of JDBC adapter I’m using is 6.0.3. I don’t have access to IS Admin for the client, only Developer access in DEV and QA.

I’ve decided to send them a deployment to use my local package.
Please advise if there is an alternative.

There is a patch available for the JDBC adapter to support timestamps.

I deployed the packaged from my local IS to the client’s IS and it seems to have worked with the TIMESTAMP displaying. Also the adapterservice is allowing the string to be inserted as the creation_datetime.

Thank you for your help.

I’ll recommend to the client to get the latest patch of the JDBC Adapter