I connected to mysql and loaded the appropriate drivers, but this error appears:
** BEGIN NESTED EXCEPTION **
java.net.ConnectException
MESSAGE: Connection refused: connect
STACKTRACE:
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:305)
...
...
...
SQLException: null
my code is:
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url1, user1, pass1);
stmt = conn.createStatement();
System.out.println(query);
rs = stmt.executeQuery(query);
while(rs.next())
{
System.out.println(rs.getString("Titel") + "\n");
}
}
catch (Exception ex)
{
System.out.println("SQLException: " + ex.getMessage());
}
any ideas?