Type: HypersonicSQL Server
Driver: leave it as it is: org.hsql.jdbcDriver
URL: set to: jdbc:HypersonicSQL:hsql://localhost:1476
User: sa
Password: leave it blank
URL, user and password depend on how you configured your datasource in jboss.jcml
I have it like this:
<mbean name="DefaultDomain:service=XADataSource,name=DefaultDS">
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:HypersonicSQL:hsql://localhost:1476</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password" />
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
You can find more info at http://hsql.oron.ch/
Marko.
> -----Original Message-----
> From: Jim Archer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 21, 2001 4:36 AM
> To: JBoss-User
> Subject: [jBoss-User] How to use HSQL DatabaseManager to look at my
> data?
>
>
> Hi All...
>
> I am wondering how I could use the Hypersonic SQL Database
> Manager to view
> the database tables jBoss is creating. I have deployed my app and was
> interested in looking to see that the data was being
> persisted as I expect
> it to be.
>
> I started Database Manager thusly:
>
> java -cp hsql.jar org.hsql.util.DatabaseManager
>
> Which launches it. Then, I get lost. What should I put into
> the url, user
> and password fields?
>
> Thanks...
>
> Jim
>
>
> ********************************************
> I shall be telling this with a sigh
> Somewhere ages and ages hence:
> Two roads diverged in a wood, and I -
> I took the one less traveled by,
> And that has made all the difference.
>
> - Robert Frost, 1916
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
>
