Using Linux – What is HSQL URL string format?
19 September, 2013
Hi,
As per post here :http://www.yellowfinbi.com/YFForum-Install-Ski-Team-Tutorial-Database-post-installation-?thread=107595
I'm having trouble with this on a linux platform. What should the Connection String be?
The application is installed in /usr/local/yellowfin but any combination of relative and absolute path names just doesn't seem to return any tables or data.
Thanks
Brendon
As per post here :http://www.yellowfinbi.com/YFForum-Install-Ski-Team-Tutorial-Database-post-installation-?thread=107595
I'm having trouble with this on a linux platform. What should the Connection String be?
The application is installed in /usr/local/yellowfin but any combination of relative and absolute path names just doesn't seem to return any tables or data.
Thanks
Brendon
Hi Brendon,
The general url is:
jdbc:hsqldb:file:/tutorialdata/newskiteam;shutdown=true
So if Yellowfin is installed at "/Applications/Yellowfin 6.3" then the url will be:
jdbc:hsqldb:file:/Applications/Yellowfin 6.3/tutorialdata/newskiteam;shutdown=true
jdbc:hsqldb:file:/Applications/Yellowfin 6.3/tutorialdata/newskiteam;shutdown=true
So I guess yours would be :
jdbc:hsqldb:file:/usr/local/yellowfin/tutorialdata/newskiteam;shutdown=true
Does this work?
Also, please ensure that you have the Ski Team DB correctly in the Tutorial folder, and it should be about 8mb.
Regards,
David
The general url is:
jdbc:hsqldb:file:/tutorialdata/newskiteam;shutdown=true
So if Yellowfin is installed at "/Applications/Yellowfin 6.3" then the url will be:
jdbc:hsqldb:file:/Applications/Yellowfin 6.3/tutorialdata/newskiteam;shutdown=true
jdbc:hsqldb:file:/Applications/Yellowfin 6.3/tutorialdata/newskiteam;shutdown=true
So I guess yours would be :
jdbc:hsqldb:file:/usr/local/yellowfin/tutorialdata/newskiteam;shutdown=true
Does this work?
Also, please ensure that you have the Ski Team DB correctly in the Tutorial folder, and it should be about 8mb.
Regards,
David