Get your CodeRanch badge!*
The moose likes JDBC and the fly likes java.io.ioException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.io.ioException" Watch "java.io.ioException" New topic
Author

java.io.ioException

sri pathy
Greenhorn

Joined: May 19, 2006
Posts: 1
I get the error java.io.ioException LOB locators cannot span transactions,
when I try to insert a BLOB object into oracle DB.
My SP reads
procname(filename1 in char, filedata out Blob)
insert into ...(filename1, empty_blob);
select filecontent from ... where filename=filename1 for update.

my java code reads
java.sql.BLOB b = (BLOB)getQueryOutParam("filedata").getBlob();

pls help..
Ernest Friedman-Hill
author and iconoclast
Marshal

Joined: Jul 08, 2003
Posts: 24168
    
  30

Hi,

Welcome to JavaRanch!

I'm going to move this to our JDBC forum, where it will be more on-topic.


[Jess in Action][AskingGoodQuestions]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.io.ioException
 
Similar Threads
Problem updating BLOB
inserting blob with CMP
Error inserting byte[] to Oracle BLOB
inserting blob to oracle
javax.sql.rowset.serial.SerialBlob cannot be cast to oracle