debug log

I'm trying to implement Sun's Message Queue with ASA 9.0.2.

Sun Message Queue is dying while doing an insert. Is there an option I can 
set in Sybase that will show the the attempted SQL in some sort of log? I 
think the problem has something to do the jdbc driver and having a log would 
help to narrow it down.

I translated the transaction log, but that did not show anything.

Preston 


0
Preston
3/22/2005 11:20:32 PM
sybase.sqlanywhere.general 32637 articles. 22 followers. Follow

1 Replies
531 Views

Similar Articles

[PageSpeed] 37

The "request level log" is what you want.

To start it, from dbisql...

CALL sa_server_option('Request_level_log_file','C:\\temp\\rlog.txt' );
CALL sa_server_option('Request_level_logging', 'SQL+hostvars' );

To stop it...

CALL sa_server_option ( 'Request_level_logging', 'NONE' );

Breck





On 22 Mar 2005 15:20:32 -0800, "Preston" <nospam@nospam.com> wrote:

>I'm trying to implement Sun's Message Queue with ASA 9.0.2.
>
>Sun Message Queue is dying while doing an insert. Is there an option I can 
>set in Sybase that will show the the attempted SQL in some sort of log? I 
>think the problem has something to do the jdbc driver and having a log would 
>help to narrow it down.
>
>I translated the transaction log, but that did not show anything.
>
>Preston 
>

--
SQL Anywhere Studio 9 Developer's Guide 
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20 
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
0
Breck
3/22/2005 11:41:59 PM
Reply: