Hi, This is a very dangerous combination (it will corrupt the database) so this shouldn't be allowed. The check didn't work correctly when opening the database the first time (because of the order of settings in the URL). The next version will not allow this (no matter if it's the first or seconds connection).
Regards, Thomas On Wed, May 4, 2011 at 7:58 AM, kensystem <[email protected]> wrote: > 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. > > -- 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.
