Thread: JDBC2 question -- can't find files needed

JDBC2 question -- can't find files needed

From

"Kogotkov, Vyacheslav"

Date:

22 January 2001, 13:08:09

   Hi,

   Please, help !
   I try to work with PostgreSQL 7.0.3 using JDBC2.
For performance reasons I'd like to use the JDBC2.0 standard extension too
which is represented by the package javax.sql.*. This package allows me to
use the included connection pooling mechanism which is recomended for server
applications. Thatfore I've been analyzing the JDBC driver source codes,
which was on my Linux server, and thereby I missed the classes like:

PostgreConnectionPoolDataSource.java
PostgreDataSource.java

Is it possible to find a PostgreJDBC driver which supports the requirements
of the JDBC2.0 standard extension javax.sql.* ???
   While I've been searching in the Internet I found this:
www.postgresql.org/docs/pgsql/src/interfaces/jdbc/
<http://www.postgresql.org/docs/pgsql/src/interfaces/jdbc/> . Overthere in
the subdirectory org/postgresql I've found a source file named
PostgresqlDataSource.java.
But I haven't found any description for it and I don't know if I can use it
for PostgreSQL
of 7.0.3 version.

   Thanks for your attention.
   Slava

Re: JDBC2 question -- can't find files needed

From

The Hermit Hacker

Date:

22 January 2001, 13:14:26

this message has been bounced to pgsql-jdbc@postgresql.org ...


On Mon, 22 Jan 2001, Kogotkov, Vyacheslav wrote:

>    Hi,
>
>    Please, help !
>    I try to work with PostgreSQL 7.0.3 using JDBC2.
> For performance reasons I'd like to use the JDBC2.0 standard extension too
> which is represented by the package javax.sql.*. This package allows me to
> use the included connection pooling mechanism which is recomended for server
> applications. Thatfore I've been analyzing the JDBC driver source codes,
> which was on my Linux server, and thereby I missed the classes like:
>
> PostgreConnectionPoolDataSource.java
> PostgreDataSource.java
>
> Is it possible to find a PostgreJDBC driver which supports the requirements
> of the JDBC2.0 standard extension javax.sql.* ???
>    While I've been searching in the Internet I found this:
> www.postgresql.org/docs/pgsql/src/interfaces/jdbc/
> <http://www.postgresql.org/docs/pgsql/src/interfaces/jdbc/> . Overthere in
> the subdirectory org/postgresql I've found a source file named
> PostgresqlDataSource.java.
> But I haven't found any description for it and I don't know if I can use it
> for PostgreSQL
> of 7.0.3 version.
>
>    Thanks for your attention.
>    Slava
>
>

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org

Re: JDBC2 question -- can't find files needed

From

Peter Mount

Date:

22 January 2001, 20:26:51

At 18:07 22/01/01 +0300, Kogotkov, Vyacheslav wrote:
>    Hi,
>
>    Please, help !
>    I try to work with PostgreSQL 7.0.3 using JDBC2.
>For performance reasons I'd like to use the JDBC2.0 standard extension too
>which is represented by the package javax.sql.*. This package allows me to
>use the included connection pooling mechanism which is recomended for server
>applications. Thatfore I've been analyzing the JDBC driver source codes,
>which was on my Linux server, and thereby I missed the classes like:
>
>PostgreConnectionPoolDataSource.java
>PostgreDataSource.java
>
>Is it possible to find a PostgreJDBC driver which supports the requirements
>of the JDBC2.0 standard extension javax.sql.* ???
>    While I've been searching in the Internet I found this:
>www.postgresql.org/docs/pgsql/src/interfaces/jdbc/
><http://www.postgresql.org/docs/pgsql/src/interfaces/jdbc/> . Overthere in
>the subdirectory org/postgresql I've found a source file named
>PostgresqlDataSource.java.
>But I haven't found any description for it and I don't know if I can use it
>for PostgreSQL
>of 7.0.3 version.

Just double checked my copy of CVS and its in there 
(src/interfaces/jdbc/org/postgresql/PostgresqlDataSource.java). Now as that 
copy of CVS is only a few days old, try fetching it from anoncvs. 
Instructions are on the web site.

PS: In 7.1 the standard extensions are known as the Enterprise edition, and 
is automatically built if ANT (the new method of building, replacing make) 
finds the javax.* classes.

Peter

RE: JDBC2 question -- can't find files needed

From

"Kogotkov, Vyacheslav"

Date:

23 January 2001, 11:42:41

   Hi Peter,
  Thanks a lot for your help.  1. I've tried to connect to anonCVS according
to documentation
cvs -d :pserver:anoncvs@postgresql.org:/home/projects/pgsql/cvsroot login
bu got message "Unknown host postgresql.org"
  2. I've found file PostgreDataSource.java on 
www.postgresql.org/docs/pgsql/src/interfaces/jdbc/org/postgresql
Is it enough or you advise to use latest version ?
  3. Can I compile 7.0.3 sources with PostgreDataSource.java and 
can I use this pooling mechanism with 7.0.3. Postgresql
or with 7.1. only ?  Thanks and regards,  Slava

-----Original Message-----
From: Peter Mount [mailto:peter@retep.org.uk]
Sent: Tuesday, January 23, 2001 1:04 AM
To: Kogotkov, Vyacheslav; 'pgsql-interfaces@postgresql.org'
Subject: Re: JDBC2 question -- can't find files needed

At 18:07 22/01/01 +0300, Kogotkov, Vyacheslav wrote:
>    Hi,
>
>    Please, help !
>    I try to work with PostgreSQL 7.0.3 using JDBC2.
>For performance reasons I'd like to use the JDBC2.0 standard extension too
>which is represented by the package javax.sql.*. This package allows me to
>use the included connection pooling mechanism which is recomended for
server
>applications. Thatfore I've been analyzing the JDBC driver source codes,
>which was on my Linux server, and thereby I missed the classes like:
>
>PostgreConnectionPoolDataSource.java
>PostgreDataSource.java
>
>Is it possible to find a PostgreJDBC driver which supports the requirements
>of the JDBC2.0 standard extension javax.sql.* ???
>    While I've been searching in the Internet I found this:
>www.postgresql.org/docs/pgsql/src/interfaces/jdbc/
><http://www.postgresql.org/docs/pgsql/src/interfaces/jdbc/> . Overthere in
>the subdirectory org/postgresql I've found a source file named
>PostgresqlDataSource.java.
>But I haven't found any description for it and I don't know if I can use it
>for PostgreSQL
>of 7.0.3 version.

Just double checked my copy of CVS and its in there 
(src/interfaces/jdbc/org/postgresql/PostgresqlDataSource.java). Now as that 
copy of CVS is only a few days old, try fetching it from anoncvs. 
Instructions are on the web site.

PS: In 7.1 the standard extensions are known as the Enterprise edition, and 
is automatically built if ANT (the new method of building, replacing make) 
finds the javax.* classes.

Peter