-
1. Re: Can not start the Hypersonic Manager Tool
sysuser1 Feb 4, 2004 11:38 AM (in response to erich0328)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 Feb 4, 2004 8:20 PM (in response to 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 Feb 6, 2004 2:01 AM (in response to 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 Oct 7, 2004 6:47 PM (in response to erich0328)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 Oct 20, 2004 7:10 PM (in response to erich0328)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
norman.richards Oct 21, 2004 11:20 PM (in response to erich0328)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 Oct 22, 2004 12:57 PM (in response to erich0328)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 Mar 22, 2007 1:46 PM (in response to erich0328)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 Mar 29, 2007 3:27 AM (in response to erich0328)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 Mar 29, 2007 4:05 AM (in response to erich0328)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 Mar 30, 2007 2:23 PM (in response to erich0328)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 May 18, 2007 1:52 PM (in response to erich0328)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 May 18, 2007 2:54 PM (in response to erich0328)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 May 19, 2007 2:32 PM (in response to erich0328)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?