OraFAQ Forum: Windows » how to retrieve the blob column data from table?

Home » Infrastructure » Windows » how to retrieve the blob column data from table? (oracle 10g,xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to retrieve the blob column data from table? [message #497815]

Mon, 07 March 2011 06:11

shankar123
Messages: 3
Registered: March 2011
Location: INDIA

Junior Member

I use the oracle 10g database.I am trying to insert and retrive the image.Inserting an image is done.but while retrieving an image iam getting an run time exception in java "java.sql.sqlexception:general error".i am not able to understand this.
The code to insert the image is
FileInputStream fi=new FileInputStream(f);
int size = fi.available();
System.out.println("j"+size);
byte b1[] = new byte[size];
i=fi.read(b1,0,size);
System.out.println("i"+i);
st.executeUpdate("insert into image1 values('b1',"+k+")");
when i am retrieving the image i tried like this
ResultSet rs=st.executeQuery("select imagecolumn from tablename");
here iam getting an exception as i named above.

Report message to a moderator

Re: how to retrieve the blob column data from table? [message #497826 is a reply to message #497815]

Mon, 07 March 2011 06:55

Michel Cadot
Messages: 68417
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Copy and paste the error code and error you get.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Report message to a moderator

Re: how to retrieve the blob column data from table? [message #497828 is a reply to message #497815]

Mon, 07 March 2011 06:57

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

st.executeUpdate("insert into image1 values('b1',"+k+")");

What is this "k" you insert here? You should be inserting with a bind variable you set with setBlob

Report message to a moderator

Re: how to retrieve the blob column data from table? [message #498204 is a reply to message #497828]

Wed, 09 March 2011 04:20

shankar123
Messages: 3
Registered: March 2011
Location: INDIA

Junior Member

the exception that i got at resultset is
java.sql.sqlexception:general error

Report message to a moderator

Re: how to retrieve the blob column data from table? [message #498208 is a reply to message #497828]

Wed, 09 March 2011 04:22

shankar123
Messages: 3
Registered: March 2011
Location: INDIA

Junior Member

you dont bother about the k variable.I can take care of that.
please tell me about the problem i have at resultset. I am getting exception there?

Report message to a moderator

Previous Topic:	Connecting Oracle to Remote Access Server
Next Topic:	rename command in dos

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 22 18:27:03 CDT 2023