Re: [HACKERS] JDBC driver debug out?
Thanks. It works. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp > Add > > DriverManager.setLogWriter(new PrintWriter(System.out)); > > below the setLogLevel and it will > > I'll fix this though > > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > > On 23 October 2015 at 22:35, Tatsuo Ishiiwrote: > >> Unfortunately it doesn't work (no debug trace). >> >> Best regards, >> -- >> Tatsuo Ishii >> SRA OSS, Inc. Japan >> English: http://www.sraoss.co.jp/index_en.php >> Japanese:http://www.sraoss.co.jp >> >> > This should work better >> > >> > >> https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc41-SNAPSHOT/ >> > >> > Dave Cramer >> > >> > da...@postgresintl.com >> > www.postgresintl.com >> > >> > On 23 October 2015 at 21:32, Dave Cramer wrote: >> > >> >> No, I need to provide you with a 41 version. >> >> >> >> I just happened to have java 1.8 on my machine. >> >> >> >> Dave Cramer >> >> >> >> da...@postgresintl.com >> >> www.postgresintl.com >> >> >> >> On 23 October 2015 at 21:31, Tatsuo Ishii wrote: >> >> >> >>> Dave, >> >>> >> >>> Thanks for the quick response. Unfortunately now I'm getting error >> >>> with the JDBC driver. >> >>> >> >>> warning: >> >>> >> /usr/local/pgsql/share/postgresql-9.4-1204-jdbc42-20151023.230759-1.jar(org/postgresql/Driver.class): >> >>> major version 52 is newer than 51, the highest major version supported >> by >> >>> this compiler. >> >>> It is recommended that the compiler be upgraded. >> >>> 1 warning >> >>> [snip] >> >>> Exception in thread "main" java.lang.UnsupportedClassVersionError: >> >>> org/postgresql/Driver : Unsupported major.minor version 52.0 >> >>> at java.lang.ClassLoader.defineClass1(Native Method) >> >>> at java.lang.ClassLoader.defineClass(ClassLoader.java:800) >> >>> at >> >>> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) >> >>> at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) >> >>> at java.net.URLClassLoader.access$100(URLClassLoader.java:71) >> >>> at java.net.URLClassLoader$1.run(URLClassLoader.java:361) >> >>> at java.net.URLClassLoader$1.run(URLClassLoader.java:355) >> >>> at java.security.AccessController.doPrivileged(Native Method) >> >>> at java.net.URLClassLoader.findClass(URLClassLoader.java:354) >> >>> at java.lang.ClassLoader.loadClass(ClassLoader.java:425) >> >>> at >> sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) >> >>> at java.lang.ClassLoader.loadClass(ClassLoader.java:358) >> >>> at java.lang.Class.forName0(Native Method) >> >>> at java.lang.Class.forName(Class.java:191) >> >>> at begin_select_sleep.dbAccess(begin_select_sleep.java:39) >> >>> at begin_select_sleep.main(begin_select_sleep.java:21) >> >>> >> >>> $ java -version >> >>> java version "1.7.0_79" >> >>> OpenJDK Runtime Environment (IcedTea 2.5.6) >> (7u79-2.5.6-0ubuntu1.14.04.1) >> >>> OpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode) >> >>> >> >>> Probably I should upgrade Java... >> >>> >> >>> Best regards, >> >>> -- >> >>> Tatsuo Ishii >> >>> SRA OSS, Inc. Japan >> >>> English: http://www.sraoss.co.jp/index_en.php >> >>> Japanese:http://www.sraoss.co.jp >> >>> >> >>> > Tatsuo, >> >>> > >> >>> > Can you confirm it is fixed in this snapshot >> >>> > >> >>> >> https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/ >> >>> > >> >>> > Dave Cramer >> >>> > >> >>> > da...@postgresintl.com >> >>> > www.postgresintl.com >> >>> > >> >>> > On 23 October 2015 at 19:00, Dave Cramer wrote: >> >>> > >> >>> >> Tatsuo, >> >>> >> >> >>> >> posting to jdbc list >> >>> >> >> >>> >> Dave Cramer >> >>> >> >> >>> >> da...@postgresintl.com >> >>> >> www.postgresintl.com >> >>> >> >> >>> >> On 23 October 2015 at 18:28, Tatsuo Ishii >> >>> wrote: >> >>> >> >> >>> >>> It seems >> >>> >>> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does >> >>> >>> not work anymore in the newer JDBC driver. >> >>> >>> >> >>> >>> As far as I know, postgresql-9.2-1003.jdbc4.jar or >> >>> >>> postgresql-9.3-1104.jdbc41.jar work fine and produce following >> output >> >>> >>> for example: >> >>> >>> >> >>> >>> 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) >> >>> >>> 16:36:36.464 (1) Trying to establish a protocol version 3 >> connection >> >>> to >> >>> >>> localhost:11000 >> >>> >>> 16:36:36.481 (1) Receive Buffer Size is 530904 >> >>> >>> 16:36:36.481 (1) Send Buffer Size is 1313280 >> >>> >>> 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, >> >>> >>> client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, >> >>> >>> extra_float_digits=2) >> >>> >>> 16:36:36.487 (1)<=BE
Re: [HACKERS] JDBC driver debug out?
Add DriverManager.setLogWriter(new PrintWriter(System.out)); below the setLogLevel and it will I'll fix this though Dave Cramer da...@postgresintl.com www.postgresintl.com On 23 October 2015 at 22:35, Tatsuo Ishiiwrote: > Unfortunately it doesn't work (no debug trace). > > Best regards, > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese:http://www.sraoss.co.jp > > > This should work better > > > > > https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc41-SNAPSHOT/ > > > > Dave Cramer > > > > da...@postgresintl.com > > www.postgresintl.com > > > > On 23 October 2015 at 21:32, Dave Cramer wrote: > > > >> No, I need to provide you with a 41 version. > >> > >> I just happened to have java 1.8 on my machine. > >> > >> Dave Cramer > >> > >> da...@postgresintl.com > >> www.postgresintl.com > >> > >> On 23 October 2015 at 21:31, Tatsuo Ishii wrote: > >> > >>> Dave, > >>> > >>> Thanks for the quick response. Unfortunately now I'm getting error > >>> with the JDBC driver. > >>> > >>> warning: > >>> > /usr/local/pgsql/share/postgresql-9.4-1204-jdbc42-20151023.230759-1.jar(org/postgresql/Driver.class): > >>> major version 52 is newer than 51, the highest major version supported > by > >>> this compiler. > >>> It is recommended that the compiler be upgraded. > >>> 1 warning > >>> [snip] > >>> Exception in thread "main" java.lang.UnsupportedClassVersionError: > >>> org/postgresql/Driver : Unsupported major.minor version 52.0 > >>> at java.lang.ClassLoader.defineClass1(Native Method) > >>> at java.lang.ClassLoader.defineClass(ClassLoader.java:800) > >>> at > >>> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) > >>> at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) > >>> at java.net.URLClassLoader.access$100(URLClassLoader.java:71) > >>> at java.net.URLClassLoader$1.run(URLClassLoader.java:361) > >>> at java.net.URLClassLoader$1.run(URLClassLoader.java:355) > >>> at java.security.AccessController.doPrivileged(Native Method) > >>> at java.net.URLClassLoader.findClass(URLClassLoader.java:354) > >>> at java.lang.ClassLoader.loadClass(ClassLoader.java:425) > >>> at > sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) > >>> at java.lang.ClassLoader.loadClass(ClassLoader.java:358) > >>> at java.lang.Class.forName0(Native Method) > >>> at java.lang.Class.forName(Class.java:191) > >>> at begin_select_sleep.dbAccess(begin_select_sleep.java:39) > >>> at begin_select_sleep.main(begin_select_sleep.java:21) > >>> > >>> $ java -version > >>> java version "1.7.0_79" > >>> OpenJDK Runtime Environment (IcedTea 2.5.6) > (7u79-2.5.6-0ubuntu1.14.04.1) > >>> OpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode) > >>> > >>> Probably I should upgrade Java... > >>> > >>> Best regards, > >>> -- > >>> Tatsuo Ishii > >>> SRA OSS, Inc. Japan > >>> English: http://www.sraoss.co.jp/index_en.php > >>> Japanese:http://www.sraoss.co.jp > >>> > >>> > Tatsuo, > >>> > > >>> > Can you confirm it is fixed in this snapshot > >>> > > >>> > https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/ > >>> > > >>> > Dave Cramer > >>> > > >>> > da...@postgresintl.com > >>> > www.postgresintl.com > >>> > > >>> > On 23 October 2015 at 19:00, Dave Cramer wrote: > >>> > > >>> >> Tatsuo, > >>> >> > >>> >> posting to jdbc list > >>> >> > >>> >> Dave Cramer > >>> >> > >>> >> da...@postgresintl.com > >>> >> www.postgresintl.com > >>> >> > >>> >> On 23 October 2015 at 18:28, Tatsuo Ishii > >>> wrote: > >>> >> > >>> >>> It seems > >>> >>> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does > >>> >>> not work anymore in the newer JDBC driver. > >>> >>> > >>> >>> As far as I know, postgresql-9.2-1003.jdbc4.jar or > >>> >>> postgresql-9.3-1104.jdbc41.jar work fine and produce following > output > >>> >>> for example: > >>> >>> > >>> >>> 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) > >>> >>> 16:36:36.464 (1) Trying to establish a protocol version 3 > connection > >>> to > >>> >>> localhost:11000 > >>> >>> 16:36:36.481 (1) Receive Buffer Size is 530904 > >>> >>> 16:36:36.481 (1) Send Buffer Size is 1313280 > >>> >>> 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, > >>> >>> client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, > >>> >>> extra_float_digits=2) > >>> >>> 16:36:36.487 (1)<=BE AuthenticationOk > >>> >>> > >>> >>> However postgresql-9.4-1204.jdbc41.jar shows nothing. > >>> >>> > >>> >>> Best regards, > >>> >>> -- > >>> >>> Tatsuo Ishii > >>> >>> SRA OSS, Inc. Japan > >>> >>> English: http://www.sraoss.co.jp/index_en.php > >>> >>> Japanese:http://www.sraoss.co.jp > >>> >>> > >>> >>> > >>> >>>
Re: [HACKERS] JDBC driver debug out?
Unfortunately it doesn't work (no debug trace). Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp > This should work better > > https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc41-SNAPSHOT/ > > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > > On 23 October 2015 at 21:32, Dave Cramerwrote: > >> No, I need to provide you with a 41 version. >> >> I just happened to have java 1.8 on my machine. >> >> Dave Cramer >> >> da...@postgresintl.com >> www.postgresintl.com >> >> On 23 October 2015 at 21:31, Tatsuo Ishii wrote: >> >>> Dave, >>> >>> Thanks for the quick response. Unfortunately now I'm getting error >>> with the JDBC driver. >>> >>> warning: >>> /usr/local/pgsql/share/postgresql-9.4-1204-jdbc42-20151023.230759-1.jar(org/postgresql/Driver.class): >>> major version 52 is newer than 51, the highest major version supported by >>> this compiler. >>> It is recommended that the compiler be upgraded. >>> 1 warning >>> [snip] >>> Exception in thread "main" java.lang.UnsupportedClassVersionError: >>> org/postgresql/Driver : Unsupported major.minor version 52.0 >>> at java.lang.ClassLoader.defineClass1(Native Method) >>> at java.lang.ClassLoader.defineClass(ClassLoader.java:800) >>> at >>> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) >>> at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) >>> at java.net.URLClassLoader.access$100(URLClassLoader.java:71) >>> at java.net.URLClassLoader$1.run(URLClassLoader.java:361) >>> at java.net.URLClassLoader$1.run(URLClassLoader.java:355) >>> at java.security.AccessController.doPrivileged(Native Method) >>> at java.net.URLClassLoader.findClass(URLClassLoader.java:354) >>> at java.lang.ClassLoader.loadClass(ClassLoader.java:425) >>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) >>> at java.lang.ClassLoader.loadClass(ClassLoader.java:358) >>> at java.lang.Class.forName0(Native Method) >>> at java.lang.Class.forName(Class.java:191) >>> at begin_select_sleep.dbAccess(begin_select_sleep.java:39) >>> at begin_select_sleep.main(begin_select_sleep.java:21) >>> >>> $ java -version >>> java version "1.7.0_79" >>> OpenJDK Runtime Environment (IcedTea 2.5.6) (7u79-2.5.6-0ubuntu1.14.04.1) >>> OpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode) >>> >>> Probably I should upgrade Java... >>> >>> Best regards, >>> -- >>> Tatsuo Ishii >>> SRA OSS, Inc. Japan >>> English: http://www.sraoss.co.jp/index_en.php >>> Japanese:http://www.sraoss.co.jp >>> >>> > Tatsuo, >>> > >>> > Can you confirm it is fixed in this snapshot >>> > >>> https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/ >>> > >>> > Dave Cramer >>> > >>> > da...@postgresintl.com >>> > www.postgresintl.com >>> > >>> > On 23 October 2015 at 19:00, Dave Cramer wrote: >>> > >>> >> Tatsuo, >>> >> >>> >> posting to jdbc list >>> >> >>> >> Dave Cramer >>> >> >>> >> da...@postgresintl.com >>> >> www.postgresintl.com >>> >> >>> >> On 23 October 2015 at 18:28, Tatsuo Ishii >>> wrote: >>> >> >>> >>> It seems >>> >>> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does >>> >>> not work anymore in the newer JDBC driver. >>> >>> >>> >>> As far as I know, postgresql-9.2-1003.jdbc4.jar or >>> >>> postgresql-9.3-1104.jdbc41.jar work fine and produce following output >>> >>> for example: >>> >>> >>> >>> 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) >>> >>> 16:36:36.464 (1) Trying to establish a protocol version 3 connection >>> to >>> >>> localhost:11000 >>> >>> 16:36:36.481 (1) Receive Buffer Size is 530904 >>> >>> 16:36:36.481 (1) Send Buffer Size is 1313280 >>> >>> 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, >>> >>> client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, >>> >>> extra_float_digits=2) >>> >>> 16:36:36.487 (1)<=BE AuthenticationOk >>> >>> >>> >>> However postgresql-9.4-1204.jdbc41.jar shows nothing. >>> >>> >>> >>> Best regards, >>> >>> -- >>> >>> Tatsuo Ishii >>> >>> SRA OSS, Inc. Japan >>> >>> English: http://www.sraoss.co.jp/index_en.php >>> >>> Japanese:http://www.sraoss.co.jp >>> >>> >>> >>> >>> >>> -- >>> >>> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >>> >>> To make changes to your subscription: >>> >>> http://www.postgresql.org/mailpref/pgsql-hackers >>> >>> >>> >> >>> >> >>> >> >> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] JDBC driver debug out?
Dave, Thanks for the quick response. Unfortunately now I'm getting error with the JDBC driver. warning: /usr/local/pgsql/share/postgresql-9.4-1204-jdbc42-20151023.230759-1.jar(org/postgresql/Driver.class): major version 52 is newer than 51, the highest major version supported by this compiler. It is recommended that the compiler be upgraded. 1 warning [snip] Exception in thread "main" java.lang.UnsupportedClassVersionError: org/postgresql/Driver : Unsupported major.minor version 52.0 at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(ClassLoader.java:800) at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) at java.net.URLClassLoader.access$100(URLClassLoader.java:71) at java.net.URLClassLoader$1.run(URLClassLoader.java:361) at java.net.URLClassLoader$1.run(URLClassLoader.java:355) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:354) at java.lang.ClassLoader.loadClass(ClassLoader.java:425) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) at java.lang.ClassLoader.loadClass(ClassLoader.java:358) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:191) at begin_select_sleep.dbAccess(begin_select_sleep.java:39) at begin_select_sleep.main(begin_select_sleep.java:21) $ java -version java version "1.7.0_79" OpenJDK Runtime Environment (IcedTea 2.5.6) (7u79-2.5.6-0ubuntu1.14.04.1) OpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode) Probably I should upgrade Java... Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp > Tatsuo, > > Can you confirm it is fixed in this snapshot > https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/ > > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > > On 23 October 2015 at 19:00, Dave Cramerwrote: > >> Tatsuo, >> >> posting to jdbc list >> >> Dave Cramer >> >> da...@postgresintl.com >> www.postgresintl.com >> >> On 23 October 2015 at 18:28, Tatsuo Ishii wrote: >> >>> It seems >>> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does >>> not work anymore in the newer JDBC driver. >>> >>> As far as I know, postgresql-9.2-1003.jdbc4.jar or >>> postgresql-9.3-1104.jdbc41.jar work fine and produce following output >>> for example: >>> >>> 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) >>> 16:36:36.464 (1) Trying to establish a protocol version 3 connection to >>> localhost:11000 >>> 16:36:36.481 (1) Receive Buffer Size is 530904 >>> 16:36:36.481 (1) Send Buffer Size is 1313280 >>> 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, >>> client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, >>> extra_float_digits=2) >>> 16:36:36.487 (1)<=BE AuthenticationOk >>> >>> However postgresql-9.4-1204.jdbc41.jar shows nothing. >>> >>> Best regards, >>> -- >>> Tatsuo Ishii >>> SRA OSS, Inc. Japan >>> English: http://www.sraoss.co.jp/index_en.php >>> Japanese:http://www.sraoss.co.jp >>> >>> >>> -- >>> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >>> To make changes to your subscription: >>> http://www.postgresql.org/mailpref/pgsql-hackers >>> >> >> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] JDBC driver debug out?
No, I need to provide you with a 41 version. I just happened to have java 1.8 on my machine. Dave Cramer da...@postgresintl.com www.postgresintl.com On 23 October 2015 at 21:31, Tatsuo Ishiiwrote: > Dave, > > Thanks for the quick response. Unfortunately now I'm getting error > with the JDBC driver. > > warning: > /usr/local/pgsql/share/postgresql-9.4-1204-jdbc42-20151023.230759-1.jar(org/postgresql/Driver.class): > major version 52 is newer than 51, the highest major version supported by > this compiler. > It is recommended that the compiler be upgraded. > 1 warning > [snip] > Exception in thread "main" java.lang.UnsupportedClassVersionError: > org/postgresql/Driver : Unsupported major.minor version 52.0 > at java.lang.ClassLoader.defineClass1(Native Method) > at java.lang.ClassLoader.defineClass(ClassLoader.java:800) > at > java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) > at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) > at java.net.URLClassLoader.access$100(URLClassLoader.java:71) > at java.net.URLClassLoader$1.run(URLClassLoader.java:361) > at java.net.URLClassLoader$1.run(URLClassLoader.java:355) > at java.security.AccessController.doPrivileged(Native Method) > at java.net.URLClassLoader.findClass(URLClassLoader.java:354) > at java.lang.ClassLoader.loadClass(ClassLoader.java:425) > at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) > at java.lang.ClassLoader.loadClass(ClassLoader.java:358) > at java.lang.Class.forName0(Native Method) > at java.lang.Class.forName(Class.java:191) > at begin_select_sleep.dbAccess(begin_select_sleep.java:39) > at begin_select_sleep.main(begin_select_sleep.java:21) > > $ java -version > java version "1.7.0_79" > OpenJDK Runtime Environment (IcedTea 2.5.6) (7u79-2.5.6-0ubuntu1.14.04.1) > OpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode) > > Probably I should upgrade Java... > > Best regards, > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese:http://www.sraoss.co.jp > > > Tatsuo, > > > > Can you confirm it is fixed in this snapshot > > > https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/ > > > > Dave Cramer > > > > da...@postgresintl.com > > www.postgresintl.com > > > > On 23 October 2015 at 19:00, Dave Cramer wrote: > > > >> Tatsuo, > >> > >> posting to jdbc list > >> > >> Dave Cramer > >> > >> da...@postgresintl.com > >> www.postgresintl.com > >> > >> On 23 October 2015 at 18:28, Tatsuo Ishii wrote: > >> > >>> It seems > >>> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does > >>> not work anymore in the newer JDBC driver. > >>> > >>> As far as I know, postgresql-9.2-1003.jdbc4.jar or > >>> postgresql-9.3-1104.jdbc41.jar work fine and produce following output > >>> for example: > >>> > >>> 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) > >>> 16:36:36.464 (1) Trying to establish a protocol version 3 connection to > >>> localhost:11000 > >>> 16:36:36.481 (1) Receive Buffer Size is 530904 > >>> 16:36:36.481 (1) Send Buffer Size is 1313280 > >>> 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, > >>> client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, > >>> extra_float_digits=2) > >>> 16:36:36.487 (1)<=BE AuthenticationOk > >>> > >>> However postgresql-9.4-1204.jdbc41.jar shows nothing. > >>> > >>> Best regards, > >>> -- > >>> Tatsuo Ishii > >>> SRA OSS, Inc. Japan > >>> English: http://www.sraoss.co.jp/index_en.php > >>> Japanese:http://www.sraoss.co.jp > >>> > >>> > >>> -- > >>> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > >>> To make changes to your subscription: > >>> http://www.postgresql.org/mailpref/pgsql-hackers > >>> > >> > >> >
Re: [HACKERS] JDBC driver debug out?
This should work better https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc41-SNAPSHOT/ Dave Cramer da...@postgresintl.com www.postgresintl.com On 23 October 2015 at 21:32, Dave Cramerwrote: > No, I need to provide you with a 41 version. > > I just happened to have java 1.8 on my machine. > > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > > On 23 October 2015 at 21:31, Tatsuo Ishii wrote: > >> Dave, >> >> Thanks for the quick response. Unfortunately now I'm getting error >> with the JDBC driver. >> >> warning: >> /usr/local/pgsql/share/postgresql-9.4-1204-jdbc42-20151023.230759-1.jar(org/postgresql/Driver.class): >> major version 52 is newer than 51, the highest major version supported by >> this compiler. >> It is recommended that the compiler be upgraded. >> 1 warning >> [snip] >> Exception in thread "main" java.lang.UnsupportedClassVersionError: >> org/postgresql/Driver : Unsupported major.minor version 52.0 >> at java.lang.ClassLoader.defineClass1(Native Method) >> at java.lang.ClassLoader.defineClass(ClassLoader.java:800) >> at >> java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142) >> at java.net.URLClassLoader.defineClass(URLClassLoader.java:449) >> at java.net.URLClassLoader.access$100(URLClassLoader.java:71) >> at java.net.URLClassLoader$1.run(URLClassLoader.java:361) >> at java.net.URLClassLoader$1.run(URLClassLoader.java:355) >> at java.security.AccessController.doPrivileged(Native Method) >> at java.net.URLClassLoader.findClass(URLClassLoader.java:354) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:425) >> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308) >> at java.lang.ClassLoader.loadClass(ClassLoader.java:358) >> at java.lang.Class.forName0(Native Method) >> at java.lang.Class.forName(Class.java:191) >> at begin_select_sleep.dbAccess(begin_select_sleep.java:39) >> at begin_select_sleep.main(begin_select_sleep.java:21) >> >> $ java -version >> java version "1.7.0_79" >> OpenJDK Runtime Environment (IcedTea 2.5.6) (7u79-2.5.6-0ubuntu1.14.04.1) >> OpenJDK 64-Bit Server VM (build 24.79-b02, mixed mode) >> >> Probably I should upgrade Java... >> >> Best regards, >> -- >> Tatsuo Ishii >> SRA OSS, Inc. Japan >> English: http://www.sraoss.co.jp/index_en.php >> Japanese:http://www.sraoss.co.jp >> >> > Tatsuo, >> > >> > Can you confirm it is fixed in this snapshot >> > >> https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/ >> > >> > Dave Cramer >> > >> > da...@postgresintl.com >> > www.postgresintl.com >> > >> > On 23 October 2015 at 19:00, Dave Cramer wrote: >> > >> >> Tatsuo, >> >> >> >> posting to jdbc list >> >> >> >> Dave Cramer >> >> >> >> da...@postgresintl.com >> >> www.postgresintl.com >> >> >> >> On 23 October 2015 at 18:28, Tatsuo Ishii >> wrote: >> >> >> >>> It seems >> >>> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does >> >>> not work anymore in the newer JDBC driver. >> >>> >> >>> As far as I know, postgresql-9.2-1003.jdbc4.jar or >> >>> postgresql-9.3-1104.jdbc41.jar work fine and produce following output >> >>> for example: >> >>> >> >>> 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) >> >>> 16:36:36.464 (1) Trying to establish a protocol version 3 connection >> to >> >>> localhost:11000 >> >>> 16:36:36.481 (1) Receive Buffer Size is 530904 >> >>> 16:36:36.481 (1) Send Buffer Size is 1313280 >> >>> 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, >> >>> client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, >> >>> extra_float_digits=2) >> >>> 16:36:36.487 (1)<=BE AuthenticationOk >> >>> >> >>> However postgresql-9.4-1204.jdbc41.jar shows nothing. >> >>> >> >>> Best regards, >> >>> -- >> >>> Tatsuo Ishii >> >>> SRA OSS, Inc. Japan >> >>> English: http://www.sraoss.co.jp/index_en.php >> >>> Japanese:http://www.sraoss.co.jp >> >>> >> >>> >> >>> -- >> >>> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >> >>> To make changes to your subscription: >> >>> http://www.postgresql.org/mailpref/pgsql-hackers >> >>> >> >> >> >> >> > >
Re: [HACKERS] JDBC driver debug out?
Tatsuo, Can you confirm it is fixed in this snapshot https://oss.sonatype.org/content/repositories/snapshots/org/postgresql/postgresql/9.4-1204-jdbc42-SNAPSHOT/ Dave Cramer da...@postgresintl.com www.postgresintl.com On 23 October 2015 at 19:00, Dave Cramerwrote: > Tatsuo, > > posting to jdbc list > > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > > On 23 October 2015 at 18:28, Tatsuo Ishii wrote: > >> It seems >> org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does >> not work anymore in the newer JDBC driver. >> >> As far as I know, postgresql-9.2-1003.jdbc4.jar or >> postgresql-9.3-1104.jdbc41.jar work fine and produce following output >> for example: >> >> 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) >> 16:36:36.464 (1) Trying to establish a protocol version 3 connection to >> localhost:11000 >> 16:36:36.481 (1) Receive Buffer Size is 530904 >> 16:36:36.481 (1) Send Buffer Size is 1313280 >> 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, >> client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, >> extra_float_digits=2) >> 16:36:36.487 (1)<=BE AuthenticationOk >> >> However postgresql-9.4-1204.jdbc41.jar shows nothing. >> >> Best regards, >> -- >> Tatsuo Ishii >> SRA OSS, Inc. Japan >> English: http://www.sraoss.co.jp/index_en.php >> Japanese:http://www.sraoss.co.jp >> >> >> -- >> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-hackers >> > >
[HACKERS] JDBC driver debug out?
It seems org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does not work anymore in the newer JDBC driver. As far as I know, postgresql-9.2-1003.jdbc4.jar or postgresql-9.3-1104.jdbc41.jar work fine and produce following output for example: 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) 16:36:36.464 (1) Trying to establish a protocol version 3 connection to localhost:11000 16:36:36.481 (1) Receive Buffer Size is 530904 16:36:36.481 (1) Send Buffer Size is 1313280 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, extra_float_digits=2) 16:36:36.487 (1)<=BE AuthenticationOk However postgresql-9.4-1204.jdbc41.jar shows nothing. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] JDBC driver debug out?
Tatsuo, posting to jdbc list Dave Cramer da...@postgresintl.com www.postgresintl.com On 23 October 2015 at 18:28, Tatsuo Ishiiwrote: > It seems > org.postgresql.Driver.setLogLevel(org.postgresql.Driver.DEBUG) does > not work anymore in the newer JDBC driver. > > As far as I know, postgresql-9.2-1003.jdbc4.jar or > postgresql-9.3-1104.jdbc41.jar work fine and produce following output > for example: > > 16:36:36.459 (1) PostgreSQL 9.3 JDBC4.1 (build 1104) > 16:36:36.464 (1) Trying to establish a protocol version 3 connection to > localhost:11000 > 16:36:36.481 (1) Receive Buffer Size is 530904 > 16:36:36.481 (1) Send Buffer Size is 1313280 > 16:36:36.481 (1) FE=> StartupPacket(user=t-ishii, database=test, > client_encoding=UTF8, DateStyle=ISO, TimeZone=Asia/Tokyo, > extra_float_digits=2) > 16:36:36.487 (1)<=BE AuthenticationOk > > However postgresql-9.4-1204.jdbc41.jar shows nothing. > > Best regards, > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > English: http://www.sraoss.co.jp/index_en.php > Japanese:http://www.sraoss.co.jp > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >