Oracle 异常

常见SQLException异常 Oracle ORA-00904 、ORA-00942:

ORA-00904:  invalid column name 无效列名

ORA-00942:  table or view does not exist 表或者视图不存在

ORA-01400:  cannot insert NULL into () 不能将空值插入

ORA-00936:　缺少表达式

ORA-00933:　SQL 命令未正确结束

ORA-01722:　无效数字：（一般可能是企图将字符串类型的值填入数字型而造成）

ORA-06530:  ACCESS_INTO_NULL　
      Your program attempts to assign values to the attributes of an uninitialized (atomically  null) object.
企图将值写入未初化对象的属性

ORA-06592:  CASE_NOT_FOUND
     None of th  choice  in the WHEN clauses of a CASE statement is selected,  and there is no  ELSE clause.
case语句格式有误，没有分支语句

ORA-06531:  COLLECTION_IS_NULL
     Your program attempts to apply collection methods othe  than EXIST  to an uninitialized(atomically  null) nested table or varray, or th  program attempts to assign values to the elements of an  uninitialized nested table  or  varray.
企图将集合填入未初始化的嵌套表中

ORA-06511:  CURSOR_ALREADY_OPEN
     Your program attempts to open an already open cursor. A cursor must be closed before it can  be reopened.  A cursor FOR loop automatically opens the cursor to which it refers. So, your  program cannot open that cursor inside  the  loop.
企图打开已经打开的指针．指针已经打开，要再次打开必须先关闭．

ORA-00001:  DUP_VAL_ON_INDEX
     Your program attempts to store duplicate values in a database column that is constrained by  a unique index.
数据库字段存储重复，主键唯一值冲突

ORA-01001:  INVALID_CURSOR　无效指针
    Your program attempts an illegal cursor operation such as closing an unopened cursor.
非法指针操作，例如关闭未打开的指针

ORA-01722:  INVALID_NUMBER　无效数字
     In a SQL statement, the conversion of a character string into a number fails because the  string does not represent a valid number. (In  procedural statements, VALUE_ERROR is raised.) This exception is also raised when the LIMIT-clause expression in a bulk FETCH  statement does not evaluate to a positive number.
在sql语句中，字符数字类型转换错误，无法将字符串转化成有效数字．此错误也可能因为在limit从句表达式中fetch语句无法对应指定数字

ORA-01017:  LOGIN_DENIED　拒绝访问
     Your program attempts to log on to Oracle with an invalid username and/or password.
企图用无效的用户名或密码登录oracle

ORA-01403:  NO_DATA_FOUND  无数据发现
     A SELECT INTO statement returns no rows, or your program references a deleted element in a  nested table  or an  uninitialized  element  in  an  index-by  table.  SQL  aggregate  functions  such  as  AVG  and  SUM  always  return  a value or a null.  So, a SELECT INTO statement that calls an aggregate function  never  raises  NO_DATA_FOUND. The FETCH statement is  expected to return no rows eventually, so when that happens, no exception is raised.
  
ORA-01012:  NOT_LOGGED_ON   未登录
     Your program issues  a database call without being connected to Oracle.
程序发送数据库命令，但未与oracle建立连接
  
ORA-06501:  PROGRAM_ERROR  程序错误
     PL/SQL  has  an  internal  problem.
pl/sql系统问题
  
ORA-06504:  ROWTYPE_MISMATCH  行类型不匹配
    The  host  cursor  variable  and  PL/SQL  cursor  variable  involved  in  an  assignment  have  incompatible  return  types.
For example, when an open host cursor variable is passed to a stored  subprogram, the return types of the actual and formal parameters must be compatible.
  
ORA-30625:  SELF_IS_NULL  
     Your  program  attempts  to  call  a  MEMBER  method  on  a  null  instance.  That  is,  the  built-in  parameter  SELF (which  is  always  the  first  parameter  passed  to  a  MEMBER  method)  is  null.
  
