Cambo Harvest Supper Ceilidh – 12th Oct

Ned Pearson – Cambo fiddler

Autumn is a lovely time of year – not least because it’s the season for village dances!

Kirkwhelpington was the first Saturday in September – and now we have Cambo on Saturday 12th October with Kathy Anderson on piano. It’s a family dance starting at 6pm in the village hall (here: tickets are £10/£5 (children) and the facebook event has more details:

Playing at Cambo is a bit special – because it’s where renowned fiddler Ned Pearson played for dances almost a century ago. Field recordings of his music (from the 1950’s) are in the British Library


New Tunes Casting of the Hand & Rothley Road

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 – Master pipemaker

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:

And here’s the notes for anyone who wants to learn it: The Master of Monkseaton

JDBC connections for OpenOffice HSQLDB

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:

  1. 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
  2. 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\
  3. Rename the files using your database name (backup is not needed):
    • properties =
    • data =
    • script = ManuscriptLibrary.script
  4. 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)
  5. 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.