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

[seamguy]

Thanks, Norman. I had to dig through my JARs until I found embedded-jboss-beans.xml in mc-conf.jar, and in that XML file, I found the db definition (shown below).

Now the only question I have is how do I access that database from the command line? With mysql, I can just run the mysql command and do a 'show databases;' and I'm off and running. How do I do the same thing with hsqldb?

Another question: How do I change to mysql instead of hsqldb? Do I have to unjar mc-conf.jar, edit embedded-jboss-beans.xml, then reJAR the JAR file and restart the application?

Sorry if this is more about mysql and hsqldb than Seam. I have no problems with Seam (yet!) and I really want to look at the database that Seam is manipulating. Somehow, it doesn't seem like it should be this difficult.

Thanks for your help.



  |    <!--
  |       <bean class="org.jboss.jdbc.HypersonicDatabase"
  |         name="jboss:service=Hypersonic,database=localDB">
  |         <property name="database">localDB</property>
  |         <property name="inProcessMode">true</property>
  |         <property name="dbDataDir">.</property>
  |       </bean>
  |    -->
  | 
  |    <bean name="DefaultDSBootstrap" class="org.jboss.resource.adapter.jdbc.local.LocalTxDataSource">
  |       <property name="driverClass">org.hsqldb.jdbcDriver</property>
  |       <property name="connectionURL">jdbc:hsqldb:.</property>
  |       <!--      <property name="connectionURL">jdbc:hsqldb:./hypersonic/localDB</property> -->
  |       <property name="userName">sa</property>
  |       <property name="jndiName">java:/DefaultDS</property>
  |       <property name="minSize">0</property>
  |       <property name="maxSize">10</property>
  |       <property name="blockingTimeout">1000</property>
  |       <property name="idleTimeout">100000</property>
  |       <property name="transactionManager"><inject bean="TransactionManager"/></property>
  |       <property name="cachedConnectionManager"><inject bean="CachedConnectionManager"/></property>
  |       <property name="initialContextProperties"><inject bean="InitialContextProperties"/></property>
  |    </bean>
  | 
  |    <bean name="DefaultDS" class="java.lang.Object">
  |       <constructor factoryMethod="getDatasource">
  |          <factory bean="DefaultDSBootstrap"/>
  |       </constructor>
  |    </bean>
  | 
  |   | 
  |   | 

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

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