[Resolvido]Sistema loga no trabalho mas nao loga no meu notebook

Front-end
#1

Pessoal

Estou fazendo um sistema web, a parte de login ja ta perfeita… Estou utilizando Spring + jsf + hibernate.
No pc do trabalho (o mysql fica instalado em outra maquina ex: maquinax:3306…) o sistema loga perfeitamente, sem nenhum erro.
Entao, instalei o eclipse no note, instalei o mysql, criei um banco ( com o mesmo nome do banco do trabalho), peguei o projeto, importei p o meu note, Restaurei todo o conteudo do banco, mudei o arquivo de configuracao do hibernate para localhost:3306… Entao, pagina do login abre perfeitamente, quando eu vou logar no sistema ele nao entra…
Ele abre a pagina de erro q eu fiz p o login… Estou usando o windows 7.

Alguem tem ideia pq ta acontecendo isso ? No console ele nao mostra nenhuma msg de erro…

#2

Você cadastrou o usuário no banco de dados?
O usuário que irá logar?

#3

Mas qual a exceção lançada? Deve ter alguma coisa.
Você tentou logar em modo debug? Assim pode analisar os objetos, como por exemplo, o que usou para realizar a consulta do login.

#4

[quote=Hebert Coelho]Você cadastrou o usuário no banco de dados?
O usuário que irá logar?[/quote]

Sim… Ja olhei o conteudo do banco, ta = ao conteudo do banco do pc do trab… Eu fiz um backup do banco e depois eu restaurei no note…
Eu to achando q eh algo no windows… meu arquivo “host” do windows do note ta diferente do meu arquivo host do pc do trab…
Eu instalei um anti-spy no meu note, ele adicionou coisas nesse arquivo, sera q eh isso ?

#5

[quote=tiago__][quote=Hebert Coelho]Você cadastrou o usuário no banco de dados?
O usuário que irá logar?[/quote]

Sim… Ja olhei o conteudo do banco, ta = ao conteudo do banco do pc do trab… Eu fiz um backup do banco e depois eu restaurei no note…
Eu to achando q eh algo no windows… meu arquivo “host” do windows do note ta diferente do meu arquivo host do pc do trab…
Eu instalei um anti-spy no meu note, ele adicionou coisas nesse arquivo, sera q eh isso ? [/quote]Desative o anti-spy. Pode ser que ele esteja bloqueando a comunicação.

Mas eu também acho muito estranho nenhuma mensagem de error está sendo exibida.

#6

[quote=romarcio]Mas qual a exceção lançada? Deve ter alguma coisa.
Você tentou logar em modo debug? Assim pode analisar os objetos, como por exemplo, o que usou para realizar a consulta do login.
[/quote]

Nao loguei utilizando debug nao… Qnd starta o tomcat ele n mostra nada, qnd tento logar ele tb n mostra nada no console. Eu sou novo em desenvolvimento, nao sei fzer o tal Debug :confused:

#7

[quote=tiago__][quote=romarcio]Mas qual a exceção lançada? Deve ter alguma coisa.
Você tentou logar em modo debug? Assim pode analisar os objetos, como por exemplo, o que usou para realizar a consulta do login.
[/quote]

Nao loguei utilizando debug nao… Qnd starta o tomcat ele n mostra nada, qnd tento logar ele tb n mostra nada no console. Eu sou novo em desenvolvimento, nao sei fzer o tal Debug :/[/quote]

Eu desinstalei o anti-spy e nada… Mas o arquivo “host” continua como tava, to tentando apagar o q o anti-spy add, mas nao ta indo… To como administrador da maquina mas mesmo assim ele ta dizendo q nao posso, to trabalhando nisso. Eu to achando q eh isso…

#8

Qnd eu dou start no tomcat:

