ansaurus

Question

Hibernate returning no results show this error INFO: Not binding factory to JNDI, no JNDI name configured

Answer 1

A:

The log you pasted doesn't show any ERROR (nor FATAL nor WARNING) message and the particular message you're showing is just telling you that you didn't bind the SessionFactory to JNDI. There is nothing wrong with that, many application don't use a JNDI-bound SessionFactory and this is not really relevant when using JPA anyway. So just ignore this INFOrmational message.

Actually, according to the log file, everything looks fine: your entities have been detected, the named queries processed, the schema has been updated (so the connection to the DB is OK), etc.

That being said, I would first activate SQL logging to see what is happening exactly (this won't solve the problem but still). You can set either set the following property in your persistence.xml:

<!-- Echo all executed SQL to stdout -->
<property name="hibernate.show_sql" value="true"/>

Or (and I prefer this option because I want fine control over logging anyway), by setting the logging level to debug for the following category:

org.hibernate.SQL

And run the generated SQL against the database.

Second thing, I suggest using an injected container-managed EntityManager instead of using an application managed EntityManager (that's the preferred way to go in a managed environment):

@Stateless
public class VMatterDetailsFacade implements VMatterDetailsFacadeLocal {
    public static final Logger log = Logger.getLogger("ejb.VMatterDetailsFacade");

    @PersistenceContext(unitName = "DBAppPU")
    private EntityManager em;

    @Override
    public VMatterDetails find(String str) {
        throw new UnsupportedOperationException("Not supported yet.");
    }

    @Override
    public List findAll() {
        log.info("Find All Executing");
        List matterDetailsList = em.createNamedQuery("VMatterDetails.findAll")
            .getResultList();
        log.info("Find All Return");
        return matterDetailsList;
    }
    @Override
    public int count() {
        throw new UnsupportedOperationException("Not supported yet.");
    }
    ...
}

But again, this is just a side note, this won't solve your problem.

Start with checking the generated SQL and update your question with the result. If the query returns data, please tell us how you checked that the bean method doesn't work.

References

Hibernate Core documentation
- 3.5. Logging

Pascal Thivent 2010-09-03 02:20:13

Thanks,there was nothing wrong with the hibernate configuration,the issue was with the table in the database.i recreated the DB structure again and it was working perfectly.

BinCode 2010-09-06 11:37:13

ansaurus

tags:

views:

answers:

Hibernate returning no results show this error INFO: Not binding factory to JNDI, no JNDI name configured

References

related questions