Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Java MySQL - Named Pipe connection throws warning on close
- public static List<List> QueryDB(int RowValue) {
- List<Long> ValueList = new ArrayList();
- try {
- try (Connection Connection_T = MySQLConnectionResources.createConnection()) {
- try (Statement Statement_T = Connection_T.createStatement()) {
- String String_T = "SELECT AColumn FROM ATable WHERE BColumn = " + RowValue + ";";
- try (ResultSet ResultSet_T = Statement_T.executeQuery(String_T)) {
- while (ResultSet_T.next()) {
- ValueList.add(ResultSet_T.getLong("AColumn"));
- }
- }
- }
- }
- } catch(SQLException SQLException_P) {
- System.err.println("ERROR: Failed to query the database.");
- ValueList.clear();
- }
- List<List> Result_M = new ArrayList();
- Result_M.add(ValueList);
- return Result_M;
- }
- Thu Sep 22 00:31:54 EDT 2011 WARN: Caught while disconnecting...
- EXCEPTION STACK TRACE:
- ** BEGIN NESTED EXCEPTION **
- java.net.SocketException
- MESSAGE: Socket is not connected
- STACKTRACE:
- java.net.SocketException: Socket is not connected
- at java.net.Socket.shutdownInput(Socket.java:1456)
- at com.mysql.jdbc.MysqlIO.quit(MysqlIO.java:1687)
- at com.mysql.jdbc.ConnectionImpl.realClose(ConnectionImpl.java:4368)
- at com.mysql.jdbc.ConnectionImpl.close(ConnectionImpl.java:1557)
- at ... my class/method here (my class.java:#)
- ** END NESTED EXCEPTION **
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public final class main {
- public static void main(String[] args) {
- Connection conn = null;
- try {
- conn =
- DriverManager.getConnection("jdbc:mysql:///database?socketFactory=com.mysql.jdbc.NamedPipeSocketFactory&namedPipePath=\\.\Pipe\mysql.sock",
- "root", "password");
- conn.close();
- } catch (SQLException ex) {
- // handle any errors
- }
- }
- }
Add Comment
Please, Sign In to add comment