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: 14
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: 185
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

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

Thu, 23 March 2017 02:47

Jared Ebersole

Messages: 2
Registered: March 2017

Junior Member

Do you know how I could implement this? I can't teallow follow that tutorial.

Jared

Report message to a moderator

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

Thu, 23 March 2017 16:55

Paolo Bazzi

Messages: 14
Registered: January 2017

Junior Member

Hi Jared

Theres is an implementation example in the Scout beginners guide:

https://eclipsescout.github.io/6.0/beginners-guide.html#sec-my_contacts_guide

The code of the mentioned contacts demo application is available here:
https://github.com/BSI-Business-Systems-Integration-AG/org.eclipse.scout.docs/tree/releases/6.0.x/code/contacts

E.g. the SQL service implementation is here:
https://github.com/BSI-Business-Systems-Integration-AG/org.eclipse.scout.docs/blob/releases/6.0.x/code/contacts/org.eclipse.scout.contacts.server/src/main/java/org/eclipse/scout/contacts/server/sql/DerbySqlService.java

Maybe you could also find some additional input in this thread: https://www.eclipse.org/forums/index.php/t/1076182/

Regards,
Paolo

Report message to a moderator

Previous Topic:	[6.1.0.M5] Missing RunContext when calling Service from CredentialVerifier
Next Topic:	How to integrate Eclipse Scout [Neon] with JasperReports

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 23 08:49:56 GMT 2017

.:: Contact :: Home ::.