• Post Reply Bookmark Topic Watch Topic
  • New Topic

java.io.ioException

 
sri pathy
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 24215
37
Chrome Eclipse IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Welcome to JavaRanch!

I'm going to move this to our JDBC forum, where it will be more on-topic.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!