Pooja,

    In your getDBConnection method you need to do this change -

            connection = ds.getConnection();
            connection.setAutoCommit(false);

    Also, in your ejbCreate() method you better close the connection in a finally{} 
block.

    This should take care of the issue.

Rama


********************************************************************

     I've got plenty of common sense. I just choose to ignore it.
                                                     - Calvin
********************************************************************

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

Reply via email to