Adgang til MySQL via JSP
Jeg har prob. med at få en connection ned mod min MySQL db. jeg har bl.a. følgende kode på en JSP side:<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.SQLException" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Statement" %>
<%
try {
Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/puis?user=puis&password=puis");
Statement stmt = null;
ResultSet rs = null;
try {
stmt = conn.createStatement();
rs = stmt.executeQuery("SELECT * FROM Vendor");
while(rs.next()){
System.out.println(rs.getString("Name"));
}
} catch (Exception e){
e.printStackTrace();
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}
%>
Jeg får fejlen:
SQLException: No suitable driver
SQLState: 08001
VendorError: 0
Nogen fornuftig forklaring ??
