Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: How I can access the HSQLDB database?

  1. #1

    Default How I can access the HSQLDB database?

    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

  2. #2
    Join Date
    Feb 2009
    Posts
    21

    Default

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

    Code:
    <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>
    Last edited by PiKo; 07-06-2010 at 04:19 AM.

  3. #3

    Default

    Thanks,

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

    Regards.

  4. #4
    Join Date
    Feb 2009
    Posts
    21

    Default

    You can use any SQL client like SQuirrel for example.

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

  5. #5

    Default

    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.
    Last edited by sbante@infocepts.com; 01-17-2018 at 08:43 AM.

  6. #6

    Default Missing User\Role details while accessing HSQLDB with SQL client like SQuirrel

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.