`
up2pu
  • 浏览: 223591 次
  • 性别: Icon_minigender_1
  • 来自: 北京
社区版块
存档分类
最新评论

连接Oracle 8i数据库报错

阅读更多
有个系统原来运行在Oracle 9i和10g上,现在需要兼容Oracle 8i的数据库,启动应用报以下错误,经过检查发现,Oracle 11g的驱动无法连接Oracle 8i,把应用中的ojdbc5.jar(Oracle 11g版本)替换成ojdbc14.jar(Oracle 10g或者9i版本)即可。
2011-11-10 12:33:57,615 ERROR [org.springframework.web.context.ContextLoader] - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionAdvisor' defined in ServletContext resource [/WEB-INF/config/applicationContext.xml]: Cannot resolve reference to bean 'transactionInterceptor' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionInterceptor' defined in ServletContext resource [/WEB-INF/config/applicationContext.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in ServletContext resource [/WEB-INF/config/dataSourceContext.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/config/dataAccessContext.xml]: Invocation of init method failed; nested exception is java.lang.ArrayIndexOutOfBoundsException: 7
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionInterceptor' defined in ServletContext resource [/WEB-INF/config/applicationContext.xml]: Cannot resolve reference to bean 'transactionManager' while setting bean property 'transactionManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in ServletContext resource [/WEB-INF/config/dataSourceContext.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/config/dataAccessContext.xml]: Invocation of init method failed; nested exception is java.lang.ArrayIndexOutOfBoundsException: 7
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in ServletContext resource [/WEB-INF/config/dataSourceContext.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/config/dataAccessContext.xml]: Invocation of init method failed; nested exception is java.lang.ArrayIndexOutOfBoundsException: 7
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in ServletContext resource [/WEB-INF/config/dataAccessContext.xml]: Invocation of init method failed; nested exception is java.lang.ArrayIndexOutOfBoundsException: 7
Caused by: java.lang.ArrayIndexOutOfBoundsException: 7
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:989)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
	at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
	at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)
	at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)
	at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1881)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1174)
	at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:871)
	at org.springframework.orm.hibernate3.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:797)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1057)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1024)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:140)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:248)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:950)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:740)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:417)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:140)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:248)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:950)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:740)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:417)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:140)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:248)
	at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:128)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:329)
	at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:97)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:684)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:622)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:381)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:140)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
	at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findCandidateAdvisors(AbstractAdvisorAutoProxyCreator.java:100)
	at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.findEligibleAdvisors(AbstractAdvisorAutoProxyCreator.java:73)
	at org.springframework.aop.framework.autoproxy.AbstractAdvisorAutoProxyCreator.getAdvicesAndAdvisorsForBean(AbstractAdvisorAutoProxyCreator.java:57)
	at org.springframework.aop.framework.autoproxy.AbstractAutoProxyCreator.postProcessAfterInitialization(AbstractAutoProxyCreator.java:255)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:312)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1033)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:421)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:140)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)
	at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)
	at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)
	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)
	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3934)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4429)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:526)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:987)
	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:909)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:495)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1206)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:314)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:722)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
	at org.apache.catalina.core.StandardService.start(StandardService.java:516)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:583)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
分享到:
评论

相关推荐

    Mysql转Oracle软件 DBMover for Mysql to Oracle

    高效直接连接Oracle和Mysql数据库。甚至不需要安装客户端。 向导式操作。 可以保存配置文件。 可以同时连接Mysql和Oracle,直接将数据导入Oracle。也可以保存数据到Dump文件。 功能完善的错误处理机制。记录每一条有...

    linux下连接oracle数据库.docx

    在Linux环境下连接Oracle数据库通常涉及使用Oracle的C++接口,即Oracle Call Interface (OCI)。以下是一些关于这个过程的关键知识点: 1. ** OCI库**:`occi.h`是Oracle OCI C++封装的头文件,它提供了C++类来访问...

    通过oracle客户端配置TNS测试报错问题

    在使用Oracle数据库时,可能会遇到各种连接问题,其中之一就是"ORA-12170:TNS:连接超时"的错误。这个错误通常表明客户端尝试连接到Oracle服务器时,超过了预设的时间限制而未成功建立连接。以下是一些解决这个问题...

    oracle报错大全(珍藏版)

    ### Oracle报错大全(珍藏版) #### ORA-00001: Unique Constraint Violated 当尝试插入或更新违反唯一约束的数据时触发此错误。例如,在具有唯一索引的列上插入重复数据。 #### ORA-00017: Rollback Segment Full...

    oracle管理员教程

    "ORACLE8i数据库管理员.doc"文档可能涵盖了Oracle 8i版本的特定信息。Oracle 8i是2001年发布的一个重要版本,引入了如Internet数据库连接、XML支持和流技术等创新特性。理解这些特性和它们在当时对企业数据库管理的...

    ORACLE DB数据库常见问题解决及诊断技巧集锦-ORACLE DBA故障修复必备手册

    ### ORACLE DB数据库常见问题解决及诊断技巧集锦 #### 关于Oracle数据库问题诊断信息获取 在处理Oracle数据库的问题时,正确地收集相关信息至关重要。以下是一些关键步骤: 1. **确认MAX_DUMP_FILE_SIZE参数设置*...

    将长于4000字符的字符串转化为CLOB类型存入数据库

    - **创建OracleConnection对象**:首先需要创建一个连接到Oracle数据库的对象。 - **创建OracleCommand对象**:接着创建一个用于执行SQL命令的对象。 - **创建OracleParameter对象**:然后创建一个参数对象,并...

    pb连接SQLSERVER2005问题解决

    pb连接SQLSERVER2005,提示如下错误:Unable to load the requested Database interface.Please make sure both the interface and client software are properly installed. 解决办法:下载ntwdblib.dll然后将其copy...

    Oracle 临时表空间使用注意

    Oracle 临时表空间是Oracle数据库管理系统中的一个重要组成部分,主要用于存储执行特定操作时产生的临时数据,例如排序、连接和聚合操作。这些操作在处理大量数据时尤为常见,因此了解临时表空间的使用注意事项对于...

    java编写oracle的存储过程,为什么调用System.in阻塞IO时不起作用?还报错?

    当你从Java应用中调用一个存储过程时,这个调用是通过数据库连接发送的SQL命令完成的。如果存储过程中包含了对System.in的依赖,那么在服务器端是没有上下文来提供输入的,这就会引发错误。 报错的原因可能有以下几...

    Linux上安装Oracle所需的rpm包

    3. **libaio**:异步输入/输出库,Oracle数据库使用libaio进行高效的数据I/O操作。虽然未直接列出,但在安装Oracle时,libaio是必需的,因为它提供了非阻塞I/O的能力,这对于数据库性能至关重要。 4. **pdksh**:...

    SuSE11下安装oracle10g

    - **登录 SQL*Plus**:使用 SQL*Plus 工具登录数据库,验证是否能够成功连接。 - **检查数据库状态**:使用 `status database` 命令查看数据库的状态是否为 OPEN。 ### 总结 本文详细介绍了如何在虚拟机环境下...

    [数据库]处理 Oracle SQL in 超过1000 的解决方案.txt

    由于IN子句中的值超过了1000个,Oracle将会报错,提示超出限制。为了解决这个问题,我们需要采取一些措施来分批处理这些值。 #### 解决方案 一种常见的解决方法是将大列表拆分成多个小列表,并通过多个OR条件连接...

    oracle 存储过程 databaselink 收集

    这里`remote_db_address`应替换为远程数据库的连接字符串,例如`'(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=remote_host)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=remote_service)))'`。...

    oracle客户端安装和plsqldeveloper配置[归纳].pdf

    Oracle客户端安装完毕后,接下来是配置PL/SQL Developer来连接Oracle数据库。PL/SQL Developer是一款强大的Oracle数据库管理工具,用于编写、调试和管理PL/SQL代码。在Windows 7 64位系统上,假设你的Oracle版本为11...

    oracle数据库导入导出命令解析

    由于Oracle8i将相关的可执行文件目录设置为了全局路径,这使得在命令行中直接调用exp.exe和imp.exe成为可能。Oracle的这些工具是用Java编写的,实际的执行是通过调用包装后的类文件完成的。 对于Oracle数据库的导出...

    Oracle中把ArrayOracle中把

    首先,需要加载 Oracle 驱动并建立数据库连接。然后,创建一个 `CallableStatement` 对象,准备调用存储过程 `test1`。关键在于创建 `ArrayDescriptor` 来描述自定义类型,并将 Java List 转换为 Oracle 的 Array ...

    orai18n.jar

    在数据库操作过程中,我们经常会遇到各种字符集相关的错误,其中“java.sql.SQLException: 不支持的字符集”是一个常见的报错信息,尤其当涉及到Oracle数据库时。这个错误通常意味着数据库系统无法识别或处理特定的...

    Oracle的安装过程

    5. 安装Oracle软件:使用`xhost`命令允许本地连接,切换到`oracle`用户,并进入解压后的安装目录,运行`./runInstaller`启动安装程序。在安装过程中选择“软件仅安装”模式,之后可以使用Database Configuration ...

Global site tag (gtag.js) - Google Analytics