Re: insert blob through sql on 400??

["Kaushal Trivedi" <e_ediam@xxxxxxxxxxx>]

I have got the java code that should do the job.

 

PreparedStatement ps=treeCon.prepareStatement("INSERT INTO LOGOFILE (LGBLOB) VALUES (?)");

File f = new File("snslogo.gif");

 

 FileInputStream logoStrm=new FileInputStream(f);
  ps.setBinaryStream(1,logoStrm,(int) f.length());

ps.execute();

 

but when this code is executed on as400 driver SQL Exception is data typr mismatch.

on ODBC driver it says operation not supported.

 

What settings do i require for the db field description. just declaring a field B and length 9 is enough.

Can anybody suggest what may be wrong on the backend.

TIA

Kaush

----- Original Message -----

From: Christopher A. Libby

To: WEB400@midrange.com

Sent: Wednesday, March 28, 2001 6:37 PM

Subject: RE: insert blob through sql on 400??

I'm not entirely sure of the JAVA Code, but you might also want to define Content-Type field (in case you need to upload something other than GIF's to the server). 

 

---------------------------------------------------------
Christopher A. Libby, Programmer/Analyst
Maine Public Service Company (www.mainepublicservice.com)
clibby@mainepublicservice.com (207) 768-5811 ext. 2210

-----Original Message-----
From: owner-web400@midrange.com [mailto:owner-web400@midrange.com]On Behalf Of Kaushal Trivedi
Sent: Wednesday, March 28, 2001 7:04 AM
To: WEB400@midrange.com
Subject: insert blob through sql on 400??

I want to insert a gif into a db table.

i have declared the db field to be blob.

can anybody tell me what java code to write to insert a gif obj into db blob field.

thanxx in advance.

Kaush

Maine Public Service Company
www.mainepublicservice.com

Maine Public Service Company
www.mainepublicservice.com