ORA-06500:  STORAGE_ERROR  存储错误
     PL/SQL runs out of memory  or memory has been corrupted.
PL/SQL运行内存溢出或内存冲突
      
ORA-06533:  SUBSCRIPT_BEYOND_COUNT   子句超出数量
      Your program references a nested table or varray element using an index number larger than the number of elements in  the collection.
  
ORA-06532:  SUBSCRIPT_OUTSIDE_LIMIT   子句非法数量
Your program references a nested table or varray element using an index number (-1  for  example)  that  is outside  the  legal  range.
  
ORA-01410:  SYS_INVALID_ROWID   无效的字段名
   The conversion  of  a  character  string  into  a  universal  rowid  fails  because  the  character  string  does  not represent  a  valid  rowid.
  
ORA-00051:  TIMEOUT_ON_RESOURCE    资源等待超时
A time-out occurs while Oracle is waiting for a resource.
  
ORA-01422:  TOO_MANY_ROWS    返回超过一行
A SELECT INTO statement returns more  han one row.
  
ORA-06502:  VALUE_ERROR   值错误
An arithmetic, conversion, truncation, or size-constraint error occurs. For example, when  your program selects a column value into a character  variable, if the value is  longer  than  the  declared  length  of  the  variable, PL/SQL aborts the assignment and raises VALUE_ERROR.  In procedural statements,  VALUE_ERROR  is raised if the conversion of a character string into a number fails.  (In SQL statements, INVALID_NUMBER is raised.)
  
ORA-01476:  ZERO_DIVIDE  除0错误
Your program attempts to divide a number by zero.

java.sql.SQLException（jdbc连接不到oracle）

JavaWeb实训过程中， 在Java和Oracle连接不成功。报错如下：

java.sql.SQLException: Undefined Error
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.frank.update.util.DBUtil.getConnection(DBUtil.java:13)
at com.frank.update.main.Update.main(Update.java:27)
Caused by: oracle.net.ns.NetException: Undefined Error
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
... 8 more
null
Exception in thread "main" java.lang.NullPointerException
at com.frank.update.main.Update.main(Update.java:30)

google了好久，stackOverflow也看了好多回答，有的说 127.0.0.1的问题，有是说是端口的问题，有说是监听器没有开启。但是这些方法并没解决我的问题，后来我的朋友在百度贴吧找到了答案。（醉了，stackoverflow 没有找到答案，竟然在百度贴吧找到了，真是高人在民间呀）

附上链接：
解决问题的链接

解决方法是：将驱动包更新到 ojdbc14.jar 即可。
后来我想了下，造成这个错误的原因是：
项目本身是从别处import导入的。开始还配置了jdk版本，IDE还提示做了些更改，唯独没有改变jar 包。后来ojdbc6_g.jar改成了ojbc14.jar,问题奇迹般解决。
————————————————
摘自：https://blog.csdn.net/Zheng548/article/details/51804463

java.sql.SQLException：ORA-00917：缺少逗号(java.sql.SQLException: ORA-00917: missing comma)

I'm pulling my hair out trying to find the cause of the SqlExcpetion below. I'm using Oracle Database 11g Express and SqlDeveloper. I've looked through other posts, but so far no help.

java.sql.SQLException: ORA-00917: missing comma

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1029)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1498)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at com.ets.hr.dao.EmployeeDAO.createEmployee(EmployeeDAO.java:30)
at Test.main(Test.java:62)

Method below:

