JDBC MetaData Question > Squirrel > No TABLE retrieved from connection

[adriens]

While loading connexin objects, I cannot retrieve tables : it remains empty :

Still, i can query nodes :

I thought nodes (and maybe relationships too) would be returned as "Tables" and properties mapped as columns : am i wrong ? Is the actual behavior the expected one ?

Thank you in advance for your answer.

Kind regards, Adrien

[omarlarus]

Hi @adriens , the standard behaviour is:

• Label -> Table
• Property -> Column

So the relationships should not be shown. But there's something not working in your case. I'm checking it.

[adriens]

Let me know if you need me to make any additional test.

[adriens]

Here are some logs about not finding tableNames :

2018-08-22 22:08:51,656 [Thread-2] INFO  net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog  - ao?t 22, 2018 10:08:51 PM org.neo4j.driver.internal.logging.JULogger info
2018-08-22 22:08:51,656 [Thread-2] INFO  net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog  - INFOS: Direct driver instance 85284748 created for server address localhost:7687
2018-08-22 22:08:51,828 [Thread-2] INFO  net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog  - ao?t 22, 2018 10:08:51 PM org.neo4j.driver.internal.logging.JULogger info
2018-08-22 22:08:51,828 [Thread-2] INFO  net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog  - INFOS: Closing driver instance 85284748
2018-08-22 22:08:51,828 [Thread-2] INFO  net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog  - ao?t 22, 2018 10:08:51 PM org.neo4j.driver.internal.logging.JULogger info
2018-08-22 22:08:51,828 [Thread-2] INFO  net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog  - INFOS: Closing connection pool towards localhost:7687
2018-08-22 22:08:54,058 [Thread-2] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  - failed to load table names
java.lang.NullPointerException
    at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:130)
    at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:109)
    at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:92)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:284)
    at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:639)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:129)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:163)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1319)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:483)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:341)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.initialLoad(SchemaInfo.java:179)
    at net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:233)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Thread.java:748)

[omarlarus]

Hi @adriens , there's a new PR that will fix the issue. If you need the jar I can send you a preview.

[adriens]

Hi @omarlarus : if you want me to test it, I can dot it, like you did it last time. One more tester is never too much, no ? 😸 It's up to you, just let me know 👍

[omarlarus]

Here's a preview. Thanks a lot

[adriens]

Hi, sorry, but bad news around here this time :

