I'm doing a copy/paste of the connection string from the code (where it works) to the Netbeans "Drivers: Connect With" properties window.  So I doubt that's the problem.  I was able to use the "Databases: New Connection" and supply all the values and that seems to be the trick for me.

dga

On 10/14/19 11:20 AM, Emilian Bold wrote:
I think their example is bad.

Here http://hsqldb.org/doc/2.0/guide/running-chapt.html they mention
.getConnection("jdbc:hsqldb:file:testdb", "SA", ""); but if I use in
CoolBeans jdbc:hsqldb:file:testdb it fails because it actually tries
to create the file at /testdb ie. in a place where normal users don't
have permissions.

If I use jdbc:hsqldb:file:~/testdb then it creates a DB in my homefolder.

So the trick is to write the full path.

--emi

On Mon, Oct 14, 2019 at 6:08 PM Don <don.albert...@gmail.com> wrote:
I can use the HSQL Driver from Java Code and I can use connections in
the IDE made with previous releases of Netbeans but I cannot create a
new connection.  Even using an existing connection and changing the file
location, both the Test Connection and the Next Button produce a
red-letter message that the connection failed.

I have connections to a local Oracle server, and a cloud-based
MSSQLServer instance, but trying to connect to a local file-based db
fails. Has anyone else experienced this difficulty?


Don


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@netbeans.apache.org
For additional commands, e-mail: users-h...@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists

Reply via email to