S
seth brundle
I have a mysql table with 9M records which I am reading row by row though
j/connection/jdbc..
The program stops around 100,000 records with the following Exception(s):
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
Last packet sent to the server was 2369890 ms ago.
From a little research it seemed that this was a problem with buffered
prepared statements creating too much idle time on the server connection and
the connection timing out, so I inserted the option
'useServerPrepStmts=false' in the connection string to process it one row at
a time from a suggestion on mysql website - but this did not fix or change
the problem in any way.
Any ideas? I'm kinda new to Java and never had this issue with Perl/DBI with
the same table...
j/connection/jdbc..
The program stops around 100,000 records with the following Exception(s):
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
Last packet sent to the server was 2369890 ms ago.
From a little research it seemed that this was a problem with buffered
prepared statements creating too much idle time on the server connection and
the connection timing out, so I inserted the option
'useServerPrepStmts=false' in the connection string to process it one row at
a time from a suggestion on mysql website - but this did not fix or change
the problem in any way.
Any ideas? I'm kinda new to Java and never had this issue with Perl/DBI with
the same table...