jdbc driver and dbvisualizer

[Stephen Sprague]

hey guys,

is this a known issue?

>  Method DatabaseMetaData.getTypeInfo is not yet implemented

Seems like a pretty high-level method to be missing so maybe something else might be at play?  Any ideas most welcome.

thanks,

Stephen.

Here's my stack trace from DBViz:

2017-02-09 21:34:26.185 INFO    36 [ExecutorRunner-pool-3-thread-1 - L.ￄﾁ] Exception while caching data types for database: presto-160-prod
com.onseven.dbvis.K.B.Q: com.facebook.presto.jdbc.NotImplementedException: Method DatabaseMetaData.getTypeInfo is not yet implemented
    at com.onseven.dbvis.K.B.P.ￄﾡ(Z:1111)
    at com.onseven.dbvis.K.B._.ￄﾜ(Z:2717)
    at com.onseven.dbvis.K.B._.ￄﾎ(Z:2518)
    at com.onseven.dbvis.db.L.ￄﾕ(Z:3124)
    at com.onseven.dbvis.db.I.L.ￄﾡ(Z:1582)
    at com.onseven.dbvis.db.I.L.ￄﾁ(Z:1239)
    at com.onseven.dbvis.db.I.L.ￄﾃ(Z:1768)
    at com.onseven.dbvis.db.I.H.ￄﾳ(Z:2009)
    at com.onseven.dbvis.db.I.K.ￄﾳ(Z:235)
    at com.onseven.dbvis.db.I.D.ￄﾡ(Z:1756)
    at com.onseven.dbvis.K.B._.ￄﾜ(Z:2717)
    at com.onseven.dbvis.K.B.L.ￄﾂ(Z:1374)
    at com.onseven.dbvis.K.B.L.doInBackground(Z:1521)
    at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at javax.swing.SwingWorker.run(SwingWorker.java:334)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: com.facebook.presto.jdbc.NotImplementedException: Method DatabaseMetaData.getTypeInfo is not yet implemented
    at com.facebook.presto.jdbc.PrestoDatabaseMetaData.getTypeInfo(PrestoDatabaseMetaData.java:1055)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at com.onseven.dbvis.g.B.E.ￄﾁ(Z:482)
    at com.onseven.dbvis.g.B.F$A.call(Z:1369)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)

Here's some config info from my box:

2017-02-09 21:23:52.545 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] Product: DbVisualizer 9.5.6 [Build #2608]
2017-02-09 21:23:52.548 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] OS: Mac OS X
2017-02-09 21:23:52.548 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] OS Version: 10.12.1
2017-02-09 21:23:52.548 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] OS Arch: x86_64
2017-02-09 21:23:52.549 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] Java Version: 1.8.0_111
2017-02-09 21:23:52.549 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] Java VM: Java HotSpot(TM) 64-Bit Server VM
2017-02-09 21:23:52.549 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] Java Vendor: Oracle Corporation
2017-02-09 21:23:52.549 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] Java Home: /Library/Internet Plug-Ins/JavaAppletPlugin.plugin/Contents/Home
2017-02-09 21:23:52.549 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] DbVis Home: /Applications/DbVisualizer.app/Contents/java/app
2017-02-09 21:23:52.549 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] User Home: /Users/spragues
2017-02-09 21:23:52.550 CONFIG  36 [AWT-EventQueue-0 - D.ￄﾁ] PrefsDir: /Users/spragues/.dbvis

[David Phillips]

Thanks for the detailed report. Most JDBC features have been implemented as needed and I don't think anyone has asked for this yet. Please file a GitHub issue. It should be easy to implement, so this is a good beginner task for new contributors.

[Piotr Findeisen]

Hi Stephen,

Unless you're going to implement this method (or wait:), you can give Teradata's JDBC driver for Presto a try.

( http://www.teradata.com/products-and-services/presto-download/ )

Best regards,

Piotr

--
You received this message because you are subscribed to the Google Groups "Presto" group.
To unsubscribe from this group and stop receiving emails from it, send an email to presto-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Stephen Sprague]

Thanks guys!  I will take up both your suggestions.

Cheers,

Stephen.

To unsubscribe from this group and stop receiving emails from it, send an email to presto-users+unsubscribe@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

You received this message because you are subscribed to the Google Groups "Presto" group.

To unsubscribe from this group and stop receiving emails from it, send an email to presto-users+unsubscribe@googlegroups.com.

[Stephen Sprague]

and just to follow up on this.  I did create a presto github issue and i did try the teradata jdbc driver for which it does implement this method and looks like it works!
 

much obliged gentlemen.

​Cheers,

Stephen.​