Question

java远程链接access数据库，报 No suitable driver

Class.forName("org.objectweb.rmijdbc.Driver").newInstance();
String url = "jdbc:rmi://192.168.211.128/jdbc:odbc:JDBC_ODBC";
Connection con = DriverManager.getConnection(url);
Statement st = con.createStatement();
String sql = "select * from ajun";
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
%>
<tr>
<td><%=rs.getInt(1)%></td>
<td><%=rs.getString(2) %></td>
<td><%=rs.getString(3) %></td>
</tr>
<%
}
rs.close();
st.close();
con.close();
%>
一直报org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: No suitable driver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:541)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause javax.servlet.ServletException: java.sql.SQLException: No suitable driver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.index_jsp._jspService(index_jsp.java:131)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWr....................................
求各位大神帮忙指点！！

Answer 1

检查这4个问题：

1. 连接URL格式是否有问题

2. 驱动字符串是否正确

3. 驱动是否在classpath中

4. JDBC_ODBC这个数据源是否在服务器上创建？
   

Answer 2

数据库驱动jar包build path了吗

追问

build path 了，用此方法本机的数据库是可以访问的！