You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-user@db.apache.org by Fabricio Pedroso Jorge <fp...@gmail.com> on 2010/05/05 04:54:52 UTC
Problems to use Derby Network Server
Hello... This is my first e-mail, and i hope i can help and be helped...
At this moment, i need help. My problem is tah a can't connect my
application to a database, using Derby Network Server. Let me explain
better:
I have 2 machines in my LAN, using the following IPs: (203.203.1.1) - Server
and (203.203.1.2) Client. I'm trying to conect the client to the server,
but i keep getting the following message: "Connection refuse: connect"
On the server, i've installed Derby Network Server, configured it properly
and started successfully. Then copied my Derby database to DERBY_HOME\bin.
OBS: Using the ij, i can connect to the database using the localhost
address, but when i try to use de server IP, i get "Connection refuse:
connect".
On the client, when i try to create a connection, via NETBEANS 6.8, using
the following URL: "jdbc:derby://203.203.1.1:1527/BDHistoricoPeso", i get,
again the error "Connection refuse: connect"
Thats the problem: i simply can't connect mai client to the server... i
can't create a connection via NETBEANS to my server... I don't know what to
do anymore, and i hope you guys "show me the light"
Thanks!!!
--
Atenciosamente,
Fabrício Pedroso Jorge.
Programador de Sistemas Júnior - SEFA-PA
Bacharel em Ciência da Computação - CESUPA
Resumo Profissional:
http://br.linkedin.com/pub/fabricio-jorge/19/554/58b
RE: Problems to use Derby Network Server
Posted by "Thomas J. Taylor" <Th...@Miami.edu>.
Hello Fabricio,
Ive normally seen a Connection Refused: connect message when a firewall
is blocking a network port (Windows Firewall most likely). You can add an
exception to the firewall on the server (203.203.1.1) for port 1527.
Alternately, you can try disabling the firewall briefly to confirm that with
the firewall turned off you can connect to the derby network server.
FYI. you will normally see a Connection Timeout message when either the
destination (server) IP address is wrong, or the network server has not
started.
Best regards,
Thomas Taylor
From: Fabricio Pedroso Jorge [mailto:fpjbito@gmail.com]
Sent: Tuesday, May 04, 2010 10:55 PM
To: derby-user@db.apache.org
Subject: Problems to use Derby Network Server
Hello... This is my first e-mail, and i hope i can help and be helped...
At this moment, i need help. My problem is tah a can't connect my
application to a database, using Derby Network Server. Let me explain
better:
I have 2 machines in my LAN, using the following IPs: (203.203.1.1) - Server
and (203.203.1.2) Client. I'm trying to conect the client to the server, but
i keep getting the following message: "Connection refuse: connect"
On the server, i've installed Derby Network Server, configured it properly
and started successfully. Then copied my Derby database to DERBY_HOME\bin.
OBS: Using the ij, i can connect to the database using the localhost
address, but when i try to use de server IP, i get "Connection refuse:
connect".
On the client, when i try to create a connection, via NETBEANS 6.8, using
the following URL: "jdbc:derby://203.203.1.1:1527/BDHistoricoPeso", i get,
again the error "Connection refuse: connect"
Thats the problem: i simply can't connect mai client to the server... i
can't create a connection via NETBEANS to my server... I don't know what to
do anymore, and i hope you guys "show me the light"
Thanks!!!
--
Atenciosamente,
Fabrício Pedroso Jorge.
Programador de Sistemas Júnior - SEFA-PA
Bacharel em Ciência da Computação - CESUPA
Resumo Profissional:
http://br.linkedin.com/pub/fabricio-jorge/19/554/58b
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 9.0.814 / Virus Database: 271.1.1/2854 - Release Date: 05/04/10
14:27:00
Re: Problems to use Derby Network Server
Posted by "Jasvinder S. Bahra" <bb...@blueyonder.co.uk>.
Fabricio,
Can you try executing the following command on your client machine... "ping
203.203.1.1" (less quotes), and reply with what is returned. You might be
having some kind of network issues.
In addition, I would recommend you move the database directory into the
DERBY_HOME directory. It makes no sense for the database directory to be in
the DERBY_HOME\bin directory - the bin directory should, speaking
conventionally, just hold the Apache Derby application files.
My suspicion is that Netbeans isn't using the DERBY_HOME\bin directory as
the 'current' directory when attempting to run Apache Derby - so when Derby
attempts to look in the 'current' directory for the database files, it can't
find them.
Jazz
----- Original Message -----
From: Fabricio Pedroso Jorge
To: Derby Discussion
Sent: Wednesday, May 05, 2010 4:32 AM
Subject: Re: Problems to use Derby Network Server
Hi... thanks for the fast reply.
@Thomas J. Taylor: I've completely disabled my Windows Firewall.
@Bryan Pendleton: I've used the following parameter on my server:
"startNetworkServer -h 203.203.1.1 -p 1527". With it, the server started
correctly, but now, when i try to create a new connection via netbeans, a
new message appears, saying that the database could not be found. My
database is inside DERBY_HOME/bin, and i think that's the correct directory.
Again, thanks for the fast reply :)
2010/5/5 Bryan Pendleton <bp...@gmail.com>
On 05/04/2010 07:54 PM, Fabricio Pedroso Jorge wrote:
Thats the problem: i simply can't connect mai client to the server..
On your server machine, when starting the Network Server, did you
pass the '-h' argument?
If you didn't, that's probably the problem.
thanks,
bryan
--
Atenciosamente,
Fabrício Pedroso Jorge.
Programador de Sistemas Júnior - SEFA-PA
Bacharel em Ciência da Computação - CESUPA
Resumo Profissional:
http://br.linkedin.com/pub/fabricio-jorge/19/554/58b
Re: Problems to use Derby Network Server
Posted by Fabricio Pedroso Jorge <fp...@gmail.com>.
Hi... thanks for the fast reply.
@Thomas J. Taylor: I've completely disabled my Windows Firewall.
@Bryan Pendleton: I've used the following parameter on my server:
"startNetworkServer -h 203.203.1.1 -p 1527". With it, the server started
correctly, but now, when i try to create a new connection via netbeans, a
new message appears, saying that the database could not be found. My
database is inside DERBY_HOME/bin, and i think that's the correct directory.
Again, thanks for the fast reply :)
2010/5/5 Bryan Pendleton <bp...@gmail.com>
> On 05/04/2010 07:54 PM, Fabricio Pedroso Jorge wrote:
>
>> Thats the problem: i simply can't connect mai client to the server..
>>
>
> On your server machine, when starting the Network Server, did you
> pass the '-h' argument?
>
> If you didn't, that's probably the problem.
>
> thanks,
>
> bryan
>
--
Atenciosamente,
Fabrício Pedroso Jorge.
Programador de Sistemas Júnior - SEFA-PA
Bacharel em Ciência da Computação - CESUPA
Resumo Profissional:
http://br.linkedin.com/pub/fabricio-jorge/19/554/58b
Re: Problems to use Derby Network Server
Posted by Bryan Pendleton <bp...@gmail.com>.
On 05/04/2010 07:54 PM, Fabricio Pedroso Jorge wrote:
> Thats the problem: i simply can't connect mai client to the server..
On your server machine, when starting the Network Server, did you
pass the '-h' argument?
If you didn't, that's probably the problem.
thanks,
bryan