September 04, 2010, 02:39:59 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  Home Help Media Affiliates Login Register  
Pages: [1]   Go Down
  Print  
Author Topic: Hypersonic java.sql.SQLException: User not found: SA  (Read 1915 times)
0 Members and 1 Guest are viewing this topic.
Arkie
Javaforums.net Admin
Senior Member
*

Reputation: 16
Developer @ Javaforums.net
Offline Offline
Posts: 2620
Referrals: 13

WWW Awards
« on: February 04, 2009, 09:34:43 AM »

If you are running JBoss and encounter this error:

ERROR [org.jboss.jdbc.HypersonicDatabase] Starting failed
jboss:database=localDB,service=Hypersonic
java.sql.SQLException: User not found: SA
        at org.hsqldb.Trace.getError(Unknown Source)
        at org.hsqldb.Trace.error(Unknown Source)
        at org.hsqldb.UserManager.get(Unknown Source)
        at org.hsqldb.UserManager.getUser(Unknown Source)
        at org.hsqldb.Database.connect(Unknown Source)
        at org.hsqldb.jdbcConnection.openStandalone(Unknown Source)
        at org.hsqldb.jdbcConnection.(Unknown Source)
        at org.hsqldb.jdbcDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at org.jboss.jdbc.HypersonicDatabase.getConnection(HypersonicDatabase.java:812)
        at
org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:623)
        at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:593)
       
etc..

try to remove the directories "tmp" , "work" , "data" in: X:\jboss-4.2.3.GA\server\default and run JBoss again, this will enable you to rebuild the database and JBoss should run without the " User not found: SA" error. I suspect that this happens when you are closing the JBoss application server while it's still trying to read/write data to the Hypersonic database. Solved my problems.
« Last Edit: February 04, 2009, 02:37:59 PM by HappyFace » Logged

Java and .NET developer

To students: It doesn't matter how hard you've studied; the material won't be on the exam anyway.

Fan of http://www.retardedweblogger.com
Oh man, too much stuff to do in so little time.

http://img222.imageshack....707/arkietomatoesmall.jpg
Blizzcon 2k9 Grubby and Cassandra Ng engaged ! <3
Triple D, eerste Denken Dan Doen
Javaforums.net :: a community about Java software development.
« on: February 04, 2009, 09:34:43 AM »

Your Ad Here
 Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.10 | SMF © 2006-2009, Simple Machines LLC
TinyPortal v0.9.8 © Bloc
Valid XHTML 1.0! Valid CSS!
Page created in 0.149 seconds with 32 queries.

Google visited last this page Yesterday at 08:05:16 AM