openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Dick (JIRA)" <>
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
             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

Recent versions of the JDBC driver for Oracle return 2007 as the DATA_TYPE for XMLType column
(observed on Earlier versions ( 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.

View raw message