any idea why an insert from within a web application will take about a minute while the same insert runs extremely fast from the console?
any idea how to trace the source of this problem? On Monday, March 12, 2012 1:53:18 AM UTC-7, Igal wrote: > > I'm trying to use H2 database in Server mode, so I can access it both from > within Railo (Open Source Application Server - > https://groups.google.com/forum/#!forum/railo ) and in the H2 Console at > the same time. > > I replaced the h2.jar that ships with Railo (version 0.9 from 2006) with a > current version: 1.3.164 > > I added a Datasource into server. > > <data-source allow="511" blob="true" class="org.h2.Driver" clob="true" > connectionTimeout="1" > custom="path=C%3A%5Ch2db-data%5C" > database="testdb" > dsn="jdbc:h2:{path}{database};AUTO_SERVER=TRUE;DB_CLOSE_DELAY=10" host="" > metaCacheTimeout="60000" name="h2test" storage="false" username="sa" > validate="false"/> > > I actually got it to work but every INSERT I do from within Railo takes > about a minute. running the same INSERT from the Console works fast. > > any ideas what I'm doing wrong? > > -- 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/-/1ICrv1Yd9JMJ. 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.
