[OPENICF-81] DatabaseTableConnector can't handle timestamp data type from Oracle Created: 21/Feb/13  Updated: 14/Jan/15  Resolved: 14/Mar/13

Status: Closed
Project: OpenICF
Component/s: Database Table Connector
Affects Version/s: databasetable-connector-1.1.0.0
Fix Version/s: None

Type: Bug Priority: Major
Reporter: johan Assignee: Gael Allioux
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: Text File exception_timestamp.txt    
Case Id: https://support.forgerock.com/tickets/538

 Description   

Resource for LiveSync: Oracle database table
Data type of changeLogColumn: timestamp(6)

When starting LiveSyn on the Oracle DB table, the following exception is thrown:
java.lang.IllegalArgumentException: Attribute type 'class oracle.sql.TIMESTAMP' is not supported.



 Comments   
Comment by Gael Allioux [ 13/Mar/13 ]

Should have a look at this:

http://alberlau.blogspot.fr/2008/01/oracle-jdbc-oraclesqltimestamp-issue.html

and try to set the -Doracle.jdbc.J2EE13Compliant=true as a JVM option in the openidm startup.sh file
to see if any better...

Comment by iris [ 14/Mar/13 ]

Setting -Doracle.jdbc.J2EE13Compliant=true as a JVM option in the openidm startup.sh file solves the problem.

Comment by Ladislav Folta [ 14/Jan/15 ]

Verified by customer.

Generated at Tue Sep 22 11:38:36 UTC 2020 using Jira 7.13.12#713012-sha1:6e07c38070d5191bbf7353952ed38f111754533a.