public void createEmployee(Employee e){
    try{
        Class.forName(oracleClass);
        Connection conn = DriverManager.getConnection(oracleUrl, "hr", "hr");
        Statement s = conn.createStatement();
        String query = "INSERT INTO employees VALUES(" +
                       e.getEmployeeId() + ", '" +
                       e.getFirstName() + "', '" +
                       e.getLastName() + "', '" +
                       e.getEmail() + "', '" +
                       e.getPhoneNumber() + "', " +
                       e.getHireDate() + ", '" +
                       e.getJobId() + "', " +
                       e.getSalary() + ", " +
                       e.getCommissionPct() + ", " +
                       e.getManagerId() + ", " +
                       e.getDepartmentId() + ")";

        s.executeQuery(query);//LINE 30 - SqlException Here
        System.out.println("Query Executed: Create Employee");
    }
    catch(SQLException se){
        se.printStackTrace();
    }
    catch(ClassNotFoundException ce){
        ce.printStackTrace();
    }
}

Employee Class:

package com.ets.hr.dto;

import java.util.Date;

public class Employee {

//CONSTRUCTORS
public Employee(){}

public Employee(long eId, 
                String firstName, 
                String lastName, 
                String email, 
                String phoneNumber, 
                Date hireDate, 
                String jobId, 
                double salary, 
                double commissionPct,
                long managerId,
                long departmentId){
    this.firstName = firstName;
    this.lastName = lastName;
    this.email = email;
    this.phoneNumber = phoneNumber;
    this.hireDate = hireDate;
    this.jobId = jobId;
    this.salary = salary;
    this.commissionPct = commissionPct;
    this.managerId = managerId;
    this.departmentId = departmentId;
}

//instance variables (from HR.EMPLOYEE table)
private long employeeId;
private String firstName;
private String lastName;
private String email;
private String phoneNumber;
private Date hireDate;
private String jobId;
private double salary;
private double commissionPct;
private long managerId;
private long departmentId;

//GETTERS
public long getEmployeeId(){
    return this.employeeId;
}
public String getFirstName(){
    return this.firstName;
}
public String getLastName(){
    return this.lastName;
}
public String getEmail(){
    return this.email;
}
public String getPhoneNumber(){
    return this.phoneNumber;
}
public Date getHireDate(){
    return this.hireDate;
}
public String getJobId(){
    return this.jobId;
}
public double getSalary(){
    return this.salary;
}
public double getCommissionPct(){
    return this.commissionPct;
}
public long getManagerId(){
    return this.managerId;
}
public long getDepartmentId(){
    return this.departmentId;
}

//SETTERS
public void setEmployeeId(long employeeId){
    this.employeeId = employeeId;
}
public void setFirstName(String firstName){
    this.firstName = firstName;
}
public void setLastName(String lastName){
    this.lastName = lastName;
}
public void setEmail(String email){
    this.email = email;
}
public void setPhoneNumber(String phoneNumber){
    this.phoneNumber = phoneNumber;
}
public void setHireDate(Date hireDate){
    this.hireDate = hireDate;
}
public void setJobId(String jobId){
    this.jobId = jobId;
}
public void setSalary(double salary){
    this.salary = salary;
}
public void setCommissionPct(double commissionPct){
    this.commissionPct = commissionPct;
}
public void setManagerId(long managerId){
    this.managerId = managerId;
}
public void setDepartmentId(long departmentId){
    this.departmentId = departmentId;
}

public void printEmployee(){
    System.out.println("Employee ID: " + this.getEmployeeId());
    System.out.println("Employee Name: " + this.getFirstName() + this.getLastName());
    System.out.println("Employee Email: " + this.getEmail());
    System.out.println("Employee Phone: " + this.getPhoneNumber());
    System.out.println("Employee Hire Date: " + this.getHireDate());
    System.out.println("Employee Job ID: " + this.getJobId());
    System.out.println("Employee Salary: " + this.getSalary());
    System.out.println("Employee Commission Pct: " + this.getCommissionPct());
    System.out.println("Employee Manager ID: " + this.getManagerId());
    System.out.println("Employee Department ID: " + this.getDepartmentId());
}

}

 

解决方案

You shouldn't be trying to build your own SQL string, because you have to deal with quoting and escaping (which has bitten you here).

