[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] ORA-1461 trying to insert String to XMLType

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
> dap@xxxxxxxxxxxxxxxxxxxx

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 , 
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.