2 Replies Latest reply on Apr 5, 2018 1:18 AM by Techapat

    Dbvisualizer can't get table for JDBC

    Techapat

      Hi All,

       

      I used Dbvisualizer connected by JDBC to PIServer. It was connect and saw catalog but it can't get table and show message log below. How can i fix it?

      An error occurred while executing the database request for:

      PI SQL Data Access Server 1.5.16302.2 using PIOLEDB

      PIOLEDB: 3.4.1.28

      com.osisoft.jdbc.Driver

      1.5.17320.1

       

       

      The command that caused the problem:

      getTables

       

       

      Details:

         Type: java.lang.reflect.UndeclaredThrowableException

       

       

      Stack Trace:

      java.lang.NoSuchMethodError: sun.nio.ch.DirectBuffer.cleaner()Lsun/misc/Cleaner;

         at com.osisoft.rdsa.DataReader.setCurrentRow(DataReader.java:124)

         at com.osisoft.rdsa.DataReader.next(DataReader.java:75)

         at com.osisoft.jdbc.DatabaseMetaDataImpl.getTables(DatabaseMetaDataImpl.java:568)

         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

         at java.base/java.lang.reflect.Method.invoke(Unknown Source)

         at com.onseven.dbvis.g.B.E.?(Z:482)

         at com.onseven.dbvis.g.B.F$A.call(Z:1369)

      [wrapped] java.lang.Exception: java.lang.NoSuchMethodError: sun.nio.ch.DirectBuffer.cleaner()Lsun/misc/Cleaner;

         at com.onseven.dbvis.g.B.F$A.call(Z:2374)

         at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

      [wrapped] java.lang.reflect.UndeclaredThrowableException

         at com.sun.proxy.$Proxy5.getTables(Unknown Source)

         at com.onseven.dbvis.db.N.?(Z:3052)

         at com.onseven.dbvis.K.C.M.?(Z:1146)

         at com.onseven.dbvis.K.C.M.?(Z:1470)

         at com.onseven.dbvis.K.C.W.?(Z:2613)

         at com.onseven.dbvis.K.C.W.?(Z:1357)

         at com.onseven.dbvis.K.C.A.?(Z:112)

         at com.onseven.dbvis.K.C.A.?(Z:906)

         at com.onseven.dbvis.K.C.W.?(Z:2613)

         at com.onseven.dbvis.K.C.W.?(Z:1357)

         at com.onseven.dbvis.objects.H.C.?(Z:2705)

         at com.onseven.dbvis.objects.H.C.?(Z:2852)

         at com.onseven.dbvis.objects.H.C.?(Z:2714)

         at com.onseven.dbvis.K.C.W.?(Z:2613)

         at com.onseven.dbvis.K.C.J.?(Z:1374)

         at com.onseven.dbvis.K.C.J.doInBackground(Z:1521)

         at java.desktop/javax.swing.SwingWorker$1.call(Unknown Source)

         at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

         at java.desktop/javax.swing.SwingWorker.run(Unknown Source)

         at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

         at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

         at java.base/java.lang.Thread.run(Unknown Source)

       

       

      System Information:

      Product: DbVisualizer Free 10.0.8 [Build #2841]

      OS: Windows Server 2012 R2

      OS Version: 6.3

      OS Arch: amd64

      Java Version: 9.0.4

      Java VM: Java HotSpot(TM) 64-Bit Server VM

      Java Vendor: Oracle Corporation

      Java Home: c:\program files\dbvisualizer\jre

      DbVis Home: C:\Program Files\DbVisualizer

      User Home:

      PrefsDir:

      SessionId:

      BindDir: null

        • Re: Dbvisualizer can't get table for JDBC
          cvillanua

          Hello Techapat!

           

          Thank you for posting in PI Square .

          The issue that you are having is because the current version of JDBC does not support Java version 9.

           

          System Information:

          Product: DbVisualizer Free 10.0.8 [Build #2841]

          OS: Windows Server 2012 R2

          OS Version: 6.3

          OS Arch: amd64

          Java Version: 9.0.4

          Java VM: Java HotSpot(TM) 64-Bit Server VM

          Java Vendor: Oracle Corporation

          Java Home: c:\program files\dbvisualizer\jre

          DbVis Home: C:\Program Files\DbVisualizer

          User Home:

          PrefsDir:

          SessionId:

          BindDir: null

           

          You will have to downgrade your java version to 8 in order to make it work with your current release (JDBC 1.5.17320.1)

           

           

          The good news is that the upcoming version would be supporting Java 9 this version should be out in Q2. PI System Roadmap

           

          Thank you,

           

          Carlos.

          5 of 5 people found this helpful