19/10/2012 12:29:07 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\Program Files\Java\jre6\bin;C:\Windows\Sun\Java\bin;C:\Windows\system32;C:\Windows;C:\Program Files\Common Files\Microsoft Shared\Windows Live;C:\Program Files (x86)\Common Files\Microsoft Shared\Windows Live;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0;C:\Program Files (x86)\Windows Live\Shared;.
19/10/2012 12:29:07 org.apache.tomcat.util.digester.SetPropertiesRule begin
AVISO: [SetPropertiesRule]{Server/Service/Engine/Host/Context} Setting property ‘source’ to ‘org.eclipse.jst.jee.server:RequisicaoMaterial’ did not find a matching property.
19/10/2012 12:29:07 org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“http-bio-8080”]
19/10/2012 12:29:07 org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler [“ajp-bio-8009”]
19/10/2012 12:29:07 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 672 ms
19/10/2012 12:29:07 org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
19/10/2012 12:29:07 org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.29
19/10/2012 12:29:07 org.apache.catalina.loader.WebappClassLoader validateJarFile
INFO: validateJarFile(D:\tomcat7\wtpwebapps\RequisicaoMaterial\WEB-INF\lib\el-api-2.2.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/el/Expression.class
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/core_rt is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/core is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/core is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/fmt_rt is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/fmt is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/fmt is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/functions is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/permittedTaglibs is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://jakarta.apache.org/taglibs/standard/scriptfree is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/sql_rt is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/sql is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/sql is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/xml_rt is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jstl/xml is already defined
19/10/2012 12:29:14 org.apache.catalina.startup.TaglibUriRule body
INFO: TLD skipped. URI: http://java.sun.com/jsp/jstl/xml is already defined
19/10/2012 12:29:14 org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
log4j:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader).
log4j:WARN Please initialize the log4j system properly.
19/10/2012 12:29:15 com.sun.faces.config.ConfigureListener contextInitialized
INFO: Inicializando Mojarra 2.0.3 (SNAPSHOT 20100624) para o contexto ‘/RequisicaoMaterial’
19/10/2012 12:29:16 com.sun.faces.spi.InjectionProviderFactory createInstance
INFO: JSF1048: Anotações PostConstruct/PreDestroy presentes. Os métodos ManagedBeans marcados com essas anotações informarão as anotações processadas.
19/10/2012 12:29:16 com.sun.faces.mgbean.BeanManager addBean
AVISO: JSF1074: O bean gerenciado denominado ‘usuarioBean’ já foi registrado. Substituindo o tipo de classe do bean gerenciado requisicao.web.UsuarioBean por requisicao.web.UsuarioBean.
19/10/2012 12:29:16 com.sun.faces.mgbean.BeanManager addBean
AVISO: JSF1074: O bean gerenciado denominado ‘setorBean’ já foi registrado. Substituindo o tipo de classe do bean gerenciado requisicao.web.SetorBean por requisicao.web.SetorBean.
19/10/2012 12:29:17 com.sun.faces.config.ConfigureListener$WebConfigResourceMonitor$Monitor
INFO: Monitoring jndi:/localhost/RequisicaoMaterial/WEB-INF/faces-config.xml for modifications
4 [localhost-startStop-1] INFO org.hibernate.cfg.annotations.Version - Hibernate Annotations 3.5.2-Final
33 [localhost-startStop-1] INFO org.hibernate.cfg.Environment - Hibernate 3.5.2-Final
35 [localhost-startStop-1] INFO org.hibernate.cfg.Environment - hibernate.properties not found
40 [localhost-startStop-1] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist
48 [localhost-startStop-1] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling
205 [localhost-startStop-1] INFO org.hibernate.annotations.common.Version - Hibernate Commons Annotations 3.2.0.Final
217 [localhost-startStop-1] INFO org.hibernate.cfg.Configuration - configuring from resource: hibernate.cfg.xml
217 [localhost-startStop-1] INFO org.hibernate.cfg.Configuration - Configuration resource: hibernate.cfg.xml
305 [localhost-startStop-1] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null
315 [localhost-startStop-1] INFO org.hibernate.cfg.search.HibernateSearchEventListenerRegister - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
388 [localhost-startStop-1] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: requisicao.usuario.Usuario
450 [localhost-startStop-1] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity requisicao.usuario.Usuario on table usuario
592 [localhost-startStop-1] INFO org.hibernate.cfg.AnnotationBinder - Binding entity from annotated class: requisicao.setor.Setor
592 [localhost-startStop-1] INFO org.hibernate.cfg.annotations.EntityBinder - Bind entity requisicao.setor.Setor on table setor
654 [localhost-startStop-1] INFO org.hibernate.cfg.AnnotationConfiguration - Hibernate Validator not found: ignoring
662 [localhost-startStop-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!)
662 [localhost-startStop-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20
662 [localhost-startStop-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false
665 [localhost-startStop-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/requmaterial
665 [localhost-startStop-1] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=****}
814 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - RDBMS: MySQL, version: 5.5.28
814 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )
838 [localhost-startStop-1] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
843 [localhost-startStop-1] INFO org.hibernate.engine.jdbc.JdbcSupportLoader - Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
844 [localhost-startStop-1] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions)
846 [localhost-startStop-1] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
846 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled
846 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled
846 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - JDBC batch size: 15
846 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - JDBC batch updates for versioned data: disabled
847 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: enabled
847 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): enabled
847 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto
848 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2
848 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1
848 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled
848 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled
848 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled
848 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
850 [localhost-startStop-1] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory
850 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {}
850 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled
850 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled
850 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled
851 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
851 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled
851 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled
856 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled
856 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled
856 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo
856 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled
856 [localhost-startStop-1] INFO org.hibernate.cfg.SettingsFactory - Check Nullability in Core (should be disabled when Bean Validation is on): enabled
893 [localhost-startStop-1] INFO org.hibernate.impl.SessionFactoryImpl - building session factory
1104 [localhost-startStop-1] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured
1110 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - Running hbm2ddl schema update
1110 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - fetching database metadata
1110 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - updating schema
1128 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: requmaterial.setor
1128 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [codigo, nome]
1128 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: []
1128 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [primary]
1140 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: requmaterial.usuario
1140 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [codigo, ativo, login, nome, senha, codigosetor, matricula]
1140 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: [codigosetor]
1140 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [primary, codigosetor]
1146 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - table found: requmaterial.usuario_permissao
1146 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - columns: [usuario, permissao]
1146 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - foreign keys: [fk9565d5b6b7bf50d7]
1146 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.TableMetadata - indexes: [fk9565d5b6b7bf50d7, usuario]
1147 [localhost-startStop-1] INFO org.hibernate.tool.hbm2ddl.SchemaUpdate - schema update complete
19/10/2012 12:29:18 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\tomcat7\webapps\docs
19/10/2012 12:29:18 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\tomcat7\webapps\examples
19/10/2012 12:29:18 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
19/10/2012 12:29:18 org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
19/10/2012 12:29:18 org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: attributeAdded(‘org.apache.jasper.compiler.TldLocationsCache’, ‘org.apache.jasper.compiler.TldLocationsCache@609a5d54’)
19/10/2012 12:29:18 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\tomcat7\webapps\host-manager
19/10/2012 12:29:18 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\tomcat7\webapps\manager
19/10/2012 12:29:18 org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory D:\tomcat7\webapps\ROOT
19/10/2012 12:29:18 org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“http-bio-8080”]
19/10/2012 12:29:18 org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler [“ajp-bio-8009”]
19/10/2012 12:29:18 org.apache.catalina.startup.Catalina start
INFO: Server startup in 11029 ms

