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.