Issues with connect to Apache Derby database on Raspberry Pi

Question

I am working on a Java project where I make apache Derby Database connections in Netbeans with maven. I want to export project to Raspberry PI, but when i am trying to execute jar file i got an error:

java.sql.SQLNonTransientConnectionException: java.net.ConnectException : Error connecting to server localhost on port 1,527 with message Connection refused.

On local computer database connects normally when I start server manually, if not i got same error.

I understand that i didnt started database server on Raspberry PI, but I can't find where and how to do it..

JohnK · Answer 1 · 2016-08-09T10:23:25.560

0

I assume that the database server runs on another machine and you can reach it from raspberry pi over network.

It tries to connect to the database server on localhost (Raspberry Pi). Since it is not running on localhost and running on another machine, you need to change the server IP address in order to connect to the database server that runs on other machine.

Check database connection string which has hostname/ip and port. As "dbhost" and "dbport" variables below:

String url = "jdbc:postgresql://" + dbhost + 
                ":" + dbport + "/" + dbname;

You can check following JDBC tutorial for more details:

Java Database Connectivity

edited Aug 09 '16 at 10:23

answered Aug 09 '16 at 10:16

JohnK

34
3

No, I want to run Derby database server on localhost (Raspberry Pi) – manyn753 Aug 09 '16 at 10:42
Then, you should install and run Derby there before running your program. – JohnK Aug 09 '16 at 11:16
But i can't find out how to do this, that's my problem – manyn753 Aug 09 '16 at 11:19
I don't understand. After you install Java to Raspberry Pi, everything else should be same – JohnK Aug 09 '16 at 11:50
But it isn't. In Netbeans i must have additionally created database in services and database server must be started. I don't know how make that step on Raspberry PI. Maybe there is other, easier way to do it? – manyn753 Aug 09 '16 at 11:56
Didn't you configured everything on another machine already? What is the difference? – JohnK Aug 09 '16 at 12:07
I didn't configured Derby on Raspberry PI, i can't find working manual to do this. – manyn753 Aug 09 '16 at 12:11

score 0 · Answer 2 · answered Aug 09 '16 at 13:36

0

For information about running the Derby Network Server, see the Derby Admin Guide at https://db.apache.org/derby/docs/10.12/adminguide/index.html

Specifically, see https://db.apache.org/derby/docs/10.12/adminguide/tadmincbdjhhfd.html

answered Aug 09 '16 at 13:36

Bryan Pendleton

16,128
3
32
56

Issues with connect to Apache Derby database on Raspberry Pi

2 Answers2