HSQL POC
20 February, 2012
Hello perhaps my question is a little stupid but...
If I am in a POC, and I have installed Yellowfin using HSQL and after I need to modify some values how can I access to HSQL via JDBC? what is the username and the password?
Thanks
If I am in a POC, and I have installed Yellowfin using HSQL and after I need to modify some values how can I access to HSQL via JDBC? what is the username and the password?
Thanks
Hi Jordi,
When connecting to HSQL by default the username is SA and the password is left blank.
If you do not have a database connection tool such as DBVisualizer you can follow the instructions below to launch the HSQL Database Manager.
By opening the command line and then navigating to YellowfinappserverwebappsROOTWEB-INFlib you can enter [code]java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing[/code] which will then launch the HSQL Database Manager.
After that you will need to connect to the configdb.data file located in Yellowfindata
Below is an example of the connection details:
Let me know if you have any issues.
Regards,
Steven
When connecting to HSQL by default the username is SA and the password is left blank.
If you do not have a database connection tool such as DBVisualizer you can follow the instructions below to launch the HSQL Database Manager.
By opening the command line and then navigating to YellowfinappserverwebappsROOTWEB-INFlib you can enter [code]java -cp hsqldb.jar org.hsqldb.util.DatabaseManagerSwing[/code] which will then launch the HSQL Database Manager.
After that you will need to connect to the configdb.data file located in Yellowfindata
Below is an example of the connection details:
Let me know if you have any issues.
Regards,
Steven
Thanks for your help