#9

Tem que ter pelo menos uma exceção dizendo que o acesso ao banco está sendo negado por algum motivo.
Nem no console da IDE aparece um erro quando você tenta logar?

#10

Olhe o log depois da primeira tentativa de logar.

#11

Qnd eu tento logar ele mostra isso no console:

19/10/2012 12:33:44 com.sun.faces.lifecycle.ELResolverInitPhaseListener populateFacesELResolverForJsp
INFO: JSF1027: [/RequisicaoMaterial] Os ELResolvers para JSF não foram registrados com o contêiner JSP.

No pc to trabalho ele mostra a mesma coisa… N eh nenhum erro, mas…

#12

[quote=romarcio]Tem que ter pelo menos uma exceção dizendo que o acesso ao banco está sendo negado por algum motivo.
Nem no console da IDE aparece um erro quando você tenta logar? [/quote]

Nem no console nem na IDE ?

#13

Esse log fica na pasta do programa ne ?

#14

Ja descobri q nao eh assim… Adicionei a aba Error Log, tentei logar, olhei e vi q nao tem nenhum erro…

So pode ser alguma coisa no windows.

#15

Muito estranho,esse sistema não precisa de nenhuma dependência que esteja na rede da tua empresa?Uma app de autenticação por exemplo?

#16

