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.