<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>hi all</DIV>
<DIV> </DIV>
<DIV>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:</DIV>
<DIV> </DIV>
<DIV><BR>com.opencms.core.CmsException: 4 Sql exception. Detailed error:
[com.opencms.file.mssql.CmsDbAccess] [Microsoft][SQLServer 2000 Driver for
JDBC]Invalid parameter binding(s).. <BR>root cause was java.sql.SQLException:
[Microsoft][SQLServer 2000 Driver for JDBC]Invalid parameter
binding(s).<BR> at
com.opencms.file.genericSql.CmsDbAccess.getFilesInFolder(CmsDbAccess.java:3383)<BR> at
com.opencms.file.genericSql.CmsResourceBroker.helperGetFilesInFolder(CmsResourceBroker.java:4047)<BR> at
com.opencms.file.genericSql.CmsResourceBroker.getFilesInFolder(CmsResourceBroker.java:3331)<BR> at
com.opencms.file.CmsObject.getFilesInFolder(CmsObject.java:1696)<BR> at
com.opencms.workplace.CmsHelperMastertemplates.getTemplateElements(CmsHelperMastertemplates.java:117)<BR> at
com.opencms.workplace.CmsHelperMastertemplates.getTemplates(CmsHelperMastertemplates.java:77)<BR> at
com.opencms.workplace.CmsXmlTemplateEditor.getAvailableTemplates(CmsXmlTemplateEditor.java:164)<BR> at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR> at
java.lang.reflect.Method.invoke(Method.java:324)<BR> at
com.opencms.workplace.CmsSelectBox.handleSpecialWorkplaceTag(CmsSelectBox.java:114)<BR> at
com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplateFile.java:234)<BR> at
sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)<BR> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR> at
java.lang.reflect.Method.invoke(Method.java:324)<BR> at
com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:1515)<BR> at
com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.java:510)<BR> at
com.opencms.template.CmsXmlTemplateFile.generateElementCacheVariant(CmsXmlTemplateFile.java:588)<BR> at
com.opencms.template.CmsXmlTemplate.startProcessing(CmsXmlTemplate.java:1288)<BR> at
com.opencms.workplace.CmsWorkplaceDefault.startProcessing(CmsWorkplaceDefault.java:550)<BR> at
com.opencms.workplace.CmsXmlTemplateEditor.getContent(CmsXmlTemplateEditor.java:731)<BR> at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:171)<BR> at
com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)<BR> at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache.java:149)<BR> at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:285)<BR> at
com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)<BR> at
com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)<BR> at
com.opencms.core.OpenCms.showResource(OpenCms.java:956)<BR> at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)<BR> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)<BR> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)<BR> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)<BR> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR> at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)<BR> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)<BR> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)<BR> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR> at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)<BR> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)<BR> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)<BR> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)<BR> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)<BR> at
java.lang.Thread.run(Thread.java:536)<BR>>-----------<BR>>Root
cause:<BR>>java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC]Invalid parameter binding(s).<BR>> at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)<BR>> at
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)<BR>> at
com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)<BR>> at
com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)<BR>> at
com.microsoft.jdbc.base.BasePreparedStatement.preImplExecute(Unknown
Source)<BR>> at
com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown
Source)<BR>> at
com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown
Source)<BR>> at
com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown
Source)<BR>> at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.java:173)<BR>> at
com.opencms.file.genericSql.CmsDbAccess.getFilesInFolder(CmsDbAccess.java:3348)<BR>> at
com.opencms.file.genericSql.CmsResourceBroker.helperGetFilesInFolder(CmsResourceBroker.java:4047)<BR>> at
com.opencms.file.genericSql.CmsResourceBroker.getFilesInFolder(CmsResourceBroker.java:3331)<BR>> at
com.opencms.file.CmsObject.getFilesInFolder(CmsObject.java:1696)<BR>> at
com.opencms.workplace.CmsHelperMastertemplates.getTemplateElements(CmsHelperMastertemplates.java:117)<BR>> at
com.opencms.workplace.CmsHelperMastertemplates.getTemplates(CmsHelperMastertemplates.java:77)<BR>> at
com.opencms.workplace.CmsXmlTemplateEditor.getAvailableTemplates(CmsXmlTemplateEditor.java:164)<BR>> at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR>> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR>> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>> at
java.lang.reflect.Method.invoke(Method.java:324)<BR>> at
com.opencms.workplace.CmsSelectBox.handleSpecialWorkplaceTag(CmsSelectBox.java:114)<BR>> at
com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplateFile.java:234)<BR>> at
sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)<BR>> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR>> at
java.lang.reflect.Method.invoke(Method.java:324)<BR>> at
com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:1515)<BR>> at
com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.java:510)<BR>> at
com.opencms.template.CmsXmlTemplateFile.generateElementCacheVariant(CmsXmlTemplateFile.java:588)<BR>> at
com.opencms.template.CmsXmlTemplate.startProcessing(CmsXmlTemplate.java:1288)<BR>> at
com.opencms.workplace.CmsWorkplaceDefault.startProcessing(CmsWorkplaceDefault.java:550)<BR>> at
com.opencms.workplace.CmsXmlTemplateEditor.getContent(CmsXmlTemplateEditor.java:731)<BR>> at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:171)<BR>> at
com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)<BR>> at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache.java:149)<BR>> at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:285)<BR>> at
com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)<BR>> at
com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)<BR>> at
com.opencms.core.OpenCms.showResource(OpenCms.java:956)<BR>> at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)<BR>> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)<BR>> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR>> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)<BR>> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)<BR>> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)<BR>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR>> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR>> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR>> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR>> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR>> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR>> at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)<BR>> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)<BR>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR>> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)<BR>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)<BR>> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)<BR>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)<BR>> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR>> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR>> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)<BR>> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR>> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR>> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR>> at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)<BR>> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)<BR>> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)<BR>> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)<BR>> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)<BR>> at
java.lang.Thread.run(Thread.java:536)</DIV>
<DIV> </DIV>
<DIV>java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid
parameter binding(s).<BR> at
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown
Source)<BR> at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown
Source)<BR> at
com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)<BR> at
com.microsoft.jdbc.base.BasePreparedStatement.validateParameters(Unknown
Source)<BR> at
com.microsoft.jdbc.base.BasePreparedStatement.preImplExecute(Unknown
Source)<BR> at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown
Source)<BR> at
com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown
Source)<BR> at
com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown
Source)<BR> at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.java:173)<BR> at
com.opencms.file.genericSql.CmsDbAccess.getFilesInFolder(CmsDbAccess.java:3348)<BR> at
com.opencms.file.genericSql.CmsResourceBroker.helperGetFilesInFolder(CmsResourceBroker.java:4047)<BR> at
com.opencms.file.genericSql.CmsResourceBroker.getFilesInFolder(CmsResourceBroker.java:3331)<BR> at
com.opencms.file.CmsObject.getFilesInFolder(CmsObject.java:1696)<BR> at
com.opencms.workplace.CmsHelperMastertemplates.getTemplateElements(CmsHelperMastertemplates.java:117)<BR> at
com.opencms.workplace.CmsHelperMastertemplates.getTemplates(CmsHelperMastertemplates.java:77)<BR> at
com.opencms.workplace.CmsXmlTemplateEditor.getAvailableTemplates(CmsXmlTemplateEditor.java:164)<BR> at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR> at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR> at
java.lang.reflect.Method.invoke(Method.java:324)<BR> at
com.opencms.workplace.CmsSelectBox.handleSpecialWorkplaceTag(CmsSelectBox.java:114)<BR> at
com.opencms.workplace.CmsXmlWpTemplateFile.handleAnyTag(CmsXmlWpTemplateFile.java:234)<BR> at
sun.reflect.GeneratedMethodAccessor77.invoke(Unknown Source)<BR> at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR> at
java.lang.reflect.Method.invoke(Method.java:324)<BR> at
com.opencms.template.A_CmsXmlContent.processNode(A_CmsXmlContent.java:1515)<BR> at
com.opencms.template.A_CmsXmlContent.getProcessedData(A_CmsXmlContent.java:510)<BR> at
com.opencms.template.CmsXmlTemplateFile.generateElementCacheVariant(CmsXmlTemplateFile.java:588)<BR> at
com.opencms.template.CmsXmlTemplate.startProcessing(CmsXmlTemplate.java:1288)<BR> at
com.opencms.workplace.CmsWorkplaceDefault.startProcessing(CmsWorkplaceDefault.java:550)<BR> at
com.opencms.workplace.CmsXmlTemplateEditor.getContent(CmsXmlTemplateEditor.java:731)<BR> at
com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:171)<BR> at
com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:185)<BR> at
com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache.java:149)<BR> at
com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:285)<BR> at
com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:341)<BR> at
com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:274)<BR> at
com.opencms.core.OpenCms.showResource(OpenCms.java:956)<BR> at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:310)<BR> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:740)<BR> at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)<BR> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)<BR> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)<BR> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR> at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)<BR> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR> at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)<BR> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)<BR> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)<BR> at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)<BR> at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)<BR> at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)<BR> at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)<BR> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)<BR> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)<BR> at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)<BR> at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)<BR> at
java.lang.Thread.run(Thread.java:536)</DIV>
<DIV> </DIV>
<DIV>With rc2 version everything was OK.</DIV>
<DIV> </DIV>
<DIV>Any idea?</DIV>
<DIV> </DIV>
<DIV>Stafano <BR></DIV></FONT></BODY></HTML>