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 115186 - Make it possible to specify a different port number for the Java DB server / Derby in multiuser environment
Summary: Make it possible to specify a different port number for the Java DB server / ...
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: Derby (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker with 1 vote (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
: 69636 85467 (view as bug list)
Depends on:
Blocks: 152869
  Show dependency tree
 
Reported: 2007-09-10 21:09 UTC by David Vancouvering
Modified: 2014-10-05 18:12 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description David Vancouvering 2007-09-10 21:09:04 UTC
Right now you can't use NB to specify what port number the Java DB server should listen on (if, for example, the default
port is already taken).

We should add an option (under Tools->Java DB->Settings ?) to specify the port.

Right now here's what you have to do (cut-and-paste from an email on the user list when the user encountered this problem):

* Find out the home location for Java DB.  In NB 6, this is under
Tool->Java DB->Settings->Database Location.  Under NB 5.5 this is
buried under NB preferences->Advanced->IDE Configuration->Server and
External Tool Settings->Java DB Database->Database Location.   By
default it is <home dir>/.netbeans (at least on UNIX/Mac systems).

* In that directory, edit a file named derby.properties

* Add an entry for derby.drda.portNumber with a different port number, e.g.

derby.drda.portNumber=1888

* Restart the Java DB network server (Tools->Java DB Database->Stop
Java DB Server and then Start Java DB Server)

* Change your database URLs for your database connections to specify
the new port number, e.g. "jdbc:derby:localhost:1888/mydb;create=true"
Comment 1 Jiri Rechtacek 2009-10-16 14:14:17 UTC
Reassigned to new owner.
Comment 2 matthias42 2012-08-20 08:47:33 UTC
*** Bug 69636 has been marked as a duplicate of this bug. ***
Comment 3 matthias42 2014-10-05 18:12:54 UTC
*** Bug 85467 has been marked as a duplicate of this bug. ***