HI, For read intensive appps II use multi_theaded=1 without problems. You really need lock_mode=0 , their use is not recommended for general use: > > The value 0 means no locking (should only be used for testing; also known as > |READ_UNCOMMITTED|). Please note that using |SET LOCK_MODE| 0 while at the > same time using multiple connections may result in inconsistent transactions. > regards, Dario
El 08/10/10 16:10, Jason Tesser escribió: > lock_mode=0 > > Thanks, > Jason Tesser > dotCMS Lead Development Manager > 1-305-858-1422 > > > > On Fri, Oct 8, 2010 at 3:08 PM, Dario Fassi <[email protected]> wrote: >> Hi, >> I use DBCP on my projects and don't have this problems. >> >> What's your connection URL ? >> Are you using MULTI_THREADED or MVCC mode ? >> >> regards, >> Dario >> >> >> El 08/10/10 15:29, LORDs_diakonos escribió: >>> We are using dbcp to configure db pooling. >>> >>> I have many threads stuck like the one below. Any reason why this >>> would be . Seems like an odd place to be stuck. Does H2 limit the >>> number of connections or something? >>> >>> "TP-Processor41" daemon prio=10 tid=0x00002aad4c60e000 nid=0x4e3f >>> waiting for monitor entry [0x0000000045c83000] >>> java.lang.Thread.State: BLOCKED (on object monitor) >>> at org.h2.command.Command.executeQuery(Command.java:130) >> -- >> 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.
