[opencms-dev] OpenCMS 5.0b in Oracle 8.1.7?

Thomas Gick thomasgick at web.de
Fri Oct 4 10:07:16 CEST 2002 

Hi list,

does anybody already runs OpenCMS 5.0b against Oracle 8.1.7?

My Runtime Environment:

OpenCMS 5.0b
Oracle 8.1.7 (runs with UTF8)
RedHat Linux 7.3
Apache Tomcat 4.0.4
JDK 1.4.1 RC1
Oracle Driver: ojdbc14_g.jar ( in build.inputlib.oracle changed)

I can install Opencms but after restarting tomcat afterwards i cannot login anymore as admin:
I get the following error:

[CmsException]: 4 Sql exception. Detailed Error: [com.opencms.file.genericSql.CmsDbAccess]Fail to convert between UTF8 and UCS2: failUTF8Conv. Caught Exception: >java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv<
	at com.opencms.file.genericSql.CmsDbAccess.readUser(CmsDbAccess.java:10165)
	at com.opencms.file.genericSql.CmsResourceBroker.loginUser(CmsResourceBroker.java:4279)
	at com.opencms.file.CmsObject.loginUser(CmsObject.java:2256)
	at com.opencms.workplace.CmsLogin.getContent(CmsLogin.java:169)
	at com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:167)
	at com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:171)
	at com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache.java:148)
	at com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:253)
	at com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:309)
	at com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:267)
	at com.opencms.core.OpenCms.showResource(OpenCms.java:684)
	at com.opencms.core.OpenCmsHttpServlet.doPost(OpenCmsHttpServlet.java:285)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	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:243)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
	at java.lang.Thread.run(Thread.java:536)
>java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
>	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
>	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
>	at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
>	at oracle.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:2261)
>	at oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(DBConversion.java:2046)
>	at oracle.jdbc.dbaccess.DBConversion.charBytesToJavaChars(DBConversion.java:878)
>	at oracle.jdbc.dbaccess.DBConversion.CHARBytesToJavaChars(DBConversion.java:807)
>	at oracle.jdbc.ttc7.TTCItem.getChars(TTCItem.java:298)
>	at oracle.jdbc.dbaccess.DBDataSetImpl.getCharsItem(DBDataSetImpl.java:1493)
>	at oracle.jdbc.driver.OracleStatement.getCharsInternal(OracleStatement.java:3354)
>	at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3556)
>	at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:434)
>	at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
>	at com.opencms.file.genericSql.CmsDbAccess.readUser(CmsDbAccess.java:10136)
>	at com.opencms.file.genericSql.CmsResourceBroker.loginUser(CmsResourceBroker.java:4279)
>	at com.opencms.file.CmsObject.loginUser(CmsObject.java:2256)
>	at com.opencms.workplace.CmsLogin.getContent(CmsLogin.java:169)
>	at com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:167)
>	at com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:171)
>	at com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache.java:148)
>	at com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:253)
>	at com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:309)
>	at com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:267)
>	at com.opencms.core.OpenCms.showResource(OpenCms.java:684)
>	at com.opencms.core.OpenCmsHttpServlet.doPost(OpenCmsHttpServlet.java:285)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
>	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
>	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:243)
>	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
>	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
>	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
>	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
>	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
>	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
>	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
>	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
>	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
>	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
>	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
>	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
>	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
>	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
>	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
>	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
>	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
>	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
>	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
>	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
>	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
>	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
>	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
>	at java.lang.Thread.run(Thread.java:536)

java.sql.SQLException: Fail to convert between UTF8 and UCS2: failUTF8Conv
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
	at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1130)
	at oracle.jdbc.dbaccess.DBConversion.failUTF8Conv(DBConversion.java:2261)
	at oracle.jdbc.dbaccess.DBConversion.utf8BytesToJavaChars(DBConversion.java:2046)
	at oracle.jdbc.dbaccess.DBConversion.charBytesToJavaChars(DBConversion.java:878)
	at oracle.jdbc.dbaccess.DBConversion.CHARBytesToJavaChars(DBConversion.java:807)
	at oracle.jdbc.ttc7.TTCItem.getChars(TTCItem.java:298)
	at oracle.jdbc.dbaccess.DBDataSetImpl.getCharsItem(DBDataSetImpl.java:1493)
	at oracle.jdbc.driver.OracleStatement.getCharsInternal(OracleStatement.java:3354)
	at oracle.jdbc.driver.OracleStatement.getStringValue(OracleStatement.java:3556)
	at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:434)
	at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
	at com.opencms.file.genericSql.CmsDbAccess.readUser(CmsDbAccess.java:10136)
	at com.opencms.file.genericSql.CmsResourceBroker.loginUser(CmsResourceBroker.java:4279)
	at com.opencms.file.CmsObject.loginUser(CmsObject.java:2256)
	at com.opencms.workplace.CmsLogin.getContent(CmsLogin.java:169)
	at com.opencms.template.cache.CmsElementXml.getContent(CmsElementXml.java:167)
	at com.opencms.template.cache.CmsUri.callCanonicalRoot(CmsUri.java:171)
	at com.opencms.template.cache.CmsElementCache.callCanonicalRoot(CmsElementCache.java:148)
	at com.opencms.launcher.CmsXmlLauncher.generateOutput(CmsXmlLauncher.java:253)
	at com.opencms.launcher.CmsXmlLauncher.launch(CmsXmlLauncher.java:309)
	at com.opencms.launcher.A_CmsLauncher.initlaunch(A_CmsLauncher.java:267)
	at com.opencms.core.OpenCms.showResource(OpenCms.java:684)
	at com.opencms.core.OpenCmsHttpServlet.doPost(OpenCmsHttpServlet.java:285)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	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:243)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2347)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
	at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
	at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1027)
	at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1125)
	at java.lang.Thread.run(Thread.java:536)



Please help

Thomas


______________________________________________________________________________
Den Komfort von WEB.DE FreeMail nutzen, aber die alten E-Mail-Adressen nicht
aufgeben? Kein Problem: http://freemail.web.de/?mc=021128

More information about the opencms-dev mailing list