I thought I followed your instructions to the bone, but when trying to load the Split_HSQLDB_Wizard_v3c.odb, I'm getting a message "Please add a copy of the HSQLDB engine (hsqldb.jar) to the current folder: Note:..... (several more pages of information below). I tried reinstalling the Java Development Kit.. no luck.
Hi Sean, thanks for doing this. So cool. Although, I'm having some issues. if I open the Split_HSQLDB_Wizard_v3c I don't get the pop-up window at the start with the naming options for the back-end like you do. It opens the database but if I try to do anything I get the following message "The connection to the data source "Rainfall" could not be established. The driver class 'org.hsqldb.jdbcDriver' could not be loaded.The additional driver class path is 'file:///D:/LocalData/LibreOffice%20Base%20Databases/Rainfall%20LibreOffice%20Database/Rainfall%20Database/driver/hsqldb.jar'. I've copied the "Rainfall Database" folder into a new folder I created for it but no luck getting it to work. The driver file hsqldb.jar is inside the "driver" folder with "sqltool.jar" so not sure what I've got to do to get it to load when opening the database. Hope you enjoy the cheeky coffee mate, cheers.
Hi Steve, Thanks for the coffee. You need to install the Oracle Java driver, you can get it at ... www.oracle.com/java/technologies/javase-downloads.html Also watch this 3 minute or so video, that will take you through this Step by Step. It includes installing the Oracle Java driver. czcams.com/video/LSjzIwDo0nU/video.html Let me know if this solves the problem, cheers.
@@BusinessProgrammer I installed the oracle java jdk file & installed in Tools>Options>Advanced but it didn't make any difference if I try to open "Split_HSQLDB_Wizard_v3c.odb". Still getting the same message. If I start a new database everything seems to work okay. So I'm now trying to work out how to import the 2019.csv file into a new database instead.
Woohoo, I fixed it. I just had to read the message..doh! I created the following folders in Users/Public/database/AutoValueFix/driver then copied & pasted the hsqldb.jar file in there & bob's ya uncle...working. Can now click on Tables & no message. Wasted time searching the internet when all I had to do was use the old grey matter...getting greyer by the minute.....lol.
Well, I created the tblRainfall_Live but when I enter the SQL code to link it to the 2019_Rainfall.csv file it says "1: user lacks privilege or object not found: tblRainfall_Live". Not sure how to fix & don't really have the time to search for solutions. Seems to be the split database only that has issues with. Something to do with my user permissions it seems.
@@devostevo1132 Imagine the fun I had learning this without ghostbusters ;-) 2019_Rainfall.csv needs to be in the Database folder of the split database (I do mention that in the video....), let me know if that fixes it.
Great tutorial with best video and efforts. Thank you again !!
You’re welcome Mahendra
This tutorial explained a lot for me. Thanks.
You’re welcome
Good job Hannibal!
Thanks Henry
Just noticed something. @7:14 should "Rate" be a "Text [VARCHAR]" or "Double [DOUBLE]" which is the same format as "Rate" is in "tblRainFall_Live"?
I thought I followed your instructions to the bone, but when trying to load the Split_HSQLDB_Wizard_v3c.odb, I'm getting a message "Please add a copy of the HSQLDB engine (hsqldb.jar) to the current folder: Note:..... (several more pages of information below). I tried reinstalling the Java Development Kit.. no luck.
Did you use the Oracle JDK, don't use JAVA jdk.
Hi Sean, thanks for doing this. So cool. Although, I'm having some issues. if I open the Split_HSQLDB_Wizard_v3c I don't get the pop-up window at the start with the naming options for the back-end like you do. It opens the database but if I try to do anything I get the following message "The connection to the data source "Rainfall" could not be established.
The driver class 'org.hsqldb.jdbcDriver' could not be loaded.The additional driver class path is 'file:///D:/LocalData/LibreOffice%20Base%20Databases/Rainfall%20LibreOffice%20Database/Rainfall%20Database/driver/hsqldb.jar'. I've copied the "Rainfall Database" folder into a new folder I created for it but no luck getting it to work. The driver file hsqldb.jar is inside the "driver" folder with "sqltool.jar" so not sure what I've got to do to get it to load when opening the database. Hope you enjoy the cheeky coffee mate, cheers.
Hi Steve, Thanks for the coffee.
You need to install the Oracle Java driver, you can get it at ...
www.oracle.com/java/technologies/javase-downloads.html
Also watch this 3 minute or so video, that will take you through this Step by Step. It includes installing the Oracle Java driver.
czcams.com/video/LSjzIwDo0nU/video.html
Let me know if this solves the problem, cheers.
@@BusinessProgrammer I installed the oracle java jdk file & installed in Tools>Options>Advanced but it didn't make any difference if I try to open "Split_HSQLDB_Wizard_v3c.odb". Still getting the same message. If I start a new database everything seems to work okay. So I'm now trying to work out how to import the 2019.csv file into a new database instead.
Woohoo, I fixed it. I just had to read the message..doh! I created the following folders in Users/Public/database/AutoValueFix/driver then copied & pasted the hsqldb.jar file in there & bob's ya uncle...working. Can now click on Tables & no message. Wasted time searching the internet when all I had to do was use the old grey matter...getting greyer by the minute.....lol.
Well, I created the tblRainfall_Live but when I enter the SQL code to link it to the 2019_Rainfall.csv file it says "1: user lacks privilege or object not found: tblRainfall_Live". Not sure how to fix & don't really have the time to search for solutions. Seems to be the split database only that has issues with. Something to do with my user permissions it seems.
@@devostevo1132 Imagine the fun I had learning this without ghostbusters ;-)
2019_Rainfall.csv needs to be in the Database folder of the split database (I do mention that in the video....), let me know if that fixes it.