How I can access the HSQLDB database?

[Martillo]

Hello,

I need to know how I can access the bd "hsqldb"

What is username and password to access it?

I hope you can help me.

Regards

[PiKo]

You can find all information that you need in pentaho-solutions/system/hibernate/hsql.hibernate.cfg.xml

<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="connection.url">jdbc:hsqldb:hsql://localhost:9001/hibernate</property>
<property name="connection.username">hibuser</property>
<property name="connection.password">password</property>

[Martillo]

Thanks,

Do you know any software for can see this data base?

Regards.

[PiKo]

You can use any SQL client like SQuirrel for example.

You just need to download and install the jdbc driver for HSQLDB.

[sbante@infocepts.com]

Hello,
I know this is bit old but recently I have encountered same problem while dealing with biserver 6.1 community edition, actually, i migrate the default hsqldb metadata to MySQL but the user is missing won't find the user and there role details in respective schemas so i revert the changes and try to link hsqldb via. SQL client like SQuirrel but while accessing all the schemas like quartz, hibernate and sampledata there but again no user details. can any have the idea about this please let me know I search a lot but nothing is relevant so please let me if you aware of that ????

Thanks In Advance.
Sachin.

[sbante@infocepts.com]

Hello,

I am using bi-server 6.1 community edition, actually, I link hsqldb via. SQL client like SQuirrel but while accessing all the schemas like quartz, hibernate and sampledata there is no user\role details. can any have an idea about this please let me know I search a lot but nothing is relevant so please let me if you aware of that ????

And from where exactly the user details get fetch because in-memory data I can access thought SQL client so it should have user\role details but it won't please let me know if any alternative for same.

Thanks In Advance.