This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 136822 - Can't establish connection with remote Derby server
Summary: Can't establish connection with remote Derby server
Status: RESOLVED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: Derby (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks: 98689
  Show dependency tree
 
Reported: 2008-06-09 14:28 UTC by kaa
Modified: 2008-07-29 01:17 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
image (108.41 KB, image/jpeg)
2008-07-03 17:41 UTC, kaa
Details
exception (2.28 KB, text/plain)
2008-07-03 17:41 UTC, kaa
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kaa 2008-06-09 14:28:54 UTC
Product Version: NetBeans IDE Dev (Build 200806081201)
Java: 1.6.0_06; Java HotSpot(TM) Client VM 10.0-b22
System: Windows XP version 5.1 running on x86; MS932;

Steps:
1. Make sure the server is started on machine1.
2. Using another machine2: 
   a) launch NetBeans
   b) add new connection to the sample database using IP address of machine1 with default port number:
      jdbc:derby://IP:1527/sample
      the driver is org.apache.derby.jdbc.ClientDriver
   c) Press OK

There is an error message about refused connection.
Comment 1 kaa 2008-06-09 14:30:11 UTC
default password didn't help
Comment 2 kaa 2008-06-09 14:43:04 UTC
my firewall was temporary disabled.
Comment 3 David Vancouvering 2008-06-09 18:02:51 UTC
Hi, kaa.  Can you connect to the database using another tool, like ij or SQuirreL SQL?
Comment 4 kaa 2008-06-10 13:32:59 UTC
I have no sql clients.
I tried ping the server (129.159.127.69) using telnet:

C:\Sun\nb_0608\bin>telnet 129.159.127.69 1527
Connecting To 129.159.127.69...Could not open connection to the host, on port 1527: Connect failed

Using localhost I was able to do itt.


Comment 5 David Vancouvering 2008-06-16 22:32:02 UTC
It looks like the remote server is not up if you can not telnet to it.  Please verify that the server is up.  Also,
please download SquirrelSQL at http://www.squirrelsql.org/, it's a very easy install, and see if you can connect to the
remote server with Squirrel.
Comment 6 David Vancouvering 2008-07-02 19:37:57 UTC
Hello, kaa. Haven't heard back from you.  Can you please respond, or we'll close the issue since I just don't have
enough information to go on.  Normally Java DB works just fine, so I'm pretty sure it's something in your environment.
Comment 7 kaa 2008-07-03 17:39:52 UTC
Results of experiment: 
1. I downloaded and installed SquirrelSQL client on my WinXp.
2. Added libs with drivers (db-derby-10.4.1.3-lib.zip) to the client.
3. Ran NetBeans on WinXP, started Db server and connected to the sample database using SquirrelSQL.
   Driver: org.apache.derby.jdbc.ClientDriver
4. Ran Netbeans on Solaris 10. Db server looks started there since I was able to connect to the sample database.
5. Got Solaris10 IP using ifconfig, ping from WinXP gave me a replay <1ms
6. On WinXP: disable firewall, tried to connect using the same approach with obtained IP.

Can't connect. Did I missed some steps?
Attaching stack trace from SquirrelSQL and image with connection data.



Comment 8 kaa 2008-07-03 17:41:11 UTC
Created attachment 63899 [details]
image
Comment 9 kaa 2008-07-03 17:41:47 UTC
Created attachment 63900 [details]
exception
Comment 10 David Vancouvering 2008-07-28 23:35:30 UTC
It says the connection is refused, which is what you got with NetBeans as well.

Can you *telnet* to that IP address and port?  So for instance do:

$ telnet 129.159.127.69 1527

does that work?  If it doesn't, it means the server is not up and running on that port.  If it does, it means either
something *else* is listening on that port and doesn't recognize the Derby client and thus refuses the connection, or
there is a problem with the Derby server.

In any case, this is not a NB issue, so I'm closing it.  Please contact me directly via email if you need more help;
alternately you'll find the derby-users alias quite helpful, see http://db.apache.org/derby and select "Community" to
sign up for the mailing list.