Original Post
Hello, i just tried to get the first example to work:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import com.mysql.management.driverlaunched.ServerLauncherSocketFactory;
public class ConnectorMXJTestExample {
public static void main(String[] args) throws Exception {
String hostColonPort = "localhost:3306";
String driver = com.mysql.jdbc.Driver.class.getName();
String url = "jdbc:mysql://" + hostColonPort + "&#<span class="java-number">47</span>;"</span> + <span class="java-literal">"?"</span>
+ <span class="java-literal">"socketFactory="</span>
+ ServerLauncherSocketFactory.<span class="java-keyword">class</span>.getName();
String userName = <span class="java-literal">"root"</span>;
String password = <span class="java-literal">""</span>;
<span class="java-keyword">Class</span>.forName(driver);
Connection conn = <span class="java-keyword">null</span>;
<span class="java-keyword">try</span> {
conn = DriverManager.getConnection(url, userName, password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(<span class="java-literal">"SELECT VERSION()"</span>);
rs.next();
String version = rs.getString(<span class="java-number">1</span>);
rs.close();
stmt.close();
System.out.println(<span class="java-literal">"------------------------"</span>);
System.out.println(version);
System.out.println(<span class="java-literal">"------------------------"</span>);
} <span class="java-keyword">finally</span> {
<span class="java-keyword">try</span> {
conn.close();
} <span class="java-keyword">catch</span> (Exception e) {
e.printStackTrace();
}
ServerLauncherSocketFactory.shutdown(hostColonPort);
}
}
}
</pre></div><!--ENDSCRIPT-->
With the following compile statement and execute statement:
H:\MySQL\connector-mxj>javac ConnectorMXJTestExample.java -cp H:\MySQL\jar\conne
ctor-mxj.jar;H:\MySQL\jar\mysql-connector-java-3.1.11-bin.jar
H:\MySQL\connector-mxj>java ConnectorMXJTestExample -cp H:\MySQL\jar\connector-m
xj.jar;H:\MySQL\jar\mysql-connector-java-3.1.11-bin.jar
and get only the following error
Exception in thread "main" java.lang.NoClassDefFoundError: ConnectorMXJTestExamp
le
The error seems to be caused by
String driver = com.mysql.jdbc.Driver.class.getName()
But if i reduce the code to the following:
Class.forName("com.mysql.jdbc.Driver").newInstance();
I still get the same error.
can any body help me? Thanks a lot!</code></pre></div>