SQLException: No more data to read from socket

[Ankit Doshi]

Hi,

I came across this error and spent a few hours before I could get rid of it, hence thought of posting it here in case it may be useful to others.

While trying to run the below update statement from my Java code, I was getting the SQLException: No more data to read from socket from the executeUpdate method call.

Connection con = //code to get connection object
String query = "UPDATE TABLE MYTABLE SET COL1='?', COL2='?' WHERE PK_ID='?'";
PreparedStatement pstmt = con.prepareStatement(query);
pstmt.executeUpdate();

When I removed the single quotes from the query (like below), it worked.

String query = "UPDATE TABLE MYTABLE SET COL1=?, COL2=? WHERE PK_ID=?";

By the way, anyone knows the reason why it doesn't work WITH single quotes?

-Ankit

[Jeanne Boyarsky]

Originally posted by Ankit Doshi:
By the way, anyone knows the reason why it doesn't work WITH single quotes?

That would depend on your database driver and whether the columns were char/varchar or numeric.

[Ankit Doshi]

I'm sorry, I forgot to mention that.

I used the OracleDriver and the columns were varchar2.

[Jeanne Boyarsky]

Odd. Maybe it's a driver bug?

[teemrap hgnis]

this is because you populate the prepared statement params using the data type call
.setString(...) or .setInteger(...) etc therefore you dont need to put the quotes.
When you get a PreparedStatement from connection the passed query is compiled and stored into Oracle so every time its just the params that are populated using the setters.