Thread: RE: [INTERFACES] ConnectionPoolDataSource (JDBC)
New in the 7.0 driver: * javax.sql support (thanks arkin) * Transaction Isolation (should have been in 6.5.3, but got missed) * dutch translation of errors * Array support * The driver is now under the package org.postgresql not postgresql * Rewrote the Makefile These will be done by the end of this weekend: * LOCATOR()'s (required for BLOB & CLOB) * java.sql.BLOB & java.sql.CLOB support * The way our type extensions will support the standard way introduced in JDBC2.0 * Copy support (finally) * InputStream & OutputStream support for Large Objects * Translations of error messages for some other languages (using babelfish) * New ImageViewer example * Rewritten blob example And possible if I get chance before 7.0 is released (in order of priority): * StarOffice support (both Linux & Windog) * Implement the JAVA_OBJECT data type * Implement Structure support * CallableStatement * ResultSet to use a cursor when retrieving results These won't be done until after 7.0: * RowSet's * Updateable ResultSet's (not sure how to do this yet) Peter -- Peter Mount Enterprise Support Maidstone Borough Council Any views stated are my own, and not those of Maidstone Borough Council. -----Original Message----- From: Joe Shevland [mailto:shevlandj@kpi.com.au] Sent: Friday, February 04, 2000 6:39 PM To: Peter Mount; 'Jaume Pausas'; pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] ConnectionPoolDataSource (JDBC) Oi oi! Is 7.0 close and whats in the beast? Thanks, Joe -- Any views stated are in the hope that Peter Mount moves quickly on the PostgreSQL JDBC driver ;) ----- Original Message ----- From: "Peter Mount" <petermount@it.maidstone.gov.uk> To: "'Jaume Pausas'" <a1649@dis.ulpgc.es>; <pgsql-interfaces@postgreSQL.org> Sent: Thursday, February 03, 2000 6:14 AM Subject: RE: [INTERFACES] ConnectionPoolDataSource (JDBC) > If you mean the javax.sql standard extensions, they are in the 7.0 > release. > > ie: I'm currently merging the supplied sources into the cvs source at > the moment. > > Peter > > -- > Peter Mount > Enterprise Support > Maidstone Borough Council > Any views stated are my own, and not those of Maidstone Borough Council. > > > > -----Original Message----- > From: Jaume Pausas [mailto:a1649@dis.ulpgc.es] > Sent: Thursday, February 03, 2000 1:16 PM > To: pgsql-interfaces@postgreSQL.org > Subject: [INTERFACES] ConnectionPoolDataSource (JDBC) > > > Hi > > I´ve been reading a short course about jdbc 2.0 and there put that some > drivers includes implementation of the ConnectionPoolDataSource > interface. Does postgresql driver include it? > > Anybody have an implementation of a spooled database? > > > > ************ > > ************ >
That sounds awesome! Thanks for all the good work. Regards, Joe ----- Original Message ----- From: "Peter Mount" <petermount@it.maidstone.gov.uk> To: "'Joe Shevland'" <shevlandj@kpi.com.au>; "Peter Mount" <petermount@it.maidstone.gov.uk>; "'Jaume Pausas'" <a1649@dis.ulpgc.es>; <pgsql-interfaces@postgreSQL.org> Sent: Friday, February 04, 2000 4:51 AM Subject: RE: [INTERFACES] ConnectionPoolDataSource (JDBC) > New in the 7.0 driver: > * javax.sql support (thanks arkin) > * Transaction Isolation (should have been in 6.5.3, but got missed) > * dutch translation of errors > * Array support > * The driver is now under the package org.postgresql not postgresql > * Rewrote the Makefile > > These will be done by the end of this weekend: > * LOCATOR()'s (required for BLOB & CLOB) > * java.sql.BLOB & java.sql.CLOB support > * The way our type extensions will support the standard way introduced > in JDBC2.0 > * Copy support (finally) > * InputStream & OutputStream support for Large Objects > * Translations of error messages for some other languages (using > babelfish) > * New ImageViewer example > * Rewritten blob example > > And possible if I get chance before 7.0 is released (in order of > priority): > * StarOffice support (both Linux & Windog) > * Implement the JAVA_OBJECT data type > * Implement Structure support > * CallableStatement > * ResultSet to use a cursor when retrieving results > > These won't be done until after 7.0: > * RowSet's > * Updateable ResultSet's (not sure how to do this yet) > > Peter > > -- > Peter Mount > Enterprise Support > Maidstone Borough Council > Any views stated are my own, and not those of Maidstone Borough Council. > > > > -----Original Message----- > From: Joe Shevland [mailto:shevlandj@kpi.com.au] > Sent: Friday, February 04, 2000 6:39 PM > To: Peter Mount; 'Jaume Pausas'; pgsql-interfaces@postgreSQL.org > Subject: Re: [INTERFACES] ConnectionPoolDataSource (JDBC) > > > Oi oi! Is 7.0 close and whats in the beast? > > Thanks, > Joe > > -- > Any views stated are in the hope that Peter Mount > moves quickly on the PostgreSQL JDBC driver ;) > > > ----- Original Message ----- > From: "Peter Mount" <petermount@it.maidstone.gov.uk> > To: "'Jaume Pausas'" <a1649@dis.ulpgc.es>; > <pgsql-interfaces@postgreSQL.org> > Sent: Thursday, February 03, 2000 6:14 AM > Subject: RE: [INTERFACES] ConnectionPoolDataSource (JDBC) > > > > If you mean the javax.sql standard extensions, they are in the 7.0 > > release. > > > > ie: I'm currently merging the supplied sources into the cvs source at > > the moment. > > > > Peter > > > > -- > > Peter Mount > > Enterprise Support > > Maidstone Borough Council > > Any views stated are my own, and not those of Maidstone Borough > Council. > > > > > > > > -----Original Message----- > > From: Jaume Pausas [mailto:a1649@dis.ulpgc.es] > > Sent: Thursday, February 03, 2000 1:16 PM > > To: pgsql-interfaces@postgreSQL.org > > Subject: [INTERFACES] ConnectionPoolDataSource (JDBC) > > > > > > Hi > > > > I´ve been reading a short course about jdbc 2.0 and there put that > some > > drivers includes implementation of the ConnectionPoolDataSource > > interface. Does postgresql driver include it? > > > > Anybody have an implementation of a spooled database? > > > > > > > > ************ > > > > ************ > > >
Peter Mount wrote: > > New in the 7.0 driver: > * javax.sql support (thanks arkin) Thank you. I want to point out that the Oracle JDBC drivers do not seem to support javax.sql yet. Nice to see Postgresql getting ahead of the curve :-) Are there any plans to support X/Open error code reporting? Rather than just reporting the message, the X/Open error code will be reported allowing the application to determine from the SQLException what went wrong. This allows the application to determine duplicate keys, aborted transactions, etc. > * ResultSet to use a cursor when retrieving results Which type of cursors will be supported? arkin > These won't be done until after 7.0: > * RowSet's > * Updateable ResultSet's (not sure how to do this yet) > > Peter -- ---------------------------------------------------------------------- Assaf Arkin www.exoffice.com CTO, Exoffice Technologies, Inc. www.exolab.org