Problema com Conexão com Banco usando Hibernate

5 respostas
F

Alguém pode me ajudar, da uma olhada no erro q está dando...

21/08/2006 08:42:19 WARN [SettingsFactory 95] - Could not obtain connection metadata
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
	at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
	at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
	at net.sf.hibernate.cfg.Configuration.buildSettings(Configuration.java:1132)
	at net.sf.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:766)
	at com.sebrae.hibernate.ser.ConnectionFactory.<init>(ConnectionFactory.java:37)
	at com.sebrae.hibernate.ser.ConnectionFactory.getInstance(ConnectionFactory.java:83)
	at com.sebrae.hibernate.ser.UsuarioService.getUsuarioEmail(UsuarioService.java:153)
	at com.sebrae.struts.form.ser.SerLogonForm.validate(SerLogonForm.java:62)
	at org.apache.struts.action.RequestProcessor.processValidate(RequestProcessor.java:942)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:255)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
	at java.lang.Thread.run(Thread.java:534)
21/08/2006 08:42:19 INFO [SettingsFactory 102] - Use scrollable result sets: false
21/08/2006 08:42:19 INFO [SettingsFactory 105] - Use JDBC3 getGeneratedKeys(): false
21/08/2006 08:42:19 INFO [SettingsFactory 108] - Optimize cache for minimal puts: false
21/08/2006 08:42:19 INFO [SettingsFactory 117] - Query language substitutions: {}
21/08/2006 08:42:19 INFO [SettingsFactory 128] - cache provider: net.sf.ehcache.hibernate.Provider
21/08/2006 08:42:19 INFO [Configuration 1093] - instantiating and configuring caches
21/08/2006 08:42:19 INFO [SessionFactoryImpl 119] - building session factory
21/08/2006 08:42:20 INFO [SessionFactoryObjectFactory 82] - no JNDI name configured
21/08/2006 08:42:21 WARN [JDBCExceptionReporter 38] - SQL Error: 0, SQLState: 08001
21/08/2006 08:42:21 ERROR [JDBCExceptionReporter 46] - [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
21/08/2006 08:42:21 WARN [JDBCExceptionReporter 38] - SQL Error: 0, SQLState: HY000
21/08/2006 08:42:21 ERROR [JDBCExceptionReporter 46] - [Microsoft][SQLServer 2000 Driver for JDBC]Connection refused: connect
21/08/2006 08:42:21 ERROR [JDBCException 38] - Cannot open connection
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
	at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
	at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
	at java.sql.DriverManager.getConnection(DriverManager.java:512)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at net.sf.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:101)
	at net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:278)
	at net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3297)
	at net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3277)
	at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
	at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:704)
	at net.sf.hibernate.loader.Loader.doQuery(Loader.java:185)
	at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
	at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
	at net.sf.hibernate.loader.Loader.list(Loader.java:946)
	at net.sf.hibernate.loader.CriteriaLoader.list(CriteriaLoader.java:121)
	at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3604)
	at net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
	at com.sebrae.hibernate.ser.UsuarioService.getUsuarioEmail(UsuarioService.java:158)
	at com.sebrae.struts.form.ser.SerLogonForm.validate(SerLogonForm.java:62)
	at org.apache.struts.action.RequestProcessor.processValidate(RequestProcessor.java:942)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:255)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
	at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
	at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
	at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:793)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:702)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:571)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:644)
	at java.lang.Thread.run(Thread.java:534)

5 Respostas

robson.java

Cara, esse problema ocorre porque o SQLServer não está atualizado, você precisa baixar um path de atualização, eu baxei o Service pack 3a e corrigiu esse bag.

Qualquer coisa estamos ai.

F

eu baixei ele tb, só q qnd vou instalar da a seguinte msg…

“Aguarde enquanto o Windows configura o Microsoft SQL Server Desktop Engine”

ai passa um poquim e da outra msg…

“A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit.”

Marcel_Horner

Essa outra mensagem diz que vc precisa utilizar um “strong password” por razoes de seguranca.

Um “strong password” eh:

  1. Formado de no minimo 7 caracteres
  2. Formado por uma combinacao de letras, numeros e simbolos
  3. Nao deve ser uma palavra, nem um comando, nem um nome de pessoa, nem um nome de sistema e nem um nome de usuario.
  4. Deve se modificado frequentemente e cada novo password deve ser consideravelmente diferente do anterior

Fonte: MSDN Library:
MSDN Home > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2,000 > Managing Security > Creating Security Accounts

F

ainda ñ deu certo, instalei o sp2…

F

tirei a versão do service pack 2 e coloquei a 3 e ainda ñ deu certo, alguém sabe o q pode ser???

Criado 21 de agosto de 2006
Ultima resposta 21 de ago. de 2006
Respostas 5
Participantes 3