Hello,
I'm trying to configure configure hibernate 2 within my application and I'm getting inconsistant behaviour between classes.
When I save a new instance of a location object defined as:
<class name="com.aberrantdevelopment.hijira.type.impl.LocationImpl" table="location">
<id name="id" column="id" type="string" unsaved-value="id_value">
<generator class="uuid.hex" />
</id>
<property name="name" column="name" type="string" />
<property name="address" column="address" type="string" />
<property name="city" column="city" type="string" />
<property name="province" column="province" type="string" />
<property name="country" column="country" type="string" />
<property name="postalCode" column="postal_code" type="string" />
<many-to-one name="communityType" column="community_type_id" class="com.aberrantdevelopment.hijira.type.impl.TypeImpl" />
<many-to-one name="type" column="type_id" class="com.aberrantdevelopment.hijira.type.impl.TypeImpl" />
<many-to-one name="status" column="status_id" class="com.aberrantdevelopment.hijira.type.impl.StatusImpl" />
<property name="createdOn" column="created_on" type="date" />
<property name="modifiedOn" column="modified_on" type="date" />
</class>
There it saves just fine. However when I try to save a new instance of an Event defined ast follows:
<class name="com.aberrantdevelopment.hijira.type.impl.EventImpl" table="event">
<id name="id" column="id" type="string" unsaved-value="id_value">
<generator class="uuid.hex" />
</id>
<property name="title" column="title" type="string" />
<property name="summary" column="summary" type="string" />
<property name="description" column="description" type="string" />
<property name="startDate" column="date_start" type="date" />
<property name="endDate" column="date_end" type="date" />
<property name="createdOn" column="created_on" type="date" />
<property name="modifiedOn" column="modified_on" type="date" />
<many-to-one name="communityType" column="community_type_id" class="com.aberrantdevelopment.hijira.type.impl.TypeImpl" />
<many-to-one name="type" column="type_id" class="com.aberrantdevelopment.hijira.type.impl.TypeImpl" />
<many-to-one name="status" column="status_id" class="com.aberrantdevelopment.hijira.type.impl.StatusImpl" />
</class>
with a *non-null* value for type and communityType I get a "net.sf.hibernate.HibernateException: SQL update or deletion failed (row not found)" exception.
If I set these two value to NULL, the instance is stored and no exception is thrown!?!?!
The FAQs and other postings in regards to this point to the "unsaved-value" key being defined incorrectly, however I have tried all possible values for the key and I get the same error. I don't understand why for one class the type and communityType values are incorrect however, within another it works just fine.
THe code is listed below, migrateEvent() throws the exception but migrateLocation does not.
Thanks,
Omar
Hibernate 2.2
SQL Server 2000
Windows 2000
[code] public static void migrateEvent() throws SQLException, NamingException
{
String strSQL = "select * from event";
Connection conn = DBManager.getConnection("default");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(strSQL);
SessionFactory sf = null;
Session session = null;
Transaction tx = null;
try
{
sf = new Configuration().configure().buildSessionFactory();
session = sf.openSession();
tx = session.beginTransaction();
EventImpl event = null;
while ( (rs != null) && (rs.next()) )
{
rs.next();
event = new EventImpl();
event.setTitle(rs.getString("title"));
event.setSummary(rs.getString("summary"));
event.setDescription(rs.getString("description"));
event.setStartDate(rs.getDate("date_start"));
event.setEndDate(rs.getDate("date_end"));
Type type = com.aberrantdevelopment.hijira.type.TypeManager.getType( TypeManager.getLookupKey(rs.getInt("type_id")) );
event.setType(type);
Type type2 = com.aberrantdevelopment.hijira.type.TypeManager.getType( TypeManager.getLookupKey(rs.getInt("community_type_id")) );
event.setCommunityType(type2);
Status status = com.aberrantdevelopment.hijira.type.StatusManager.getStatus( StatusManager.getLookupKey(rs.getInt("status_id")) );
event.setStatus(status);
System.out.println("#### Processing - " + event.getTitle());
session.save( event );
System.out.println("migrateEvent attempting to commit changes");
tx.commit();
event = null;
tx.commit();
type = null;
type2 = null;
}
} catch (HibernateException he)
{
System.err.println("Hibernate Exception ocurred");
he.printStackTrace(System.err);
} catch (Exception e)
{
System.err.println("General Ex - " + e);
e.printStackTrace(System.err);
} finally
{
try
{
tx.rollback();
session.close();
} catch (HibernateException he)
{
System.err.println("Hibernate Exception ocurred in \"finally\" clause");
he.printStackTrace(System.err);
}
try
{
rs.close();
stmt.close();
conn.close();
} catch (Exception e)
{
}
}
}
public static void migrateLocation() throws SQLException, NamingException
{
String strSQL = "select * from location";
Connection conn = DBManager.getConnection("default");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(strSQL);
SessionFactory sf = null;
Session session = null;
Transaction tx = null;
try
{
sf = new Configuration().configure().buildSessionFactory();
session = sf.openSession();
tx = session.beginTransaction();
LocationImpl location = null;
while ( (rs != null) && (rs.next()) )
{
location = new LocationImpl();
location.setName(rs.getString("name"));
location.setAddress(rs.getString("address"));
location.setCity(rs.getString("city"));
location.setProvince(rs.getString("province"));
location.setPostalCode(rs.getString("postal_code"));
location.setCountry(rs.getString("country"));
Type type2 = com.aberrantdevelopment.hijira.type.TypeManager.getType( TypeManager.getLookupKey(rs.getInt("community_type_id")) );
location.setCommunityType(type2);
Type type = com.aberrantdevelopment.hijira.type.TypeManager.getType( TypeManager.getLookupKey(rs.getInt("type_id")) );
location.setType(type);
Status status = com.aberrantdevelopment.hijira.type.StatusManager.getStatus( StatusManager.getLookupKey(rs.getInt("status_id")) );
location.setStatus(status);
System.out.println("#### Processing - " + location.getName());
session.save( location );
System.out.println("migrateLocation attempting to commit changes");
tx.commit();
location = null;
type = null;
type2 = null;
}
// System.out.println("migrateEvent attempting to commit changes");
// tx.commit();
} catch (HibernateException he)
{
System.err.println("Hibernate Exception ocurred");
he.printStackTrace(System.err);
} catch (Exception e)
{
System.err.println("General Ex - " + e);
e.printStackTrace(System.err);
} finally
{
try
{
tx.rollback();
session.close();
} catch (HibernateException he)
{
System.err.println("Hibernate Exception ocurred in \"finally\" clause");
he.printStackTrace(System.err);
}
try
{
rs.close();
stmt.close();
conn.close();
} catch (Exception e)
{
}
}
}
[/code]
Login
FAQ
Search
