Caused By Java.sql.sqlrecoverableexception Io Error Unexpected Packet
Topic: Exception occurs when multiple threads access database 1 reply Latest Post - 2003-08-30T21:33:23Z by SystemAdmin Display:ConversationsBy Date 1-2 of 2 Previous Next SystemAdmin 110000D4XK 4447 Posts Pinned topic Exception occurs when multiple threads access database 2003-08-27T03:38:35Z | Tags: Answered question This question has been answered. Unanswered question This question has not been answered yet. Hey all, I am using JDBC accessing Oracle within multiple threads. Exceptions occurred soon after I started my program even there are just two threads. How can this happened? I use a single connection object in the application. and several statement and prestatement objects. I also add synchronized when using the statement objects. Below are the exceptions: Wed Aug 27 07:43:23 GMT+08:00 2003 ERRORThread-3 SQL Error: java.sql.SQLException: Io : Unexpected packet:java.sql.SQLException: Io : Unexpected packet at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333) at oracle.jdbc.ttc7.TTC7Protocol.getLobChunkSize(TTC7Protocol.java:2992) at oracle.sql.LobDBAccessImpl.getChunkSize(LobDBAccessImpl.java:322) at oracle.sql.BLOB.getChunkSize(BLOB.java:478) at oracle.sql.BLOB.getBufferSize(BLOB.java:515) at oracle.sql.BLOB.getBinaryStream(BLOB.java:250) at com.dbrg.scss.OraPageInfoDAO.select(OraPageInfoDAO.java:268) at com.dbrg.scss.OraAnalyzerWorkloadDAO.getTask(OraAnalyzerWorkloadDAO.java:251) at com.dbrg.scss.OraAnalyzerWorkloadDAO.assignWorkload(OraAnalyzerWorkloadDAO.java:75) at com.dbrg.scss.Analyzer.getWorkload(Analyzer.java:111) at com.dbrg.scss.AnalyzerWorker.run(AnalyzerWorker.java:106) Wed Aug 27 07:43:23 GMT+08:00 2003 NORMALThread-3 AnalyzerWorker is over because of no workload Wed Aug 27 07:43:23 GMT+08:00 2003 ERRORThread-2 SQL Exception: java.sql.SQLException: Io : Bad packet type:java.sql.SQLException: Io : Bad packet type at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333) at oracle.jdbc.driver.OracleResultSetImpl.internal_close(OracleR
van GoogleInloggenVerborgen veldenZoeken naar groepen of berichten
3. java.sql.SQLException: Io exception: Bad packet type
4. java.sql.SQLException: Bigger type length than Maximum
5. java.sql.SQLException: Io exception: Invalid Packet Lenght
6. java.sql.SQLException: Closed Connection
7. java.sql.SQLException: Closed Statement
8. java.sql.SQLException: Refcursor value is invalid
9. java.sql.SQLException: Io exception: Size http://www.vamsipavan.com/blog/javasqlsqlexception-io-exception-invalid-packet-lenght/ Data Unit (SDU) mismatch
10. java.sql.SQLException: Must be logged on to server All these occur almost with same reason. It is caused when more than one thread is trying to make simultaneous use https://asanga-pradeep.blogspot.com/2012/12/javasqlsqlrecoverableexception-io-error.html of the thin Oracle JDBC driver via the same Connection object. To correct this problem we have to ensure that only one thread of execution was making use of the JDBC driver caused by at a time through the same Connection OR upgrade to a later version of the driver. Further investigation says, with JDBC driver version is 9.2.0.2.0 it is reproducible and 9.2.0.3.0 is free from this. Any ways, it is advisable to go with latest jdbc driver version i.e. 10.2.0.4 which can solve this issue. Multi-thread programming needs this as quick note. Vamsi PavanVamsi Pavan is an alumni caused by java.sql.sqlrecoverableexception of IIIT-Hyderabad with honors in computer science & engineering. He works as a Techincal Lead for an MNC which is leader in data integration in Bangalore, India. His interests include data mining, crawling, information extraction & retrieval, machine learning, distributed computing and parallel programming. When he is offline, mostly he enjoys company of movies, animes, painting & drawing.More Posts - Website Follow Me:Share this:Click to share on LinkedIn (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Google+ (Opens in new window)Click to email this to a friend (Opens in new window)Click to print (Opens in new window) Related Posted on March 9, 2009 by Vamsi Pavan in Java, Jsp/servlets, Programming | 1 Comment One thought on “java.sql.SQLException: Io exception: Invalid Packet Lenght” Kunal says: December 30, 2009 at 3:48 am Finally found solution . Thanks Bala Reply Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of fol
Quote from a System V researcher Labels 10.2.0.4 (2) 10.2.0.5 (2) 10g (37) 11.1.0.7 (12) 11.2.0.1 (8) 11.2.0.2 (22) 11.2.0.3 (46) 11.2.0.4 (17) 11g (48) 11gR1 (51) 11gR2 (91) 12.1.0.1 (16) 12.1.0.2 (15) 12c (30) 3136 (1) 4390875 (1) 4430244 (1) 4483084 (1) 5155885 (1) 5447395 (1) 6627640 (1) 8898852 (1) acfs (3) acfsload (1) acfsroot (1) acfsutil (1) active database (5) active dataguard (2) add node (3) admon (1) agent (5) alias (1) apache http server (1) apconsole (1) append_values (1) aq_tm_processes (1) archive gaps (2) arcn (2) ASM (50) asmlib (9) asmtool (1) aud (1) audit (1) auto commit (2) auto start (4) average (1) awk (2) awr (1) backup (15) basic replication (2) batch (1) bind variables (2) bitmap (2) blob (5) block devices (11) blockdev (1) blockrecovery (1) bonding (2) brief (3) buffers (1) bug (13) business intelligence (1) cache (2) CALIBRATE_IO (2) CallableStatement (1) cdb (3) cfq (1) chain (1) change port (2) check (1) chkconfig (1) chunk (1) client (2) clone (5) close (1) cloud (1) Cloud Control (2) CLSC_RECEIVE (1) cluster (31) clustering factor (1) clusterware (25) compatible.asm (1) compatible.rdbms (1) compress (2) compression (3) Connect (2) connect through (1) connection leak (1) connection reset (1) contention (2) controlfile (5) convert (4) copy (2) cost (3) cpu (1) create_stored_outlines (2) cron (1) crs (2) crs_stat (1) CRS-2632 (1) CRS-2640 (1) CRS-2674 (1) crsd.log (1) CVE-2012-1675 (2) cvu (1) database (21) datafile (5) dataguard (26) dataguard broker (7) db cpu (1) db file sequential read (1) db time (1) db_domain (1) db_securefile (1) dblinks (1) dbms_aw_exp (1) DBMS_CSX_INT (1) dbms_cube_exp (2) dbms_file_transfer (2) dbms_lob (1) dbms_outln (2) dbms_rowid (1) dbms_space (2) dbms_sqltune (1) dbms_stats (1) dbshut (1) dbstart (1) dbua (10) dbw (1) dbwn (1) ddl (1) deadline (1) DEFERRED_SEGMENT_CREATION (1) delete node (4) deleted (1) dependency (1) deprecated (1) design pattern (1) dhcp (1) dictionary scripts (1) diskmon (1) dispatcher (1) division (1) dmidecode (1) dnfs (1) DNS (2) downgrade (3) DSTv11 (1) duplicate (3) egid (1) elevator (1)