SQLQuery and HSQLDB 1.7.3

Hi!

I'm playing around with SQLQuery plugin.
I seems to have some problems with the HSQLDB.
If the special HSQLDB driver configuration is used in the connection properties, the generated url does not contain the database name and therefore the database cannot be connected.
If the "Other driver" configuration is used, it works. The database is connected and sql commands can be executed successfully.
The one remaining problem is that the "show database structure" command doesn't work properly. It opens the "SQL Shema" toolwiindow and seems to present a view on the database, but it doesn't seem to find any tables.
Is this feature unavailable for generic jdbc or have I configured it somehow uncorrectly?

Any hints are welcome
Robert

1 comment
Comment actions Permalink

Robert F. Beeger wrote:

Hi!

I'm playing around with SQLQuery plugin.
I seems to have some problems with the HSQLDB.
If the special HSQLDB driver configuration is used in the connection properties, the generated url does not contain the database name and therefore the database cannot be connected.
If the "Other driver" configuration is used, it works. The database is connected and sql commands can be executed successfully.


The support for the HSQLDB driver was developed by a third party.
The source code for the plugin will be downloaded with the plugin. Maybe
you can have a look at the code and change it to make it work.

The one remaining problem is that the "show database structure" command doesn't work properly. It opens the "SQL Shema" toolwiindow and seems to present a view on the database, but it doesn't seem to find any tables.
Is this feature unavailable for generic jdbc or have I configured it somehow uncorrectly?


I only use default JDBC methods for getting the database structure. Some
drivers/databases do not correctly support this interface. There are
also differences as what is the default schema name (Oracle: the user
name, SQLServer and Sybase: 'dbo', MySQL: the database name). The schema
name is required to get the list of tables.


Any hints are welcome
Robert

0

Please sign in to leave a comment.