Pessoal , fiz a seguinte rotina
EntityManagerFactory factory= Persistence.createEntityManagerFactory("lims-pu");
EntityManager manager= factory.createEntityManager();
Session session = (Session) manager.getDelegate();
Criteria criteria = session.createCriteria(PrecoPorMetodo.class);
criteria.setProjection(Projections.rowCount());
List result = criteria.list();
System.out.println("No. of rows: "+result);
return criteria.list();
///persistence
<persistence xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"
version="1.0">
<persistence-unit name="lims-pu" transaction-type="JTA">
<jta-data-source>java:/LimsDS</jta-data-source>
<jar-file>../auditor-ejb-${pom.version}.jar</jar-file>
<jar-file>../usuario-ejb-${pom.version}.jar</jar-file>
<jar-file>../funcionario-ejb-${pom.version}.jar</jar-file>
<jar-file>../cliente-ejb-${pom.version}.jar</jar-file>
<jar-file>../orcamento-ejb-${pom.version}.jar</jar-file>
<jar-file>../comum-ejb-${pom.version}.jar</jar-file>
<jar-file>../analise-ejb-${pom.version}.jar</jar-file>
<jar-file>../coleta-ejb-${pom.version}.jar</jar-file>
<jar-file>../faturamento-ejb-${pom.version}.jar</jar-file>
<jar-file>../laudo-ejb-${pom.version}.jar</jar-file>
<properties>
<property name="hibernate.transaction.manager_lookup_class"
value="org.hibernate.transaction.JBossTransactionManagerLookup"/>
<property name="hibernate.dialect" value="${hibernate.dialect}" />
<!-- property name="hibernate.hbm2ddl.auto" value="${hibernate.hbm2ddl}" /-->
<property name="hibernate.show_sql" value="${hibernate.show_sql}" />
<property name="hibernate.cache.provider_class" value="${hibernate.cache.provider_class}"/>
<property name="hibernate.cache.use_second_level_cache" value="${hibernate.cache.use_second_level_cache}"/>
<property name="hibernate.cache.use_query_cache" value="${hibernate.cache.use_query_cache}"/>
<property name="hibernate.jdbc.batch_size" value="0" />
</properties>
</persistence-unit>
</persistence>
Analisando o Log, verifiquei a seguinte situaçao :
2012-11-06 14:04:09,203 DEBUG [org.hibernate.cache.EhCacheProvider] started EHCache region: org.hibernate.cache.StandardQueryCache
2012-11-06 14:04:09,203 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named HQL queries
2012-11-06 14:04:09,203 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries
2012-11-06 14:04:09,203 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 5538684310335488
2012-11-06 14:04:09,203 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] Looking for a JTA transaction to join
2012-11-06 14:04:09,203 DEBUG [org.hibernate.ejb.AbstractEntityManagerImpl] No JTA transaction found
2012-11-06 14:04:16,857 INFO [STDOUT] No. of rows: []
O result esta vindo nulo, sendo que existe dados na minha tabela.
O problema de estar vindo nulo, pode ser o problema “No JTA transaction found”??? Alguem ja passou por isso ???