Instead, use a PreparedStatement and let the JDBC API escape, quote and format (eg dates) your values for you:

String query = "INSERT INTO employees VALUES (?,?,?,?,?,?,?,?,?,?,?)";
PreparedStatement ps = conn.prepareStatement(query);
ps.setInt(e.getEmployeeId(), 1);
ps.setString(e.getFirstName(), 2);
ps.setDate(e.getHireDate(), 6);
// etc - there is a setter for each basic datatype
ps.execute();
ps.close();

The coding is easier, and readability goes way up too.

 

我正在试着找出下面SqlExcpetion的原因。我正在使用Oracle Database 11g Express和SqlDeveloper。我查看了其他帖子，但到目前为止没有任何帮助。



  java.sql.SQLException：ORA-00917：缺少逗号
 
 at oracle.jdbc.driver.T4CTTIoer.processError（T4CTTIoer.java:447）
 at oracle.jdbc.driver.T4CTTIoer.processError（T4CTTIoer.java:396) 
 at oracle.jdbc.driver.T4C8Oall.processError（T4C8Oall.java:951）
 at oracle.jdbc.driver.T4CTTIfun.receive（T4CTTIfun.java:513）
 at oracle.jdbc.driver.T4CTTIfun .doRPC（T4CTTIfun.java:227）
 at oracle.jdbc.driver.T4C8Oall.doOALL（T4C8Oall.java:531）
 at oracle.jdbc.driver.T4CStatement.doOall8（T4CStatement.java:195 ）
 at oracle.jdbc.driver.T4CStatement.executeForRows（T4CStatement.java:1029）
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout（OracleStatement.java:1336）
 at oracle。 jdbc.driver.OracleStatement.executeQuery（OracleStatement.java:1498）
 at oracle.jdbc.driver.OracleStatementWrapper.executeQuery（OracleStatementWrapper.java:406）
 at com.ets.hr.dao.EmployeeDAO。 createEmplo是（EmployeeDAO.java:30）
在Test.main（Test.java:62）



< p>以下方法：

 



  public void createEmployee（Employee e）{
 try {
 Class.forName （oracleClass）; 
连接conn = DriverManager.getConnection（oracleUrl，hr，hr）; 
 Statement s = conn.createStatement（）; 
 String query =INSERT INTO employees VALUES（+ 
 e.getEmployeeId（）+，'+ 
 e.getFirstName（）+'，'+ 
 e.getLastName（）+'，'+ 
 e.getEmail（）+'，'+ 
 e.getPhoneNumber（）+'，+ 
 e.getHireDate （）+，'+ 
 e.getJobId（）+'，+ 
 e.getSalary（）+，+ 
 e.getCommissionPct（）+， + 
 e.getManagerId（）+，+ 
 e.getDepartmentId（）+）; 
 
 s.executeQuery（query）; // LINE 30  -  SqlException这里
 System.out.println（执行的查询：创建员工）; 
} 
 catch（SQLException se）{
 se.printStackTrace（）; 
} 
 catch（ClassNotFoundException ce）{
 ce.printStackTrace（）; 
} 
}



员工类别：



  package com.ets.hr.dto; 
 
 import java.util.Date; 
 
