Hi Gerrit,
Based on Apache Derby page, between the embedded mode and network mode there is no difference, https://db.apache.org/derby/docs/10.0/manuals/admin/hubprnt19.html#Differences+between+running+Derby+in+embedded+mode+and+using+the+Network+Server Have you tried to create an encrypted database via the network mode using the steps mentioned in your link ? It should work, otherwise can you please post your errors/stacktrace/exceptions. What I did on my side to try your scenario : Start Apache Derby in network mode Create a dummy encrypted database and connect to it via ij: connect 'jdbc:derby://localhost:1527/MyDbTest;create=true;dataEncryption=true'; After that I’ve started to create tables and to execute SQL queries (select), just to play with the database. It worked, no difference between embedded vs network mode. Remember to append to the URL the host and the port where Apache Derby server is started ( in my case it was localhost : 1527). What I’ve followed in order to achieve the above: http://db.apache.org/derby/papers/DerbyTut/ns_intro.html#ij_ns_client http://db.apache.org/derby/papers/DerbyTut/ij_intro.html#ij_connect https://db.apache.org/derby/docs/10.0/manuals/develop/develop15.html If you want a more custom example regarding the algorithm that can be used to encrypt the database, please have a look into this page : https://db.apache.org/derby/docs/10.2/ref/rrefattribencryptkey.html If you need more information, please let me know. Regards, George Sent from Windows Mail From: Hohl, Gerrit Sent: Wednesday, August 24, 2016 10:15 AM To: [email protected] Hello everyone, I've used Apache Derby for years now as an embedded RDBMS. BTW: Thanks to all developer doing a great job developing this database system. :-D But now I want to use it as a separate service running on Ubuntu Linux. This is no problem. But I haven't found any explanation or example how to create and use encrypted database if I'm running Derby as a service. I found only this page: https://db.apache.org/derby/docs/10.0/manuals/develop/develop115.html But it seems it only deals with an embedded Derby version. Regards, Gerrit
