H2 database in Railo

Igal

unread,

Mar 12, 2012, 4:53:18 AM3/12/12

to h2-da...@googlegroups.com

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?

Igal

unread,

Mar 15, 2012, 3:59:57 PM3/15/12

to h2-da...@googlegroups.com

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?

Thomas Mueller

unread,

Mar 19, 2012, 3:23:52 PM3/19/12

to h2-da...@googlegroups.com

Hi,

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?

No.

any idea how to trace the source of this problem?

Yes, I suggest to use the built-in profiling tool, or any other profiling tool, so see what happens. See also the "performance" section in the documentation.