|
Hi,
My mapping file query is like this
<hibernate-mapping package="com.cognizant.brokerportal.generatequote.valueobject">
<class name="GroupDetailsFormVo" table="LE_REP_SUBMIT">
<id name="submit_id1" type="java.lang.Integer" column="submit_id">
<generator class="increment"/>
</id>
<property name="submitstatus1" type="java.lang.Integer">
<column name="submit_status" />
</property>
<query name="updateStatus">
<![CDATA[from GroupDetailsFormVo groupDetailsFormVo where groupDetailsFormVo.submit_id1=:submit_id1]]>
</query>
</hibernate-mapping>
And my code is :
SessionFactory sessions = null;
Session session = null;
Transaction tx = null;
sessions = UserSessionFactory.getSessionFactory();
session = sessions.openSession();
tx = session.beginTransaction();
list1 =session.getNamedQuery("updateStatus").setInteger("submit_id1",777).list();
for(int i=0;i<list1.size();i++)
{
groupDetailsFormVo=(GroupDetailsFormVo)list1.get(i);
int eg=groupDetailsFormVo.getSubmitstatus1();
groupDetailsFormVo.setSubmitstatus1(2);
session.saveOrUpdate(groupDetailsFormVo);
}
tx.commit();
session.close();
It prints the submit status but when i try to update the same it shows me these errors
15:28:54,725 WARN [JDBCExceptionReporter] SQL Error: 208, SQLState: 42S02
15:28:54,725 ERROR [JDBCExceptionReporter] [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'groupDetailsFormVo'.
15:28:54,741 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: could not update: [com.cognizant.brokerportal.generatequote.valueobject.GroupDetailsFormVo#777]
Can anyone help me ????
|
|
|
|
|
|
|
|