Received: from criticalsoftware.com ([194.65.152.210])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f4UAQ0E97341
	for <pgsql-interfaces@postgresql.org>;
	Wed, 30 May 2001 06:26:01 -0400 (EDT)
	(envelope-from rmaia@criticalsoftware.com)
Received: from valkyrie (valkyrie.critical.pt [192.168.3.72])
	by criticalsoftware.com (8.11.0/8.11.0) with SMTP id f4UANgC96160;
	Wed, 30 May 2001 11:23:42 +0100 (WEST)
Content-Type: text/plain;
  charset="iso-8859-1"
From: Ricardo Maia <rmaia@criticalsoftware.com>
Organization: Critical Software, SA
To: Manika dey <bithi@ipr.res.in>
Subject: Re: Using BLOBs with several DBMS
Date: Wed, 30 May 2001 11:23:43 +0100
X-Mailer: KMail [version 1.2]
Cc: pgsql-interfaces@postgresql.org
References: <Pine.GSO.4.10.10105300959120.16395-100000@sun9.plasma.ernet.in>
In-Reply-To: <Pine.GSO.4.10.10105300959120.16395-100000@sun9.plasma.ernet.in>
MIME-Version: 1.0
Message-Id: <01053011234300.00675@valkyrie>
Content-Transfer-Encoding: 8bit
X-Archive-Number: 200105/128
X-Sequence-Number: 1658


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