Thread: JDBC 2.0 Standard Extensions for PostgreSQL
Are list members interested in an implementation of the JDBC standard extensions? I've been working on implementations of DataSource and connection pooling for an internal project and would be willing to contribute this to the PostgreSQL JDBC driver if it is of interest to others. Some initial thoughts: - A new package would be added (say postgresql.jdbc2.stdext) - This package would only build as an option from the Makefile (this would prevent make breaking for Java users who do not JNDI and the javax.sql installed) - Initial cut would include DataSource and connection pooling only (no RowSet support) Anyone interested? -- David Marshall email: dmarshall@vmguys.com VM Systems, Inc. phone: 1-941-596-2480 Naples, FL USA fax: 1-941-596-2483
David, We already got that working and very successfuly. It supports PooledConnectionDataSource for connection pooling and XADataSource (the real heavy stuff) for X/A transaction control (required for EJB environments). The code is not yet part of the official distribution, but I've sent it to Peter and would to see it appear in the next release. In the meanwhile you can grab the JAR from ftp://ftp.exolab.org/pub/jars/postgresql-6.3.jar. I'll also add the sources in the src directory later today. Are you looking to use it in any particular environment? arkin David Marshall wrote: > > Are list members interested in an implementation of the JDBC standard extensions? > > I've been working on implementations of DataSource and connection pooling for an internal project > and would be willing to contribute this to the PostgreSQL JDBC driver if it is of interest to > others. > > Some initial thoughts: > > - A new package would be added (say postgresql.jdbc2.stdext) > - This package would only build as an option from the Makefile (this would prevent make breaking > for Java users who do not JNDI and the javax.sql installed) > - Initial cut would include DataSource and connection pooling only (no RowSet support) > > Anyone interested? > > -- > David Marshall email: dmarshall@vmguys.com > VM Systems, Inc. phone: 1-941-596-2480 > Naples, FL USA fax: 1-941-596-2483 > > ************
Assaf, Am looking to use this in a Linux 2.2 / Blackdown 1.2.2 environment in sync with a JMS implementation we're working on. Hadn't planned on tackling the XA part until later, but see you've done that too. Just looked at your web-site. Is your implementation part of Tyrex? David Assaf Arkin wrote: > David, > > We already got that working and very successfuly. It supports > PooledConnectionDataSource for connection pooling and XADataSource (the > real heavy stuff) for X/A transaction control (required for EJB > environments). > > The code is not yet part of the official distribution, but I've sent it > to Peter and would to see it appear in the next release. > > In the meanwhile you can grab the JAR from > ftp://ftp.exolab.org/pub/jars/postgresql-6.3.jar. I'll also add the > sources in the src directory later today. > > Are you looking to use it in any particular environment? > > arkin > > David Marshall wrote: > > > > Are list members interested in an implementation of the JDBC standard extensions? > > > > I've been working on implementations of DataSource and connection pooling for an internal project > > and would be willing to contribute this to the PostgreSQL JDBC driver if it is of interest to > > others. > > > > Some initial thoughts: > > > > - A new package would be added (say postgresql.jdbc2.stdext) > > - This package would only build as an option from the Makefile (this would prevent make breaking > > for Java users who do not JNDI and the javax.sql installed) > > - Initial cut would include DataSource and connection pooling only (no RowSet support) > > > > Anyone interested? > > > > -- > > David Marshall email: dmarshall@vmguys.com > > VM Systems, Inc. phone: 1-941-596-2480 > > Naples, FL USA fax: 1-941-596-2483 > > > > ************
It was derived from Tyrex and used to test Tyrex, but the PostgreSQL specific code is contributed to PostgreSQL under their license. I'm using Linux 2.2/Sun JDK 1.2.2 (Blackdown with the name filed off) running Tyrex inside Tomcat and it works like a charm. Are you considering using or contributing to an open source JMS implementation? arkin David Marshall wrote: > > Assaf, > > Am looking to use this in a Linux 2.2 / Blackdown 1.2.2 environment in sync with a JMS implementation > we're working on. Hadn't planned on tackling the XA part until later, but see you've done that too. > > Just looked at your web-site. Is your implementation part of Tyrex? > > David > > Assaf Arkin wrote: > > > David, > > > > We already got that working and very successfuly. It supports > > PooledConnectionDataSource for connection pooling and XADataSource (the > > real heavy stuff) for X/A transaction control (required for EJB > > environments). > > > > The code is not yet part of the official distribution, but I've sent it > > to Peter and would to see it appear in the next release. > > > > In the meanwhile you can grab the JAR from > > ftp://ftp.exolab.org/pub/jars/postgresql-6.3.jar. I'll also add the > > sources in the src directory later today. > > > > Are you looking to use it in any particular environment? > > > > arkin > > > > David Marshall wrote: > > > > > > Are list members interested in an implementation of the JDBC standard extensions? > > > > > > I've been working on implementations of DataSource and connection pooling for an internal project > > > and would be willing to contribute this to the PostgreSQL JDBC driver if it is of interest to > > > others. > > > > > > Some initial thoughts: > > > > > > - A new package would be added (say postgresql.jdbc2.stdext) > > > - This package would only build as an option from the Makefile (this would prevent make breaking > > > for Java users who do not JNDI and the javax.sql installed) > > > - Initial cut would include DataSource and connection pooling only (no RowSet support) > > > > > > Anyone interested? > > > > > > -- > > > David Marshall email: dmarshall@vmguys.com > > > VM Systems, Inc. phone: 1-941-596-2480 > > > Naples, FL USA fax: 1-941-596-2483 > > > > > > ************
Assaf Arkin wrote: > It was derived from Tyrex and used to test Tyrex, but the PostgreSQL > specific code is contributed to PostgreSQL under their license. > > I'm using Linux 2.2/Sun JDK 1.2.2 (Blackdown with the name filed off) > running Tyrex inside Tomcat and it works like a charm. > > Are you considering using or contributing to an open source JMS > implementation? > Yes, whatever we do in this arena will be open-source. We're getting off topic. Let's take the rest of this conversation off-list. David
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thu, 13 Jan 2000, David Marshall wrote: >Are list members interested in an implementation of the JDBC standard >extensions? FWIW, at least this list member would be very interested in such a thing. - -- Jim Wise jwise@draga.com -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 5.0i for non-commercial use Charset: noconv iQA/AwUBOH55gS2NgFbJL33VEQJUUgCZAX+El3naLHF9cwuWTCNl76fBtKsAn0NW 9/gYnAcI3XB2m8/oeqEMsbjg =cRIC -----END PGP SIGNATURE-----
I've put the sources on the FTP: ftp.exolab.org/pub/src/postgresql-6.3-src.tar.gz You will find the standard DataSource in postgresql.DataSource, which extends the pool/xa implementation in postgresql.xa.XADataSourceImpl. You are free to use and distribute it under the terms of the PostgreSQL license. arkin Jim Wise wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On Thu, 13 Jan 2000, David Marshall wrote: > > >Are list members interested in an implementation of the JDBC standard > >extensions? > > FWIW, at least this list member would be very interested in such a > thing. > > - -- > Jim Wise > jwise@draga.com > > -----BEGIN PGP SIGNATURE----- > Version: PGPfreeware 5.0i for non-commercial use > Charset: noconv > > iQA/AwUBOH55gS2NgFbJL33VEQJUUgCZAX+El3naLHF9cwuWTCNl76fBtKsAn0NW > 9/gYnAcI3XB2m8/oeqEMsbjg > =cRIC > -----END PGP SIGNATURE----- > > ************