I wanted to test it with both Tomcat pool and BoneCP. Below is my config for
Tomcat pool (I did not include any extra jar as it's part of Tomcat).
Here is my resources.xml packaged with my war:
<?xml version="1.0" encoding="UTF-8"?>
<resources>
<Resource id="sportivityDS" type="javax.sql.DataSource"
dataSourceCreator="tomcat">
JdbcDriver org.postgresql.Driver
JdbcUrl jdbc:postgresql://127.0.0.1:5432/db
JtaManaged true
UserName db
Password dbpw
MaxActive 100
InitialSize 2
MaxIdle 25
MinIdle 2
suspectTimeout 60
maxWait 10000
TimeBetweenEvictionRunsMillis 60000
minEvictableIdleTimeMillis 60000
testOnBorrow true
validationInterval 30000
removeAbandoned true
removeAbandonedTimeout 60
logAbandoned true
abandonWhenPercentageFull 60
NumTestsPerEvictionRun 2
ValidationQuery SELECT 1
</Resource>
</resources>
I get below when I start Tomee:
Aug 2, 2012 3:37:54 PM org.apache.tomcat.jdbc.pool.DataSource registerJmx
SEVERE: Unable to register JDBC pool with JMX
java.lang.NullPointerException
at
org.apache.tomcat.jdbc.pool.DataSource.registerJmx(DataSource.java:135)
at
org.apache.tomcat.jdbc.pool.DataSource.preRegister(DataSource.java:102)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.<init>(TomEEDataSourceCreator.java:89)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator.pool(TomEEDataSourceCreator.java:42)
at
org.apache.openejb.resource.jdbc.DataSourceFactory.create(DataSourceFactory.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.apache.xbean.recipe.ReflectionUtil$StaticFactory.create(ReflectionUtil.java:996)
at
org.apache.xbean.recipe.ObjectRecipe.internalCreate(ObjectRecipe.java:276)
at org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:96)
at org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:61)
at org.apache.xbean.recipe.AbstractRecipe.create(AbstractRecipe.java:49)
at
org.apache.openejb.assembler.classic.Assembler.createResource(Assembler.java:1612)
at
org.apache.openejb.config.ConfigurationFactory.install(ConfigurationFactory.java:377)
at
org.apache.openejb.config.AutoConfig.installResource(AutoConfig.java:1813)
at org.apache.openejb.config.AutoConfig.deploy(AutoConfig.java:1475)
at org.apache.openejb.config.AutoConfig.deploy(AutoConfig.java:190)
at
org.apache.openejb.config.ConfigurationFactory$Chain.deploy(ConfigurationFactory.java:342)
at
org.apache.openejb.config.ConfigurationFactory.configureApplication(ConfigurationFactory.java:825)
at
org.apache.tomee.catalina.TomcatWebAppBuilder.startInternal(TomcatWebAppBuilder.java:753)
at
org.apache.tomee.catalina.TomcatWebAppBuilder.configureStart(TomcatWebAppBuilder.java:708)
at
org.apache.tomee.catalina.GlobalListenerSupport.lifecycleEvent(GlobalListenerSupport.java:118)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at
org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
at
org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5173)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at
org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
at
org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
--
View this message in context:
http://openejb.979440.n4.nabble.com/default-tomee-ds-pool-tp4656531p4656637.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
