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.
> >
