I am developing a profile for CockroachDB. I have a cockroachdb.xml profile that is extending the generic profile. A have a database profile path configured in preferences. DbVis sees the profile.
The issue I am having is that I am receiving the following error:
2018-03-30 09:58:08.754 WARN 1 [ExecutorRunner-pool-2-thread-1 - L.ᅣヒ] There is no Command with id suffix: getSchemaNames
I have added a command in the cockroachdb.xml file to override the command in the generic profile:
The original error is gone, but now in the Debug Window I get the following error:
2018-03-30 10:28:25.638 INFO 352 [ExecutorRunner-pool-2-thread-1 - A.<init>] Error extracting column: 2 from ResultSetMetaData
java.lang.NullPointerException
at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:185)
at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:181)
at org.postgresql.jdbc.PgResultSetMetaData.getSQLType(PgResultSetMetaData.java:499)
at org.postgresql.jdbc.PgResultSetMetaData.getColumnType(PgResultSetMetaData.java:387)
at com.onseven.dbvis.sql.A.<init>(Z:1489)
at com.onseven.dbvis.K.C.S.ᅣチ(Z:1215)
at com.onseven.dbvis.K.C.W.ᅣチ(Z:1510)
at com.onseven.dbvis.K.C.W.ᅣツ(Z:1331)
at com.onseven.dbvis.K.C.M.ᅣル(Z:925)
at com.onseven.dbvis.K.C.M.ᅣᄄ(Z:1167)
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.db.N.ᅣチ(Z:3005)
at com.onseven.dbvis.db.N.ᅣニ(Z:2382)
at com.onseven.dbvis.db.I.L.ᅣチ(Z:3400)
at com.onseven.dbvis.db.I.L.ᅣチ(Z:1139)
at com.onseven.dbvis.db.I.L.ᅣテ(Z:1492)
at com.onseven.dbvis.db.I.H.ᅣᄡ(Z:1849)
at com.onseven.dbvis.db.I.K.ᅣᄡ(Z:3063)
at com.onseven.dbvis.db.I.D.ᅣᄄ(Z:1756)
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 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:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
2018-03-30 10:28:27.319 INFO 352 [ExecutorRunner-pool-2-thread-1 - A.<init>] Error extracting column: 2 from ResultSetMetaData
java.lang.NullPointerException
at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:185)
at org.postgresql.jdbc.TypeInfoCache.getSQLType(TypeInfoCache.java:181)
at org.postgresql.jdbc.PgResultSetMetaData.getSQLType(PgResultSetMetaData.java:499)
at org.postgresql.jdbc.PgResultSetMetaData.getColumnType(PgResultSetMetaData.java:387)
at com.onseven.dbvis.sql.A.<init>(Z:1489)
at com.onseven.dbvis.K.C.S.ᅣチ(Z:1215)
at com.onseven.dbvis.K.C.W.ᅣチ(Z:1510)
at com.onseven.dbvis.K.C.W.ᅣツ(Z:1331)
at com.onseven.dbvis.K.C.M.ᅣル(Z:925)
at com.onseven.dbvis.K.C.M.ᅣᄄ(Z:1167)
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 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:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Can you explain what getSchemaNames is used for and what columns it needs?
Thanks
1 Comment
Roger Bjärevall
said
almost 5 years ago
Hi Nathan,
To better understand what is going on please enableDebug DbVisualizerinTools->Debug Window and theDebugtab and then connect to the database. Then useHelp->Contact Supportin DbVisualizer to send the log file to us.
Nathan Aaron
Hi,
I am developing a profile for CockroachDB. I have a cockroachdb.xml profile that is extending the generic profile. A have a database profile path configured in preferences. DbVis sees the profile.
The issue I am having is that I am receiving the following error:
I have added a command in the cockroachdb.xml file to override the command in the generic profile:
The original error is gone, but now in the Debug Window I get the following error:
Can you explain what getSchemaNames is used for and what columns it needs?
Thanks