2018-08-27 20:53:54,553 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:53:54 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:53:54,553 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1120434653 2018-08-27 20:53:54,553 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:53:54 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:53:54,553 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:53:56,885 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:53:56 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:53:56,885 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1876024671 created for server address localhost:7687 2018-08-27 20:53:57,010 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:53:57 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:53:57,010 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1876024671 2018-08-27 20:53:57,010 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:53:57 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:53:57,010 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:53:59,338 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:53:59 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:53:59,338 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 553833998 created for server address localhost:7687 2018-08-27 20:53:59,447 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:53:59 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:53:59,447 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 553833998 2018-08-27 20:53:59,447 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:53:59 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:53:59,447 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:01,780 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:01 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:01,780 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 501643978 created for server address localhost:7687 2018-08-27 20:54:01,889 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:01 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:01,889 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 501643978 2018-08-27 20:54:01,889 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:01 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:01,889 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:04,233 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:04 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:04,233 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1863040077 created for server address localhost:7687 2018-08-27 20:54:04,390 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:04 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:04,390 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1863040077 2018-08-27 20:54:04,390 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:04 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:04,390 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:06,731 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:06 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:06,731 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 13238366 created for server address localhost:7687 2018-08-27 20:54:06,856 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:06 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:06,856 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 13238366 2018-08-27 20:54:06,856 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:06 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:06,856 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:09,200 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:09 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:09,200 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1110090871 created for server address localhost:7687 2018-08-27 20:54:09,309 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:09 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:09,309 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1110090871 2018-08-27 20:54:09,309 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:09 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:09,309 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:11,650 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:11 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:11,650 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 724377073 created for server address localhost:7687 2018-08-27 20:54:11,775 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:11 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:11,775 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 724377073 2018-08-27 20:54:11,775 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:11 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:11,775 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:14,104 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.SessionManager - Failed to get allowed Schemas java.lang.NullPointerException at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:130) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:109) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:92) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:284) at net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:703) at net.sourceforge.squirrel_sql.client.session.SessionManager.getAllowedSchemas(SessionManager.java:655) at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:638) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:129) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:163) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1319) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:483) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:341) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:200) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:190) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:316) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2018-08-27 20:54:14,104 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:14 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:14,104 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1727563453 created for server address localhost:7687 2018-08-27 20:54:14,213 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:14 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:14,213 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1727563453 2018-08-27 20:54:14,213 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:14 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:14,213 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:16,556 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - failed to load table names java.lang.NullPointerException at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:130) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:109) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:92) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:284) at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:639) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:129) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:163) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadTables(SchemaInfo.java:1319) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadTables(SchemaInfo.java:483) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:341) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:200) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:190) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:316) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2018-08-27 20:54:16,618 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:16 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:16,618 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1349846205 created for server address localhost:7687 2018-08-27 20:54:16,728 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:16 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:16,728 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1349846205 2018-08-27 20:54:16,728 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:16 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:16,728 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:19,069 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures java.lang.NullPointerException at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:130) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:109) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:92) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:284) at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:639) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:129) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:163) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:156) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:628) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:418) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:345) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:200) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:190) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:316) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2018-08-27 20:54:19,132 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:19 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:19,132 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1200144103 created for server address localhost:7687 2018-08-27 20:54:19,241 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:19 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:19,241 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1200144103 2018-08-27 20:54:19,241 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:19 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:19,241 [Thread-4] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:21,575 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures java.lang.NullPointerException at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:130) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:109) at net.sourceforge.squirrel_sql.fw.sql.ResultSetReader.<init>(ResultSetReader.java:92) at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getSchemas(SQLDatabaseMetaData.java:284) at net.sourceforge.squirrel_sql.client.session.SessionManager.areAllSchemasAllowed(SessionManager.java:639) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getAllSchemaLoadInfos(SchemaInfoCache.java:129) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:163) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfoCache.getMatchingSchemaLoadInfos(SchemaInfoCache.java:156) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadUDTs(SchemaInfo.java:664) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadUDTs(SchemaInfo.java:449) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:348) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:200) at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:190) at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:316) at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82) at java.lang.Thread.run(Thread.java:748) 2018-08-27 20:54:21,575 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:21 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:21,575 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 378200137 created for server address localhost:7687 2018-08-27 20:54:21,684 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:21 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:21,684 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 378200137 2018-08-27 20:54:21,684 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:21 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:21,684 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:24,013 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:24 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:24,013 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1307808320 created for server address localhost:7687 2018-08-27 20:54:24,122 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:24 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:24,122 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1307808320 2018-08-27 20:54:24,122 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:24 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:24,122 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:26,444 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:26 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:26,444 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 2034624332 created for server address localhost:7687 2018-08-27 20:54:26,569 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:26 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:26,569 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 2034624332 2018-08-27 20:54:26,569 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:26 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:26,569 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:28,897 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:28 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:28,897 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1920174707 created for server address localhost:7687 2018-08-27 20:54:29,022 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:29 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:29,022 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1920174707 2018-08-27 20:54:29,022 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:29 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:29,022 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:31,497 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:31 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:31,497 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 826708189 created for server address localhost:7687 2018-08-27 20:54:31,628 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:31 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:31,628 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 826708189 2018-08-27 20:54:31,628 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:31 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:31,628 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:33,940 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:33 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:33,940 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1876810652 created for server address localhost:7687 2018-08-27 20:54:34,050 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:34 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:34,050 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1876810652 2018-08-27 20:54:34,050 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:34 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:34,050 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:36,384 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:36 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:36,384 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1687817018 created for server address localhost:7687 2018-08-27 20:54:36,509 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:36 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:36,509 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1687817018 2018-08-27 20:54:36,509 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:36 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:36,509 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:38,838 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:38 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:38,838 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 761700330 created for server address localhost:7687 2018-08-27 20:54:38,947 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:38 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:38,947 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 761700330 2018-08-27 20:54:38,947 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:38 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:38,947 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:41,304 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:41 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:41,304 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 2118254821 created for server address localhost:7687 2018-08-27 20:54:41,413 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:41 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:41,429 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 2118254821 2018-08-27 20:54:41,429 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:41 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:41,429 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:43,757 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:43 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:43,757 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 553667262 created for server address localhost:7687 2018-08-27 20:54:43,882 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:43 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:43,882 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 553667262 2018-08-27 20:54:43,882 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:43 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:43,882 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:46,215 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:46 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:46,215 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 351003619 created for server address localhost:7687 2018-08-27 20:54:46,339 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:46 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:46,339 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 351003619 2018-08-27 20:54:46,339 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:46 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:46,339 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687 2018-08-27 20:54:48,668 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:48 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:48,668 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Direct driver instance 1466284987 created for server address localhost:7687 2018-08-27 20:54:48,777 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:48 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:48,777 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing driver instance 1466284987 2018-08-27 20:54:48,777 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - ao?t 27, 2018 8:54:48 PM org.neo4j.driver.internal.logging.JULogger info 2018-08-27 20:54:48,777 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.fw.util.log.SystemOutToLog - INFOS: Closing connection pool towards localhost:7687

