-
Type: Bug
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Component/s: Core VCS
-
Backlog priority:600
-
Sprint:nxFG 9.1.9
-
Story Points:1
When migrating to a newer version of Oracle (12c), or maybe of its JDBC drive (ojdbc7), more specific SQL types are returned when introspecting the table's columns. What was returned an indeterminate OTHER may now be returned as a specific NVARCHAR or CLOB.
Because Nuxeo does checks to ensure that the columns are of the proper type, failures may occur, like:
SQL type mismatch for "CONTENT"."NAME": expected 12, database has -9 / NVARCHAR2 (2000) SQL type mismatch for "COMMENT"."TEXT": expected 2005, database has 2011 / NCLOB (4000) SQL type mismatch for "RELATION"."TARGETSTRING": expected 2005, database has 12 SQL type mismatch for "STORY"."VERSION": expected -5, database has 3 / DECIMAL (38)
java.sql.Type has: -9=NVARCHAR, -5=BIGINT, 3=DECIMAL, 12=VARCHAR, 2005=CLOB, 2011=NCLOB