Start a new topic

Error From Custom Database Profile

 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:

 

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:



    <Command id="cockroachdb.getSchemaNames">
      <SQL>
                <![CDATA[
show databases;
         ]]>
      </SQL>
      <Filter index="Database" label="Name"/>
    </Command>

 

 

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

Hi Nathan,


To better understand what is going on please enable Debug DbVisualizer in Tools->Debug Window and the Debug tab and then connect to the database. Then use Help->Contact Support in DbVisualizer to send the log file to us. 


Regards


Roger

Login or Signup to post a comment