[opencms-dev] SQL Server Delete Folder Broken
Bruce Norman
bnorman at tibco.com
Wed Feb 18 16:04:02 CET 2004
Thanks for any help. I am using OpenCms 5.01 and have modified the mssql
query.properties as noted in earlier newsgroup suggestions to fix other
similar SQL Server issues. I'm assuming this might be the same issue but I
have not been able to figure it out.
The error returned when trying to delete a folder is:
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:4208)
at
com.opencms.file.genericSql.CmsDbAccess.deleteFolder(CmsDbAccess.java:2073)
at
com.opencms.file.genericSql.CmsResourceBroker.deleteFolder(CmsResourceBroker
.java:2454)
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:147)
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:961)
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:2417)
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:193)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:549)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:666)
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:4182)
> at
com.opencms.file.genericSql.CmsDbAccess.deleteFolder(CmsDbAccess.java:2073)
> at
com.opencms.file.genericSql.CmsResourceBroker.deleteFolder(CmsResourceBroker
.java:2454)
> 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:147)
> 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:961)
> 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:2417)
> 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:193)
> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:549)
> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:666)
> 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:4182)
at
com.opencms.file.genericSql.CmsDbAccess.deleteFolder(CmsDbAccess.java:2073)
at
com.opencms.file.genericSql.CmsResourceBroker.deleteFolder(CmsResourceBroker
.java:2454)
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:147)
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:961)
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:2417)
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:193)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConne
ction(Http11Protocol.java:549)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav
a:666)
at java.lang.Thread.run(Thread.java:534)
-----Original Message-----
From: opencms-dev-admin at opencms.org [mailto:opencms-dev-admin at opencms.org]
On Behalf Of Andras Balogh
Sent: Wednesday, February 18, 2004 12:48 AM
To: opencms-dev at opencms.org
Subject: Re: [opencms-dev] SQL Server Delete Folder Broken
Hello Bruce,
Can you tell which version you are using?
Also posting the exact stack trace of the error will help to see where
the problem is.
Best wishes,
Andras
Bruce Norman wrote:
> Still having a problem resolving ability to delete folder on SQL
> Server implementation. Get Invalid parameter binding(s). If anyone can
> give me pointer how to fix this I'd appreciate it.
>
>
> Thx
>
> Bruce Norman
>
_______________________________________________
This mail is send to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please visit
http://mail.opencms.org/mailman/listinfo/opencms-dev
More information about the opencms-dev
mailing list