[jboss-user] [JBoss Seam] - Re: Where is the database?

[seamguy]

Thanks for the suggestions, Norman. I tried setting the URL you suggested in the HSQLDB manager connect dialog, but that throws an exception. I tried numerous other variants and they all throw exceptions too.

I really don't want to have to figure out how to launch the DB manager from within the application, or try to install a Seam component just to examine tables. All of that is way too much trouble for what should be a very simple thing.

I find it difficult to believe that I cannot just type in a URL in the HSQLDB manager connect dialog and access my database when using JBoss embedded EJB3 in Tomcat. I have now spent an entire day trying to just view my db tables. I am really, really, frustrated. This is really quite ridiculous.

Does anyone know how to do this? Is anyone running Seam in Tomcat with the JBoss embedded EJB3 server? If so, how do you access the HSQL database?

To summarize: I have a simple Seam app that manipulates one db table and I want to view that table in the database. My application runs in Tomcat with the JBoss embedded EJB3 server. In $JBOSS_HOME/server/default/data/hypersonic, I start the HSQLDB manager with this command:

java -cp /Developer/Java/Tools/hsqldb/lib/hsqldb.jar org.hsqldb.util.DatabaseManagerSwing

I can connect with the default info in the Contact dialog:

Type: HSQL Database Engine In-Memory
Driver: org.hsqldb.jdbcDriver
URL: jdbc:hsqldb:mem:.
User: sa

These are the same as the settings in the embedded-jboss-beans.xml that's in the mc-conf.jar file in resources/WEB-INF/lib, but I don't see any database tables. If I try a different URL, such as jdbc:hsqldb:hsql://localhost:1701, I get a socket connection error.

Does anyone know what to type in the Connect dialog so that I can connect to my database and view my table?

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3989137#3989137

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3989137