Are you sure the jar is the good one ?

[omarlarus]

The jar is named: "neo4j-jdbc-driver-3.4.1.jar", are you using it into the connection? Is the dropbox link right?

If it's all ok about the jar, can you try to right click to "refresh items" and wait for a little: sometimes Squirrel's quite slow to load the information.

[adriens]

Yep, classpath has been updated :

But table fodler remains empty. Did you manage to make it run on this Squirrel version ?...on Windows ?

[adriens]

Looks like Squirrel is trying to load procedures while trying to refresh tables :

2018-08-27 21:25:00,957 [Thread-4] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo  - Error occurred creating keyword collection
java.lang.UnsupportedOperationException: Method getProcedureTerm in class org.neo4j.jdbc.Neo4jDatabaseMetaData is not yet implemented.
    at org.neo4j.jdbc.utils.ExceptionBuilder.buildUnsupportedOperationException(ExceptionBuilder.java:43)
    at org.neo4j.jdbc.Neo4jDatabaseMetaData.getProcedureTerm(Neo4jDatabaseMetaData.java:555)
    at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedureTerm(SQLDatabaseMetaData.java:537)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadKeywords(SchemaInfo.java:946)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:288)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:200)
    at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:190)
    at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:316)
    at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
    at java.lang.Thread.run(Thread.java:748)

...hence causing table retrieval not to be run in fact

[adriens]

COuld you implement at org.neo4j.jdbc.Neo4jDatabaseMetaData.getProcedureTerm ?

[omarlarus]

I tested it on SQuirrel 3.8.1 on Mac. Sometimes I did the "refresh items" because the tool has a strange implementation that often closes and reopen the connection. Other tools like DBeaver are more efficient. When it refreshes the items, it loads a lot of information, not only the table names (the neo4j labels).

[adriens]

When it refreshes the items, it loads a lot of information, not only the table names (the neo4j labels).

Yes, totally matching what i could observe here too.

org.neo4j.jdbc.Neo4jDatabaseMetaData.getProcedureTerm seems to be one of them.

[adriens]

Could you try implement it ?

[adriens]

It should do the trick. 😸

[adriens]

https://docs.oracle.com/javase/8/docs/api/java/sql/DatabaseMetaData.html

[adriens]

@omarlarus : i've created a PR to fix this see https://github.com/neo4j-contrib/neo4j-jdbc/pull/168

[adriens]

It'as alreay available on master.

[adriens]

let me know if you want me to give it a try.