I'm getting a HibernateException while trying to query my oracle database for my DataIdentifierGroup object. I've tried using regular jdbc and i'm able to query this table. I've tried several access methods, session.find(), session.get(), session.createCriteria(DataIdentifierGroup.class).list() and nothing seems to be working. I'm not sure what i'm doing wrong.
Servlet Code:
try {
logger.info("Just About to call Hibernate Classes");
logger.info("Calling Configuration()");
Configuration conf = new Configuration();
logger.info("Calling configure()");
conf.configure();
logger.info("Calling buildSessionFactory()");
SessionFactory sf = conf.buildSessionFactory();
logger.info("Got Hibernate Session Factory");
logger.info("Opening Session");
Session session = sf.openSession();
logger.info("Got Sesssion From Session Factory");
Query query = session.createQuery("from DataIdentifierGroup");
logger.info("Performing Query");
Iterator it = query.iterate();
logger.info("Executed Query");
while(it.hasNext()) {
DataIdentifierGroup dataIdentifierGroup = DataIdentifierGroup) it.next();
out.println("<p><b>Group Id:</b> " + dataIdentifierGroup.getIdentifierGroupId());
}
} catch (HibernateException he) {
System.out.println("HibernateException Thrown - " + he.getMessage());
out.println("HibernateException Thrown - " + he.getMessage());
} catch (Exception e) {
System.out.println("Exception Thrown - " + e.toString());
out.println("Exception Thrown - " + e.toString());
}
hiberante.cfg.xml:
<hibernate-configuration>
<session-factory>
<!-- properties -->
<property name="hibernate.connection.datasource">java:comp/env/CITTPDEV</property>
<property name="dialect">net.sf.hibernate.dialect.Oracle9Dialect</property>
<property name="show_sql">true</property>
<property name="hibernate.cache.provider_class">net.sf.hibernate.cache.OSCacheProvider</property>
<property name="hibernate.cache.use_query_cache">true</property>
<!-- mapping files -->
<mapping resource="DataIdentifierGroup.hbm.xml"/>
<mapping resource="DataIdentifier.hbm.xml"/>
</session-factory>
</hibernate-configuration>
DataIdentifierGroup.hbm.xml:
<hibernate-mapping package="com.jpmorganchase.gcrm.cment.caching.ORMO">
<class name="DataIdentifierGroup" table="CME_DATA_IDENTIFIER_GROUP" mutable="false">
<cache usage="read-only"/>
<!-- A 32 hex character is our surrogate key. It's automatically
generated by Hibernate with the UUID pattern. -->
<id name="identifierGroupId" type="java.math.BigDecimal" column="IDENTIFIER_GROUP_ID">
<generator class="assigned"/>
</id>
<property name="identifierGroupName" type="java.lang.String" column="IDENTIFIER_GROUP_NAME"/>
<property name="updateDate" type="java.sql.Timestamp" column="UPDATE_DATE"/>
<property name="updateUserId" type="java.math.BigDecimal" column="UPDATE_USER_ID"/>
</class>
</hibernate-mapping>
DataIdentifierGroup.java:
package com.jpmorganchase.gcrm.cment.caching.ORMO;
import java.math.BigDecimal;
import java.sql.Timestamp;
public class DataIdentifierGroup {
private BigDecimal identifierGroupId;
private String identifierGroupName;
private Timestamp updateDate;
private BigDecimal updateUserId;
public DataIdentifierGroup() {
}
public BigDecimal getIdentifierGroupId() {
return identifierGroupId;
}
public void setIdentifierGroupId(BigDecimal identifierGroupId) {
this.identifierGroupId = identifierGroupId;
}
public String getIdentifierGroupName() {
return identifierGroupName;
}
public void setIdentifierGroupName(String identifierGroupName) {
this.identifierGroupName = identifierGroupName;
}
public Timestamp getUpdateDate() {
return updateDate;
}
public void setUpdateDate(Timestamp updateDate) {
this.updateDate = updateDate;
}
public BigDecimal getUpdateUserId() {
return updateUserId;
}
public void setUpdateUserId(BigDecimal updateUserId) {
this.updateUserId = updateUserId;
}
}
Login
FAQ
Search