公共类员工{
 
 // CONSTRUCTORS 
公共员工（）{} 
 
公共员工（长期eId，
 String firstName，
 String lastName，
 String email，
 String phoneNumber，
 date hireDate，
 String jobId，
 double salary，
 double commissionPct，
 long managerId，
 long departmentId）{
 this.firstName = firstName; 
 this.lastName = lastName; 
 this.email = email; 
 this.phoneNumber = phoneNumber; 
 this.hireDate = hireDate; 
 this.jobId = jobId; 
 this.salary = salary; 
 this.commissionPct = commissionPct; 
 this.managerId = managerId; 
 this.departmentId = departmentId; 
} 
 
 //实例变量（来自HR.EMPLOYEE表）
 private long employeeId; 
 private String firstName; 
 private String lastName; 
 private String email; 
 private String phoneNumber; 
 private Date hireDate; 
 private String jobId; 
私人双薪; 
 private double commissionPct; 
 private long managerId; 
 private long departmentId; 
 
 // GETTERS 
 public long getEmployeeId（）{
 return this.employeeId; 
} 
 public String getFirstName（）{
 return this.firstName; 
} 
 public String getLastName（）{
 return this.lastName; 
} 
 public String getEmail（）{
 return this.email; 
} 
 public String getPhoneNumber（）{
 return this.phoneNumber; 
} 
 public Date getHireDate（）{
 return this.hireDate; 
} 
 public String getJobId（）{
 return this.jobId; 
} 
 public double getSalary（）{
 return this.salary; 
} 
 public double getCommissionPct（）{
 return this.commissionPct; 
} 
 public long getManagerId（）{
 return this.managerId; 
} 
 public long getDepartmentId（）{
 return this.departmentId; 
} 
 
 // SETTERS 
 public void setEmployeeId（long employeeId）{
 this.employeeId = employeeId; 
} 
 public void setFirstName（String firstName）{
 this.firstName = firstName; 
} 
 public void setLastName（String lastName）{
 this.lastName = lastName; 
} 
 public void setEmail（String email）{
 this.email = email; 
} 
 public void setPhoneNumber（String phoneNumber）{
 this.phoneNumber = phoneNumber; 
} 
 public void setHireDate（Date hireDate）{
 this.hireDate = hireDate; 
} 
 public void setJobId（String jobId）{
 this.jobId = jobId; 
} 
 public void setSalary（double salary）{
 this.salary = salary; 
} 
 public void setCommissionPct（double commissionPct）{
 this.commissionPct = commissionPct; 
} 
 public void setManagerId（long managerId）{
 this.managerId = managerId; 
} 
 public void setDepartmentId（long departmentId）{
 this.departmentId = departmentId; 
} 
 
 public void printEmployee（）{
 System.out.println（Employee ID：+ this.getEmployeeId（））; 
 System.out.println（员工姓名：+ this.getFirstName（）+ this.getLastName（））; 
 System.out.println（员工电子邮件：+ this.getEmail（））; 
 System.out.println（员工电话：+ this.getPhoneNumber（））; 
 System.out.println（员工雇用日期：+ this.getHireDate（））; 
 System.out.println（员工职位ID：+ this.getJobId（））; 
 System.out.println（Employee Salary：+ this.getSalary（））; 
 System.out.println（Employee Commission Pct：+ this.getCommissionPct（））; 
 System.out.println（员工经理ID：+ this.getManagerId（））; 
 System.out.println（员工部门ID：+ this.getDepartmentId（））; 
}



}

 

您不应该尝试构建自己的SQL字符串，因为您必须处理引用和转义（这里已经咬过你）。



相反，使用 PreparedStatement 并让JDBC API转义，引用和格式化（例如日期）你的 你的值：< / p>

 字符串查询=INSERT INTO员工价值观（？，？，？，？，？，？，？，？，？， ？）？; 
 PreparedStatement ps = conn.prepareStatement（query）; 
 ps.setInt（e.getEmployeeId（），1）; 
 ps.setString（e.getFirstName（），2）; 
 ps.setDate（e.getHireDate（），6）; 
 //等 - 每个基本数据类型都有一个setter 
 ps.execute（）; 
 ps.close（）;



编码更容易，可读性也越来越高。

 

 

https://www.it1352.com/1470289.html

Druid java.sql.SQLException: 违反协议 / Oracle连接报错生违反协议

1. 报错背景

    tomcat + Oracle + Druid连接池后台报错（ java.sql.SQLException: 违反协议），很奇怪的是只有某种特殊情况下才报错，项目其他功能都运转正常，报错信息看最后面代码示例。

