you can use it for all properties if you want - Romain
2012/8/9 Filip Hanik (mailing lists) <[email protected]> > And the = sign right? > > > -----Original Message----- > > From: Romain Manni-Bucau [mailto:[email protected]] > > Sent: Thursday, August 09, 2012 11:32 AM > > To: [email protected] > > Subject: Re: default tomee ds pool > > > > 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.ConnectionStat > > e;org.apache.tomcat.jdbc.pool.interceptor.SlowQueryReportJmx(threshold=1 > > 000,maxQueries=1500); > > > > > > > > > > > org.apache.tomcat.jdbc.pool.interceptor.StatementCache(prepared=true,cal > > lable=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.getInte > > rceptorClass(PoolProperties.java:944) > > > at > > > > > org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:468) > > > at > > > > > org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:14 > > 3) > > > at > > > > > > > > org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy. > > java:116) > > > at > > > > > > > > org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.j > > ava:103) > > > at > > > > > > > > org.apache.tomee.jdbc.TomEEDataSourceCreator$TomEEDataSource.<init>(TomE > > EDataSourceCreator.java:112) > > > at > > > > > > > > org.apache.tomee.jdbc.TomEEDataSourceCreator.pool(TomEEDataSourceCreator > > .java:49) > > > at > > > > > > > > org.apache.openejb.resource.jdbc.DataSourceFactory.create(DataSourceFact > > ory.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(ReflectionUt > > il.java:996) > > > at > > > > > org.apache.xbean.recipe.ObjectRecipe.internalCreate(ObjectRecipe.java:27 > > 6) > > > 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(ConfigurationFact > > ory.java:377) > > > at > > > > > org.apache.openejb.config.AutoConfig.installResource(AutoConfig.java:181 > > 3) > > > 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(Configuratio > > nFactory.java:342) > > > at > > > > > > > > org.apache.openejb.config.ConfigurationFactory.configureApplication(Conf > > igurationFactory.java:825) > > > at > > > > > > > > org.apache.tomee.catalina.TomcatWebAppBuilder.startInternal(TomcatWebApp > > Builder.java:781) > > > at > > > > > > > > org.apache.tomee.catalina.TomcatWebAppBuilder.configureStart(TomcatWebAp > > pBuilder.java:736) > > > at > > > > > > > > org.apache.tomee.catalina.GlobalListenerSupport.lifecycleEvent(GlobalLis > > tenerSupport.java:118) > > > at > > > > > > > > org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSu > > pport.java:119) > > > at > > > > > > > > org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase. > > java:90) > > > at > > > > > > > > org.apache.catalina.core.StandardContext.startInternal(StandardContext.j > > ava:5173) > > > at > > > org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150) > > > at > > > > > > > > org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.jav > > a:1559) > > > at > > > > > > > > org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.jav > > a: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. > > > > >
