Pessoal,
to começando a usar o Hibernate e não estou conseguindo configurar ele no OracleXE. Eu consigo cadastrar no banco, mas não consigo consultar, alterar e excluir.
Minha impressão é que não funciona em operações em que usa a condição Where.
Alguem tem alguma idéia do que seja??
Postem ae por favor !!
Segue os códigos abaixo:
hibernate.properties:
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@localhost:1521:XE
hibernate.connection.username=system
hibernate.connection.password=123
hibernate.hbm2ddl.auto=update
DAO:
public class DAODiaria {
private SessionFactory fabrica;
public DAODiaria()throws Exception
{
fabrica = new Configuration().addClass(Diaria.class).buildSessionFactory();
}
public void cadastrar(Diaria D)throws Exception
{
Session sessao = fabrica.openSession();
Transaction transacao = sessao.beginTransaction();
sessao.save(D);
transacao.commit();
sessao.flush();
sessao.close();
}
public void alterar(Diaria D)throws Exception
{
Session sessao = fabrica.openSession();
Transaction transacao = sessao.beginTransaction();
sessao.update(D);
transacao.commit();
sessao.flush();
sessao.close();
}
public void excluir(Diaria D)throws Exception
{
Session sessao = fabrica.openSession();
Transaction transacao = sessao.beginTransaction();
sessao.delete(D);
transacao.commit();
sessao.flush();
sessao.close();
}
public Diaria consultar (Diaria D)throws Exception
{
Session sessao = fabrica.openSession();
Transaction transacao = sessao.beginTransaction();
D=(Diaria)sessao.get(Diaria.class,D.getCodigo());
transacao.commit();
sessao.flush();
sessao.close();
return D;
}
}
Segue o Output ao tentar consultar no banco:
(…)
2009-03-21 20:02:45,546 DEBUG org.hibernate.persister.entity.AbstractEntityPersister Static SQL for entity: modelo.Diaria
2009-03-21 20:02:45,546 DEBUG org.hibernate.persister.entity.AbstractEntityPersister Version select: select cod from diaria where cod =?
2009-03-21 20:02:45,546 DEBUG org.hibernate.persister.entity.AbstractEntityPersister Snapshot select: select diaria_.cod, diaria_.descricao as descricao8_, diaria_.valor as valor8_ from diaria diaria_ where diaria_.cod=?
2009-03-21 20:02:45,546 DEBUG org.hibernate.persister.entity.AbstractEntityPersister Insert 0: insert into diaria (descricao, valor, cod) values (?, ?, ?)
2009-03-21 20:02:45,546 DEBUG org.hibernate.persister.entity.AbstractEntityPersister Update 0: update diaria set descricao=?, valor=? where cod=?
2009-03-21 20:02:45,546 DEBUG org.hibernate.persister.entity.AbstractEntityPersister Delete 0: delete from diaria where cod=?
2009-03-21 20:02:45,546 DEBUG org.hibernate.loader.entity.EntityLoader Static select for entity modelo.Diaria: select diaria0_.cod as cod8_0_, diaria0_.descricao as descricao8_0_, diaria0_.valor as valor8_0_ from diaria diaria0_ where diaria0_.cod=?
2009-03-21 20:02:45,546 DEBUG org.hibernate.loader.entity.EntityLoader Static select for entity modelo.Diaria: select diaria0_.cod as cod8_0_, diaria0_.descricao as descricao8_0_, diaria0_.valor as valor8_0_ from diaria diaria0_ where diaria0_.cod=?
2009-03-21 20:02:45,546 DEBUG org.hibernate.loader.entity.EntityLoader Static select for entity modelo.Diaria: select diaria0_.cod as cod8_0_, diaria0_.descricao as descricao8_0_, diaria0_.valor as valor8_0_ from diaria diaria0_ where diaria0_.cod=? for update
2009-03-21 20:02:45,546 DEBUG org.hibernate.loader.entity.EntityLoader Static select for entity modelo.Diaria: select diaria0_.cod as cod8_0_, diaria0_.descricao as descricao8_0_, diaria0_.valor as valor8_0_ from diaria diaria0_ where diaria0_.cod=? for update nowait
2009-03-21 20:02:45,546 DEBUG org.hibernate.loader.entity.EntityLoader Static select for entity modelo.Diaria: select diaria0_.cod as cod8_0_, diaria0_.descricao as descricao8_0_, diaria0_.valor as valor8_0_ from diaria diaria0_ where diaria0_.cod=? for update nowait
2009-03-21 20:02:45,546 DEBUG org.hibernate.loader.entity.EntityLoader Static select for action ACTION_MERGE on entity modelo.Diaria: select diaria0_.cod as cod8_0_, diaria0_.descricao as descricao8_0_, diaria0_.valor as valor8_0_ from diaria diaria0_ where diaria0_.cod=?
2009-03-21 20:02:45,546 DEBUG org.hibernate.loader.entity.EntityLoader Static select for action ACTION_REFRESH on entity modelo.Diaria: select diaria0_.cod as cod8_0_, diaria0_.descricao as descricao8_0_, diaria0_.valor as valor8_0_ from diaria diaria0_ where diaria0_.cod=?
2009-03-21 20:02:45,546 DEBUG org.hibernate.impl.SessionFactoryObjectFactory registered: 40288182202b42f201202b45a42a0004 (unnamed)
2009-03-21 20:02:45,546 INFO org.hibernate.impl.SessionFactoryObjectFactory Not binding factory to JNDI, no JNDI name configured
2009-03-21 20:02:45,546 DEBUG org.hibernate.impl.SessionFactoryImpl instantiated session factory
2009-03-21 20:02:45,546 INFO org.hibernate.tool.hbm2ddl.SchemaUpdate Running hbm2ddl schema update
2009-03-21 20:02:45,546 INFO org.hibernate.tool.hbm2ddl.SchemaUpdate fetching database metadata
2009-03-21 20:02:45,593 INFO org.hibernate.tool.hbm2ddl.SchemaUpdate updating schema
2009-03-21 20:02:45,593 DEBUG org.hibernate.cfg.Configuration processing extends queue
2009-03-21 20:02:45,593 DEBUG org.hibernate.cfg.Configuration processing collection mappings
2009-03-21 20:02:45,593 DEBUG org.hibernate.cfg.Configuration processing native query and ResultSetMapping mappings
2009-03-21 20:02:45,593 DEBUG org.hibernate.cfg.Configuration processing association property references
2009-03-21 20:02:45,593 DEBUG org.hibernate.cfg.Configuration processing foreign key constraints
2009-03-21 20:02:45,609 INFO org.hibernate.tool.hbm2ddl.TableMetadata table found: SYSTEM.DIARIA
2009-03-21 20:02:45,609 INFO org.hibernate.tool.hbm2ddl.TableMetadata columns: [cod, valor, descricao]
2009-03-21 20:02:45,609 INFO org.hibernate.tool.hbm2ddl.TableMetadata foreign keys: []
2009-03-21 20:02:45,609 INFO org.hibernate.tool.hbm2ddl.TableMetadata indexes: [sys_c005301]
2009-03-21 20:02:45,609 INFO org.hibernate.tool.hbm2ddl.SchemaUpdate schema update complete
2009-03-21 20:02:45,609 DEBUG org.hibernate.impl.SessionFactoryImpl Checking 0 named HQL queries
2009-03-21 20:02:45,609 DEBUG org.hibernate.impl.SessionFactoryImpl Checking 0 named SQL queries
2009-03-21 20:02:45,609 DEBUG org.hibernate.impl.SessionImpl opened session at timestamp: [telefone removido]
2009-03-21 20:02:45,609 DEBUG org.hibernate.transaction.JDBCTransaction begin
2009-03-21 20:02:45,609 DEBUG org.hibernate.jdbc.ConnectionManager opening JDBC connection
2009-03-21 20:02:45,609 DEBUG org.hibernate.transaction.JDBCTransaction current autocommit status: false
2009-03-21 20:02:45,609 DEBUG org.hibernate.loader.Loader loading entity: [modelo.Diaria#1]
2009-03-21 20:02:45,625 DEBUG org.hibernate.jdbc.AbstractBatcher about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2009-03-21 20:02:45,625 DEBUG org.hibernate.SQL select diaria0_.cod as cod8_0_, diaria0_.descricao as descricao8_0_, diaria0_.valor as valor8_0_ from diaria diaria0_ where diaria0_.cod=?
2009-03-21 20:02:45,625 DEBUG org.hibernate.jdbc.AbstractBatcher about to open ResultSet (open ResultSets: 0, globally: 0)
2009-03-21 20:02:45,625 DEBUG org.hibernate.jdbc.AbstractBatcher about to close ResultSet (open ResultSets: 1, globally: 1)
2009-03-21 20:02:45,625 DEBUG org.hibernate.jdbc.AbstractBatcher about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2009-03-21 20:02:45,625 DEBUG org.hibernate.engine.StatefulPersistenceContext initializing non-lazy collections
2009-03-21 20:02:45,625 DEBUG org.hibernate.loader.Loader done entity load
2009-03-21 20:02:45,625 DEBUG org.hibernate.transaction.JDBCTransaction commit
2009-03-21 20:02:45,625 DEBUG org.hibernate.transaction.JDBCTransaction committed JDBC Connection
2009-03-21 20:02:45,625 DEBUG org.hibernate.jdbc.ConnectionManager aggressively releasing JDBC connection
2009-03-21 20:02:45,625 DEBUG org.hibernate.jdbc.ConnectionManager releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]