2. 可能原因（OALL8-jdbc与Oracle驱动版本不一致）

    1、jdbc配置出错（驱动配置）：oracle.jdbc.OracleDriver

    2、oracle驱动版本不对

         PLSQL中查看：select * from v$version;

        Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

        PL/SQL Release 11.2.0.4.0 - Production

        CORE 11.2.0.4.0 Production

        TNS for Linux: Version 11.2.0.4.0 - Production

        NLSRTL Version 11.2.0.4.0 - Production

   3、可能原因OALL8-jdbc与Oracle驱动版本不一致

       之前数据库用的版本是PL/SQL Release 10.2.0.5.0 - Production，后来升级到了PL/SQL Release 11.2.0.4.0 - Production，所以需要将jdbc升级对应版本。JDBC下载链接

     pom：

  1. <dependency>
  2. <groupId>ojdbc</groupId>
  3. <artifactId>ojdbc</artifactId>
  4. <!-- <version>6</version> -->
  5. <version>14-10gR3</version>
  6. </dependency>
  7.  
  8.  
  9. <dependency>
  10. <groupId>com.oracle</groupId>
  11. <artifactId>ojdbc6</artifactId>
  12. <version>11.2.0.4.0</version>
  13. </dependency>

 

Oracle版本对应的JDBC版本

2. 可能原因（网上的一种靠谱的解答）

    原文链接

2.1 背景

项目中Oracle使用druid数据库连接池，为了提高访问数据库的效率，开启了PreparedStatement Cache。但是随着项目的运行，也出现了一些问题，在项目运行的过程中，给表添加字段后，会一直出现"ORA-17401:违反协议"异常。应用重启后，不再抛出。

问题描述
在应用持续运行中，给生产库中的某张表添加字段，然后涉及该表查询的地方不断抛出"ORA-17401:违反协议"异常，直到重启引用。

异常描述
"ORA-17401:违反协议"是TTC(Two-Task Common)的一个错误。TTC是oracle通信协议里较为靠上的一层，用于处理客户端与数据库服务器通信时的协议差异，比如转换字符集和数据类型。用以确保Oracle的客户端和服务器在不同的网络交互模式（比如TCP/IP、共享内存）下可以透明地交互。


2.2 问题定位

        1. 重启应用异常不再抛出，反应出重新建立数据库链接能够修复该错误；

        2. 部分项目使用其他连接池没有此问题，而druid与之最大的差异就是开启了PreparedStatement Cache。PreparedStatement实际上避免了相同SQL语句重复解析和建立游标，同时也复用了相同的数据结构。那么当服务器端的表结构即数据结构发生改变时，很有可能TTC就会无法处理这种改变。而使用普通的Statement时，因为不存在数据结构的复用，所以也就不会出现"违反协议异常"。

所以，根据以上两点，关闭了PreparedStatement Cache后，重复之前错误的流程，不再抛出该异常。

但是选择druid就是为了其PreparedStatement Cache这个特性，然后只能继续找问题，最后查阅代码，发现之前的mapper.xml中，查询都是直接使用的select *，对部分改为select [字段] 后，发现问题不再出现，但是和其他开发人人员沟通后，认为将目前项目所有的查询修改，工作量较大，风险较高，而且同样的查询在每个项目中都有，也不想进行重构，所以，只能用其他的办法来解决。

2.3 最终解决方案

在和其他人员沟通后，只能将修改后的影响降为最低，所以只能通过如下代码，在每次修改表结构后，主动清除每个应用服务器上每个数据库连接的PreparedStatement Cache，以此来尽量避免由用户行为触发异常的出现。

  1. @Resource(name = "druidDataSource")
  2. private DruidDataSource druidDataSource;
  3.  
  4. public void clearDruidStatementCache() {
  5. Log.info("DruidDataSource", "清除Druid的Statement Cache Start......");
  6. if (druidDataSource != null) {
  7. try {
  8. druidDataSource.clearStatementCache();
  9. } catch (SQLException e) {
  10. Log.error("DruidDataSource", "清除Druid的Statement Cache Error", e);
  11. }
  12. }
  13. Log.info("DruidDataSource", "清除Druid的Statement Cache End......");
  14. }

