Jboss server startup problem

[moonny]

i'm developing a eclipse rcp project and JBOSS as myAS. but i noticed an error in the server log displayed as below when i try to startup my server.

ERROR [org.jboss.jdbc.HypersonicDatabase] Starting failed jboss:database=localDB,service=Hypersonic
java.sql.SQLException: User not found: SA

while in the command prompt of starting server, a message

" MBenas that are the root cause of the problem
ObjectName:jboss:database=localDB,service=Hypersonic
state:FAILED
Reason: java.sql.SQLException:User not found:SA
Depends On Me:
jboss.jca:name=DefaultDS,service=ManagedConnectionFactory"

will this error affect my project?? how to fix this error??
thanks in advance

[weston.price]

Yes, it will effect your project as the default DataSource cannot be deployed. As a result, anything that depends on this datasource will also not be deployed. For some reason, the default user of Hypersonic was changed to "SA" when it should read "sa". Under your deploy directory you will find a file called:

hsqldb-ds.xml

inside this file you should see an XML entry like the following:

 <user-name>sa</user-name>
 <password></password>

Verify that the <user-name> element value is in lower case no "SA"

[moonny]

i have checked the hsqldb-ds.xml and found out that the user name is "sa". what's the otherwise reason for happen this?? thanks.

[weston.price]

Strange. I don't see how that is being that the output to the console is completely different. How are you starting the server?

[moonny]

i start the server by typing c:\cd jboss-4.0.2/bin/run -b 127.0.0.1 in command prompt. Any suggestion how to solve it? thanks