pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgresql and java2
2+ messages / 2 participants
[nested] [flat]

* postgresql and java2
@ 2000-08-02 20:20  JavierG <javierg@softel.cu>
  0 siblings, 1 reply; 2+ messages in thread

From: JavierG @ 2000-08-02 20:20 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-sql

Hi:

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? To
put it another way: when I access an array (for instance) in PostgreSQL
through the JDBC driver, does the driver returns a SQL 3 ARRAY
(java.sql.Array) or a Java Object (java.lang.Object)?
I’m sorry if this sounds “newbie”, but this is the first time I use an
ORDMS…

Thanks in advance
  J.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] postgresql and java2
@ 2000-08-15 09:15  Peter Mount <peter@retep.org.uk>
  parent: JavierG <javierg@softel.cu>
  0 siblings, 0 replies; 2+ messages in thread

From: Peter Mount @ 2000-08-15 09:15 UTC (permalink / raw)
  To: JavierG <javierg@softel.cu>; pgsql-general@postgresql.org; pgsql-sql

First sorry for the late reply, I only get this list from home, and just got 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 type relates to our arrays. From the documentation I have (JDBC API Tutorial and Reference, Second Edition) it mentions things like CREATE TYPE statements, etc. I'm not sure if we could implement them purely within JDBC/Java.

Peter

-- 
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 ----- 
  From: JavierG 
  To: pgsql-general@postgresql.org ; pgsql-sql@postgresql.org 
  Sent: Wednesday, August 02, 2000 9:20 PM
  Subject: [SQL] postgresql and java2 


  Hi:

   

  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? To put it another way: when I access an array (for instance) in PostgreSQL through the JDBC driver, does the driver returns a SQL 3 ARRAY (java.sql.Array) or a Java Object (java.lang.Object)?  

  I'm sorry if this sounds "newbie", but this is the first time I use an ORDMS.

   

  Thanks in advance

    J.

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-08-15 09:15 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-02 20:20 postgresql and java2 JavierG <javierg@softel.cu>
2000-08-15 09:15 ` Peter Mount <peter@retep.org.uk>

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