Re: [eclipselink-users] ORA-1461 trying to insert String to XMLType

[Yiping Zhao <yiping.zhao@xxxxxxxxxx>]

Hi David,

In main branch,  "customfeatures" jpa test model is under 
trunk\foundation\eclipselink.extension.oracle.test\resource\customfeatures, 
the persistence.xml is under 
trunk\foundation\eclipselink.extension.oracle.test\resource\customfeatures, 
you can take a look at it.

Yiping

David Parker wrote:
> Thanks for the response! I agree that it is a JDBC issue. Your 
> suggestion sounds promising, but I'm afraid I have no idea where to 
> start, not having used the "native" toplink/eclipselink stuff. If you 
> could just point me to the doc for this, I'd appreciate it.
>
> Thanks!
>
> - DAP
>
> On Mar 30, 2009, at 1:44 PM, James Sutherland wrote:
>
> > Seems to be a JDBC issue, I would assume you will get the same error 
> > through
> > raw JDBC (SQLPlus does not use JDBC).
> >
> > In EclipseLink there is a special mapping to handle XML Types, trying 
> > using
> > the DirectToXMLTypeMapping.  You can add this mapping using a
> > DescriptorCustomizer.
> >
> >
> > David Parker-13 wrote:
> > > I have a JPA object with a String attribute that is bound to a
> > > database column of XMLType (Oracle 10g R2). When I try to persist the
> > > object, I get the error
> > >     ORA-01461: can bind a LONG value only for insert into a LONG column
> > > I have seen some posts in various places about problems of this kind
> > > with writing to an XMLType. I am just using XMLType for the first
> > > time, so I may be missing some configuration, but I am able to insert
> > > into it OK from SQL*Plus.
> > >
> > > Is there specific support in Eclipselink somewhere for XMLType fields,
> > > or has anybody run into this?
> > > =============================================
> > > David Parker
> > > dap@xxxxxxxxxxxxxxxxxxxx
> >
> >
> > -----
> > ---
> > http://wiki.eclipse.org/User:James.sutherland.oracle.com James 
> > Sutherland
> > http://www.eclipse.org/eclipselink/
> > EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
> > TopLink
> > Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink ,
> > http://wiki.oracle.com/page/TopLink TopLink
> > Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
> > http://www.nabble.com/EclipseLink-f26430.html EclipseLink
> > Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence
> > --
> > View this message in context: 
> > http://www.nabble.com/ORA-1461-trying-to-insert-String-to-XMLType-tp22747045p22788767.html 
> >
> > Sent from the EclipseLink - Users mailing list archive at Nabble.com.
> >
> > _______________________________________________
> > eclipselink-users mailing list
> > eclipselink-users@xxxxxxxxxxx
> > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
> =============================================
> David Parker
> dap@xxxxxxxxxxxxxxxxxxxx
>
>
>
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users