MySql DriverManager.getConnection failed
Jeg har et problem med at få forbindelse med min MySql server fra en applet via nedenstående kode. Min Class.forName() går fint, men min DriverManager.getConnection() fejler.Min MySql er kørende og jeg når den fint via PHP.
(Skal min JDBC driver registrers på en eller anden måde ?)
---------- KODEN:
class DBconnect {
private static final String hostname = \"localhost\";
private static final String port = \"3306\";
private static final String database = \"TestDB\";
private static final String username = \"root\";
private static final String password = \"\";
String returnString;
public String TrySelect() {
Connection c = getConnection();
// do an SELECT
try {
Statement s = (Statement)c.createStatement();
ResultSet r = s.executeQuery(\"SELECT fname FROM names\");
returnString = r.getString(\"fname\");
} catch ( Exception e ) {returnString = returnString + \" - Query failed\";}
return returnString;
}
private Connection getConnection() {
// Register the driver using Class.forName()
try {
Class.forName(\"org.gjt.mm.mysql.Driver\").newInstance();
} catch ( Exception e ) {returnString = \"forName failed\";}
// ask the DriverManager for a connection to the database
Connection conn = null;
try {
conn = DriverManager.getConnection(\"jdbc:mysql://\" + hostname + \":\"+ port +\"/\" + database + \"?user=\" + username + \"&password=\" + password );
//conn = DriverManager.getConnection(\"jdbc:mysql://localhost:3306/TestDB\");
} catch ( Exception e) {returnString = \"DriverManager failed\";}
return conn;
}
}
