Mais um erro

VEja a jsp:

<%@page import="java.sql.*"%>

<html>
<head>
</head>
<body>

<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;

Class c = Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:teste");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from clientes");
%>

      <table>
	<%while (rs.next()){%>
        <tr>
          <td><%=rs.getString("nome")%></td>
          <td><%=rs.getString("cidade")%></td>
        </tr>
	<%}%>
      </table>
    
</body>
</html>

Agora vejam este erro, ta acusndo que naum tem a base de dados, mas posso garantir que existe esta base de dados. O que pode ser?

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
	org.apache.jsp.recebe_jsp._jspService(org.apache.jsp.recebe_jsp:89)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Nome da fonte de dados não encontrado e nenhum driver padrão especificado
	sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
	sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
	sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
	sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)
	sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
	java.sql.DriverManager.getConnection(Unknown Source)
	java.sql.DriverManager.getConnection(Unknown Source)
	org.apache.jsp.recebe_jsp._jspService(org.apache.jsp.recebe_jsp:57)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
Apache Tomcat/5.5.9

5 Respostas

Topicos relacionados