Hello All,
As a part of my enterprise application, I have one functionality, where code selects all of the records from one table and process them one by one. If the record gets processed succesfully then application deletes this record, if not, then set the 'Processed' flag to 'NO'.
When ever I am executing this piece of code with 300 records in the table, application select all of the records and starts processing them one by one. First 14 records getting processed properly and as per the flow records are getting deleted also from the table.
When it crosses 14th record then on 15th application processed the record but after that when it tries to delete this record application just hangs. I am not sure why application is not able to delete 15th record.
If you stop the application and restart it then again application will delete first 14 records and will stop on 15th record.
Code of my delete method is as follows
<blockquote>
code:
<pre name="code" class="core">
public void delete( BatchEntry batchEntry )
{
Connection _con = null;
Statement _st = null;
try
{
_con = getHibernateSession().connection();
_st = _con.createStatement();
_st.executeQuery( "Delete from BATCH_ENTRIES where ID = " + batchEntry.getId() );
_con.commit();
}
catch ( SQLException _se )
{
try
{
_con.rollback();
}
catch ( SQLException se )
{
m_log.error( "Could not rollback DB connection", se );
}
m_log.error( "SQLException while deleting record from BATCH_ENTRIES, exception is : ", _se );
throw new FitnessRuntimeException( _se );
}
finally
{
close( _st );
close( _con );
}
}
</pre>
</blockquote>
Please do let me know if you need any more information.
Thanks
[ July 16, 2008: Message edited by: Mark Spritzler ]
