Java.sql.SQLException:Io exception: Got minus one from a read call

Blog Category:

• Oracle

Application connection under Tomcat server The Oracle times is wrong and the following exception occurs:

Java.sql.SQLException:Io exception: Got minus one from a read call

Querying database connections:

Java code

2. Sql> Select Username,count (username) from V$session where username are not null GROUP by username;
6. USERNAME COUNT (USERNAME)
8. ------------------------------ ---------------
10. SP2
12. YWTWEBDB
14. SYS 2
16. INFO 1
18. MF 658
20. UC 183
24. 6 rows selected.

Java code

1. Sql> Select COUNT (*) from v$session where status=' ACTIVE ';
3. COUNT (*)
4. ----------
5. 675

The reason is unclear: the performance is the database connection number is large, the temporary processing is restarts the database, restarts after the resolution, but the estimation is not the final workaround. Connection condition after reboot:

Java code

2. Number of database connections at normal times:
4. Sql> Select Username,count (username) from V$session where username are not null GROUP by username;
8. USERNAME COUNT (USERNAME)
10. ------------------------------ ---------------
12. SP2
14. YWTWEBDB 2
16. SYS 1
18. INFO 1
20. MF
22. Myjin 1
24. UC
28. 7 rows selected.

The following is a collection of online solutions for this issue:

http://www.iteye.com/topic/1126453

Http://blog.sina.com.cn/s/blog_529aacbd0100t22b.html

Http://hi.baidu.com/xjieni/item/1afbff62dab025167cdecc21

Excerpts are as follows:

Java code

2. It is strange to have the following exception when you accidentally connect to Oracle with Java today:
4. Caused By:java.sql.SQLException:Io exception: Got minus one from a read call
6. At Oracle.jdbc.dbaccess.DBError.throwSqlException (Dberror.java:134)
8. At Oracle.jdbc.dbaccess.DBError.throwSqlException (Dberror.java:179)
10. At Oracle.jdbc.dbaccess.DBError.throwSqlException (Dberror.java:333)
12. At Oracle.jdbc.driver.oracleconnection.<init> (oracleconnection.java:404)
14. At Oracle.jdbc.driver.OracleDriver.getConnectionInstance (Oracledriver.java:468)
16. At Oracle.jdbc.driver.OracleDriver.connect (Oracledriver.java:314) ....
20. Issue after restarting the app, an error occurred when the app connected to Oracle failed to start the app.
24. Finally restart the ORACLE11G service, no problem, but have not found a specific reason.
28. Later on in another application also found the same problem, found that the severity of the problem, after analysis may be the driving problem, without restarting the ORACLE11G service, replace the latest version of the JDBC driver package, problem resolution;
32. Ojdbc14.jar version of the problem: (View the MANIFEST.MF file for the jar package)
34. Manifest-version: 1.0
36. Specification-title:oracle JDBC driver classes for use with JDK14
38. Sealed: True
40. Created-by: 1.4.2_08 (Sun Microsystems Inc.)
42. Implementation-title:ojdbc14.jar
44. Specification-vendor:oracle Corporation
46. Specification-version:oracle JDBC Driver Version- "10.2.0.1.0"
48. Implementation-version:oracle JDBC Driver Version- "10.2.0.1.0"
50. Implementation-vendor:oracle Corporation
52. Implementation-time:wed June: £ 2005
56. name:oracle/sql/converter/
58. Sealed: false
62. name:oracle/sql/
64. Sealed: false
68. name:oracle/sql/converter_xcharset/
70. Sealed: false
76. Ojdbc14.jar version To resolve the issue:
78. Manifest-version: 1.0
80. Specification-title:oracle JDBC driver classes for use with JDK14
82. Sealed: True
84. Created-by: 1.4.2_14 (Sun Microsystems Inc.)
86. Implementation-title:ojdbc14.jar
88. Specification-vendor:oracle Corporation
90. Specification-version:oracle JDBC Driver Version- "10.2.0.4.0"
92. Implementation-version:oracle JDBC Driver Version- "10.2.0.4.0"
94. Implementation-vendor:oracle Corporation
96. Implementation-time:sat Feb 2 : £º
100. name:oracle/sql/converter/
102. Sealed: false
106. name:oracle/sql/
108. Sealed: false
112. name:oracle/sql/converter_xcharset/
114. Sealed: false

Java code

1. caught: java.sql.sqlexception: io  exception: got minus  one from a read call  
2. when using JDBC to connect to Oracle, the above error occurred several times, and then went to the Internet to find the following basic methods are available:   
3.   
4. 1: Database connection is full, expand database connection pool   
5.   
6. 2: the IP of the machine is not in the Sqlnet.ora, after the addition of the restart Listerner can   
7.   
8. 3: Database load balancer, specified (server=dedicated), remove this can be   
9.   
10. 4: The network administrator restricts access to Oracle on the Oracle configuration, which is similar to 2, Also modify the Oracle configuration,   
11. is looking for a solution, now the database does not belong to my tube, can not restart, expand the connection pool symptoms do not cure, and the database connection pool is written by myself, Blind enlargement can cause many problems for other users to access, preferably by destroying the links created earlier. Alas, this is the disadvantage of code is not standardized AH. When creating connection, you must not forget the close, even if the connection pool do not forget returnconnection ah.   

Java code

2. Because the database is always normal, it cannot be a configuration-like error.
4. After the DBA has checked something, the conclusion is that the system is not enough resources.
6. --View system resources
8. SELECT Resource_name,
10. Current_utilization,
12. Max_utilization,
14. LIMIT,
16. ROUND (Max_utilization/limit * 100) | | '% ' rate
18. From (SELECT resource_name,
20. Current_utilization,
22. Max_utilization,
24. To_number (initial_allocation) LIMIT
26. From V$resource_limit
28. WHERE resource_name in (' processes ', ' sessions ')
30. and Max_utilization > 0);
34. Resource_name current_utilization max_utilization LIMIT Rate
36. ------------------------------ ------------------- --------------- ---------- -----
38. processes                                        312              500         500 100%&NBSP;&NBSP;
40. Sessions 317 509 555 92%
42. Discovery is insufficient resources.
44. The processing methods are:
46. Alter system set processes=scope=spfile;
48. Alter system set sessions=1110 scope=spfile; then restart the database
52. It's just that the values are down after I reboot, and there are other reasons why resources are not enough.

Java.sql.SQLException:Io exception: Got minus one from a read call