Обсуждение: JDBC2 question -- can't find files needed
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
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
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
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