Problema de conexao SQL server e Java

0 respostas
C
Bom galera to com um problema de conexão entre o Jbuilder e o SQL server. O codigo e o seguinte:
import java.sql.*;
import java.util.*;

public class Repositorio {

  static ResourceBundle res = ResourceBundle.getBundle("sismail.Res1");
  private static boolean DEBUG = false;
  //  private Connection connection;

   private final String driver = res.getString("driver");
   private static final String url = res.getString("url");
   private static final String user = res.getString("Usuario");
   private static final String password = res.getString("senha");
   private static Repositorio rep = new Repositorio();

   private Repositorio()
       {

     try {
       Class.forName(driver);
     }
     catch (ClassNotFoundException cex) {
       System.out.println(res.getString("nao_achei_o_drive_do"));
       //throw new Exception("_Nenhum_driver_dispon");
     }

   }

   public static Connection getConnection() throws SQLException {
     Connection connection = null;
     try {
     connection = DriverManager.getConnection(url, user, password);
     }
     catch (SQLException sex) {
        throw new SQLException(sex.getMessage());
      }
     return connection;
   }
   public static void devolveconexao(Connection connection) {
    try {
      connection.close();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }

  }
}//Fim de Classe
O arquivo de reposição eh esse:
url=jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=hotel
Usuario=sa
senha=
driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
e os erros de mensagewns são esses:

javax.servlet.ServletException: Servlet execution threw an exception
javax.servlet.ServletException: Servlet execution threw an exception
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:484)

Se vc's puderem me ajudar eu agradeço muito!!!! Isso seria para pegar no Banco os dados de login e senha de usuario para uma autenticação.

Criado 9 de junho de 2005
Respostas 0
Participantes 1