EndorsementInstructions is of text datatype in one of the tables. I have specified that as below in corresponding hibernate mapping file..
Code:
<property name="EndorsementInstructions" type="java.lang.String" length="30000" lazy="true">
<column name="EndorsementInstructions" sql-type="text"></column>
</property>
Java code snippet -
Code:
Transaction tx = HibernateUtil.startTransaction();
Request_Text reqText = Request_TextHibernateDaoFactory.create().findRequest_Text(map);
reqText.setEndorsementInstructions(instructions); //it takes String
Request_TextHibernateDaoFactory.create().updateRequestText(reqText);
tx.commit();
And it gives me below exception -
Code:
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The DBMS returned an unspecified error.
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:731)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:333)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)
Can someone please help me out to resolve this error? Thanks.