CODEWITHSUNDEEP
oracle-databasecoldfusion
tsurahman
tsurahman

Reputation: 1912

Oracle error "No more data to read from socket" When Using jdbc:oracle:thin

I have an Oracle error No more data to read from socket. It's a connection using ColdFusion datasource jdbc:oracle:thin

how to fix it?

Thank you

Upvotes: 1

Views: 1645

Answers (2)

Ankursonikajen
Ankursonikajen

Reputation: 61

use this - conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);

not this- conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);

Upvotes: 1

Jon Heller
Jon Heller

Reputation: 36808

Sometimes this is the result of a really serious Oracle error, like an ORA-600 or ORA-7445. Ask your DBA to look for any trace files.

Upvotes: 2

Related Questions