Re: nvarchar / nclob

From: Mike Kienenberger (mkienen..mail.com)
Date: Wed Jan 04 2006 - 11:45:31 EST

  • Next message: Mike Kienenberger: "Re: No access to getObjectStore().getFlattenedInserts() / getFlattenedDeletes()"

    I'd recommend trying different Oracle drivers first.
    Oracle driver quality varies greatly even in minor point releases.

    On 1/4/06, Andrus Adamchik <andru..bjectstyle.org> wrote:
    >
    > On Jan 3, 2006, at 9:56 AM, Cris Daniluk wrote:
    >
    > > Cayenne seems to have "forgotten" how to map nvarchar / nclob types in
    > > Oracle. I'm pretty sure this worked before, but now they are imported
    > > as type "OTHER".
    >
    > Probably the driver is to blame. I don't think we ever had any
    > special handling of those.
    >
    >
    > > I don't know if nvarchar / nclob are standard types, though they are
    > > used by numerous RDBMS - so not sure where they should be registered
    > > (globally or by adapter). Any ideas?
    >
    > Should be pretty easy to fix. Simplest way to do it is inside
    > OracleAdapter.buildAttribute(..). Alternatively we may build a
    > generic algorithm for handling OTHER by matching DB-specific
    > "TYPE_NAME" (returned by JDBC together with Type.OTHER) against
    > types.xml mapping. The last approach requires more testing, but is
    > more generic.
    >
    > Care to open a bug report?
    >
    > Andrus
    >

    This archive was generated by hypermail 2.0.0 : Wed Jan 04 2006 - 11:45:35 EST