openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <j...@apache.org>
Subject [jira] Created: (OPENJPA-1779) Unknown column type returned for Oracle XMLType columns
Date Tue, 31 Aug 2010 22:37:52 GMT
Unknown column type returned for Oracle XMLType columns
-------------------------------------------------------

                 Key: OPENJPA-1779
                 URL: https://issues.apache.org/jira/browse/OPENJPA-1779
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc
    Affects Versions: 1.2.2
            Reporter: Michael Dick
            Priority: Minor


I've only seen this as an issue when using Oracle's XMLType and using openjpa.jdbc.SchemaFactory=native
to build mapping information from the database. There may be other ways this problem can be
exposed.

Recent versions of the JDBC driver for Oracle return 2007 as the DATA_TYPE for XMLType column
(observed on 11.2.0.1.0). Earlier versions (10.2.0.3.0) returned java.sql.Types.OTHER. What's
odd is that I don't see 2007 as a defined constant  for java.sql.Types - as a result OpenJPA
throws an exception citing an unknown column type. It's not clear to me whether this is a
bug in the JDBC driver or something we need to adapt to, or whether 2007 was just a holding
place for Types.SQLXML (which is set to 2009). 

As a workaround we can treat 2007 as Types.OTHER for Oracle (at least for OpenJPA 1.2.x).

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message