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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | James Loh | 2001-05-31 15:06:34 | Postgresql unit |
Previous Message | Joe Conway | 2001-05-31 04:59:52 | remote database queries |