Re: Using BLOBs with several DBMS

Hi,Declare the field type as oid for which youwant it to be type blob. we can surely create and update table with type
blobusing jdbc.
 

manika



-------------------------------------------------------------------

From:-                          | Ms. Manika Dey.                |Ph.No:--Engineer-SC (Comp. Tech.)      | IPR -- 02712
-69276 I.P.R                          |          EXT 336,315BHAT, GANDHINAGAR              | Residence -- 079 -
6745701Gujrat-- 382 428              | FAX --- 69017 ------------------------------------------------------------------




                                                     


On Tue, 29 May 2001, Ricardo Maia wrote:

> 
> Hi,
> 
> 
> I'm trying to make a application in JAVA that connects thought JDBC to DBMS. 
> It should create tables, insert data and make queries.
> 
> My question is: how can i create a table with one BLOB field, in a DBMS 
> independent way?
> 
> I am using PostgreSQL7.1 and Oracle 8 but I want to make it be able to work 
> with other DBMSs.
> 
> 
> Thanks
> 
> Ricardo Maia
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>