on 1-05-22 01.42, The Allisons at [EMAIL PROTECTED] wrote:
> Is there a special user/password combo I should be using? I'm using
> 'sa' and 'foo' for them, respectively.
Yes ... I can highly recommend anybody that uses HypersonicSQL to download
the source distr. at : http://sourceforge.net/projects/hsqldb/
I myself would not leave home without it ... ;-) plenty *cool stuff* there
as a DatabaseManager GUI - a data TransferTool - Doc's describing benchmarks
... Relating to Your question - the Doc's sez :
"
There is a build-in security system using users, passwords and access
rights. There exists by default a 'System Administrator' with the user name
'sa' and the password '' (empty password). This special user can create new
users, drop users and grant and revoke access rights for tables to other
users. The general users can only change their own password and connect as
another user. All this user administration can be done by SQL scripts
(GRANT, REVOKE). Access can be granted also to PUBLIC.
"
please note JBoss 2.2.1 uses the 1.4 version of HypersonicSQL. there are now
also a 1.6 version hsqldb, and it uses another driverManager tag :
HSQL/HypersonicSQL = 1.4
hsqldb = 1.6
String dbStrVersion_1_4 = "jdbc:HypersonicSQL:hsql://localhost:"+port;
String dbStrVersion_1_6 = "jdbc:hsqldb:hsql://localhost:"+port;
so if U want to switch to the 1.6 version - U also need to recompile
org.jboss.jdbc.HypersonicDatabase.java and switch to :
DriverManager.getConnection(dbStrVersion_1_6, user, password);
Loads of Hype and Sonic fun 2 U all
/peter
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
