Problem Accessing HSQLDB Inmemory Tables

[vijay sachin]

Hi All,

Using Hibernate I am Creating tables in HSQLDB and inserting records to the tables.

Using DatabaseManagerSwing I tried to see the table data but I can't find tables itself.

My hibernate_hsqldb.cfg.xml file configuration

<hibernate-configuration>
   <session-factory>        
        <property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
       <!--  <property name="connection.url">jdbc:hsqldb:mem:testdb</property>-->
         <property name="connection.url">jdbc:hsqldb:mem://localhost/</property>
        <property name="connection.username">sa</property>
        <property name="connection.password"></property>
        <property name="connection.pool_size">20</property>
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
        <property name="current_session_context_class">org.hibernate.context.ManagedSessionContext</property>
        <property name="hibernate.cache.use_second_level_cache">false</property>
        <property name="hibernate.cache.use_query_cache">false</property>
        <property name="show_sql">false</property>
        <property name="hibernate.connection.zeroDateTimeBehavior">round</property>

        <mapping resource="com/sdp/hibernate/hbm/Policy.hbm.xml"/>
    </session-factory>  
</hibernate-configuration> 

In HSQL Database Manager Tool I am giving Following Information

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

Problem: When Login with above credentials I can't able to see any tables.
But Using Hibernate I can Insert data to tables, one more thing using Hibernate I am not able to
retrieve table data. Query size is coming zero.

If we configure with this URL jdbc:hsqldb:mem://localhost/
Where the tables will be created and how I access them.