Eclipse Community Forums: scout » Offline Storage of Derby Database for Raspberry Pi

Help

Home

Home » Eclipse Projects » scout » Offline Storage of Derby Database for Raspberry Pi(database storage)

Show: Today's Messages :: Show Polls :: Message Navigator

Offline Storage of Derby Database for Raspberry Pi [message #1757991]

Wed, 22 March 2017 15:22

Jared Ebersole

Messages: 2
Registered: March 2017

Junior Member

I have create an Eclipse Scout project, and am hosting it on a Raspberry Pi. The database workd perfect (Add employee and store info in database). The only problem is if the Rapberry Pi shuts off all of the data is gone.

So, how do I store the data locally so that if anyting happens to the Raspberry Pi the data does not dissappear?

Report message to a moderator

Re: Offline Storage of Derby Database for Raspberry Pi [message #1758007 is a reply to message #1757991]

Wed, 22 March 2017 17:54

Paolo Bazzi

Messages: 17
Registered: January 2017

Junior Member

Hi Jared,

Do you use the Apache Derby in-memory database? In this case the database content is only kept in memory and deleted if the Raspberry is rebooted. You could try to use the Apache Derby database with a file as persistence location. Derby can be operated as database embedded to your Java Scout application. See for instance https://db.apache.org/derby/papers/DerbyTut/embedded_intro.html

Regards,
Paolo

Report message to a moderator

Re: Offline Storage of Derby Database for Raspberry Pi [message #1758009 is a reply to message #1757991]

Wed, 22 March 2017 18:03

Andreas Hoegger

Messages: 186
Registered: February 2010

Senior Member

My assumption is you are using the Derby in memory DB. Have a look in your AbstractDerbySqlService getConfiguredJdbcMappingName method implementation. And use something like jdbc:derby:/var/myDatabase. Ensure to have a database at the given location.
Visit Derby Manual for more information.

-andreas

Report message to a moderator