Posted by cormac.foley on 02/12/07 20:23

Hi,

I'm developing a java application which uses SQL Server as the
database. I use Callable Statements to connect to the database. I use
JRun as the app server. When
running the application I want to be able to monitor locks/process
info etc in the 'Current Activity' section in the 'Management'
section
in SQL Server.


The problem is that at the moment if I look at the 'Last TSQL command
batch' in the process or lock, it does not display the sql for the
current call. It displays what seems to be the precompiled call:
#jdbc#9;1


Anyone know how to get it to display the sql?


Is it a driver issue or is there a SQL Server setting to get it to do
this?


Thanks

• Next in forum: Re: SQL Format Function "0000"
• Prev in forum: Callable statements, SQLServer and JRun
• Thread view: Callable statements, SQLServer and JRun

[Reply to this message]