Here’s two new jigs in D that fit well on the pipes
The Casting of the Hand has been on the bench for a while but was finished in May. Originally cast as a votive offering in the 2nd or 3rd century, and later cast into a ditch; my wife was fortunate to be working on an an archaeological dig at Vindolanda when a small bronze hand was uncovered in 2018.
Rothley Crag is near Cambo in Northumberland and the second tune came to me whilst driving between the two (en route to Rothbury Festival)
Colin Ross – fiddler, piper & master pipe-maker passed away recently. Amongst many other sets of pipes, he made both of my main chanters which I’ve played for the last 20 years or so and passed on his pipe-making knowledge to my family.
The ‘super-extended’ F chanter or ‘geet lang walking stick’ as it’s sometimes called is what I now play most and it is a masterpiece for which I am very grateful. I was on holiday when I heard of his passing; this tune came to me whilst reflecting on various memories – and playing his instruments. I always loved the way he played the fiddle and particularly the energy he applied to the big fiddle slow airs – this tune always knew it was going to be in D, use the extended range (a little) and use the top B. The original instruction was ‘Unmawkishly’ – but this was changed to ‘Slow & vigourously’ to be better understood!
Here’s the recording I made in the cottage kitchen on my phone shortly after I’d finished it:
How to connect to and query an OpenOffice database with JDBC
The internet completely failed to provide a clear answer to this question – so having worked it out and on the off chance that someone else needs to know the answer; here’s how to run queries from SQuirrel SQL against your ODB data:
Create your new database in Open Office Base (or equivalent):
Call it anything you like but in this post I call mine ‘ManuscriptLibrary‘
Add a table to the database, this is the table you want to query – mine is called ‘Manuscript‘
Save and Close the Open Office Base file
Extract the database files from the ODB file:
Open the file ‘ManuscriptLibrary.odb’ in your favourite zip tool (7-Zip, WinZip .. whatever).
Select the database folder and copy the four files (properties, backup, data, script) out to a local directory such as C:\Path\To\Extracted\Files\
Rename the files using your database name (backup is not needed):
properties = ManuscriptLibrary.properties
data = ManuscriptLibrary.data
script = ManuscriptLibrary.script
Open Squirrel SQL:
Add a new Alias with the HSQLSB Standalone driver (you will need to add the hsqldb jar to enable this driver)
Set the URL to: jdbc:hsqldb:file:///C:/Path/To/Extracted/Files/ManuscriptLibrary (ManuscriptLibrary is the name of the DB and the name you used in step 3 above)
Set the User Name: sa (Do not set the Password – it’s empty)
Hit OK (note the driver will connect even if you get the filenames wrong – so Test is spectacularly unhelpful)
Connect to the DB:
Double click on the saved Alias or hit Connect
In the Objects tab, expand PUBLIC > PUBLIC > TABLE – at this point you should see the table you created in step 1 (‘Manuscript‘), you may need to hit refresh at this point
Select SQL tab and run the query: select * from “Manuscript”; (note the table name is in double quotes). You should get the contents of the table. If you get error codes 42501 or -5501 this means that either – the ODB files weren’t found or the table name is wrong.
And now no doubt you want to manipulate the data and put it back into an ODB file that can be edited in Open Office – that’s a topic for another post.