Hi, I have one open connection in TCP mode (h2-1.3.152.jar), then
attempting to open another, the server throws:
JdbcSQLException: Cannot change the setting "LOCK_MODE=0 &
MULTI_THREADED" when the database is already open; [90133-152]
Is this throw correct, considering that the URL is the same for the
first and second connection?:
jdbc:h2:tcp://192.168.0.2:9101//var/tomcat/h2db/
netoid;LOCK_MODE=0;MULTI_THREADED=1;DB_CLOSE_ON_EXIT=FALSE;TRACE_LEVEL_FILE=1;MODE=PostgreSQL
Stack is:
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at org.h2.engine.Database.setLockMode(Database.java:1801)
at org.h2.command.dml.Set.update(Set.java:195)
at
org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:212)
at org.h2.engine.Engine.openSession(Engine.java:182)
at org.h2.engine.Engine.createSessionAndValidate(Engine.java:
138)
at org.h2.engine.Engine.createSession(Engine.java:121)
at org.h2.server.TcpServerThread.run(TcpServerThread.java:124)
at java.lang.Thread.run(Thread.java:619)
at org.h2.engine.SessionRemote.done(SessionRemote.java:507)
at org.h2.engine.SessionRemote.initTransfer(SessionRemote.java:
113)
at
org.h2.engine.SessionRemote.connectServer(SessionRemote.java:322)
at
org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:
221)
at
org.h2.engine.SessionRemote.createSession(SessionRemote.java:215)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:111)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:95)
at org.h2.Driver.connect(Driver.java:58)
at java.sql.DriverManager.getConnection(DriverManager.java:
525)
at java.sql.DriverManager.getConnection(DriverManager.java:
171)
.....
Regards,
ken
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
