[opencms-dev] Deleting folders on OpenCMS and SQL Server (Eva?)

[Lex van Sonderen]

Hello,

We installed OpenCMS on Win2K, Tomcat and SQL Server using the excellent
tips from Eva.
Everything works fine until I tried to delete a folder.  I got the included
exception.  Did anybody have the same problem?  Eva maybe?

Best,

Lex van Sonderen - Halotec Interactive - Netherlands
----------------------------------------------------
com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.mssql.CmsDbAccess] [Microsoft][SQLServer 2000 Driver for
JDBC]Invalid parameter binding(s)..
root cause was java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Invalid parameter binding(s).
 at
com.opencms.file.genericSql.CmsDbAccess.getSubFolders(CmsDbAccess.java:4207)
 at
com.opencms.file.genericSql.CmsDbAccess.removeFolder(CmsDbAccess.java:10445)
 at
com.opencms.file.genericSql.CmsResourceBroker.deleteFolder(CmsResourceBroker
.java:2452)
 at com.opencms.file.CmsObject.doDeleteFolder(CmsObject.java:1283)
 at
com.opencms.file.CmsResourceTypeFolder.deleteResource(CmsResourceTypeFolder.
java:647)
 at com.opencms.file.CmsObject.deleteResource(CmsObject.java:1256)
 at com.opencms.workplace.CmsDelete.getContent(CmsDelete.java:146)
 at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:171)
 at com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)
 at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache
.java:149)
 at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:285)
 at com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)
 at com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)
 at com.opencms.core.OpenCms.showResource(OpenCms.java:956)
 at com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
 at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
 at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
 at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
 at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
 at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
 at java.lang.Thread.run(Thread.java:534)
>-----------
>Root cause:
>java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid
parameter binding(s).
> at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
> at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
> at
com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)
> at
com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)
> at com.microsoft.jdbc.base.BasePreparedStatement.preImplExecute(Unknown
Source)
> at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
> at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown
Source)
> at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown
Source)
> at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.ja
va:173)
> at
com.opencms.file.genericSql.CmsDbAccess.getSubFolders(CmsDbAccess.java:4181)
> at
com.opencms.file.genericSql.CmsDbAccess.removeFolder(CmsDbAccess.java:10445)
> at
com.opencms.file.genericSql.CmsResourceBroker.deleteFolder(CmsResourceBroker
.java:2452)
> at com.opencms.file.CmsObject.doDeleteFolder(CmsObject.java:1283)
> at
com.opencms.file.CmsResourceTypeFolder.deleteResource(CmsResourceTypeFolder.
java:647)
> at com.opencms.file.CmsObject.deleteResource(CmsObject.java:1256)
> at com.opencms.workplace.CmsDelete.getContent(CmsDelete.java:146)
> at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:171)
> at com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)
> at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache
.java:149)
> at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:285)
> at com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)
> at com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)
> at com.opencms.core.OpenCms.showResource(OpenCms.java:956)
> at com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
> at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
> at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
> at java.lang.Thread.run(Thread.java:534)

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid
parameter binding(s).
 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
 at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
 at com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)
 at com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)
 at com.microsoft.jdbc.base.BasePreparedStatement.preImplExecute(Unknown
Source)
 at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
 at com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown
Source)
 at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown
Source)
 at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.ja
va:173)
 at
com.opencms.file.genericSql.CmsDbAccess.getSubFolders(CmsDbAccess.java:4181)
 at
com.opencms.file.genericSql.CmsDbAccess.removeFolder(CmsDbAccess.java:10445)
 at
com.opencms.file.genericSql.CmsResourceBroker.deleteFolder(CmsResourceBroker
.java:2452)
 at com.opencms.file.CmsObject.doDeleteFolder(CmsObject.java:1283)
 at
com.opencms.file.CmsResourceTypeFolder.deleteResource(CmsResourceTypeFolder.
java:647)
 at com.opencms.file.CmsObject.deleteResource(CmsObject.java:1256)
 at com.opencms.workplace.CmsDelete.getContent(CmsDelete.java:146)
 at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:171)
 at com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)
 at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache
.java:149)
 at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:285)
 at com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)
 at com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)
 at com.opencms.core.OpenCms.showResource(OpenCms.java:956)
 at com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:256)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:191)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180
)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
 at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:171)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172
)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:641)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:174)
 at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invok
eNext(StandardPipeline.java:643)
 at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
 at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
 at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
 at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
 at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:392)
 at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
 at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:619)
 at java.lang.Thread.run(Thread.java:534)