dbconnection – Make Me Engineer

Is java.sql.Connection thread safe?

May 29, 2022 by Tarik

If the JDBC driver is spec-compliant, then technically yes, the object is thread-safe, but you should avoid sharing connections between threads, since the activity on the connection will mean that only one thread will be able to do anything at a time. You should use a connection pool (like Apache Commons DBCP) to ensure that … Read more

nodejs mysql Error: Connection lost The server closed the connection

May 14, 2022 by Tarik

Try to use this code to handle server disconnect: var db_config = { host: ‘localhost’, user: ‘root’, password: ”, database: ‘example’ }; var connection; function handleDisconnect() { connection = mysql.createConnection(db_config); // Recreate the connection, since // the old one cannot be reused. connection.connect(function(err) { // The server is either down if(err) { // or restarting … Read more