i'd try to remove the quotes ;) - Romain
2012/8/9 zeeman <[email protected]> > 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. >
