c oracle nullable,oracle 19c作为知识库的问题

(本文档仅供参考)

问题

使用部分版本的oracle19c作为知识库部署V95时，使用smartbi.war自带的驱动测试连接失败

解决方案

需要更换驱动jar：_JDBC_oracle_ojdbc8.jar，用这个驱动替换已经有的驱动_JDBC_oracle_ojdbc5_11g.jar，另外还需要增加一个jar：orai18n-12.1.0.2.0.jar

如果未添加orai18n-12.1.0.2.0.jar，在部署了Workflow.ext流程引擎扩展包时，升级V95过程中会报如下错误：

流程引擎初始化失败

smartbilibs.org.camunda.bpm.engine.ProcessEngineException: Process engine persistence exception

at smartbilibs.org.camunda.bpm.engine.impl.interceptor.CommandInvocationContext.rethrow(CommandInvocationContext.java:153)

at smartbilibs.org.camunda.bpm.engine.impl.interceptor.CommandContext.close(CommandContext.java:229)

at smartbilibs.org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:119)

at smartbilibs.org.camunda.bpm.engine.impl.interceptor.ProcessApplicationContextInterceptor.execute(ProcessApplicationContextInterceptor.java:70)

at smartbilibs.org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)

at smartbilibs.org.camunda.bpm.engine.impl.ProcessEngineImpl.executeSchemaOperations(ProcessEngineImpl.java:121)

at smartbilibs.org.camunda.bpm.engine.impl.ProcessEngineImpl.(ProcessEngineImpl.java:93)

at smartbilibs.org.camunda.bpm.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:815)

at smartbi.workflow.util.WorkFlowManager.(WorkFlowManager.java:68)

at smartbi.workflow.util.WorkFlowManager.getInstance(WorkFlowManager.java:47)

at smartbi.workflow.WorkflowModule.activate(WorkflowModule.java:80)

at smartbi.framework.Framework.activate(Smartbi:90)

at smartbi.extension.spring.SmartbiContextLoaderListener.contextInitialized(SmartbiContextLoaderListener.java:154)

at com.ibm.ws.webcontainer.webapp.WebApp.notifyServletContextCreated(WebApp.java:1836)

at com.ibm.ws.webcontainer.webapp.WebAppImpl.initialize(WebAppImpl.java:442)

at com.ibm.ws.webcontainer.webapp.WebGroupImpl.addWebApplication(WebGroupImpl.java:88)

at com.ibm.ws.webcontainer.VirtualHostImpl.addWebApplication(VirtualHostImpl.java:171)

at com.ibm.ws.webcontainer.WSWebContainer.addWebApp(WSWebContainer.java:904)

at com.ibm.ws.webcontainer.WSWebContainer.addWebApplication(WSWebContainer.java:789)

at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:427)

at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:719)

at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1248)

at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1578)

at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:704)

at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:1153)

at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:800)

at com.ibm.ws.runtime.component.ApplicationMgrImpl$5.run(ApplicationMgrImpl.java:2317)

at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5574)

at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5700)

at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)

at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2322)

at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:436)

at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123)

at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:379)

at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.access$500(CompositionUnitMgrImpl.java:127)

at com.ibm.ws.runtime.component.CompositionUnitMgrImpl$CUInitializer.run(CompositionUnitMgrImpl.java:985)

at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:524)

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1909)

Caused by:

java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK

at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:233)

at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:194)

at oracle.jdbc.driver.PhysicalConnection.throughDbCharset(PhysicalConnection.java:10365)

at oracle.jdbc.driver.PhysicalConnection.enquoteIdentifier(PhysicalConnection.java:10442)

at oracle.jdbc.driver.OracleStatement.enquoteIdentifier(OracleStatement.java:6452)

at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3853)

at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:270)

at oracle.jdbc.driver.GeneratedResultSet.getString(GeneratedResultSet.java:596)

at smartbilibs.org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:37)

at smartbilibs.org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:26)

at smartbilibs.org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:66)

... 60 more

以及：

ERROR doUpgrade(smartbi.catalogtree.upgrade.UpgradeTask_0_0_4:186) - 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK

java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK

at oracle.sql.CharacterSetUnknown.failCharsetUnknown(CharacterSetFactoryThin.java:233)

at oracle.sql.CharacterSetUnknown.convert(CharacterSetFactoryThin.java:194)

at oracle.jdbc.driver.PhysicalConnection.throughDbCharset(PhysicalConnection.java:10365)

at oracle.jdbc.driver.PhysicalConnection.enquoteIdentifier(PhysicalConnection.java:10442)

at oracle.jdbc.driver.OracleStatement.enquoteIdentifier(OracleStatement.java:6452)

at oracle.jdbc.driver.OracleStatement.getColumnIndex(OracleStatement.java:3853)

at oracle.jdbc.driver.InsensitiveScrollableResultSet.findColumn(InsensitiveScrollableResultSet.java:270)

at oracle.jdbc.driver.GeneratedResultSet.getCharacterStream(GeneratedResultSet.java:720)