Hibernate version:3.0.5
Name and version of the database you are using: Oracle 10g
Ok, I'm having touble with preforming a select, i.e. with session.get
I dropped all my tables and created a small one just to try and figure out what's the problem, with no luck.
Notice that I succeed on INSERT, i.e. session.persist, though fail in the SELECT.
My bean :
public class Test implements Serializable
{
Integer id;
Date creationDate;
Date lastUpdateDate;
public Integer getId ( )
{
return id;
}
public void setId ( Integer new_obj )
{
id = new_obj;
}
public void setCreationDate ( Date new_obj )
{
creationDate = new_obj;
}
public Date getCreationDate ( )
{
return creationDate;
}
public Date getLastUpdateDate ( )
{
return lastUpdateDate;
}
public void setLastUpdateDate ( Date new_obj )
{
lastUpdateDate = new_obj;
}
}
My main :
public static void main ( String[] args )
{
Test test = new Test();
test.setId(new Integer(4));
test.setCreationDate(new Date());
test.setLastUpdateDate(new Date());
SessionFactory sessionFactory =
new Configuration( ).configure ( ).buildSessionFactory ();
Session session = sessionFactory.openSession();
try {
Transaction transaction = session.beginTransaction();
session.get(Test.class, test);
transaction.commit();
} finally {
session.close();
}
}
My hibrenate.cfg.xml
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@rddb1:1521:rd_db_60</property>
<property name="connection.username">username</property>
<property name="connection.password">password</property>
<property name="show_sql">true</property>
<property name="use_sql_comments">false</property>
<property name="generate_statistics">true</property>
<property name="autocommit">false</property>
<property name="dialect">org.hibernate.dialect.OracleDialect</property>
<!-- Mapping files -->
<mapping resource="tables/TTest.hbm.xml"/>
</session-factory>
</hibernate-configuration>
My hbm (TTest.hbm.xml):
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="tables.Test" table="T_TEST" dynamic-update="true">
<id name="id" column="ID"></id>
<property name="creationDate"
column="CREATION_DATE"
type="timestamp"
not-null="false"
insert="true"
update="true"
precision="0"
scale="1"
/>
<property name="lastUpdateDate"
column="LAST_UPDATE_DATE"
type="timestamp"
not-null="false"
insert="true"
update="true"
precision="0"
scale="1"
/>
</class>
</hibernate-mapping>
And my exception :
java.lang.ClassCastException
at org.hibernate.type.IntegerType.set(IntegerType.java:39)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:62)
at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:44)
at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1115)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1177)
at org.hibernate.loader.Loader.doQuery(Loader.java:390)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1345)
at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101)
at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPersister.java:2471)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:351)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:332)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:113)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:167)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:621)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:614)
at HibernameTest.main(HibrenateTesting.java:34)
Exception in thread "main"
What am I doing wrong?
Login
FAQ
Search
