When performing a delete from a hibernate session, it does everything fine, but gives me 1 row like this for each delete I requested:
[JDBCExceptionReporter] NOTICE: Adding missing FROM-clause entry for table "unilog"
What is this? where is it coming from?
my delete looks like:
Code:
String queryString="from UnilogLightWeight u where u.pillangoPeriodID=? and u.unilogDate=? and u.unilogProductTypeID=? and unilog.profitcenterID=?";
Object [] objects = {this.pillangoPeriod.getPillangoPeriodID(), sdf.parse(tokens[2]), Long.valueOf(tokens[1]) , Long.valueOf(tokens[0])};
session.delete(queryString,objects,types);
my UnilogLightWeight.hbm file looks like this:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.tibbett.controlling.hibernate.UnilogLightWeight" table="unilog">
<id name="unilogID" column="unilogid" type="long" unsaved-value="null">
<generator class="sequence">
<param name="sequence">unilog_uid_sequence</param>
</generator>
</id>
<property name="amount" column="amount" length="8" type="double"/>
<property name="unilogDate" column="unilogdate" length="4" type="date"/>
<property name="profitCenterID" type="java.lang.Long" column="profitcenterid"/>
<property name="unilogProductTypeID" type="java.lang.Long" column="producttypeid"/>
<property name="measurementID" type="java.lang.Long" column="measurementid"/>
<property name="categoryID" type="java.lang.Long" column="categoryid"/>
<property name="activityID" type="java.lang.Long" column="activityid"/>
<property name="groupID" type="java.lang.Long" column="groupid"/>
<property name="pillangoPeriodID" type="java.lang.Long" column="pillangoperiodid"/>
</class>
</hibernate-mapping>
I'm going slightly mad here... I just don't see it... :(
Cheers