Hi:
I get
com.sybase.jdbc2.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction
Select convert(varchar(10),a.DateTime,103) + ' ' + convert(varchar(8),a.DateTime,108) from myTable a where a.Id = 29384
btw I am using jboss 4.0.3 and any other statement works....