2 Replies Latest reply on Sep 30, 2004 4:45 AM by Syed Ahmed Mohiuddin

    Getting The 'SET CHAINED OFF' command error

    Syed Ahmed Mohiuddin Newbie

      Hi All,

      I'm new to Jboss, I'm trying to execute sybase stored procedures from my app. I'm getting following error.

      Could not find any rigMappings. SQLException getting getReportVersionDetails2 :
      Stored procedure 'spRR_GetReportVersionDetails2' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction

      zaa.co.rmba.di.exception.ResourceException: Could not find any rigMappings. SQLException getting getReportVersionDetails2 :
      Stored procedure 'spRR_GetReportVersionDetails2' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.



      Any help will be greatly appreciated.

      thanks in advance