umm...I do not think Tomcat security can be the issue as H2 is able to create the 3 files. db, lock and trace. After that it hangs.
@Thomas, yes it hangs I waited for 15 minutes at least and even 45 minutes in some cases. I did not get any idea initially about what was going on, so I kept trying to see something in logs, but no luck. The deployment starts for sometime, until Spring framework initiates hibernate and Hibernate initiates it's data-source. That's it, it hangs and keep waiting there. Tomcat shows 503 for all the applications deployed(Do not think, other applications can be causing problems, as I tried deploying it individually also). On Friday, October 26, 2012 1:24:07 PM UTC+5:30, Tejas Shah wrote: > > I am using H2 with default settings on Red Hat Enterprise Linux and it > causes my tocat server to hang. I created a thread dump and it looks like > H2 keep waiting for gaining lock over the database file. No Exceptions > anywhere. No deadlocks detected in thread dump. I have tried using > sun/Oracle JDK as well as Open JDK. Please note the same application works > fine under Windows 7, ubuntu 12.04 and Cent OS 5.x > > Solution to this was change it to use: FILE_LOCK=SOCKET > > Now, can anybody tell me if I can use this or not? I have a single > application accessing the database. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/aLNMkKCsa4wJ. 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.
