HSQLDB server connection using username and password in server startup command in cmd is not working

Question

i am starting hsqldb server with db_name as MDB and credentials as user=test and password=test using command prompt as:

    java -cp hsqldb.jar org.hsqldb.server.Server --database.0 file:/E:/DB/mdb --dbname.0 mdb user=test 
    password=test

it starts the server without error but when i use same credentials in my java code as

    con = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/mware;file:E:/DB/mdb", "test", 
    "test");

it throws exception as:

 {java.sql.SQLInvalidAuthorizationSpecException: invalid authorization specification - not found: test
    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
    at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
    at org.hsqldb.jdbc.JDBCConnection.<init>(Unknown Source)
    at org.hsqldb.jdbc.JDBCDriver.getConnection(Unknown Source)
    at org.hsqldb.jdbc.JDBCDriver.connect(Unknown Source)}

please help

Answer 1

The correct way to start the server is:

java -cp hsqldb.jar org.hsqldb.server.Server --database.0 file:/E:/DB/mdb;user=test;password=test --dbname.0 mware 

And the connection should be like this:

con = DriverManager.getConnection("jdbc:hsqldb:hsql://localhost/mware, "test", 
"test");

Any initial database settings in addition to user and password is defined the same way. For example --database.0 file:/E:/DB/mdb;user=test;password=test;hsqldb.tx=mvcc. The properties are applied to a new database and can be changed later with SQL statements. See http://hsqldb.org/doc/2.0/guide/dbproperties-chapt.html#dpc_db_operations