Eclipse Community Forums: EclipseLink » ORA-01461:can bind a LONG value only for insert into a LONG column

Help

Home

Home » Eclipse Projects » EclipseLink » ORA-01461:can bind a LONG value only for insert into a LONG column

Show: Today's Messages :: Show Polls :: Message Navigator

ORA-01461:can bind a LONG value only for insert into a LONG column [message #387927]

Mon, 18 May 2009 16:05

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.

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Problems migrating from Toplink Essentials to EclipseLink
Next Topic:	Blob question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 03:05:34 GMT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter