JDBC driver debug out?

Started by Tatsuo Ishiiabout 10 years ago9 messages

ishii@postgresql.org

about 10 years ago

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

pg@fastcrypt.com

about 10 years ago

In reply to: Tatsuo Ishii (#1)

Re: JDBC driver debug out?

Tatsuo,

posting to jdbc list

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 18:28, Tatsuo Ishii <ishii@postgresql.org> wrote:

Show quoted text

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

pg@fastcrypt.com

about 10 years ago

In reply to: Dave Cramer (#2)

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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 19:00, Dave Cramer <pg@fastcrypt.com> wrote:

Show quoted text

Tatsuo,

posting to jdbc list

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 18:28, Tatsuo Ishii <ishii@postgresql.org> 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

ishii@postgresql.org

about 10 years ago

In reply to: Dave Cramer (#3)

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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 19:00, Dave Cramer <pg@fastcrypt.com> wrote:

Tatsuo,

posting to jdbc list

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 18:28, Tatsuo Ishii <ishii@postgresql.org> 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-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

pg@fastcrypt.com

about 10 years ago

In reply to: Tatsuo Ishii (#4)

Re: 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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:31, Tatsuo Ishii <ishii@postgresql.org> wrote:

Show quoted text

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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 19:00, Dave Cramer <pg@fastcrypt.com> wrote:

Tatsuo,

posting to jdbc list

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 18:28, Tatsuo Ishii <ishii@postgresql.org> 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

pg@fastcrypt.com

about 10 years ago

In reply to: Dave Cramer (#5)

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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:32, Dave Cramer <pg@fastcrypt.com> wrote:

Show quoted text

No, I need to provide you with a 41 version.

I just happened to have java 1.8 on my machine.

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:31, Tatsuo Ishii <ishii@postgresql.org> 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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 19:00, Dave Cramer <pg@fastcrypt.com> wrote:

Tatsuo,

posting to jdbc list

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 18:28, Tatsuo Ishii <ishii@postgresql.org>

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

ishii@postgresql.org

about 10 years ago

In reply to: Dave Cramer (#6)

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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:32, Dave Cramer <pg@fastcrypt.com> wrote:

No, I need to provide you with a 41 version.

I just happened to have java 1.8 on my machine.

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:31, Tatsuo Ishii <ishii@postgresql.org> 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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 19:00, Dave Cramer <pg@fastcrypt.com> wrote:

Tatsuo,

posting to jdbc list

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 18:28, Tatsuo Ishii <ishii@postgresql.org>

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-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc

pg@fastcrypt.com

about 10 years ago

In reply to: Tatsuo Ishii (#7)

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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 22:35, Tatsuo Ishii <ishii@postgresql.org> wrote:

Show quoted text

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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:32, Dave Cramer <pg@fastcrypt.com> wrote:

No, I need to provide you with a 41 version.

I just happened to have java 1.8 on my machine.

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:31, Tatsuo Ishii <ishii@postgresql.org> 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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 19:00, Dave Cramer <pg@fastcrypt.com> wrote:

Tatsuo,

posting to jdbc list

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 18:28, Tatsuo Ishii <ishii@postgresql.org>

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

ishii@postgresql.org

about 10 years ago

In reply to: Dave Cramer (#8)

Re: 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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 22:35, Tatsuo Ishii <ishii@postgresql.org> wrote:

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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:32, Dave Cramer <pg@fastcrypt.com> wrote:

No, I need to provide you with a 41 version.

I just happened to have java 1.8 on my machine.

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 21:31, Tatsuo Ishii <ishii@postgresql.org> 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

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 19:00, Dave Cramer <pg@fastcrypt.com> wrote:

Tatsuo,

posting to jdbc list

Dave Cramer

davec@postgresintl.com
www.postgresintl.com

On 23 October 2015 at 18:28, Tatsuo Ishii <ishii@postgresql.org>

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