Distributing a Derby DB with a Java application

Question

I have a table in a application, which loads in data from a Derby DB with a Client/Server driver. Everything works in NetBeans, even with the NetBeans DB service disconnected, but not when running the standalone distributive app. I have included the derbyclient.jar in the classpath. I have the startNetworkServer.bat in the distributable apps folder(not in /dist), and it is run within the program at initialization. I'm new to Derby, so maybe i'm missing/not including something important?

Answer 1

First i load the startNetworkServer.bat file:

ProcessBuilder pb = new ProcessBuilder("D:/Users/lapa2/Desktop/Skeneris/InventoryController/dist/startNetworkServer.bat");
p = pb.start();

Which doesn't work, I set that by manually opening cmd line for now.

Then the driver and connection are set:

private static final String jdbcDriver
= "org.apache.derby.jdbc.ClientDriver";


private static final String jdbcURL
    = "jdbc:derby://localhost:1527/D:/Users/lapa2/Desktop/Skeneris/InventoryController/dist/Lapa;create=true;";

Then I query everything i want:

db = new DataBase(userName,password,databaseName);
    String dbStatement = "select * from "+ schemaName + ".PRECES";
    ResultSet rs = db.executeQuery(dbStatement);

Doing like this, everything works in NetBeans, but no response when running the .JAR.