java.net.SocketException
MESSAGE: java.net.SocketException: Socket operation on nonsocket: JVM_BindSTACKTRACE:java.net.SocketException: java.net.SocketException: Socket operation on nonsocket: JVM_Bind at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2592) at com.mysql.jdbc.Connection.<init>(Connection.java:1509) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171)
MESSAGE: java.net.SocketException: Socket operation on nonsocket: JVM_BindSTACKTRACE:java.net.SocketException: java.net.SocketException: Socket operation on nonsocket: JVM_Bind at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2592) at com.mysql.jdbc.Connection.<init>(Connection.java:1509) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171)
public ArrayList executeQuery(String sql) {
ArrayList altData = new ArrayList();
if (sql == null || "".equals(sql.trim())) {
return altData;
}
try {
conn = this.getConnection();
statement = conn.createStatement();
result = statement.executeQuery(sql);
ResultSetMetaData metaData = (ResultSetMetaData) result.getMetaData();
while (result.next()) {
String[] data = new String[metaData.getColumnCount()];
for (int i = 0; i < data.length; i++) {
data[i] = result.getString(i + 1);
}
altData.add(data);
} }
catch (Exception ex) {
System.out.println("ERORR SQL --- " + sql);
ex.printStackTrace();
}
finally {
this.close(result, statement, conn);
}
return altData;
} public static void close(ResultSet rs, Statement stmt, Connection conn) {
if (rs != null) {
try {
rs.close();
}
catch (java.sql.SQLException ex) {
ex.printStackTrace();
}
}
if (stmt != null) {
try {
stmt.close();
}
catch (java.sql.SQLException ex) {
ex.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
}
catch (java.sql.SQLException ex) {
ex.printStackTrace();
}
}
}
java.net.SocketException
MESSAGE: Unrecognized Windows Sockets error: -1: socket available