1 2 Previous Next 18 Replies Latest reply on May 20, 2007 3:21 PM by kuvera

    Can not start the Hypersonic Manager Tool

    erich0328

      I follow the "Getting Started with Jboss" guide to enable Hypersonic server-client mode (accept tcp/ip connection).
      I could see the "service=Hypersonic" link in the jmx-console and the following commands work fine:
      ant -f jboss-build.xml db-create-table
      ant -f jboss-build.xml db-insert
      ant -f jboss-build.xml db-list

      BUT when I click "Invoke" button of startDatabaseManager MBean Operation, it shows nothing but "Operation completed successfully without a return value." There's no Hypersonic Manager Tool!

      Is there any step I missed?

      Any help is appreciated.

      Regards,
      Eric Hsu

        • 1. Re: Can not start the Hypersonic Manager Tool
          sysuser1

          May be you forgot to change hsqldb-ds.xml, see p. 20 of "Getting Started".

          • 2. Re: Can not start the Hypersonic Manager Tool
            erich0328

            Hi levw1,
            Thanks for the reply.
            I did follow the instructions in p.20 of "Getting Started".
            I use the follows

            <local-tx-datasource>
            <jndi-name>DefaultDS</jndi-name>
            <connection-url>jdbc:hsqldb:hsql://localhost:1701</connection-url>
            ... ...
            jboss:service=Hypersonic
            </local-tx-datasource>

            1701
            true
            default
            false
            true




            in hsqldb-ds.xml.

            I can not see any Hypersonic Manager Tool, after I click the "Invoke" button of startDatabaseManager MBean Operation.
            Or do you know how to start the Tool directly on the command line, such as c:>java hsqlxxx ?

            Thanks a lot.
            Eric Hsu

            • 3. Re: Can not start the Hypersonic Manager Tool
              erich0328

              I find that I run the jboss as a windows service by using JavaService-bin-1.2.0. If I run the jboss by executing run.bat in the command line. I could start the Hypersonic Manager Tool in the JMX-CONSOLE.

              • 4. Re: Can not start the Hypersonic Manager Tool
                ccsdev

                Hi, I'm having this same problem. Did you ever resolve to invoke the hypersonic databse manager while running Jboss as a Windows service?

                Thanks.

                • 5. Re: Can not start the Hypersonic Manager Tool
                  s_kimo_a

                  I got the same problem. I can't start hsql dbmangager remotely. When I click on "invoke" button, the message "Operation completed successfully without a return value." appears, but no dbmanager window pop up. The wierd thing is dbmanager window on the server is pop up, yet not on my client machine. What's wrong with that? Any idea? Thanks for all comments.

                  • 6. Re: Can not start the Hypersonic Manager Tool

                    The HSQL database manager is a local swing application, not an applet. If you want to run it remotely, you will have to run it by hand on a remote machine. I'd recommend doing it like that anyways, because when you exit the application, it tries to do a System.exit(). So, I really don't recommend messing with it anymore.



                    • 7. Re: Can not start the Hypersonic Manager Tool
                      dioni

                      So, I can't start HSQL database manager in the same machine when is JBOss instaled?. Even if I want to use HSQL only for learning a testing?

                      • 8. Re: Can not start the Hypersonic Manager Tool
                        bichka

                        I have the same problem when I try to start HSQL Database Manager tool. Does anyone have a solution for this?

                        THanks,
                        Bryan

                        • 9. Re: Same problem; I can not start the Hypersonic Manager Too
                          franboeing

                          I am having the same problem. I can't see the the link to the hypersonic DB in the JMX console.

                          When I try to create de tables with the ANT utility, I received these java errors:

                          db-create-table:
                          [java] ScriptTool.init error: socket creation error
                          [java] java.sql.SQLException:socket creation error
                          [java] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
                          [java] at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
                          etc.

                          The build however is succesful.

                          Same happens with db-insert, and db-list.
                          The messahges are the same socket error.
                          I have modified the files as it is said in the tutorial, but still..
                          Does somebody knows what this socket error means?

                          Thanks in avance

                          • 10. Re: Socket error when creating the tables
                            franboeing

                            I just found what my problem was:

                            the first two lines at the beginning of the file 'hsql-create-table.sql' that contains the script to populate the db begin with a comment like this:

                            -- create tables for online banking app --
                            -- also seeds next_id tables w. initial values --

                            Try to change the '--' to '//comment' or to '<-- comment -->'

                            It worked for me. Now I can see the link service=Hypersonic

                            Hope you have the same problem!!

                            • 11. Re: Can not start the Hypersonic Manager Tool
                              peterj

                              It sounds like either you have not configured Hypersonic to open a port, or you did not start the app server. The instructions in the Getting Started Guide are correct, if you follow them to the letter.

                              • 12. Re: Can not start the Hypersonic Manager Tool
                                kuvera

                                Is there a way to run it by hand if JBoss runs as a Windows service?

                                • 13. Re: Can not start the Hypersonic Manager Tool
                                  peterj

                                  Run what by hand? Hypersonic? Or the Manager Tool? In either case the answer is yes, but I wonder why you would run the app server as a Windows service yet still use Hypersonic (you should really be using a real database).

                                  • 14. Re: Can not start the Hypersonic Manager Tool
                                    kuvera

                                    I meant the Manager Tool, sorry for being unclear.
                                    Currently I read EJB 3.0 book, and I would like to follow the examples. That's why I'd like access to the Manager Tool. Otherwise I will use Mysql.
                                    Could you please describe how the MT is started if the service is already configured?

                                    1 2 Previous Next