From: Ricardo Maia <rmaia@criticalsoftware.com>
To: Manika dey <bithi@ipr.res.in>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Using BLOBs with several DBMS
Date: Wed, 30 May 2001 11:23:43 +0100
Message-ID: <01053011234300.00675@valkyrie> (raw)
In-Reply-To: <Pine.GSO.4.10.10105300959120.16395-100000@sun9.plasma.ernet.in>
References: <Pine.GSO.4.10.10105300959120.16395-100000@sun9.plasma.ernet.in>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rmaia@criticalsoftware.com, bithi@ipr.res.in
Subject: Re: Using BLOBs with several DBMS
In-Reply-To: <01053011234300.00675@valkyrie>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox