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.
