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