i have a name mapped to my IP address called "j2m3world.servehttp.com" using a no-ip dynamic update client. have added derby to the list of exceptions in windows firewall. i have configured my modem to run in bridged mode,so there is no question of forwarding ports. i start derby with the option -h 0.0.0.0
but still nothing seems to work. i dont know what more i have to do. please help. Thanks, Varun.M Kristian Waagan-4 wrote: > > musky wrote: >> I am trying to run the derby network server on one machine and trying to >> access the database on that machine from another machine. >> >> just for testing purposes,on the client program i give the IP address of >> the >> server machine(found out by going to findmyip.com). >> > Hello, > > As I'm sure you know, opening the database up to Internet access has > some security implications. > Now, if you want to do it, there are two things that must be done: > 1) Make sure the traffic can reach your database host from the Internet > (depending on your network setup, this might include > router/modem/firewall configuration etc) > 2) Make the Derby network server accept connection from the outside. > > Regarding point 2, by default Derby only allows connections from the > local host. You can change this with the -h option, specifying an IP > address or a host name. There is also a special value you can specify, > which makes Derby listen to / accept everything. > > > hope this helps, > -- > Kristian > >> When i try to connect using DriverManager.getconnection(URL),it gives me >> the >> following stacktrace: >> >> Cannot load Databasejava.sql.SQLNonTransientConnectionException: >> java.net.ConnectException : Error connecting to server 59.96.37.195 on >> port >> 1527 with message Connection refused: connect. >> java.sql.SQLNonTransientConnectionException: java.net.ConnectException : >> Error connecting to server 59.96.37.195 on port 1527 with message >> Connection >> refused: connect. >> at >> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown >> Source) >> at org.apache.derby.client.am.SqlException.getSQLException(Unknown >> Source) >> at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source) >> at java.sql.DriverManager.getConnection(Unknown Source) >> at java.sql.DriverManager.getConnection(Unknown Source) >> at GUIModules.DataBaseClass.createConnection(DataBaseClass.java:31) >> at >> GUIModules.GeneralLoginGUIClass$2.widgetSelected(GeneralLoginGUIClass.java:104) >> at >> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) >> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) >> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) >> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) >> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) >> at GUIModules.ShellClass.eventloop(ShellClass.java:53) >> at >> GUIModules.GeneralLoginEventLoop.generalloginshelleventloop(GeneralLoginEventLoop.java:28) >> at GUIModules.DefaultMain.main(DefaultMain.java:11) >> Caused by: org.apache.derby.client.am.DisconnectException: >> java.net.ConnectException : Error connecting to server 59.96.37.195 on >> port >> 1527 with message Connection refused: connect. >> at org.apache.derby.client.net.NetAgent.<init>(Unknown Source) >> at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source) >> at org.apache.derby.client.am.Connection.<init>(Unknown Source) >> at org.apache.derby.client.net.NetConnection.<init>(Unknown Source) >> at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source) >> at >> org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown >> Source) >> ... 13 more >> Caused by: java.net.ConnectException: Connection refused: connect >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> at java.net.PlainSocketImpl.doConnect(Unknown Source) >> at java.net.PlainSocketImpl.connectToAddress(Unknown Source) >> at java.net.PlainSocketImpl.connect(Unknown Source) >> at java.net.SocksSocketImpl.connect(Unknown Source) >> at java.net.Socket.connect(Unknown Source) >> at java.net.Socket.connect(Unknown Source) >> at java.net.Socket.<init>(Unknown Source) >> at java.net.Socket.<init>(Unknown Source) >> at javax.net.DefaultSocketFactory.createSocket(Unknown Source) >> at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) >> at java.security.AccessController.doPrivileged(Native Method) >> ... 19 more >> java.lang.NullPointerException >> at >> GUIModules.GeneralLoginGUIClass$2.widgetSelected(GeneralLoginGUIClass.java:108) >> at >> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) >> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) >> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) >> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) >> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) >> at GUIModules.ShellClass.eventloop(ShellClass.java:53) >> at >> GUIModules.GeneralLoginEventLoop.generalloginshelleventloop(GeneralLoginEventLoop.java:28) >> at GUIModules.DefaultMain.main(DefaultMain.java:11) >> Cannot load Databasejava.sql.SQLNonTransientConnectionException: >> java.net.ConnectException : Error connecting to server 59.96.37.195 on >> port >> 1527 with message Connection refused: connect. >> java.sql.SQLNonTransientConnectionException: java.net.ConnectException : >> Error connecting to server 59.96.37.195 on port 1527 with message >> Connection >> refused: connect. >> at >> org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown >> Source) >> at org.apache.derby.client.am.SqlException.getSQLException(Unknown >> Source) >> at org.apache.derby.jdbc.ClientDriver.connect(Unknown Source) >> at java.sql.DriverManager.getConnection(Unknown Source) >> at java.sql.DriverManager.getConnection(Unknown Source) >> at GUIModules.DataBaseClass.createConnection(DataBaseClass.java:31) >> at >> GUIModules.GeneralLoginGUIClass$2.widgetSelected(GeneralLoginGUIClass.java:104) >> at >> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) >> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) >> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) >> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) >> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) >> at GUIModules.ShellClass.eventloop(ShellClass.java:53) >> at >> GUIModules.GeneralLoginEventLoop.generalloginshelleventloop(GeneralLoginEventLoop.java:28) >> at >> GUIModules.GeneralLoginGUIClass$2.widgetSelected(GeneralLoginGUIClass.java:138) >> at >> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) >> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) >> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) >> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) >> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) >> at GUIModules.ShellClass.eventloop(ShellClass.java:53) >> at >> GUIModules.GeneralLoginEventLoop.generalloginshelleventloop(GeneralLoginEventLoop.java:28) >> at GUIModules.DefaultMain.main(DefaultMain.java:11) >> Caused by: org.apache.derby.client.am.DisconnectException: >> java.net.ConnectException : Error connecting to server 59.96.37.195 on >> port >> 1527 with message Connection refused: connect. >> at org.apache.derby.client.net.NetAgent.<init>(Unknown Source) >> at org.apache.derby.client.net.NetConnection.newAgent_(Unknown Source) >> at org.apache.derby.client.am.Connection.<init>(Unknown Source) >> at org.apache.derby.client.net.NetConnection.<init>(Unknown Source) >> at org.apache.derby.client.net.NetConnection40.<init>(Unknown Source) >> at >> org.apache.derby.client.net.ClientJDBCObjectFactoryImpl40.newNetConnection(Unknown >> Source) >> ... 21 more >> Caused by: java.net.ConnectException: Connection refused: connect >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> at java.net.PlainSocketImpl.doConnect(Unknown Source) >> at java.net.PlainSocketImpl.connectToAddress(Unknown Source) >> at java.net.PlainSocketImpl.connect(Unknown Source) >> at java.net.SocksSocketImpl.connect(Unknown Source) >> at java.net.Socket.connect(Unknown Source) >> at java.net.Socket.connect(Unknown Source) >> at java.net.Socket.<init>(Unknown Source) >> at java.net.Socket.<init>(Unknown Source) >> at javax.net.DefaultSocketFactory.createSocket(Unknown Source) >> at org.apache.derby.client.net.OpenSocketAction.run(Unknown Source) >> at java.security.AccessController.doPrivileged(Native Method) >> ... 27 more >> java.lang.NullPointerException >> at >> GUIModules.GeneralLoginGUIClass$2.widgetSelected(GeneralLoginGUIClass.java:108) >> at >> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) >> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) >> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) >> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) >> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) >> at GUIModules.ShellClass.eventloop(ShellClass.java:53) >> at >> GUIModules.GeneralLoginEventLoop.generalloginshelleventloop(GeneralLoginEventLoop.java:28) >> at >> GUIModules.GeneralLoginGUIClass$2.widgetSelected(GeneralLoginGUIClass.java:138) >> at >> org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:227) >> at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:66) >> at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:938) >> at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:3682) >> at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3293) >> at GUIModules.ShellClass.eventloop(ShellClass.java:53) >> at >> GUIModules.GeneralLoginEventLoop.generalloginshelleventloop(GeneralLoginEventLoop.java:28) >> at GUIModules.DefaultMain.main(DefaultMain.java:11) >> > > > -- View this message in context: http://www.nabble.com/Connecting-to-Derby-Network-Server-through-the-Internet-tp17584140p17593553.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
