Urgent! - session.HibernateContext.getSession not working...

[beyarecords]

Hi,
I am having a serious problem getting data to returned to me from postgreSQL 7.4.1 via jndi(JBoss 3.2.6) using session.HibernateContext.getSession(). It seems that a session is being returned but nothing is happening after that. Can anybody tell me wht I am not doing correctly here? Is my java code specified incorrectly? I have specified my

hibernate-service.xml doc as:


jboss.jca:service=LocalTxCM,name=PostgreSQL
java:/hibernate/SessionFactory
java:/PostgreSQL
net.sf.hibernate.dialect.PostgreSQLDialect
net.sf.ehcache.hibernate.Provider


postgres-ds.xml:

<local-tx-datasource>
<jndi-name>PostgreSQL</jndi-name>
<connection-url>jdbc:postgresql://localhost:5432/beyarecords</connection-url>
<driver-class>org.postgresql.Driver</driver-class>
<user-name>x</user-name>
y
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>
</local-tx-datasource>

standardjbosscmp-jdbc.xml:


java:/PostgreSQL
<datasource-mapping>postgreSQL</datasource-mapping>
<type-mapping>
postgreSQL
.................................................................
</type-mapping>


java code:

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.Query;
import org.jboss.hibernate.session.HibernateContext;

try {
HibernateContext session = org.jboss.hibernate.session.HibernateContext.getSession("java:/hibernate/SessionFactory");
//transaction = session.beginTransaction();
//Get User details
Query query = session.createQuery("from test.User as user where user.UserName=:username and user.UserPassword=:password")
.setString("username",username)
.setString("password",password);
user = (User) query.uniqueResult();

//transaction.commit();
//session.close();

} catch (HibernateException e) {

throw new RuntimeException("Exception in Hibernate:: " + e.getMessage(), e);
}

server.log output:

2004-10-26 13:10:24,445 DEBUG [net.sf.hibernate.impl.SessionFactoryObjectFactory] JNDI lookup: hibernate/SessionFactory
2004-10-26 13:10:24,446 DEBUG [net.sf.hibernate.impl.SessionFactoryObjectFactory] lookup: uid=d1e22501ffd5242300ffd52426a80000
2004-10-26 13:10:24,569 DEBUG [net.sf.hibernate.impl.SessionImpl] opened session
2004-10-26 13:10:24,784 INFO [org.apache.jk.server.JkCoyoteHandler] Response already commited


many thanks


Uzo

[rimmeraj]

The JNDI lookup returns a SessionFactory not a sesison. So it should look like...

SessionFactory sf = (SessionFactory)ctx.lookup("java:/hibernate/SessionFactory")
Session ses = sf.openSession();
do work here ...

ses.close();

[beyarecords]

Hi rimmeraj,
I was under the impression that the getSession method of HibernateContext took in as a parameter a sessionfactory name and then passed back a session? In http://www.jboss.org/wiki/Wiki.jsp?page=JBossHibernate

Session management it says:

'The central piece of the Hibernate Session management component in JBoss is the org.jboss.hibernate.HibernateContext class. HibernateContext exposes a static method named getSession() taking a String parameter which represents the jndi name of a SessionFactory?. If there is already a session bound to the "current context" for the given session factory name, then that session is returned; otherwise, a new session is generated, bound to the "current context", and then returned.'

Is the information above incorrect, as I specifically want to pass a session back via hibernate and not ejb?

many thanks


Uzo

[rimmeraj]

But you are not using it within the cope of an EJB. There fore there is no open transaction to bind it to.

[beyarecords]

Hi rimmeraj,
what are the java package names for the classes:

1. InitialContext ?
2. SessionFactory ?

e.g import .org.x.x.x.InitialContext


many thanks for all your help so far

Uzo

[rimmeraj]

import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import javax.naming.InitialContext;