AnsweredAssumed Answered

Dbvisualizer can't get table for JDBC

Question asked by Techapat on Apr 4, 2018
Latest reply on Apr 5, 2018 by 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

Outcomes