From: | Stephen Crawley <crawley(at)dstc(dot)edu(dot)au> |
---|---|
To: | Ricardo Maia <rjmaia(at)student(dot)dei(dot)uc(dot)pt> |
Cc: | pgsql-interfaces(at)postgresql(dot)org, crawley(at)dstc(dot)edu(dot)au |
Subject: | Re: Using BLOBs with several DBMS |
Date: | 2001-06-08 05:30:26 |
Message-ID: | 200106080530.f585UO601918@piglet.dstc.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
> 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.
It is difficult, because:
* Different versions of SQL use different names for the BLOB type.
* Some DBMS don't support blobs at all.
* Some DBMS treat blobs differently to other SQL types and
require you to use special APIs to access them.
* Not all JDBC drivers support the JDBC 2.0 Blob APIs. Of those
that do, many implement them in part only.
Given this mess, you've got two choices:
* Define a Java interface for all of your database interactions.
Create a different implementation for each DBMS you plan to support,
complete with embedded SQL statements, table schemas, etc.
* Define wrapper classes for JDBC, and try to isolate the DBMS
differences in "adapters". This (more or less) allows you to
share SQL statements / table schemas across DBMS, but it is
kind of hard getting the wrapper / adapter APIs right.
-- Steve
From | Date | Subject | |
---|---|---|---|
Next Message | J. 'FIK' Brand | 2001-06-08 05:44:34 | ODBC+Access2000, Win2k and Win98 |
Previous Message | Barry Lind | 2001-06-07 19:33:22 | Re: Dabase support for UTF, UNICODE? |