Nem tem… Eu fiz ele do zero ! Tenho certeza q n tem… Eh alguma coisa com o Windows, so pode.
To com vontade de formatar no note e instalar tudo do zero…

#17

Entao pessoal

na configuracao do spring, eu mudei a pagina de erro q eu fiz e coloquei a pagina de erro padrao do spring… Ele retornou tudo isso
Ele sitou isso aqui: : java.net.UnknownHostException: suporte02 at java.net.InetAddress.getAllByName0(Unknown Source)

Suporte02 eh o nome do pc q tem o mysql ( no meu trabalho)… Qnd eu coloquei o projeto no note, eu mudeu o nome para localhost…
Could not get JDBC Connection; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory

Parece q ele n ta pegando o jdbc driver no tomcat… To tentando resolver

Erro ao efetuar o login.

Motivo: Could not get JDBC Connection; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Server connection failure during transaction. Due to underlying exception: ‘java.net.UnknownHostException: suporte02’. ** BEGIN NESTED EXCEPTION ** java.net.UnknownHostException MESSAGE: suporte02 STACKTRACE: java.net.UnknownHostException: suporte02 at java.net.InetAddress.getAllByName0(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at java.net.InetAddress.getAllByName(Unknown Source) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:246) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2921) at com.mysql.jdbc.Connection.(Connection.java:1555) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) at org.apache.tomcat.dbcp.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.tomcat.dbcp.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:572) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:705) at org.springframework.security.core.userdetails.jdbc.JdbcDaoImpl.loadUsersByUsername(JdbcDaoImpl.java:190) at org.springframework.security.core.userdetails.jdbc.JdbcDaoImpl.loadUserByUsername(JdbcDaoImpl.java:153) at org.springframework.security.authentication.dao.DaoAuthenticationProvider.retrieveUser(DaoAuthenticationProvider.java:83) at org.springframework.security.authentication.dao.AbstractUserDetailsAuthenticationProvider.authenticate(AbstractUserDetailsAuthenticationProvider.java:125) at org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:121) at org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:49) at org.springframework.security.authentication.ProviderManager.doAuthentication(ProviderManager.java:139) at org.springframework.security.authentication.AbstractAuthenticationManager.authenticate(AbstractAuthenticationManager.java:49) at org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter.attemptAuthentication(UsernamePasswordAuthenticationFilter.java:98) at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:200) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356) at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:106) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:356) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:150) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Attempted reconnect 3 times. Giving up.)

#18

Em algum lugar do sistema ainda tá sendo usado esse nome suporte2,vê se não tem algum arquivo .properties ou outro arquivo usando esse nome.

#19

Ufa… Tinha que ter alguma exceção :wink:

O problema não parece ser com o Driver. Parece é que ele não consegue registrar o a conexão com o gerenciador do mysql. Ou, você pode estar com o MySql off, ou IP/Porta podem estar errados ou mesmo senha e login.

#20

Obrigado a todos pela ajuda… Foi um erro bobo, mas q sirva de lição !

Faltou colocar localhost no Context.xml !
Eu tinha esquecido dele…

Obrigado pessoal, e me foi mal por ter tomado o tempo de vcs com um erro bobo !

Abraços