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

    Strange error in Sybase connection: SET CHAINED command not

    guix

      Hi:
      I get

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


      When executing this inside jboss:
      Select
      convert(varchar(10),a.DateTime,103)
      + ' '
      + 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?