Re: Using BLOBs with several DBMS
От | Manika dey |
---|---|
Тема | Re: Using BLOBs with several DBMS |
Дата | |
Msg-id | Pine.GSO.4.10.10105310928120.5516-100000@sun9.plasma.ernet.in обсуждение исходный текст |
Ответ на | Re: Using BLOBs with several DBMS (Ricardo Maia <rmaia@criticalsoftware.com>) |
Список | 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 arelooking is definitely a betteridea to solve the problem for all other database .In SQLServer we use type text for largedata. If you arrive at solution i would also like knowabout it. Thanks manika ------------------------------------------------------------------- From:- | Ms. Manika Dey. |Ph.No:--Engineer-SC (Comp. Tech.) | IPR -- 02712 -69276 I.P.R | EXT 336,315BHAT, GANDHINAGAR | Residence -- 079 - 6745701Gujrat-- 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 >
В списке pgsql-interfaces по дате отправления: