Acredito que estou com um problema com jars no classpath do tomcat…
Coloquei os jars na lib da minha aplicação, nos logs do tomcat está aparecendo este erro:
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at teste.Teste.<init>(Teste.java:18)
at org.apache.jsp.listar_jsp._jspService(listar_jsp.java:50)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at teste.Teste.setConsulta(Teste.java:41)
at org.apache.jsp.listar_jsp._jspService(listar_jsp.java:119)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Unknown Source)
O código que faz a consulta é este:
<%
try {
con.setConsulta();
ResultSet temp = con.getResultado();
while (temp.next()){
%>
<tr >
<td>
<%out.print(temp.getString("_file-name"));%>
</td>
<%}
}catch (Exception e) {
e.printStackTrace();
}
%>
E a classe java é:
package teste;
import java.sql.*;
public class Teste{
public ResultSet res = null;
public Connection con;
public Statement stm;
private String sit = "";
public Teste() {
try {
String driver ="com.progress.sql.jdbc.JdbcProgressDriver";
String URL = "jdbc:jdbcprogress:T:192.168.0.3:15497:ems2mul4";
String username = "xxxx";
String password = "xxxx";
// Abre a conexão
Class.forName( driver );
con = DriverManager.getConnection( URL,username, password );
stm = con.createStatement();
con.setAutoCommit(false);
con.setTransactionIsolation(2);
sit = "Conectado ao: " + URL ;
}
catch (SQLException ex) {
ex.printStackTrace();
}
catch (ClassNotFoundException ex1){
sit = "Erro: Driver nao encontrado\n" + ex1.getMessage();
}
catch (NoClassDefFoundError ex2){
sit = "Erro: " + ex2.getMessage();
}
}
public String getSituacao(){
return sit;
}
public void setConsulta() {
try {
res = stm.executeQuery("SELECT \"_file-name\" FROM \"PUB\".\"_file\"" );
}
catch (SQLException e){
sit = "Erro: "+ e.getMessage();
}
}
public ResultSet getResultado() {
return res;
}
}
Obrigado!!
