Thanks Romain. I used this in resources.xml:
<?xml version="1.0" encoding="UTF-8"?>
<resources>
<Resource id="sportingDS" type="javax.sql.DataSource">
DataSourceCreator tomcat
JdbcDriver org.postgresql.Driver
JdbcUrl jdbc:postgresql://127.0.0.1:5432/sporting
JtaManaged true
UserName userme
Password psw
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
ValidationQuery SELECT 1
jmxEnabled true
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReportJmx(threshold=1000,maxQueries=1500);
org.apache.tomcat.jdbc.pool.interceptor.StatementCache(prepared=true,callable=false,max=100)"
</Resource>
</resources>
I get below error when starting Tomee. I can see all classes listed in
jdbcInterceptors property in tomee/lib/tomcat-jdbc.jar. How come they'er not
found?
WARNING: Tomcat-jdbc doesn't support 'MaxOpenPreparedStatements' property,
please configure the StatementCache jdbc interceptor
Aug 9, 2012 1:07:56 PM org.apache.tomee.jdbc.TomEEDataSourceCreator
updateProperties
WARNING: Tomcat-jdbc doesn't support 'PoolPreparedStatements' property,
please configure the StatementCache jdbc interceptor
Aug 9, 2012 1:07:56 PM org.apache.tomcat.jdbc.pool.ConnectionPool init
SEVERE: Unable to inform interceptor of pool start.
java.lang.ClassNotFoundException:
"org.apache.tomcat.jdbc.pool.interceptor.ConnectionState
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at
org.apache.tomcat.jdbc.pool.PoolProperties$InterceptorDefinition.getInterceptorClass(PoolProperties.java:944)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468)
at
org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
at
org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.<init>(TomEEDataSourceCreator.java:112)
at
org.apache.tomee.jdbc.TomEEDataSourceCreator.pool(TomEEDataSourceCreator.java:49)
at
org.apache.openejb.resource.jdbc.DataSourceFactory.create(DataSourceFactory.java:102)
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:1633)
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:781)
at
org.apache.tomee.catalina.TomcatWebAppBuilder.configureStart(TomcatWebAppBuilder.java:736)
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-tp4656531p4656756.html
Sent from the OpenEJB Dev mailing list archive at Nabble.com.
