Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » ORA-01461:can bind a LONG value only for insert into a LONG column
ORA-01461:can bind a LONG value only for insert into a LONG column [message #387927] Mon, 18 May 2009 16:05 Go to next message
Amod M is currently offline Amod M
Messages: 11
Registered: July 2009
Junior Member
Hi,

I am using EclipseLink1.0.1 with oracle 10g setup. Randomly I am getting
following exception when adding large attachment in clob type of column on
Oracle DB.
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert
into a LONG column
Issue is discussed in following links.
http://kr.forums.oracle.com/forums/thread.jspa?threadID=5067 65
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/ jdbc_faq.html#06_12

Do we need to have specific setting for Oracle Db for handling large data?
We have following setting.
Oracle10Platform.setUsesStringBinding(true);
Oracle10Platform.setStringBindingSize(4000);

Can anyone kindly give suggestion/feedback. Appreciate any help.
Re: ORA-01461:can bind a LONG value only for insert into a LONG column [message #387940 is a reply to message #387927] Tue, 19 May 2009 18:46 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

Does this error only occur with the value > 4k? Or can you narrow down
when the error occurs. It seems JDBC related, you could always try
switching between the thin/oci or versions of your JDBC driver.

In EclipseLink ensure that you are using the Oracle9/10 platform (you seem
to be), and that you have set your mapping's field type to Blob or Clob
(such as @Lob in JPA). Using string binding does nothing as EclipseLink
defaults to binding all parameters.

___
James
http://www.nabble.com/EclipseLink---Users-f26658.html


James : Wiki : Book : Blog : Twitter
Previous Topic:Problems migrating from Toplink Essentials to EclipseLink
Next Topic:Blob question
Goto Forum:
  


Current Time: Thu Oct 23 01:51:14 GMT 2014

Powered by FUDForum. Page generated in 0.01547 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software