How to access derby database from executable jar file?

Question

I am using java and derby database. I built derby database in netbeans IDE. I have created a executable jar file using clean and build option.

While running the project in netbeans, it connect to database goodly. But if I run executable jar file, it doesn't connect to the database.

Help me to create a executable jar file with derby database, It should run on any other system.Part of coding to connect database is

String str = textarea.getText();
    Class.forName(driver).newInstance();
    conn = DriverManager.getConnection(url+dbName,userName,password);
    String stm="select url from pingatabl where functn=?";
    PreparedStatement st = conn.prepareStatement(stm);
    st.setString(1, str);
     //Excuting Query
    ResultSet rs = st.executeQuery();
    if (rs.next()) {
    String s = rs.getString(1);
    //Sets Records in frame
    JFrame fm = new JFrame();
    fm.setVisible(true);
    fm.setSize(500,750);
    JEditorPane jm = new JEditorPane();
    fm.add(jm);
    jm.setPage(ClassLoader.getSystemResource(s));

What are your jdbc connection properties? Is the database running in embedded or server mode? — MadProgrammer
– MadProgrammer, Commented Oct 8, 2015 at 7:00
Where is the database? Inside of the Jar file? On the file system next to the database? Running in a separate process on the network? — Thilo
– Thilo, Commented Oct 8, 2015 at 7:00
My database running in server mode. How to change it to embedded mode? — Leks
– Leks, Commented Oct 8, 2015 at 7:18

Deval Khandelwal · Accepted Answer · 2015-10-08 07:10:53Z

1

You are as novice as I was 2 years ago. The thing is that you have not installed derby at all. See, Derby is a database server and netbeans has its own version of derby. So, it runs when made to run inside Netbeans but does not start when run from an executable file. So, first, install derby from https://db.apache.org/derby/ and then start the server and then you can access it from the executable file. Also, I would recommend you to use MySQL server instead of derby. But, you can always use derby.

answered Oct 8, 2015 at 7:10

Deval Khandelwal

3,5581 gold badge29 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hakanai Over a year ago

Derby is mostly an embedded database. It does have a server, but not many people use it as a server.

Collectives™ on Stack Overflow

How to access derby database from executable jar file?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related