Thread: a tool to distribute netbeans java application with java database

I developped a java application using netbeans but I have a problem with the distribution of my application after building I find a jar file but when I execute it with the netbeans IDE cloesed the database is not working !!! I there any tool that gives a jar file onsidering my database!!

Here's a first stab at a resource for you, but it may give you other ideas. We may be able to give you specific advice if you post the error message.

I tried to follow this tutorial many times but my problem is that the database connection is not established when te IDE is closed! I have to do it manually from netbeans. but the jar file is created and it runs but without the foncionalities related to the database. I am using derby driver like it is clear in the picture Sans titre.jpg
Thank you

The graphic is near impossible to read. Not your fault but a good idea not done well.

Again, it's difficult to help without seeing the code that loads/connects the database and the actual error message. Post error messages from the console that occur when the deployed .jar file is run.

Just guessing, I suspect your source code points to the database using its location on your hard drive, specifying either a relative or full path name. That likely is failing in the .jar file, because the file isn't located where the source code is looking. I haven't done it with a database for a while, but with graphics the desired object in the .jar file is loaded as a resource using getClass().getResource(). I suspect you need to do similarly for the database file.

Search for advice deploying a java app with a database file.

Thank you very much for your answer
this is the code of the connection try {
String url = "jdbc:derby://localhost:1527/";
String dbName = "Data_base";
String driver = "org.apache.derby.jdbc.ClientDriver";
String userName = "jebali";
String password = "Mypassowrd";

Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url + dbName, userName, password);

System.out.println("Connected to the database");
} catch (Exception e) {
System.out.println("erreur");
e.printStackTrace();

// System.out.println("exception"+e.getClass());

}
When building I don't have error messages and I get my jar but when i execute it when netbeans is closed the database connection is not established so all the tasks depending on the database are not done.

Oh yeah, the server piece.

I'm not familiar with the Netbeans jdbc plugin (or whatever it's called), but I'll assume the database server services are being started/managed by Netbeans as needed when you run this app in Netbeans. How does your app start or ensure the readiness of the necessary database server services on another client?

In deed It is the only way that I found is to start manually the database server!
even in netbeans tutorial it is the only described way
https://netbeans.org/kb/docs/ide/java-db.html#starting
Thank you!!

I uesed this code in order to start the server

NetworkServerControl server = new NetworkServerControl();
server.start (null);
And this code in order to connect the database

String url = "jdbc:derby://localhost:1527/";

String dbName = "Data_base";
String driver = "org.apache.derby.jdbc.ClientDriver";
String userName = "jebali";
String password = "barbara";

Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url+dbName , userName, password);

System.out.println("Connected to the database");
but the problem that the connexion is not established and this is the error
run:

java.sql.SQLNonTransientConnectionException: La connexion a été refusée car la base de données Data_base n'a pas été trouvée.
at org.apache.derby.client.am.SQLExceptionFactory40.g etSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLExce ption(Unknown Source)
at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:579)
at java.sql.DriverManager.getConnection(DriverManager .java:221)
at OBSME.OBSME.main(OBSME.java:2353)
Caused by: org.apache.derby.client.am.DisconnectException: La connexion a été refusée car la base de données Data_base n'a pas été trouvée.
at org.apache.derby.client.net.NetConnectionReply.par seRDBNFNRM(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.par seAccessRdbError(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.par seACCRDBreply(Unknown Source)
at org.apache.derby.client.net.NetConnectionReply.rea dAccessDatabase(Unknown Source)
at org.apache.derby.client.net.NetConnection.readSecu rityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowSecu rityCheckAndAccessRdb(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowUSRI DPWDconnect(Unknown Source)
at org.apache.derby.client.net.NetConnection.flowConn ect(Unknown Source)
at org.apache.derby.client.net.NetConnection.<init>(U nknown Source)
at org.apache.derby.client.net.NetConnection40.<init> (Unknown Source)
at org.apache.derby.client.net.ClientJDBCObjectFactor yImpl40.newNetConnection(Unknown Source)
... 4 more
erreur1
java.lang.NullPointerException
at OBSME.OBSME.<init>(OBSME.java:128)
at OBSME.OBSME$31.run(OBSME.java:2365)
C:\Program Files\Java\jdk1.7.0_04\bin;C:\Windows\Sun\Java\bin ;C:\Windows\system32;C:\Windows;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\Sys tem32\Wbem;C:\Windows\System32\WindowsPowerShell\v 1.0\;C:\Program Files\Windows Live\Shared;C:\Program Files\Java\jdk1.7.0_04\bin;C:\Program Files\VDownloader;C:\Program Files\MiKTeX 2.9\miktex\bin\;C:\Program Files\Apache Software Foundation\apache-maven-3.0.4\bin;.
at java.awt.event.InvocationEvent.dispatch(Invocation Event.java:251)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.j ava:701)
at java.awt.EventQueue.access$000(EventQueue.java:102 )
at java.awt.EventQueue$3.run(EventQueue.java:662)
at java.awt.EventQueue$3.run(EventQueue.java:660)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPri vilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java: 671)
at java.awt.EventDispatchThread.pumpOneEventForFilter s(EventDispatchThread.java:244)
at java.awt.EventDispatchThread.pumpEventsForFilter(E ventDispatchThread.java:163)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:147)
at java.awt.EventDispatchThread.pumpEvents(EventDispa tchThread.java:139)
at java.awt.EventDispatchThread.run(EventDispatchThre ad.java:97)
BUILD SUCCESSFUL (total time: 10 minutes 4 seconds)