Erro usando hibernate

Front-end
#1

Aqui é o log do eclipse!
alguem sabe dizer o por que desse erro?
Qualque coisa, eu posto o projeto pra vocês vizualizarem

run: 0 [main] INFO org.hibernate.cfg.Environment - Hibernate 3.5.2-Final 0 [main] INFO org.hibernate.cfg.Environment - hibernate.properties not found 0 [main] INFO org.hibernate.cfg.Environment - Bytecode provider name : javassist 15 [main] INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling 62 [main] INFO org.hibernate.cfg.Configuration - configuring from resource: hibernate.cfg.xml 62 [main] INFO org.hibernate.cfg.Configuration - Configuration resource: hibernate.cfg.xml 109 [main] INFO org.hibernate.cfg.Configuration - Reading mappings from resource : com/livro/capitulo3/crudxml/Contato.hbm.xml 140 [main] INFO org.hibernate.cfg.HbmBinder - Mapping class: com.livro.capitulo3.crudxml.Contato -> contato 156 [main] INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null 187 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!) 187 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20 187 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false 187 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/agenda 187 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root} 296 [main] WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection to query metadata java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:951) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4600) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1328) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2395) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2428) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2213) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) 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:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) 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:114) at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383) at com.livro.capitulo3.conexao.hibernateUtil.buildSessionFactory(hibernateUtil.java:21) at com.livro.capitulo3.conexao.hibernateUtil.<clinit>(hibernateUtil.java:13) at com.livro.capitulo3.crudxml.ContatoCrudXML.salvar(ContatoCrudXML.java:47) at com.livro.capitulo3.crudxml.ContatoCrudXML.main(ContatoCrudXML.java:168) 390 [main] INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect 390 [main] INFO org.hibernate.engine.jdbc.JdbcSupportLoader - Disabling contextual LOB creation as connection was null 405 [main] INFO org.hibernate.transaction.TransactionFactoryFactory - Using default transaction strategy (direct JDBC transactions) 405 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 405 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto 405 [main] INFO org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2 405 [main] INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1 405 [main] INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: enabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Order SQL inserts for batching: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 405 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory 405 [main] INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {} 405 [main] INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory 405 [main] INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout 405 [main] INFO org.hibernate.cfg.SettingsFactory - Statistics: enabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo 405 [main] INFO org.hibernate.cfg.SettingsFactory - Named query checking : enabled 405 [main] INFO org.hibernate.cfg.SettingsFactory - Check Nullability in Core (should be disabled when Bean Validation is on): enabled 421 [main] INFO org.hibernate.impl.SessionFactoryImpl - building session factory 515 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory - Not binding factory to JNDI, no JNDI name configured Não foi possível inserir o contato. Erro: Cannot open connection 546 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1045, SQLState: 28000 546 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Access denied for user 'root'@'localhost' (using password: NO) Não foi possível inserir o contato. Erro: Cannot open connection 546 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1045, SQLState: 28000 546 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Access denied for user 'root'@'localhost' (using password: NO) Não foi possível inserir o contato. Erro: Cannot open connection 546 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1045, SQLState: 28000 546 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Access denied for user 'root'@'localhost' (using password: NO) Não foi possível selecionar contatos. Erro: Cannot open connection 546 [main] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 1045, SQLState: 28000 546 [main] ERROR org.hibernate.util.JDBCExceptionReporter - Access denied for user 'root'@'localhost' (using password: NO) Exception in thread "main" org.hibernate.HibernateException: org.hibernate.exception.GenericJDBCException: Cannot open connection at com.livro.capitulo3.crudxml.ContatoCrudXML.listar(ContatoCrudXML.java:117) at com.livro.capitulo3.crudxml.ContatoCrudXML.main(ContatoCrudXML.java:170) Caused by: org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) 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:1463) at com.livro.capitulo3.crudxml.ContatoCrudXML.listar(ContatoCrudXML.java:110) ... 1 more Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:951) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4600) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1328) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2395) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2428) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2213) at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:797) at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) 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:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) 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) ... 6 more Java Result: 1 CONSTRUÍDO COM SUCESSO (tempo total: 0 segundos)

#2

Não tenha medo de ler o erro. [=

Olha só a mensagem que aparece: Access denied for user ‘root’@‘localhost’ (using password: NO)

#3

jakefrog , deculpa me expressei mail. Eu sei que o erro estar aí.: acesso negado para o úsuario root@localhost.
Como eu resolvo esse problema? estou usando o úsuario root e senha corretamente, é tanto quando eu execute minha conexão diz, que foi realizado com sucesso.

#4

INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root}
E

Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: NO)
Me dizem que o hibernate está sem configuração da senha.

#5

Posta seu arquivo: hibernate.cfg.xml

#6

Ou hibernate.properties ou a classe onde está a configuração programatíca

#7

Olha o meu hibernate.cfg.xml

[code]<?xml version='1.0' encoding='utf-8'?>

org.hibernate.dialect.MySQL5InnoDBDialect com.mysql.jdbc.Driver jdbc:mysql://localhost/agenda root 160406 thread 
   <!-- Configurações do C3PO para pool de conexões -->
   <property name="c3po.min_size">5</property>   <!--Números de conexões que o C3PO mantem preparada todo o tempo -->
   <property name="c3po.max_size">20</property>     <!--Número de conexões no pool, se o limite for ultrapassado gera uma exceção-->
   <property name="c3po.timeout">300</property>   <!--Tempo de limite para conexão inativa. No caso aqui é 300 segundos -->
   <property name="c3po.max_statements">50</property>   <!--Número máximo de declarações preparadas para irem para a memoria cache -->
   <property name="c3po.idle_test_period">3000</property><!--Tempo de inatividade em segundos antes que uma conexão seja automaticamente validade -->
   
   <!-- Configurações do debug -->
   <property name="show_sql">true</property><!--Exibe todas as saídas SQL no console-->
   <property name="format_sql">true</property><!--Exibe o comanado SQL executado tanto no console quanto no log-->
   <property name="generate_statistics">true</property><!--Habilita o hibernate a coletar estátiscas para posterior ajuste de desempenho. -->
   <property name="use_sql_comments">true</property><!--Gerar comentarios junto ao SQL para facilitar a depuração -->
   
   	<!-- Mapeando classes -->
<mapping resource="com/livro/capitulo3/crudxml/Contato.hbm.xml"/>
[/code]
#8

A senha está ali, mas o nome da propriedade não deveria ser connection.password?

<property name="password">160406</property>
#9

drsmachado, verdade !!!
vou corrigir, pra vê se resolve o probleeema -

#10

drsmachado probleeema resolvido, muitissimo obrigado !!!

quando crescer quero ser igual a você.

#11

[quote=drsmachado]A senha está ali, mas o nome da propriedade não deveria ser connection.password?

<property name="password">160406</property> [/quote]

Aham, com certeza é esse o problema.

#12

Resolvido obrigado a todos.

#13