Hi, I'm using Slide with MYSQL and tried load testing the application with 300 concurrent threads.
I get the following Exception: 18:08:09,271 INFO [STDOUT] http-0.0.0.0-8080-29, 03-Jul-2006 18:08:08, root, ACL, 409 "Conflict", 486 ms, /files/jul_i_188 18:08:09,289 INFO [STDOUT] http-0.0.0.0-8080-9, 03-Jul-2006 18:08:09, root, PROPFIND, 207 "Multi-Status", 32 ms, / 18:08:09,290 INFO [STDOUT] 03 Jul 2006 18:08:09 - org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR - SQL error (0) stateS1009 on /files: Parameter index out of range (173 > number of parameters, which is 172). 18:08:09,293 INFO [STDOUT] java.sql.SQLException: Parameter index out of range (173 > number of parameters, which is 172). 18:08:09,295 INFO [STDOUT] at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:2085 ) 18:08:09,295 INFO [STDOUT] at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:1182) 18:08:09,295 INFO [STDOUT] at org.apache.commons.dbcp.DelegatingPreparedStatement.setString(Delegating PreparedStatement.java:131) 18:08:09,296 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.clearBinding(MySqlRD BMSAdapter.java:227) 18:08:09,296 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Stand ardRDBMSAdapter.java:152) 18:08:09,298 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Stand ardRDBMSAdapter.java:107) 18:08:09,298 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeObject(Abstrac tRDBMSStore.java:432) 18:08:09,298 INFO [STDOUT] at org.apache.slide.store.AbstractStore.storeObject(AbstractStore.java:729) 18:08:09,298 INFO [STDOUT] at org.apache.slide.store.ExtendedStore.storeObject(ExtendedStore.java:629) 18:08:09,298 INFO [STDOUT] at org.apache.slide.structure.StructureImpl.store(StructureImpl.java:479) 18:08:09,298 INFO [STDOUT] at org.apache.slide.structure.StructureImpl.create(StructureImpl.java:368) 18:08:09,299 INFO [STDOUT] at org.apache.slide.webdav.method.MkcolMethod.executeRequest(MkcolMethod.ja va:204) 18:08:09,299 INFO [STDOUT] at org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedirect(Abst ractWebdavMethod.java:583) 18:08:09,299 INFO [STDOUT] at org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMe thod.java:416) 18:08:09,304 INFO [STDOUT] at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:159) 18:08:09,304 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 18:08:09,304 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:252) 18:08:09,304 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) 18:08:09,305 INFO [STDOUT] at org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:147) 18:08:09,305 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202) 18:08:09,305 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) 18:08:09,305 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilte r.java:81) 18:08:09,305 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202) 18:08:09,306 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) 18:08:09,306 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:213) 18:08:09,306 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:178) 18:08:09,306 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipa lValve.java:39) 18:08:09,306 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAs sociationValve.java:153) 18:08:09,306 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator Base.java:482) 18:08:09,306 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.j ava:59) 18:08:09,307 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :126) 18:08:09,307 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :105) 18:08:09,307 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:107) 18:08:09,307 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 48) 18:08:09,307 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85 6) 18:08:09,307 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:744) 18:08:09,308 INFO [STDOUT] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .java:527) 18:08:09,317 INFO [STDOUT] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorker Thread.java:112) 18:08:09,318 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595) 18:08:09,318 INFO [STDOUT] org.apache.slide.common.ServiceAccessException: Service [EMAIL PROTECTED] access error : Parameter index out of range (173 > number of parameters, which is 172). 18:08:09,319 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createException(S tandardRDBMSAdapter.java:1501) 18:08:09,299 INFO [STDOUT] http-0.0.0.0-8080-6, 03-Jul-2006 18:08:08, root, ACL, 200 "OK", 652 ms, /files/jul_i_186 18:08:09,319 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.MySqlRDBMSAdapter.createException(MySq lRDBMSAdapter.java:69) 18:08:09,331 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Stand ardRDBMSAdapter.java:213) 18:08:09,332 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(Stand ardRDBMSAdapter.java:107) 18:08:09,332 INFO [STDOUT] at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeObject(Abstrac tRDBMSStore.java:432) 18:08:09,332 INFO [STDOUT] at org.apache.slide.store.AbstractStore.storeObject(AbstractStore.java:729) 18:08:09,332 INFO [STDOUT] at org.apache.slide.store.ExtendedStore.storeObject(ExtendedStore.java:629) 18:08:09,334 INFO [STDOUT] at org.apache.slide.structure.StructureImpl.store(StructureImpl.java:479) 18:08:09,334 INFO [STDOUT] at org.apache.slide.structure.StructureImpl.create(StructureImpl.java:368) 18:08:09,334 INFO [STDOUT] at org.apache.slide.webdav.method.MkcolMethod.executeRequest(MkcolMethod.ja va:204) 18:08:09,345 INFO [STDOUT] at org.apache.slide.webdav.method.AbstractWebdavMethod.executeRedirect(Abst ractWebdavMethod.java:583) 18:08:09,345 INFO [STDOUT] at org.apache.slide.webdav.method.AbstractWebdavMethod.run(AbstractWebdavMe thod.java:416) 18:08:09,346 INFO [STDOUT] at org.apache.slide.webdav.WebdavServlet.service(WebdavServlet.java:159) 18:08:09,346 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 18:08:09,346 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:252) 18:08:09,346 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) 18:08:09,346 INFO [STDOUT] at org.apache.slide.webdav.filter.LogFilter.doFilter(LogFilter.java:147) 18:08:09,346 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202) 18:08:09,346 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) 18:08:09,346 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilte r.java:81) 18:08:09,346 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica tionFilterChain.java:202) 18:08:09,347 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt erChain.java:173) 18:08:09,347 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv e.java:213) 18:08:09,347 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv e.java:178) 18:08:09,347 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipa lValve.java:39) 18:08:09,347 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAs sociationValve.java:153) 18:08:09,348 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authenticator Base.java:482) 18:08:09,348 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.j ava:59) 18:08:09,348 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java :126) 18:08:09,348 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java :105) 18:08:09,348 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve. java:107) 18:08:09,349 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1 48) 18:08:09,349 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85 6) 18:08:09,349 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC onnection(Http11Protocol.java:744) 18:08:09,349 INFO [STDOUT] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint .java:527) 18:08:09,349 INFO [STDOUT] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorker Thread.java:112) 18:08:09,350 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595) Am totally clueless as to why I get the ServiceAccessException. Any help in the regard will be really appreciated. Thanks, Shobana This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. Visit us at http://www.cognizant.com
