Posted by Erland Sommarskog on 02/12/07 22:29

(cormac.foley@gmail.com) writes:
> 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?

Didn't you ask the same question a week ago or two? Yes, that was
another newsgroup, but at least you should have learnt by now that it
is a driver issue. And I hope that you should know that you should
use parameterised statements.

Well, I see on Google Groups that you also have posted your
question to comp.lang.java.programmer. Too that you did not cross-post.
It would have been interesting to see the answers from the Java folks.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]