1 2 Previous Next 16 Replies Latest reply on Sep 14, 2004 3:32 PM by Floor FLUX

    No database manager available

    oldzitterhand Newbie

      Hi everybody,

      I am getting sick of randomly testing different combinations of commenting out and commenting in this hsql-ds.xml file.

      I have the problem, that I can't start the Database Manager. If I press the "invoke" button in the jmx-console for "startDatabaseManager()" the website returns only the sentence "Operation completed successfully without a return value." but the java-app is not started and I will receive the following message in the log-file:

      2004-08-06 17:06:21,645 ERROR [org.jboss.jdbc.HypersonicDatabase] Failed to start database manager
      java.lang.reflect.InvocationTargetException:
      java.lang.NoClassDefFoundError
       at org.hsqldb.util.CommonSwing.setDefaultColor(Unknown Source)
       at org.hsqldb.util.DatabaseManagerSwing.main(Unknown Source)
       at org.hsqldb.util.DatabaseManagerSwing.main(Unknown Source)
       at java.lang.reflect.Method.invoke(Native Method)
       at org.jboss.jdbc.HypersonicDatabase$1.run(HypersonicDatabase.java:562)
      


      Everything went fine until page 23 in the manual. I even have data in my database (at least if I can trust the "ant -f jboss-build.xml db-list" command). And the strange thing is that after several combinations of commenting in and out the application seems to work. But whenever I try to log-off I receive this error:

      2004-08-06 17:11:24,157 ERROR [org.jboss.web.localhost.Engine] ApplicationDispatcher[/bank] Servlet.service() for servlet jsp threw exception
      java.lang.IllegalStateException: Cannot create a session after the response has been committed
       at org.apache.coyote.tomcat5.CoyoteRequest.doGetSession(CoyoteRequest.java:2270)
       at org.apache.coyote.tomcat5.CoyoteRequest.getSession(CoyoteRequest.java:2116)
       at org.apache.coyote.tomcat5.CoyoteRequestFacade.getSession(CoyoteRequestFacade.java:526)
       at javax.servlet.http.HttpServletRequestWrapper.getSession(HttpServletRequestWrapper.java:215)
       at org.apache.catalina.core.ApplicationHttpRequest.getSession(ApplicationHttpRequest.java:518)
       at javax.servlet.http.HttpServletRequestWrapper.getSession(HttpServletRequestWrapper.java:215)
       at org.apache.catalina.core.ApplicationHttpRequest.getSession(ApplicationHttpRequest.java:518)
       at org.apache.jsp.logoff_jsp._jspService(logoff_jsp.java:49)
       at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
       at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
       at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
       at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703)
       at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:589)
       at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
       at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)
       at org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:581)
       at com.sun.ebank.web.taglib.InsertTag.doEndTag(Unknown Source)
       at org.apache.jsp.template_jsp._jspx_meth_tt_insert_3(template_jsp.java:1313)
       at org.apache.jsp.template_jsp._jspService(template_jsp.java:581)
       at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
       at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
       at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
       at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:703)
       at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
       at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
       at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
       at com.sun.ebank.web.Dispatcher.doGet(Unknown Source)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
       at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      ...
      



      Has some one a solution for me or can please someone post his/her hsql-ds.xml file??


      my hsql-ds.xml:

      <?xml version="1.0" encoding="UTF-8"?>
      
      <!-- The Hypersonic embedded database JCA connection factory config
      $Id: hsqldb-ds.xml,v 1.1.2.13 2004/04/19 12:47:36 ejort Exp $ -->
      
      
      <datasources>
       <local-tx-datasource>
      
       <!-- The jndi name of the DataSource, it is prefixed with java:/ -->
       <!-- Datasources are not available outside the virtual machine -->
       <jndi-name>DefaultDS</jndi-name>
      
       <!-- for tcp connection, allowing other processes to use the hsqldb
       database. This requires the org.jboss.jdbc.HypersonicDatabase mbean. -->
       <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>
      
       <!-- for totally in-memory db, not saved when jboss stops.
       The org.jboss.jdbc.HypersonicDatabase mbean necessary
       <connection-url>jdbc:hsqldb:.</connection-url>
      -->
       <!-- for in-process persistent db, saved when jboss stops. The
       org.jboss.jdbc.HypersonicDatabase mbean is necessary for properly db shutdown
      
       <connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}localDB</connection-url>
      -->
       <!-- The driver class -->
       <driver-class>org.hsqldb.jdbcDriver</driver-class>
      
       <!-- The login and password -->
       <user-name>sa</user-name>
       <password></password>
      
       <!--example of how to specify class that determines if exception means connection should be destroyed-->
       <!--exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyExceptionSorter</exception-sorter-class-name-->
      
       <!-- this will be run before a managed connection is removed from the pool for use by a client-->
       <!--<check-valid-connection-sql>select * from something</check-valid-connection-sql> -->
      
       <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use -->
       <min-pool-size>5</min-pool-size>
      
       <!-- The maximum connections in a pool/sub-pool -->
       <max-pool-size>20</max-pool-size>
      
       <!-- The time before an unused connection is destroyed -->
       <!-- NOTE: This is the check period. It will be destroyed somewhere between 1x and 2x this timeout after last use -->
       <!-- TEMPORARY FIX! - Disable idle connection removal, HSQLDB has a problem with not reaping threads on closed connections -->
       <idle-timeout-minutes>0</idle-timeout-minutes>
      
       <!-- sql to call when connection is created
       <new-connection-sql>some arbitrary sql</new-connection-sql>
       -->
      
       <!-- sql to call on an existing pooled connection when it is obtained from pool
       <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
       -->
      
       <!-- example of how to specify a class that determines a connection is valid before it is handed out from the pool
       <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.DummyValidConnectionChecker</valid-connection-checker-class-name>
       -->
      
       <!-- Whether to check all statements are closed when the connection is returned to the pool,
       this is a debugging feature that should be turned off in production -->
       <track-statements/>
      
       <!-- Use the getConnection(user, pw) for logins
       <application-managed-security/>
       -->
      
       <!-- Use the security domain defined in conf/login-config.xml -->
       <security-domain>HsqlDbRealm</security-domain>
      
       <!-- Use the security domain defined in conf/login-config.xml or the
       getConnection(user, pw) for logins. The security domain takes precedence.
       <security-domain-and-application>HsqlDbRealm</security-domain-and-application>
       -->
      
       <!-- This mbean can be used when using in process persistent hypersonic -->
       <!--<depends>jboss:service=Hypersonic,database=localDB</depends>-->
       <depends>jboss:service=Hypersonic</depends>
       </local-tx-datasource>
      
       <!-- This mbean should be used only when using tcp connections. Uncomment when the tcp based connection-url is used. -->
       <mbean code="org.jboss.jdbc.HypersonicDatabase" name="jboss:service=Hypersonic">
       <attribute name="Port">1701</attribute>
       <attribute name="Silent">true</attribute>
       <attribute name="Database">default</attribute>
       <attribute name="Trace">false</attribute>
       <attribute name="No_system_exit">true</attribute>
       </mbean>
      
      
       <!-- This mbean can be used when using in process persistent db
       <mbean code="org.jboss.jdbc.HypersonicDatabase" name="jboss:service=Hypersonic,database=localDB">
       <attribute name="Database">localDB</attribute>
       <attribute name="InProcessMode">true</attribute>
       </mbean>
      -->
      


      Cheers

      oldzitterhand

        • 1. Re: No database manager available
          Keith Beattie Newbie

          In the hopes that this will nudge someone in the know to post a suggestion or solution to this problem: I too am experiencing this same 'Failed to start database manager' issue.

          TIA...

          • 3. Re: No database manager available
            Keith Beattie Newbie

             

            "darranl" wrote:
            JBoss version?

            [Server] Release ID: JBoss [WonderLand] 3.2.5 (build: CVSTag=JBoss_3_2_5 date=200408041031)
            and in case this helps...
            [ServerInfo] Java version: 1.4.2-p6,Sun Microsystems Inc.
            [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.4.2-p6-root_12_mar_2004_14_24,Sun Microsystems Inc.
            [ServerInfo] OS-System: FreeBSD 4.10-RELEASE-p2,i386


            • 4. Re: No database manager available
              Keith Beattie Newbie

               

              "ksbeattie" wrote:
              In the hopes that this will nudge someone in the know to post a suggestion or solution to this problem: I too am experiencing this same 'Failed to start database manager' issue.

              TIA...

              I'll add that the the rest of the app works, it is just the HSQL Database Manger Tool that isn't working.

              • 5. Re: No database manager available
                ragnhild Newbie

                I have the same problem, have you forund a solution?

                • 6. Re: No database manager available
                  Darran Lofthouse Master

                  Please describe your problem fully, and also describe how you have installed JBoss, where have you installed it, what is JAVA_HOME set to.

                  I have just started JBoss 3.2.5 on Windows and the Database Manager starts without any problems so it must relate to something different in our setups.

                  Ragnhild, don't waste peoples time by posting 'Me Too' posts.

                  • 7. Re: No database manager available
                    ragnhild Newbie

                     

                    "darranl" wrote:

                    Ragnhild, don't waste peoples time by posting 'Me Too' posts.


                    Unfortunately, people that ask for help often forget to post the solution to the problem if they find it themselves. That way most of the postings in this kind of forums are questions without answers.

                    No need to be rude.

                    • 8. Re: No database manager available
                      Darran Lofthouse Master

                      You only waited 11 hours after the last post before sending your Me To.

                      Anyway as before, please decribe your problem fully, as far as I am concerned JBoss 3.2.5 works out of the box with no additional configuration required for Hypersonic.

                      • 9. Re: No database manager available
                        fhefter Newbie

                        Hi all,

                        I installed JBoss 3.2.4 under WinXP at d:\jboss-3.2.4 .
                        Under Suse 9.1 a JBoss 3.2.5 in /srv/jboss/ .
                        And an other one under Win2000 also on the d:\jboss-3.2.4 .
                        All had JDK 1.4.2_05.

                        All three had no probs getting the hypersonic dbman on the local
                        side to run! But remotely not one worked with the modifications described in the manuals. See hsqldb-ds.xml and stacktrace below.

                        Any help is welcome,
                        thanks,
                        Frank

                        Here is my hsqldb-ds.xml
                        -----------------------------

                        <local-tx-datasource>
                        <jndi-name>DefaultDS</jndi-name>
                        <connection-url>jdbc:hsqldb:hsql://192.168.1.100:1701</connection-url>
                        <!-- connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}localDB</connection-url -->
                        <driver-class>org.hsqldb.jdbcDriver</driver-class>
                        <user-name>sa</user-name>

                        <min-pool-size>5</min-pool-size>
                        <max-pool-size>20</max-pool-size>
                        <idle-timeout-minutes>0</idle-timeout-minutes>
                        <track-statements/>
                        <security-domain>HsqlDbRealm</security-domain>
                        jboss:service=Hypersonic,database=localDB
                        </local-tx-datasource>

                        1701
                        true
                        default
                        false
                        true


                        localDB
                        true


                        -------------------

                        stacktrace:
                        ------------------
                        errorfree startup ....

                        17:09:23,925 INFO [JkMain] Jk running ID=0 time=0/177 config=null
                        17:13:06,672 ERROR [HypersonicDatabase] Failed to start database manager
                        java.lang.reflect.InvocationTargetException
                        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.jdbc.HypersonicDatabase$1.run(HypersonicDatabase.java:562)
                        Caused by: java.lang.NoClassDefFoundError
                        at java.lang.Class.forName0(Native Method)
                        at java.lang.Class.forName(Class.java:141)
                        at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:62)
                        at sun.awt.motif.MToolkit.(MToolkit.java:81)
                        at java.lang.Class.forName0(Native Method)
                        at java.lang.Class.forName(Class.java:141)
                        at java.awt.Toolkit$2.run(Toolkit.java:748)
                        at java.security.AccessController.doPrivileged(Native Method)
                        at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:739)
                        at java.awt.SystemColor.updateSystemColors(SystemColor.java:417)
                        at java.awt.SystemColor.(SystemColor.java:409)
                        at org.hsqldb.util.CommonSwing.setDefaultColor(Unknown Source)
                        at org.hsqldb.util.DatabaseManagerSwing.main(Unknown Source)
                        at org.hsqldb.util.DatabaseManagerSwing.main(Unknown Source)
                        ... 5 more




                        • 10. Re: No database manager available
                          fhefter Newbie

                          Once again: (Admin: Please delete tho one above :-) )

                          Hi all,

                          I installed JBoss 3.2.4 under WinXP at d:\jboss-3.2.4 .
                          Under Suse 9.1 a JBoss 3.2.5 in /srv/jboss/ .
                          And an other one under Win2000 also on the d:\jboss-3.2.4 .
                          All had JDK 1.4.2_05.

                          All three had no probs getting the hypersonic dbman on the local
                          side to run! But remotely not one worked with the modifications described in the manuals. See hsqldb-ds.xml and stacktrace below.

                          Any help is welcome,
                          thanks,
                          Frank

                          Here is my hsqldb-ds.xml
                          -----------------------------

                          <datasources>
                           <local-tx-datasource>
                           <jndi-name>DefaultDS</jndi-name>
                           <connection-url>jdbc:hsqldb:hsql://192.168.1.100:1701</connection-url>
                           <!-- connection-url>jdbc:hsqldb:${jboss.server.data.dir}${/}hypersonic${/}localDB</connection-url -->
                           <driver-class>org.hsqldb.jdbcDriver</driver-class>
                           <user-name>sa</user-name>
                           <password></password>
                           <min-pool-size>5</min-pool-size>
                           <max-pool-size>20</max-pool-size>
                           <idle-timeout-minutes>0</idle-timeout-minutes>
                           <track-statements/>
                           <security-domain>HsqlDbRealm</security-domain>
                           <depends>jboss:service=Hypersonic,database=localDB</depends>
                           </local-tx-datasource>
                           <mbean code="org.jboss.jdbc.HypersonicDatabase"
                           name="jboss:service=Hypersonic">
                           <attribute name="Port">1701</attribute>
                           <attribute name="Silent">true</attribute>
                           <attribute name="Database">default</attribute>
                           <attribute name="Trace">false</attribute>
                           <attribute name="No_system_exit">true</attribute>
                           </mbean>
                           <mbean code="org.jboss.jdbc.HypersonicDatabase"
                           name="jboss:service=Hypersonic,database=localDB">
                           <attribute name="Database">localDB</attribute>
                           <attribute name="InProcessMode">true</attribute>
                           </mbean>
                          </datasources>
                          




                          -------------------

                          stacktrace:
                          ------------------
                          errorfree startup ....
                          
                          17:09:23,925 INFO [JkMain] Jk running ID=0 time=0/177 config=null
                          17:13:06,672 ERROR [HypersonicDatabase] Failed to start database manager
                          java.lang.reflect.InvocationTargetException
                          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.jdbc.HypersonicDatabase$1.run(HypersonicDatabase.java:562)
                          Caused by: java.lang.NoClassDefFoundError
                          at java.lang.Class.forName0(Native Method)
                          at java.lang.Class.forName(Class.java:141)
                          at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:62)
                          at sun.awt.motif.MToolkit.(MToolkit.java:81)
                          at java.lang.Class.forName0(Native Method)
                          at java.lang.Class.forName(Class.java:141)
                          at java.awt.Toolkit$2.run(Toolkit.java:748)
                          at java.security.AccessController.doPrivileged(Native Method)
                          at java.awt.Toolkit.getDefaultToolkit(Toolkit.java:739)
                          at java.awt.SystemColor.updateSystemColors(SystemColor.java:417)
                          at java.awt.SystemColor.(SystemColor.java:409)
                          at org.hsqldb.util.CommonSwing.setDefaultColor(Unknown Source)
                          at org.hsqldb.util.DatabaseManagerSwing.main(Unknown Source)
                          at org.hsqldb.util.DatabaseManagerSwing.main(Unknown Source)
                          ... 5 more
                          



                          • 11. Re: No database manager available
                            Matthew Robinson Newbie

                            Hello.

                            I resolved this problem with JBoss 4.x:

                            The reason for this problem is the JAVA Runtime Environment (JRE) installed on the Windows system was installed in the default location, which is:

                            C:\Program Files\java\j2se1.4.2_04

                            This path contains a space. The default implementation of Hypersonic doesn't like this space, and fails to start the JVM to load the class.

                            Probably the best way to resolve this is to uninstall the JRE, and reinstall it under a path that has no spaces in it.

                            The way I did it was to change the startup configuration(s) to use my installed JDK rather than the JRE. This is because I prefer dependent software (in this case JBoss and the Hypersonic Data Manager) share instances of the JVM.

                            I also had to modify the JBoss run.conf file to specify the JVM details:
                            -- FILE SECTION BEGINS --
                            #
                            # Specify the location of the Java home directory. If set then $JAVA will
                            # be defined to $JAVA_HOME/bin/java, else $JAVA will be "java".
                            #
                            JAVA_HOME="C:\j2sdk1.4.2_04"

                            #
                            # Specify the exact Java VM executable to use.
                            #
                            JAVA="C:\j2sdk1.4.2_04\bin\java.exe"
                            -- FILE SECTION ENDS --

                            The JBoss service now invokes the correct version of the JVM on a directory path that contains no spaces.

                            Give this a go..

                            • 12. Re: No database manager available
                              seshan Newbie

                              Thanks very much, I stumbled into your notes here and this certainly helped me to get the standalone client application to work (I was struggling with this for hours)

                              The JMX console web application (http://localhost:8080/jmx-console/) is still not working for me. It is giving me the following error:

                              org.apache.jasper.JasperException: Unable to compile class for JSP

                              Generated servlet error:
                              C:\jboss-3.2.5\server\default\work\jboss.web\localhost\jmx-console\org\apache\jsp\index_jsp.java:53: handlePageException(java.lang.Exception) in javax.servlet.jsp.PageContext cannot be applied to (java.lang.Throwable)
                              if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
                              ^
                              1 error



                              org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
                              org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
                              org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
                              org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
                              org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
                              org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
                              org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
                              org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
                              org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
                              org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
                              javax.servlet.http.HttpServlet.service(HttpServlet.java:810)

                              Any suggestion will be appreciated.

                              • 13. Re: No database manager available
                                seshan Newbie

                                The JMX console web application (http://localhost:8080/jmx-console/) problem has been resolved for me. I installed the j2sdk version 1.4.2_05 under c:\ drive and reset the JAVA_HOME to point to the new location.

                                Thanks for the pointers I got from you

                                • 14. Re: No database manager available
                                  Floor FLUX Newbie

                                  I installed JBoss 3.2.5 in c:\jboss-3.2.5 on Windows XP SP1. %JAVA_HOME% is set to c:\j2sdk1.4.2_04. When I first installed it, running the default server worked like a charm. Upon setting up Hypersonic for TCP/IP as described in Getting Started with JBoss by Luke Taylor and The JBoss Group, Hypersonic no longer started. I have followed the instructions closely, but always get soemthing similar to this when starting JBoss:

                                  ObjectName: jboss:service=Hypersonic,database=localDB
                                  state: NOTYETINSTALLED
                                  I Depend On:
                                  Depends On Me: jboss.jca:service=ManagedConnectionFactory,name=DefaultDS

                                  One forum entry suggested removing ",database=localDB" from jboss:service=Hypsersonic,database=localDB, but this does not work for me. It only changes the message to:

                                  ObjectName: jboss:service=Hypersonic
                                  state: NOTYETINSTALLED
                                  I Depend On:
                                  Depends On Me: jboss.jca:service=ManagedConnectionFactory,name=DefaultDS

                                  Any ideas?

                                  1 2 Previous Next