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