AIX oracle jdbc丢掉问题记载fenghuang - 众发娱乐

AIX oracle jdbc丢掉问题记载fenghuang

2019-02-12 09:21:43 | 作者: 凡梦 | 标签: 问题,驱动,晋级 | 浏览: 4852

转自网上,摘抄

AIX版别 V5.3

ORACLE 版别 10.2.0.1

JDBC Driver版别 10.2.0.1 , 10.2.0.4

DATABASE CONNECT POOL  C3P0

反常信息粗心 error code [17002],。。。, Cause: java.sql.SQLException: Io exception: There is no process to read data written to a pipe



这个过错,无论是对数据库的select、insert或update都存在,怀疑是oracle驱动的问题,由于在oracle官网咱们能够看到诸如此类相应的版别与驱动信息



原以为最好的办法是用oracle版别共同的驱动版别,但通过屡次测验发现,选用高版别的JDBC DRIVER报错的时刻会向后推延久点(10.2.0.1大约1天多后,10.2.0.4粗心两天左右),可问题仍旧不可避免,也许是AIX本身的缺点,但没有证明并给予处理
虽然无法处理本问题;给出通过验证的可行性处理方案:


反常本源:
  JDBC Idle Connection Problems on AIX Platform [ID 472572.1]
  JDBC Connections from E-Business Suite Application Tier Fail with "java.sql.SQLException: Io exception: There is no process to read data written to a pipe." [ID 734293.1]

处理方案:
  晋级AIX 5.3 的 bos.net.tcp.client

详细信息:
  A.检查bos.net.tcp.client版别号
  $ lslpp -l |grep bos.net.tcp.client
  bos.net.tcp.client  5.3.0.50  COMMITTED  TCP/IP Client Support
  bos.net.tcp.client  5.3.0.50  COMMITTED  TCP/IP Client Support
  B.检查体系核版别号
  $ oslevel -r
  5300-05
  C.可晋级到的版别号 bos.net.tcp.client  5.3.0.54
  D.进行晋级作业!











请帮助剖析一下这个报错原因。



2010-12-23 16:22:29 Thread-0 ERROR (cn.com.alcatelsbell.sbg.ps.egov.common.db.ConnectionUtility:139) - Can not get database connection.

java.sql.SQLException: Io exception: There is no process to read data written to a pipe.

  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)

  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)

  at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)

  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)

  at oracle.jdbc.driver.PhysicalConnection. init (PhysicalConnection.java:414)

  at oracle.jdbc.driver.T4CConnection. init (T4CConnection.java:165)

  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)

  at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:297)

  at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:221)

  at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:165)

  at cn.com.alcatelsbell.sbg.ps.egov.common.db.AbstractConnectionUtility.getConnection(AbstractConnectionUtility.java:137)

  at cn.com.alcatelsbell.svg.bm.common.ConnectionUtility.getConnectionOfDW(ConnectionUtility.java:67)

  at cn.com.alcatelsbell.svg.bm.logloader.processor.BDSessionTrafficUtility.importBDUserSessionNMUrlTraffic(BDSessionTrafficUtility.java:48)

  at cn.com.alcatelsbell.svg.bm.logloader.processor.statistics.BDSessionTrafficStatistics.save(BDSessionTrafficStatistics.java:187)

  at cn.com.alcatelsbell.svg.bm.logloader.processor.statistics.ProcessorForStatistics.doProcessing(ProcessorForStatistics.java:173)

  at cn.com.alcatelsbell.svg.bm.logloader.processor.SegmentProcessor.run(SegmentProcessor.java:50)

  at java.lang.Thread.run(Thread.java:735)

2010-12-23 16:22:30 Thread-0 ERROR (cn.com.alcatelsbell.svg.bm.logloader.processor.BDSessionTrafficUtility:76) - insert data to BD_USER_SESSION_NMURL_TRAFFIC Exception !

java.sql.SQLException: Can not get database connection. Reason: Io exception: There is no process to read data written to a pipe.

  at cn.com.alcatelsbell.sbg.ps.egov.common.db.AbstractConnectionUtility.getConnection(AbstractConnectionUtility.java:140)

  at cn.com.alcatelsbell.svg.bm.common.ConnectionUtility.getConnectionOfDW(ConnectionUtility.java:67)

  at cn.com.alcatelsbell.svg.bm.logloader.processor.BDSessionTrafficUtility.importBDUserSessionNMUrlTraffic(BDSessionTrafficUtility.java:48)

  at cn.com.alcatelsbell.svg.bm.logloader.processor.statistics.BDSessionTrafficStatistics.save(BDSessionTrafficStatistics.java:187)

  at cn.com.alcatelsbell.svg.bm.logloader.processor.statistics.ProcessorForStatistics.doProcessing(ProcessorForStatistics.java:173)

  at cn.com.alcatelsbell.svg.bm.logloader.processor.SegmentProcessor.run(SegmentProcessor.java:50)

  at java.lang.Thread.run(Thread.java:735)






版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表众发娱乐立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章

阅读排行

  • 1
  • 2

    Oracle 简略运用huabian

    运用,数据库,用户
  • 3
  • 4
  • 5

    MySql标准fenghuang

    标准,进程,修正
  • 6

    数据库相关itjob

    触发器,时刻
  • 7
  • 8
  • 9

    oracle extractITeye环球

    部分,类型,时分
  • 10