Problemas com conexao SqlServer

Boa dia, estou fazendo um trabalho em jsp usando MVC … mas não estou conseguindo me conectar ao banco, n sei mais o que fazer nele… vou postar o codigo para ver se alguem tem uma ideia do que possa fazer.

public class DaoBase {
	
	private Connection con;
	
	public DaoBase(){
		try { 
			SQLServerDataSource ds = new SQLServerDataSource();
			ds.setUser("sa");
			ds.setPassword("sa");
			ds.setServerName("NOTE-IGOR"); //localhost
			ds.setPortNumber(1433); 
			ds.setDatabaseName("Biblioteca");
			con = ds.getConnection();
			
		} catch (SQLException e){
			System.out.println("Não consigo carregar banco de dados...");
			e.printStackTrace();
		}
	}
}

[URL=http://img353.imageshack.us/my.php?image=javaconxn9.jpg][/URL][URL=http://g.imageshack.us/thpix.php][/URL]

8:37:13,546 INFO  [Server] JBoss (MX MicroKernel) [4.2.2.GA (build: SVNTag=JBoss_4_2_2_GA date=200710221139)] Started in 15s:328ms
08:38:23,015 ERROR [STDERR] com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host NOTE-IGOR, port 1433 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
08:38:23,015 ERROR [STDERR] 	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:130)
08:38:23,015 ERROR [STDERR] 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1195)
08:38:23,015 ERROR [STDERR] 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(SQLServerConnection.java:1054)
08:38:23,015 ERROR [STDERR] 	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:758)
08:38:23,015 ERROR [STDERR] 	at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(SQLServerDataSource.java:578)
08:38:23,015 ERROR [STDERR] 	at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnection(SQLServerDataSource.java:63)
08:38:23,015 ERROR [STDERR] 	at com.pucmg.biblioteca.dao.DaoBase.<init>(DaoBase.java:25)
08:38:23,015 ERROR [STDERR] 	at com.pucmg.biblioteca.dao.TesteDAO.<init>(TesteDAO.java:5)
08:38:23,015 ERROR [STDERR] 	at com.pucmg.biblioteca.BO.LoginBO.validateLogin(LoginBO.java:8)
08:38:23,015 ERROR [STDERR] 	at com.pucmg.biblioteca.servlet.Teste.doPost(Teste.java:38)
08:38:23,015 ERROR [STDERR] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
08:38:23,015 ERROR [STDERR] 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
08:38:23,015 ERROR [STDERR] 	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
08:38:23,015 ERROR [STDERR] 	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
08:38:23,015 ERROR [STDERR] 	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
08:38:23,015 ERROR [STDERR] 	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
08:38:23,015 ERROR [STDERR] 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
08:38:23,015 ERROR [STDERR] 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
08:38:23,015 ERROR [STDERR] 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
08:38:23,015 ERROR [STDERR] 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
08:38:23,015 ERROR [STDERR] 	at java.lang.Thread.run(Thread.java:619)

13 Respostas

Topicos relacionados