Going back over my previous research, I can see I was experimenting with Derby and HSQLDB... And now I am seeing a few posts for SQLlite on the SBC3. I'm still playing around with the SBC1, so i'm not sure if SQLlite is an option to me, but I will buy an SBC3 soon.
So far in my testing, it looks like I've had the most success with HSQLDB. I was able to create a table, and add a row. However the data would not be maintained as persistent, when the app restarted, it was gone (and not due to a dropped table, etc.).
I would like a database that will maintain the data, even on power fail. It would be nice if i could choose the location for the data files, and it would be awesome if multiple userspace applications could access the same data simultaneously. is that possible?
What database should I be using? Can someone post some sample code to get connected, and I will test to see if I can save the data in the database!