[opencms-dev] sql server version 5 error

Stefano Morando smorando at dartway.com
Wed May 7 10:54:02 CEST 2003


hi all

installing the final release of Opencms with mssql server and microsoft jdbc driver, the install phase is OK but when we enter in the workplace we have a lot of database errors like this:


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.getFilesInFolder(CmsDbAccess.java:3383)
 at com.opencms.file.genericSql.CmsResourceBroker.helperGetFilesInFolder(CmsResourceBroker.java:4047)
 at com.opencms.file.genericSql.CmsResourceBroker.getFilesInFolder(CmsResourceBroker.java:3331)
 at com.opencms.file.CmsObject.getFilesInFolder(CmsObject.java:1696)
 at com.opencms.workplace.CmsHelperMastertemplates.getTemplateElements(CmsHelperMastertemplates.java:117)
 at com.opencms.workplace.CmsHelperMastertemplates.getTemplates(CmsHelperMastertemplates.java:77)
 at com.opencms.workplace.CmsXmlTemplateEditor.getAvailableTemplates(CmsXmlTemplateEditor.java:164)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at com.opencms.workplace.CmsSelectBox.handleSpecialWorkplaceTag(CmsSelectBox.java:114)
 at com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplateFile.java:234)
 at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:1515)
 at com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.java:510)
 at com.opencms.template.CmsXmlTemplateFile.generateElementCacheVariant(CmsXmlTemplateFile.java:588)
 at com.opencms.template.CmsXmlTemplate.startProcessing(CmsXmlTemplate.java:1288)
 at com.opencms.workplace.CmsWorkplaceDefault.startProcessing(CmsWorkplaceDefault.java:550)
 at com.opencms.workplace.CmsXmlTemplateEditor.getContent(CmsXmlTemplateEditor.java:731)
 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(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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:432)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
 at java.lang.Thread.run(Thread.java:536)
>-----------
>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.java:173)
> at com.opencms.file.genericSql.CmsDbAccess.getFilesInFolder(CmsDbAccess.java:3348)
> at com.opencms.file.genericSql.CmsResourceBroker.helperGetFilesInFolder(CmsResourceBroker.java:4047)
> at com.opencms.file.genericSql.CmsResourceBroker.getFilesInFolder(CmsResourceBroker.java:3331)
> at com.opencms.file.CmsObject.getFilesInFolder(CmsObject.java:1696)
> at com.opencms.workplace.CmsHelperMastertemplates.getTemplateElements(CmsHelperMastertemplates.java:117)
> at com.opencms.workplace.CmsHelperMastertemplates.getTemplates(CmsHelperMastertemplates.java:77)
> at com.opencms.workplace.CmsXmlTemplateEditor.getAvailableTemplates(CmsXmlTemplateEditor.java:164)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at com.opencms.workplace.CmsSelectBox.handleSpecialWorkplaceTag(CmsSelectBox.java:114)
> at com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplateFile.java:234)
> at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:324)
> at com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:1515)
> at com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.java:510)
> at com.opencms.template.CmsXmlTemplateFile.generateElementCacheVariant(CmsXmlTemplateFile.java:588)
> at com.opencms.template.CmsXmlTemplate.startProcessing(CmsXmlTemplate.java:1288)
> at com.opencms.workplace.CmsWorkplaceDefault.startProcessing(CmsWorkplaceDefault.java:550)
> at com.opencms.workplace.CmsXmlTemplateEditor.getContent(CmsXmlTemplateEditor.java:731)
> 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(ApplicationFilterChain.java:247)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)
> at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
> at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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:432)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
> at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
> at java.lang.Thread.run(Thread.java:536)

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.java:173)
 at com.opencms.file.genericSql.CmsDbAccess.getFilesInFolder(CmsDbAccess.java:3348)
 at com.opencms.file.genericSql.CmsResourceBroker.helperGetFilesInFolder(CmsResourceBroker.java:4047)
 at com.opencms.file.genericSql.CmsResourceBroker.getFilesInFolder(CmsResourceBroker.java:3331)
 at com.opencms.file.CmsObject.getFilesInFolder(CmsObject.java:1696)
 at com.opencms.workplace.CmsHelperMastertemplates.getTemplateElements(CmsHelperMastertemplates.java:117)
 at com.opencms.workplace.CmsHelperMastertemplates.getTemplates(CmsHelperMastertemplates.java:77)
 at com.opencms.workplace.CmsXmlTemplateEditor.getAvailableTemplates(CmsXmlTemplateEditor.java:164)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at com.opencms.workplace.CmsSelectBox.handleSpecialWorkplaceTag(CmsSelectBox.java:114)
 at com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplateFile.java:234)
 at sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:324)
 at com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:1515)
 at com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.java:510)
 at com.opencms.template.CmsXmlTemplateFile.generateElementCacheVariant(CmsXmlTemplateFile.java:588)
 at com.opencms.template.CmsXmlTemplate.startProcessing(CmsXmlTemplate.java:1288)
 at com.opencms.workplace.CmsWorkplaceDefault.startProcessing(CmsWorkplaceDefault.java:550)
 at com.opencms.workplace.CmsXmlTemplateEditor.getContent(CmsXmlTemplateEditor.java:731)
 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(ApplicationFilterChain.java:247)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.java:191)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(StandardPipeline.java:643)
 at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
 at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(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.invokeNext(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:432)
 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
 at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
 at java.lang.Thread.run(Thread.java:536)

With rc2 version everything was OK.

Any idea?

Stafano 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20030507/b115c80e/attachment.html>


More information about the opencms-dev mailing list