I'm running Tomcat 4.0.1 on a W2K server and connecting to SQL Server 2000 on another W2K server on our network. I get a Communication Link Failure from time to time. It's not a consistant error (it may or may not happen). You can see a snippet of the error below.
I've done some research on the error and there doesn't seem to be a conclusive solution to the problem or what the problem stems from. Some say it's a synchronization problem, others say it's the db driver, others say its the web server because if they restart the web server the problem goes away for some time before it reappears and so its a problem with Tomcat. The db connection I'm making is a standard connection where a Connection object is created and then closed after execution from within a servlet. I'm not using any db pooling. Can anyone provide some insite into what is happening and how I can fix it? Does this have anything to do with Tomcat?? Thanks, Scott java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Communication link failure at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188) at sun.jdbc.odbc.JdbcOdbc.SQLExecute(JdbcOdbc.java:2533) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.execute(JdbcOdbcPreparedStatement.ja va:217) at sun.jdbc.odbc.JdbcOdbcPreparedStatement.executeUpdate(JdbcOdbcPreparedStatem ent.java:139) at MyServlet.deleteRecords(MyServlet.java:408) -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
