1 Reply Latest reply on Dec 7, 2005 9:31 AM by Guillermo Guisado

    Strange error in Sybase connection: SET CHAINED command not

    Guillermo Guisado Newbie

      I get

      com.sybase.jdbc2.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction

      When executing this inside jboss:
      + ' '
      + convert(varchar(8),a.DateTime,108)
      from myTable a where a.Id = 29384

      Funnily enough , this is not a multi-statement and of course the sql works when I run directly in sybase.

      Any ideas?