[castor-dev] tomcat/hsqldb/castor configuration help

[Stephen Ince]

Has anyone done any tomcat 4.1.x/apache DB common 1.1 /hsqldb/castor? I would like to take a look at your database configuration for your webapp. I seem to have a update performance  problem. I have an object that makes 10,000 database updates.  When I update the object at the command line it does fine, 0-10 milliseconds per update. When I update the object through the webapp running on Tomcat I degrade to 100-150 milliseconds per update. The only difference is tomcat. In both cases I am using org.apache.commons.dbcp.BasicDataSource for a datasource. The inserts into database are a lot faster,  0 - 10 milliseconds.     Tomcat datasource configuration:   ---------------------------------------------------------------------------------------------------------------------------- <ResourceParams name="jdbc/ods"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>maxActive</name> <value>100</value> </parameter> <parameter> <name>maxIdle</name> <value>30</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>username</name> <value>sa</value> </parameter> <parameter> <name>password</name> <value></value> </parameter> <parameter> <name>driverClassName</name> <value>org.hsqldb.jdbcDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:hsqldb:C:/openload/modules/hsqldb/ods</value> </parameter> </ResourceParams> ----------------------------------------------------------------------------------------------------------------------------     Command line Datasource configuration: -----------------------------------------------------------------------------------------------------------------------------     public static DataSource createDataSource( String driverClassName, String url , String user, String password ) {         org.apache.commons.dbcp.BasicDataSource dataSource = new org.apache.commons.dbcp.BasicDataSource();         dataSource.setDriverClassName(driverClassName);         dataSource.setUrl( url );                 if ( user != null ) dataSource.setUsername( user );         if ( password != null ) dataSource.setPassword( password );         return dataSource;     }     Steve