5 Replies Latest reply on Apr 13, 2007 5:19 PM by genman

    Starting failed java.sql.SQLException: User not found: SA

    murphyric

      Hello All,

      I got the below error when starting "Jboss-4.0.0DR4" today.

      Kindly , suggest me if I have to go through any setting files and do any settings.

      ------------------------------------------------------------------------------------
      2004-05-28 14:27:53,590 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)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:844)
      at $Proxy29.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:369)
      at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:260)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:272)
      at $Proxy27.start(Unknown Source)
      at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:225)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:863)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:674)
      at org.jboss.deployment.MainDeployer.addDeployer(MainDeployer.java:267)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
      at $Proxy26.addDeployer(Unknown Source)
      at org.jboss.deployment.SubDeployerSupport.startService(SubDeployerSupport.java:108)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:844)
      at $Proxy17.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:369)
      at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:260)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:863)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:674)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:637)
      at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
      at $Proxy7.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:304)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:478)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:201)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:274)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
      at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:844)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:369)
      at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:260)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:863)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:674)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:637)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:621)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:232)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:643)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:174)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:386)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:291)
      at org.jboss.Main.boot(Main.java:150)
      at org.jboss.Main$1.run(Main.java:395)
      at java.lang.Thread.run(Thread.java:536)
      -------------------------------------------------------------------------------------

      Thanx in Advance


        • 1. Re: Starting failed java.sql.SQLException: User not found: S

          "sa" is the default sysadmin for hsqldb so what have you changed?

          • 2. Re: Starting failed java.sql.SQLException: User not found: S
            murphyric

            I didn't change any settings...Just Insatalled Jboss 4.0 and all my classpath was set to this installation.when I started the server...I got this error.
            Do u think I have to delete the prior Installation of Jboss 3.x on my system which was running successfully?

            Thanx n Rgds

            • 3. Re: Starting failed java.sql.SQLException: User not found: S
              jalite

              ???????

              • 4. Re: Starting failed java.sql.SQLException: User not found: S
                junedkhan

                Iam getting an error on ubuntu while starting Jboss server
                My system details
                hostname:SERVER
                hostname --fqd : localhost

                Iam using the following command to start jboss server on ubuntu
                sudo ./run.sh on directory root@SERVER:/usr/local/jboss-4.0.5.GA/bin#


                When iam typing http://localhost:8080/, iam able to view jboss page.
                The error list is as below.Is my jboss server started successfully?If yes then why iam getting "FAILED" for few in the list below??






                root@SERVER:/usr/local/jboss-4.0.5.GA/bin# sudo ./run.jar
                ./run.jar: 2: Syntax error: word unexpected (expecting ")")
                root@SERVER:/usr/local/jboss-4.0.5.GA/bin# sudo ./run.sh
                run.sh: Missing file: /lib/tools.jar
                run.sh: Unexpected results may occur. Make sure JAVA_HOME points to a JDK and not a JRE.
                =========================================================================

                JBoss Bootstrap Environment

                JBOSS_HOME: /usr/local/jboss-4.0.5.GA

                JAVA: java

                JAVA_OPTS: -Dprogram.name=run.sh -server -Xms128m -Xmx512m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000

                CLASSPATH: /usr/local/jboss-4.0.5.GA/bin/run.jar:/lib/tools.jar

                =========================================================================

                12:07:29,171 INFO [Server] Starting JBoss (MX MicroKernel)...
                12:07:29,185 INFO [Server] Release ID: JBoss [Zion] 4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)
                12:07:29,187 INFO [Server] Home Dir: /usr/local/jboss-4.0.5.GA
                12:07:29,187 INFO [Server] Home URL: file:/usr/local/jboss-4.0.5.GA/
                12:07:29,189 INFO [Server] Patch URL: null
                12:07:29,189 INFO [Server] Server Name: default
                12:07:29,189 INFO [Server] Server Home Dir: /usr/local/jboss-4.0.5.GA/server/default
                12:07:29,189 INFO [Server] Server Home URL: file:/usr/local/jboss-4.0.5.GA/server/default/
                12:07:29,190 INFO [Server] Server Log Dir: /usr/local/jboss-4.0.5.GA/server/default/log
                12:07:29,190 INFO [Server] Server Temp Dir: /usr/local/jboss-4.0.5.GA/server/default/tmp
                12:07:29,191 INFO [Server] Root Deployment Filename: jboss-service.xml
                12:07:29,864 INFO [ServerInfo] Java version: 1.4.2-02,Blackdown Java-Linux Team
                12:07:29,864 INFO [ServerInfo] Java VM: Java HotSpot(TM) Server VM Blackdown-1.4.2-02,Blackdown Java-Linux Team
                12:07:29,865 INFO [ServerInfo] OS-System: Linux 2.6.17-11-server,i386
                12:07:30,514 INFO [Server] Core system initialized
                12:07:34,493 INFO [WebService] Using RMI server codebase: http://SERVER:8083/
                12:07:34,511 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
                12:07:39,351 INFO [ServiceEndpointManager] WebServices: jbossws-1.0.3.SP1 (date=200609291417)
                12:07:40,303 INFO [SnmpAgentService] SNMP agent going active
                12:07:40,888 INFO [InterceptorChainFactory] interceptor chain is:
                class org.jboss.cache.interceptors.CallInterceptor
                class org.jboss.cache.interceptors.PessimisticLockInterceptor
                class org.jboss.cache.interceptors.UnlockInterceptor
                class org.jboss.cache.interceptors.ReplicationInterceptor
                class org.jboss.cache.interceptors.TxInterceptor
                class org.jboss.cache.interceptors.CacheMgmtInterceptor
                12:07:41,242 INFO [STDOUT]
                -------------------------------------------------------
                GMS: address is localhost:32786
                -------------------------------------------------------
                12:07:43,285 INFO [TreeCache] viewAccepted(): [localhost:32786|0] [localhost:32786]
                12:07:43,306 INFO [TreeCache] TreeCache local address is localhost:32786
                12:07:43,308 INFO [TreeCache] State could not be retrieved (we are the first member in group)
                12:07:43,308 INFO [TreeCache] parseConfig(): PojoCacheConfig is empty
                12:07:43,829 INFO [DefaultPartition] Initializing
                12:07:43,895 INFO [STDOUT]
                -------------------------------------------------------
                GMS: address is localhost:32788 (additional data: 14 bytes)
                -------------------------------------------------------
                12:07:45,910 INFO [DefaultPartition] Number of cluster members: 1
                12:07:45,910 INFO [DefaultPartition] Other members: 0
                12:07:45,910 INFO [DefaultPartition] Fetching state (will wait for 30000 milliseconds):
                12:07:45,910 INFO [DefaultPartition] New cluster view for partition DefaultPartition (id: 0, delta: 0) : [127.0.0.1:1099]
                12:07:45,910 INFO [DefaultPartition] State could not be retrieved (we are the first member in group)
                12:07:45,930 INFO [DefaultPartition] I am (127.0.0.1:1099) received membershipChanged event:
                12:07:45,930 INFO [DefaultPartition] Dead members: 0 ([])
                12:07:45,930 INFO [DefaultPartition] New Members : 0 ([])
                12:07:45,931 INFO [DefaultPartition] All Members : 1 ([127.0.0.1:1099])
                12:07:45,966 INFO [HANamingService] Started ha-jndi bootstrap jnpPort=1100, backlog=50, bindAddress=/0.0.0.0
                12:07:45,978 INFO [DetachedHANamingService$AutomaticDiscovery] Listening on 0.0.0.0/0.0.0.0:1102, group=230.0.0.4, HA-JNDI address=127.0.0.1:1100
                12:07:47,025 INFO [CorbaNamingService] Naming: [IOR:000000000000002B49444C3A6F6D672E6F72672F436F734E616D696E672F4E616D696E67436F6E746578744578743A312E3000000000000200000000000000E0000102000000000A3132372E302E302E31000DC8000000114A426F73732F4E616D696E672F726F6F74000000000000050000000000000008000000004A414300000000010000001C00000000000100010000000105010001000101090000000105010001000000210000005C000000000000000100000000000000240000001C0000007E00000000000000010000000A3132372E302E302E31000DC900400000000000000000001004010008060667810201010100000000000000000000000000000000000000000000002000000004000000000000001F0000000400000003000000010000002000000000000000020000002000000004000000000000001F0000000400000003]
                12:07:47,156 INFO [CorbaTransactionService] TransactionFactory: [IOR:000000000000003049444C3A6F72672F6A626F73732F746D2F69696F702F5472616E73616374696F6E466163746F72794578743A312E30000000000200000000000000E0000102000000000A3132372E302E302E31000DC8000000144A426F73732F5472616E73616374696F6E732F46000000050000000000000008000000004A414300000000010000001C00000000000100010000000105010001000101090000000105010001000000210000005C000000000000000100000000000000240000001C0000007E00000000000000010000000A3132372E302E302E31000DC900400000000000000000001004010008060667810201010100000000000000000000000000000000000000000000002000000004000000000000001F0000000400000003000000010000002000000000000000020000002000000004000000000000001F0000000400000003]
                12:07:48,014 INFO [Embedded] Catalina naming disabled
                12:07:48,078 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the classpath. Will load the default rule set.
                12:07:48,079 INFO [ClusterRuleSetFactory] Unable to find a cluster rule set in the classpath. Will load the default rule set.
                12:07:48,487 INFO [Http11BaseProtocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
                12:07:48,489 INFO [Catalina] Initialization processed in 409 ms
                12:07:48,489 INFO [StandardService] Starting service jboss.web
                12:07:48,492 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5.20
                12:07:48,540 INFO [StandardHost] XML validation disabled
                12:07:48,589 INFO [Catalina] Server startup in 100 ms
                12:07:48,784 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/
                12:07:49,129 INFO [WebappLoader] Dual registration of jndi stream handler: factory already defined
                12:07:49,712 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
                12:07:49,948 INFO [TomcatDeployer] deploy, ctxPath=/jbossws, warUrl=.../tmp/deploy/tmp28230jbossws-context-exp.war/
                12:07:50,132 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
                12:07:51,519 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
                12:07:52,596 INFO [MailService] Mail Service bound to java:/Mail
                12:07:52,839 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-local-jdbc.rar
                12:07:52,883 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-ha-xa-jdbc.rar
                12:07:52,903 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
                12:07:52,940 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
                12:07:52,996 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar
                12:07:53,034 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/mail-ra.rar
                12:07:53,978 WARN [ServiceController] Problem starting service jboss:database=localDB,service=Hypersonic
                java.sql.SQLException: User not found: SA
                at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
                at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
                at org.hsqldb.jdbcDriver.getConnection(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:761)
                at org.jboss.jdbc.HypersonicDatabase.startStandaloneDatabase(HypersonicDatabase.java:611)
                at org.jboss.jdbc.HypersonicDatabase.startService(HypersonicDatabase.java:557)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
                at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
                at $Proxy0.start(Unknown Source)
                at org.jboss.system.ServiceController.start(ServiceController.java:417)
                at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy4.start(Unknown Source)
                at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy42.start(Unknown Source)
                at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
                at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy8.deploy(Unknown Source)
                at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
                at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
                at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
                at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
                at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
                at $Proxy0.start(Unknown Source)
                at org.jboss.system.ServiceController.start(ServiceController.java:417)
                at sun.reflect.GeneratedMethodAccessor10.invoke(Unknown Source)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy4.start(Unknown Source)
                at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
                at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:324)
                at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                at $Proxy5.deploy(Unknown Source)
                at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
                at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
                at org.jboss.Main.boot(Main.java:200)
                at org.jboss.Main$1.run(Main.java:490)
                at java.lang.Thread.run(Thread.java:534)
                12:07:54,335 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:name=JmsXA,service=ConnectionFactoryBinding' to JNDI name 'java:JmsXA'
                12:07:54,399 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
                12:07:54,810 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

                --- MBeans waiting for other MBeans ---
                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

                --- MBEANS 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


                12:07:55,113 INFO [Http11BaseProtocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
                12:07:55,250 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
                12:07:55,262 INFO [JkMain] Jk running ID=0 time=0/35 config=null
                12:07:55,271 INFO [Server] JBoss (MX MicroKernel) [4.0.5.GA (build: CVSTag=Branch_4_0 date=200610162339)] Started in 26s:76ms

                • 5. Re: Starting failed java.sql.SQLException: User not found: S
                  genman

                  Reinstall your JBoss server and see what happens. I'm guessing something in $JBOSS_HOME/server/default/work got messed up.