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
joeNOSPAM@BEA.com - 12 Feb 2007 21:14 GMT
On Feb 12, 12:26 pm, cormac.fo...@gmail.com wrote:
> Hi,
>
[quoted text clipped - 17 lines]
>
> Thanks
It's a result of the fact that the driver sends your SQL
to be prepared (precompiled) so it is efficiently reusable.
The DBMS may store the SQL for this session-level 'procedure'.
I would suggest asking in the MS SQLServer database group,
and in MS's own newsgroups....
Joe Weinstein at BEA Systems