Skip site navigation (1) Skip section navigation (2)

Re: Using BLOBs with several DBMS

From: Manika dey <bithi(at)ipr(dot)res(dot)in>
To: Ricardo Maia <rmaia(at)criticalsoftware(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Using BLOBs with several DBMS
Date: 2001-05-31 14:31:39
Message-ID: Pine.GSO.4.10.10105310928120.5516-100000@sun9.plasma.ernet.in (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,
  I didnot try it that way, since my application
  was using java and postgresql , i used blob type.
  
 But the way you are looking is definitely a better
 idea to solve the problem for all other database .
 In SQLServer we use type text for large data.

 If you arrive at solution i would also like know
 about it.

Thanks 
manika

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

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




                                       
                


On Wed, 30 May 2001, Ricardo Maia wrote:

> 
> Hi,
> 
> I didn't want to burn a SQL type in the application code. Because if I use 
> PostgreSQL a BLOB is named as "oid" in Oracle is "long raw" and other BDMS can
> name it diferently.
> 
> I am looking for a solution that at runtime connects to the DBMS and find out 
> what SQL type corresponds to BLOB and then create a table with a field of 
> that type.
> 
> 
> Ricardo Maia
> 
> On Wednesday 30 May 2001 16:00, Manika dey wrote:
> > Hi,
> >  Declare the field type as oid for which you
> >  want it to be type blob.
> >   we can surely create and update table with type
> >   blob using jdbc.
> >
> > manika
> >
> >
> >
> >
> > -------------------------------------------------------------------
> >
> > From:-                          |
> >  Ms. Manika Dey.                |Ph.No:--
> >  Engineer-SC (Comp. Tech.)      | IPR -- 02712 - 69276
> >  I.P.R                          |          EXT 336,315
> >  BHAT, GANDHINAGAR              | Residence -- 079 - 6745701
> >  Gujrat -- 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
> 


In response to

pgsql-interfaces by date

Next:From: James LohDate: 2001-05-31 15:06:34
Subject: Postgresql unit
Previous:From: Joe ConwayDate: 2001-05-31 04:59:52
Subject: remote database queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group