May be you forgot to change hsqldb-ds.xml, see p. 20 of "Getting Started".
Thanks for the reply.
I did follow the instructions in p.20 of "Getting Started".
I use the follows
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.
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.
Hi, I'm having this same problem. Did you ever resolve to invoke the hypersonic databse manager while running Jboss as a Windows service?
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.
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.
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?
I have the same problem when I try to start HSQL Database Manager tool. Does anyone have a solution for this?
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:
[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)
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
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!!
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.
Is there a way to run it by hand if JBoss runs as a Windows service?
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).
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?