Hello,
I have managed to configure H2 in Tomcat JNDI using several
approaches. My question is which do you think is the better/best
setup?
All of these are working. Any input is much appreciated. Thanks!
<Resource
name="jdbc/h2"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory"
type="javax.sql.DataSource"
url="jdbc:h2:tcp://localhost/~/test"
driverClassName="org.h2.jdbcx.JdbcDataSource"
username="sa"
password=""
maxActive="100"
maxIdle="20" />
<Resource auth="Container"
driverClass="org.h2.Driver"
maxPoolSize="100" minPoolSize="10" acquireIncrement="2"
name="jdbc/H2c3p0" user="sa" password=""
factory="org.apache.naming.factory.BeanFactory"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
jdbcUrl="jdbc:h2:tcp://localhost/~/test" />
<Resource auth="Container"
driverClass="org.h2.jdbcx.JdbcDataSource"
maxPoolSize="100" minPoolSize="10" acquireIncrement="2"
name="jdbc/H2c3p0x" user="sa" password=""
factory="org.apache.naming.factory.BeanFactory"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
jdbcUrl="jdbc:h2:tcp://localhost/~/test" />
<Resource auth="Container"
driverClass="org.h2.Driver"
maxPoolSize="100" minPoolSize="10" acquireIncrement="2"
name="jdbc/H2cp" user="sa" password=""
factory="org.apache.naming.factory.BeanFactory"
type="com.mchange.v2.c3p0.ComboPooledDataSource"
jdbcUrl="jdbc:h2:tcp://localhost/~/test" />
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
