Re: [HACKERS] JDBC driver debug out? - Mailing list pgsql-jdbc

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