Hibernate CreateQuery

VinnY99 · Fevereiro 18, 2011, 2:52pm

[code] public boolean dbLogin(String strLogin, String strSenha) {

    try {
        Session sessao = utilLogin.getSessionFactory().getCurrentSession();
        Transaction tx = sessao.beginTransaction();
        Query select = sessao.createQuery("from Login where Login = :login");
        select.setString("login","vinny");
        lstLista = select.list();
        tx.commit();
        sessao.close();
        if (lstLista.isEmpty()) {
            return false;
        }
        return true;
    } catch (HibernateException hibernateException) {
        return false;
    }
}[/code]

Onde está o erro desta pesquisa ?

Obrigado

alanbrasil1984 · Fevereiro 18, 2011, 2:55pm

coloca o erro pra gente ver…

VinnY99 · Fevereiro 18, 2011, 4:08pm

18/02/2011 17:22:54 org.hibernate.cfg.annotations.Version <clinit> INFO: Hibernate Annotations 3.3.1.GA 18/02/2011 17:22:54 org.hibernate.cfg.Environment <clinit> INFO: Hibernate 3.2.5 18/02/2011 17:22:54 org.hibernate.cfg.Environment <clinit> INFO: hibernate.properties not found 18/02/2011 17:22:54 org.hibernate.cfg.Environment buildBytecodeProvider INFO: Bytecode provider name : cglib 18/02/2011 17:22:54 org.hibernate.cfg.Environment <clinit> INFO: using JDK 1.4 java.sql.Timestamp handling 18/02/2011 17:22:54 org.hibernate.cfg.Configuration configure INFO: configuring from resource: /hibernate.cfg.xml 18/02/2011 17:22:54 org.hibernate.cfg.Configuration getConfigurationInputStream INFO: Configuration resource: /hibernate.cfg.xml 18/02/2011 17:22:54 org.hibernate.cfg.Configuration addResource INFO: Reading mappings from resource : Entidades/Login.hbm.xml 18/02/2011 17:22:55 org.hibernate.cfg.Configuration doConfigure INFO: Configured SessionFactory: null 18/02/2011 17:22:55 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues INFO: Mapping class: Entidades.Login -> login 18/02/2011 17:22:55 org.hibernate.cfg.AnnotationConfiguration secondPassCompile INFO: Hibernate Validator not found: ignoring 18/02/2011 17:22:55 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: Using Hibernate built-in connection pool (not for production use!) 18/02/2011 17:22:55 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: Hibernate connection pool size: 20 18/02/2011 17:22:55 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: autocommit mode: false 18/02/2011 17:22:55 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/controle_livros 18/02/2011 17:22:55 org.hibernate.connection.DriverManagerConnectionProvider configure INFO: connection properties: {user=root, password=****} 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: RDBMS: MySQL, version: 5.1.53-community 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.6 ( Revision: ${svn.Revision} ) 18/02/2011 17:22:55 org.hibernate.dialect.Dialect <init> INFO: Using dialect: org.hibernate.dialect.MySQLDialect 18/02/2011 17:22:55 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory INFO: Using default transaction strategy (direct JDBC transactions) 18/02/2011 17:22:55 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Automatic flush during beforeCompletion(): disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Automatic session close at end of transaction: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: JDBC batch size: 15 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: JDBC batch updates for versioned data: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Scrollable result sets: enabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: JDBC3 getGeneratedKeys(): enabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Connection release mode: auto 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Maximum outer join fetch depth: 2 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Default batch fetch size: 1 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Generate SQL with comments: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Order SQL updates by primary key: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Order SQL inserts for batching: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 18/02/2011 17:22:55 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init> INFO: Using ASTQueryTranslatorFactory 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Query language substitutions: {} 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: JPA-QL strict compliance: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Second-level cache: enabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Query cache: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory createCacheProvider INFO: Cache provider: org.hibernate.cache.NoCacheProvider 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Optimize cache for minimal puts: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Structured second-level cache entries: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Statistics: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Deleted entity synthetic identifier rollback: disabled 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Default entity-mode: pojo 18/02/2011 17:22:55 org.hibernate.cfg.SettingsFactory buildSettings INFO: Named query checking : enabled 18/02/2011 17:22:55 org.hibernate.impl.SessionFactoryImpl <init> INFO: building session factory 18/02/2011 17:22:56 org.hibernate.impl.SessionFactoryObjectFactory addInstance INFO: Not binding factory to JNDI, no JNDI name configured Exception occurred during event dispatching: java.lang.NullPointerException at org.hibernate.hql.ast.util.SessionFactoryHelper.findSQLFunction(SessionFactoryHelper.java:342) at org.hibernate.hql.ast.tree.IdentNode.getDataType(IdentNode.java:266) at org.hibernate.hql.ast.tree.BinaryLogicOperatorNode.extractDataType(BinaryLogicOperatorNode.java:168) at org.hibernate.hql.ast.tree.BinaryLogicOperatorNode.initialize(BinaryLogicOperatorNode.java:34) at org.hibernate.hql.ast.HqlSqlWalker.prepareLogicOperator(HqlSqlWalker.java:1007) at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3992) at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1762) at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776) at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577) at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281) at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229) at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228) at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160) at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77) at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56) at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72) at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133) at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112) at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623) 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.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301) at $Proxy0.createQuery(Unknown Source) at Database_Layer.dbLogin.dbLogin(dbLogin.java:19) at Business_Layer.bsLogin.Login(bsLogin.java:21) at GUI.Login.cmdEntrarActionPerformed(Login.java:97) at GUI.Login.access$100(Login.java:6) at GUI.Login$2.actionPerformed(Login.java:43) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:6289) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6054) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4652) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4482) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4482) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:603) at java.awt.EventQueue$1.run(EventQueue.java:601) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:617) at java.awt.EventQueue$2.run(EventQueue.java:615) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:614) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178) at java.awt.Dialog$1.run(Dialog.java:1046) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:642) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:603) at java.awt.EventQueue$1.run(EventQueue.java:601) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:617) at java.awt.EventQueue$2.run(EventQueue.java:615) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:614) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

adriano_si · Fevereiro 18, 2011, 5:15pm

seu JNDI está configurado ??? Posta teu arquivo de configuração do Hibernate…

Abs []

VinnY99 · Fevereiro 20, 2011, 10:33pm

[code]<?xml version="1.0" encoding="UTF-8"?>

org.hibernate.dialect.MySQLDialect com.mysql.jdbc.Driver jdbc:mysql://localhost:3306/controle_livros root adm thread [/code]

system · Dezembro 24, 2015, 9:48am

Hibernate CreateQuery

Cursos de Mobile

Cursos de Programação

Cursos de Front-end

Cursos de DevOps

Cursos de Design & UX

Cursos de Business

Cursos de Data & BI