Received: from finch-post-10.mail.demon.net (finch-post-10.mail.demon.net [194.217.242.38]) by hub.org (8.10.1/8.10.1) with ESMTP id e7FB9nn91352; Tue, 15 Aug 2000 07:09:49 -0400 (EDT) Received: from maidast.demon.co.uk ([158.152.22.37] helo=heather) by finch-post-10.mail.demon.net with smtp (Exim 2.12 #1) id 13OebA-0004YY-0A; Tue, 15 Aug 2000 11:09:36 +0000 Message-ID: <0e5201c006a9$381df160$2516989e@maidstone.gov.uk> From: "Peter Mount" To: "JavierG" , , References: Subject: Re: [SQL] postgresql and java2 Date: Tue, 15 Aug 2000 10:15:58 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_05FB_01C006A1.CE4C92C0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200008/277 This is a multi-part message in MIME format. ------=_NextPart_000_05FB_01C006A1.CE4C92C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable First sorry for the late reply, I only get this list from home, and just go= t email working again. I was working on ARRAY and STRUCT for 7.0, but it a snag. I couldn't get a = grips with what the spec meant, and couldn't work out how the SQL3 ARRAY ty= pe relates to our arrays. From the documentation I have (JDBC API Tutorial = and Reference, Second Edition) it mentions things like CREATE TYPE statemen= ts, etc. I'm not sure if we could implement them purely within JDBC/Java. Peter --=20 Peter T Mount peter@retep.org.uk, me@petermount.com Homepage: http://www.retep.org.uk Contact details: http://petermount.com PostgreSQL JDBC: http://www.retep.org.uk/postgres/ Java PDF Generator: http://www.retep.org.uk/pdf/ ----- Original Message -----=20 From: JavierG=20 To: pgsql-general@postgresql.org ; pgsql-sql@postgresql.org=20 Sent: Wednesday, August 02, 2000 9:20 PM Subject: [SQL] postgresql and java2=20 Hi: =20=20=20 Does anybody knows if the JDBC driver maps the new SQL 3 types (ARRAY and= STRUCT) with the proprietary array and user-defined types of PostgreSQL? T= o put it another way: when I access an array (for instance) in PostgreSQL t= hrough the JDBC driver, does the driver returns a SQL 3 ARRAY (java.sql.Arr= ay) or a Java Object (java.lang.Object)?=20=20 I'm sorry if this sounds "newbie", but this is the first time I use an OR= DMS. =20=20=20 Thanks in advance J. ------=_NextPart_000_05FB_01C006A1.CE4C92C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
First sorry for the late reply, I only get= this=20 list from home, and just got email working again.
 
I was working on ARRAY and STRUCT for 7.0,= but it a=20 snag. I couldn't get a grips with what the spec meant, and couldn't work ou= t how=20 the SQL3 ARRAY type relates to our arrays. From the documentation I have (J= DBC=20 API Tutorial and Reference, Second Edition) it mentions things like CREATE = TYPE=20 statements, etc. I'm not sure if we could implement them purely within=20 JDBC/Java.
 
Peter
 
--
Peter T Mount  peter@retep.org.uk, me@petermount.com
Homepage: http://www.retep.org.uk Contact detail= s: http://petermount.com
PostgreSQL JDBC= : http://www.retep.org.uk/postgres= /
Java=20 PDF Generator: http://www.retep.org.uk/pdf/
----- Original Message -----
Fro= m:=20 JavierG
To: pgsql-general@postgresql.org= ;=20 pgsql-sql@postgresql.org
Sent: Wednesday, August 02, 2000 9= :20=20 PM
Subject: [SQL] postgresql and java= 2=20

Hi:

 <= /o:p>

Does=20 anybody knows if the JDBC driver maps the new SQL 3 types (ARRAY and STRU= CT)=20 with the proprietary array and user-defined types of PostgreSQL? To put i= t=20 another way: when I access an array (for instance) in PostgreSQL through = the=20 JDBC driver, does the driver returns a SQL 3 ARRAY (java.sql.Array) or a = Java=20 Object (java.lang.Object)? =20

I’m=20 sorry if this sounds “newbie”, but this is the first time I u= se an=20 ORDMS…

 <= /o:p>

Thanks=20 in advance

 =20 J.

------=_NextPart_000_05FB_01C006A1.CE4C92C0--