2.4 问题的查找过程

最初用的是druid1.0.25版本，根据http://www.oschina.net/news/79452/druid-1-0-27中的信息，在1.0.27版本中，进行了如下修改

根据其中所说，如果执行出错，可以从PSCache中移除，所以将版本换到了1.0.27，但是问题还是依然存在，只好继续查。

根据http://tomcat.apache.org/tomcat-5.5-doc/jndi-datasource-examples-howto#Oracle_8i,_9i_&_10g，注意如下内容

For Oracle 9i onwards you should use oracle.jdbc.OracleDriver rather than oracle.jdbc.driver.OracleDriver as Oracle have stated that oracle.jdbc.driver.OracleDriver is deprecated and support for this driver class will be discontinued in the next major release.

而我们用的是oracle.jdbc.driver.OracleDriver，并不是oracle.jdbc.OracleDriver，但是并不一定要进行修改。

这是因为根据https://github.com/alibaba/druid/issues/1598中所说，在1.0.29版本中已经兼容了两种写法，不过我还是按要求改成了正确的。

以上基本就是整个问题的查找过程，不过最后因为种种原因，暂时只是采取了一种比较不合理的方法来规避，尽量减少用户来触发从而降低体验。

3. 结合自身项目最终问题原因

tomcat 中context.xml配置的驱动为：oracle.jdbc.OracleDriver，而底层类DBpool.java中open方法中却是oracle.jdbc.driver.OracleDriver

druid的PreparedStatement Cache这个特性导致需要

OALL8-jdbc：下载对应版本的jdbc

        <dependency>
              <groupId>com.oracle</groupId>
              <artifactId>ojdbc6</artifactId>
              <version>11.2.0.4.0</version>
        </dependency>

4. 问题报错信息

  1. 问题报错信息
  2. 三月 06, 2019 1:26:54 下午 com.alibaba.druid.pool.DruidDataSource error
  3. 严重: discard connection
  4. java.sql.SQLException: 违反协议: [ 0, ]
  5. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:669)
  6. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
  7. at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
  8. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
  9. at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
  10. at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
  11. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
  12. at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1718)
  13. at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1678)
  14. at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:332)
  15. at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2600)
  16. at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473)
  17. at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188)
  18. at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598)
  19. at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:147)
  20. at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:558)
  21. at com.sinosoft.sysframework.reference.DBManager.preDeal(DBManager.java:238)
  22. at com.sinosoft.sysframework.reference.DBManager.open(DBManager.java:220)
  23. at com.sinosoft.sysframework.reference.DBManager.open(DBManager.java:193)
  24. at com.sinosoft.sysframework.reference.DBManager.open(DBManager.java:174)
  25. at com.sinosoft.sysframework.reference.DBManager.open(DBManager.java:161)
  26. at com.sinosoft.utiall.dbsvr.DBPrpDcodeCom.findByConditions(DBPrpDcodeCom.java:365)
  27. at com.sinosoft.utiall.blsvr.BLPrpDcodeCom.query(BLPrpDcodeCom.java:143)
  28. at com.sinosoft.utiall.blsvr.BLPrpDcodeCom.translateCode(BLPrpDcodeCom.java:267)
  29. at com.sinosoft.indiv.ci.interfS.ProposalQueryBusinessDecoder.transProfitFG(ProposalQueryBusinessDecoder.java:1583)

 

 

声明：本文第二章转载自“雨幕下的稻田”的心得，未经允许请不要以原创名义进行转载，尊重原创。

摘自：https://blog.csdn.net/u012723183/article/details/88232188?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase