Hi, Well this is a socket exception, so it doesn't sound like a problem within H2. If I was you, I would check if connecting via telnet is possible.
Regards, Thomas On Wed, Apr 17, 2013 at 1:51 AM, <[email protected]> wrote: > Hi, > > I'm currently using the following URL to start and connect to an H2 > database: > > > jdbc:h2:C:/db/mydb;AUTO_SERVER=TRUE;AUTO_SERVER_PORT=9090;IFEXISTS=TRUE;CIPHER=XTEA > > The following url works fine in the following scenarios: > > 1. I start up one or more java processes each with a connection to the > database > 2. I connect through the H2 Console (no other process can have the > database open) > > > If I try to connect through the H2 Console when another process has the > database open, I get the following exception (if I shut down the other > process the same url and credentials work fine). > > Any ideas what would be causing this? > > Thanks, > Grant > > org.h2.jdbc.JdbcSQLException: Connection is broken: > "java.net.SocketException: Permission denied: connect: 10.222.19.207:9090" > [90067-168] > at > org.h2.message.DbException.getJdbcSQLException(DbException.java:329<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=329&build=168> > ) > at > org.h2.message.DbException.get(DbException.java:158<http://h2database.com/html/source.html?file=org/h2/message/DbException.java&line=158&build=168> > ) > at > org.h2.engine.SessionRemote.connectServer(SessionRemote.java:399<http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=399&build=168> > ) > at > org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:317<http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=317&build=168> > ) > at > org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:108<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=108&build=168> > ) > at > org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:92<http://h2database.com/html/source.html?file=org/h2/jdbc/JdbcConnection.java&line=92&build=168> > ) > at > org.h2.Driver.connect(Driver.java:72<http://h2database.com/html/source.html?file=org/h2/Driver.java&line=72&build=168> > ) > at > org.h2.server.web.WebServer.getConnection(WebServer.java:645<http://h2database.com/html/source.html?file=org/h2/server/web/WebServer.java&line=645&build=168> > ) > at > org.h2.server.web.WebApp.login(WebApp.java:899<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=899&build=168> > ) > at > org.h2.server.web.WebApp.process(WebApp.java:205<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=205&build=168> > ) > at > org.h2.server.web.WebApp.processRequest(WebApp.java:164<http://h2database.com/html/source.html?file=org/h2/server/web/WebApp.java&line=164&build=168> > ) > at > org.h2.server.web.WebThread.process(WebThread.java:137<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=137&build=168> > ) > at > org.h2.server.web.WebThread.run(WebThread.java:93<http://h2database.com/html/source.html?file=org/h2/server/web/WebThread.java&line=93&build=168> > ) > at java.lang.Thread.run(Unknown Source) > Caused by: java.net.SocketException: Permission denied: connect > at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method) > at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source) > at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source) > at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source) > at java.net.AbstractPlainSocketImpl.connect(Unknown Source) > at java.net.PlainSocketImpl.connect(Unknown Source) > at java.net.SocksSocketImpl.connect(Unknown Source) > at java.net.Socket.connect(Unknown Source) > at > org.h2.util.NetUtils.createSocket(NetUtils.java:119<http://h2database.com/html/source.html?file=org/h2/util/NetUtils.java&line=119&build=168> > ) > at > org.h2.util.NetUtils.createSocket(NetUtils.java:100<http://h2database.com/html/source.html?file=org/h2/util/NetUtils.java&line=100&build=168> > ) > at > org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:93<http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=93&build=168> > ) > at > org.h2.engine.SessionRemote.connectServer(SessionRemote.java:395<http://h2database.com/html/source.html?file=org/h2/engine/SessionRemote.java&line=395&build=168> > ) > ... 11 more > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
