How to connect to a database using a distributed API?

Question

I'm having trouble with my distributed application in java netbeans the program is running perfectly on the original machine where i created it. but when i build it and make a distribute folder and follow the instructions and try to run it, I got an error that localhost on port 1527 has been refused.

here is my code on my do connect function

public void DoConnect()
{
    String host = "jdbc:derby://localhost:1527/KempDB";
    String uName = "main";
    String uPass = "admin";
    try
    {
        con = DriverManager.getConnection(host, uName, uPass);
        stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

        String sql = "select cv.checkvouchernumber, c.checknumber, paytoorder, bankcode, dateissued, amount from checkvoucher cv, checks c where cv.checkvouchernumber = c.checkvouchernumber and cv.checknumber = c.checknumber";
        rs = stmt.executeQuery(sql);.....
        ..........
    }
    catch(SQLException err){
        .......
    }

so this is the code I used to connect with the database server, the database server I used is built-in with java. Its a apache derby...

like I said in the original machine where I created the program runs ok without errors but when I distribute the program to another machine there's an error refusing the connection. How can I connect to the local machine where my database is? maybe you can help me on this.

Are you able to connect via a database management tool like Heidi SQL? — Lukas Eichler
– Lukas Eichler, Commented Jun 25, 2013 at 9:12
Replace localhost with ip address of machine on which your database is present.Let me know if it's working. — Rohan
– Rohan, Commented Jun 25, 2013 at 9:18
@R.S :I will try to use IP sir I will let you know immediately. — Tyran Xavier Winchester
– Tyran Xavier Winchester, Commented Jun 26, 2013 at 4:58
@R.S Hi sir, I have tried changing the localhost to the machines IP where the database is; and I encounter an error "DERBY SQL error:SQLCODE:-1, SQLSTATE:08004, SQLERRMC: Database connection refused". I hope you can help me with this — Tyran Xavier Winchester
– Tyran Xavier Winchester, Commented Jun 26, 2013 at 5:07

bzzzrd · Accepted Answer · 2013-07-04 18:38:19Z

1

Are the database Servers running on these machines? Are u starting the database server programmatically?

If you try to connect a database Server with:

jdbc:derby://localhost:1527/KempDB

This Server needs to be up and running.

For your case you should use an embedded Database. For the case your Database is already an embedded Database, then you can try using this URL:

jdbc:derby:KempDB

instead of:

jdbc:derby://localhost:1527/KempDB

Hav a look on this one

answered Jul 4, 2013 at 18:38

bzzzrd

3812 silver badges3 bronze badges

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

2 Comments

Tyran Xavier Winchester Over a year ago

only one machine runs the database server and I started that server sir., mr. R.S. answered my question, when I distribute my program to a client machine I should change the localhost to an IP of the server that runs the database server.,

Tyran Xavier Winchester Over a year ago

how ever your suggestion is great if the application I'm working is a standalone application, which is not what I am doing now. anyways thanks for the suggestion sir I will consider it for my standalone application.

Collectives™ on Stack Overflow

How to connect to a database using a distributed API?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related