HSQL 1.7.1/Netbeans JDBC not starting

From: David Nettles (tetsuoni3000_at_yahoo.co.jp)
Date: 01/28/04 

Date: 28 Jan 2004 12:40:48 -0800

I am trying to use HSQL 1.7.1 within Netbeans 3.5.1, but I am getting
mixed sad results.

If I connecting with the url "jdbc:hsqldb:." basically works OK
(SQL-92 support only). But this is just an "in memory" database... it
is never persisted.

If I connect with the url "jdbc:hsqldb:testdb" or
"jdbc:hsqldb:any-local-path" it fails with the following error (I did
specify the "sa" user with "" as password):

--[begin-error]
Unable to ontain schema.
There is insufficient information to establish a connection to obtain
list of schemas. Check database URL, user and password.
Driver message: cannot establish a conneciton to
jdbc:hsqldb:/home/david/tmp/mydbtest.properties
java.security.AccessControlExecption: access denied
(java.io.FileSystem /home/david/tmp/mydbtest.properties write))
--[end-error]

If I use demo/runManager.sh I can open a database using both the
"jdbc:hsqldb:." url as well as the "hdbc:hsqldb:any-local-path" url
without any problems and create tables query and everything else.

It does appear that there is some kind of SecurityManager kind of
issue going on here... if this is the case, how might one get past
this? If one cannot get past this one cannot manipulate the HSQL
connections for local databases within the Netbeans IDE. :(

What do you think folks? 

--
David Nettles
email: tetsuoni3000@yahoo.co.jp
web: http://www.miteyo.org

Relevant Pages

  • [JSP] Connecting to a MySQL database
    ... When I use NetBeans to connect to the ... database all works. ... But I don't know how to do a connection in Java ... Yann Laviolette ...
    (comp.lang.java.databases)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
    (microsoft.public.data.ado)