[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [eclipselink-users] ORA-1461 trying to insert String to XMLType
- From: James Sutherland <jamesssss@xxxxxxxxx>
- Date: Mon, 30 Mar 2009 10:44:15 -0700 (PDT)
- Delivered-to: firstname.lastname@example.org
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
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
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
EclipseLink , http://www.oracle.com/technology/products/ias/toplink/
Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink ,
Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
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.