ericj 0 Denunciar post Postado Março 11, 2012 estou programando com jsf e hibernate pela primeira vez achei um exemplo na net e coloquei para rodar no eclipse e deu esse erro de sql algem poderia me dá uma luz sobre esse erro? o projeto desse erro está disponivel no 4shared link: http://www.4shared.com/rar/JtvKZXaB/jsf_parte3.html para quem quiser rodar a aplicação baixa aquivo desconectar e salva no eclipse e roda(é só criar um banco com nome jsf e uma tabela pessoa) obrigado boa noite 10/03/2012 23:26:23 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:\Arquivos de programas\Java\jdk1.6.0_26\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:/Arquivos de programas/Java/jre6/bin/client;C:/Arquivos de programas/Java/jre6/bin;C:/Arquivos de programas/Java/jre6/lib/i386;C:\Arquivos de programas\PC Connectivity Solution\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Arquivos de programas\QuickTime\QTSystem\;C:\Arquivos de programas\Internet Explorer;C:\Arquivos de programas\Microsoft SQL Server\80\Tools\Binn\;C:\Documents and Settings\Eric\Desktop\eclipseIndigo;;. 10/03/2012 23:26:23 org.apache.tomcat.util.digester.SetPropertiesRule begin AVISO: [setPropertiesRule]{Server/Service/Engine/Host/Context} Setting property 'source' to 'org.eclipse.jst.jee.server:jsf' did not find a matching property. 10/03/2012 23:26:23 org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["http-bio-8080"] 10/03/2012 23:26:23 org.apache.coyote.AbstractProtocol init INFO: Initializing ProtocolHandler ["ajp-bio-8009"] 10/03/2012 23:26:23 org.apache.catalina.startup.Catalina load INFO: Initialization processed in 1025 ms 10/03/2012 23:26:23 org.apache.catalina.core.StandardService startInternal INFO: Starting service Catalina 10/03/2012 23:26:23 org.apache.catalina.core.StandardEngine startInternal INFO: Starting Servlet Engine: Apache Tomcat/7.0.25 10/03/2012 23:26:24 org.apache.catalina.util.SessionIdGenerator createSecureRandom INFO: Creation of SecureRandom instance for session ID generation using [sHA1PRNG] took [140] milliseconds. 10/03/2012 23:26:24 org.apache.catalina.loader.WebappClassLoader validateJarFile INFO: validateJarFile(C:\Arquivos de Programas RFB\progrmaçcaoWEB\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\jsf\WEB-INF\lib\servlet.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class 10/03/2012 23:26:27 org.apache.coyote.AbstractProtocol start INFO: Starting ProtocolHandler ["http-bio-8080"] 10/03/2012 23:26:27 org.apache.coyote.AbstractProtocol start INFO: Starting ProtocolHandler ["ajp-bio-8009"] 10/03/2012 23:26:27 org.apache.catalina.startup.Catalina start INFO: Server startup in 3761 ms >>>>>>>>>>>>>>>>>>>> Contrutor do PESSOA_MB <<<<<<<<<<<<<<<<<< >>>>>>>>>>>>>>>>>>>> Contrutor do PESSOA_MB <<<<<<<<<<<<<<<<<< Pessoa >> nome : null 23:26:31,984 INFO Version:15 - Hibernate Annotations 3.4.0.GA 23:26:32,031 INFO Environment:543 - Hibernate 3.3.1.GA 23:26:32,031 INFO Environment:576 - hibernate.properties not found 23:26:32,046 INFO Environment:709 - Bytecode provider name : javassist 23:26:32,062 INFO Environment:627 - using JDK 1.4 java.sql.Timestamp handling 23:26:32,171 INFO Version:14 - Hibernate Commons Annotations 3.1.0.GA 23:26:32,187 INFO Configuration:1460 - configuring from resource: /hibernate.cfg.xml 23:26:32,187 INFO Configuration:1437 - Configuration resource: /hibernate.cfg.xml 23:26:32,312 INFO Configuration:1575 - Configured SessionFactory: null 23:26:32,328 INFO HibernateSearchEventListenerRegister:53 - Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled. 23:26:32,437 INFO AnnotationBinder:419 - Binding entity from annotated class: br.com.serjaum.modelo.Pessoa 23:26:32,515 INFO EntityBinder:422 - Bind entity br.com.serjaum.modelo.Pessoa on table pessoa 23:26:32,625 INFO AnnotationConfiguration:369 - Hibernate Validator not found: ignoring 23:26:32,734 INFO DriverManagerConnectionProvider:64 - Using Hibernate built-in connection pool (not for production use!) 23:26:32,734 INFO DriverManagerConnectionProvider:65 - Hibernate connection pool size: 20 23:26:32,734 INFO DriverManagerConnectionProvider:68 - autocommit mode: false 23:26:32,734 INFO DriverManagerConnectionProvider:103 - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/jsf 23:26:32,734 INFO DriverManagerConnectionProvider:109 - connection properties: {user=root, password=****} 23:26:33,265 WARN SettingsFactory:144 - Could not obtain connection metadata java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2101) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1325) at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867) at br.com.serjaum.facade.PessoaFacadeImpl.salva(PessoaFacadeImpl.java:23) at br.com.serjaum.mb.PessoaMB.save(PessoaMB.java:29) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.el.parser.AstValue.invoke(AstValue.java:262) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278) at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:70) at javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:78) at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:57) at javax.faces.component.UICommand.broadcast(UICommand.java:143) at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321) at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296) at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253) at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466) at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32) at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:103) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:76) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178) at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290) at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:368) at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:495) 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:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) 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:987) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) 23:26:33,312 INFO Dialect:175 - Using dialect: org.hibernate.dialect.MySQLInnoDBDialect 23:26:33,328 INFO TransactionFactoryFactory:59 - Using default transaction strategy (direct JDBC transactions) 23:26:33,328 INFO TransactionManagerLookupFactory:80 - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 23:26:33,328 INFO SettingsFactory:170 - Automatic flush during beforeCompletion(): disabled 23:26:33,328 INFO SettingsFactory:174 - Automatic session close at end of transaction: disabled 23:26:33,343 INFO SettingsFactory:189 - Scrollable result sets: disabled 23:26:33,343 INFO SettingsFactory:197 - JDBC3 getGeneratedKeys(): disabled 23:26:33,343 INFO SettingsFactory:205 - Connection release mode: auto 23:26:33,343 INFO SettingsFactory:229 - Maximum outer join fetch depth: 2 23:26:33,343 INFO SettingsFactory:232 - Default batch fetch size: 1 23:26:33,343 INFO SettingsFactory:236 - Generate SQL with comments: disabled 23:26:33,343 INFO SettingsFactory:240 - Order SQL updates by primary key: disabled 23:26:33,343 INFO SettingsFactory:244 - Order SQL inserts for batching: disabled 23:26:33,343 INFO SettingsFactory:420 - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 23:26:33,359 INFO ASTQueryTranslatorFactory:47 - Using ASTQueryTranslatorFactory 23:26:33,359 INFO SettingsFactory:252 - Query language substitutions: {} 23:26:33,359 INFO SettingsFactory:257 - JPA-QL strict compliance: disabled 23:26:33,359 INFO SettingsFactory:262 - Second-level cache: enabled 23:26:33,359 INFO SettingsFactory:266 - Query cache: disabled 23:26:33,359 INFO SettingsFactory:405 - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory 23:26:33,359 INFO SettingsFactory:276 - Optimize cache for minimal puts: disabled 23:26:33,359 INFO SettingsFactory:285 - Structured second-level cache entries: disabled 23:26:33,390 INFO SettingsFactory:305 - Echoing all SQL to stdout 23:26:33,390 INFO SettingsFactory:314 - Statistics: disabled 23:26:33,390 INFO SettingsFactory:318 - Deleted entity synthetic identifier rollback: disabled 23:26:33,390 INFO SettingsFactory:333 - Default entity-mode: pojo 23:26:33,390 INFO SettingsFactory:337 - Named query checking : enabled 23:26:33,468 INFO SessionFactoryImpl:187 - building session factory 23:26:33,859 INFO SessionFactoryObjectFactory:105 - Not binding factory to JNDI, no JNDI name configured 23:26:33,937 WARN JDBCExceptionReporter:100 - SQL Error: 1045, SQLState: 28000 23:26:33,937 ERROR JDBCExceptionReporter:101 - Access denied for user 'root'@'localhost' (using password: YES) 23:26:33,968 ERROR _ErrorPageWriter:460 - An exception occurred javax.faces.FacesException: Error calling action method of component with id j_id_jsp_1910970484_1:j_id_jsp_1910970484_14 at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72) at javax.faces.component.UICommand.broadcast(UICommand.java:143) at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321) at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296) at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253) at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466) at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32) at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:103) at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:76) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:151) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178) at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290) at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:368) at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:495) 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:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) 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:987) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: javax.faces.el.EvaluationException: org.apache.jasper.el.JspELException: /pages/cadastraPessoa.jsp(37,5) '#{pessoaMB.save}' org.hibernate.exception.GenericJDBCException: Cannot open connection at javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:82) at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:57) ... 31 more Caused by: org.apache.jasper.el.JspELException: /pages/cadastraPessoa.jsp(37,5) '#{pessoaMB.save}' org.hibernate.exception.GenericJDBCException: Cannot open connection at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:79) at javax.faces.component._MethodExpressionToMethodBinding.invoke(_MethodExpressionToMethodBinding.java:78) ... 32 more Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353) at br.com.serjaum.facade.PessoaFacadeImpl.salva(PessoaFacadeImpl.java:25) at br.com.serjaum.mb.PessoaMB.save(PessoaMB.java:29) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.el.parser.AstValue.invoke(AstValue.java:262) at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278) at org.apache.jasper.el.JspMethodExpression.invoke(JspMethodExpression.java:70) ... 33 more Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:910) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3923) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1273) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2031) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:154) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) ... 46 more Compartilhar este post Link para o post Compartilhar em outros sites
Pablo Bom 2 Denunciar post Postado Março 28, 2012 Voce tem o mysql instalado ou um banco para acessar ?? se sim " Access denied for user 'root'@'localhost' (using password: YES)" confere a senha ou o caminho :) Compartilhar este post Link para o post Compartilhar em outros sites