T-SQL print statement ...

bravegag · *nix forums beginner Joined: 12 Apr 2006 Posts: 16

Hi all,

I have a java app that connects to Sybase using jConnect 6.05
and calls a stored procedure using the CallableInterface.

Any print statement within the stored procedure becomes a
SQLException on the java side???? e.g.

com.sybase.jdbc3.jdbc.SybSQLWarning: Beginning REORG REBUILD
of ...

why if it is a SQLWarning is being thrown as a SQLException?

how can I disable this (very stupid) Sybase behaviour?

- is there anything like "set showoutput off" or disable output session
parameter? or even a jConnect parameter to disable SQLException on
SQLWarning occurrences or whatever?
- Removing the print statements out of my procedure is not enough as
I call some other internal Sybase procedures that also seem to be
printing crap out.

Many thanks in advance,
Best Regards,
Giovanni

Google