Callable statements, JRun and SqlServer

Discussion in 'Java' started by cormac.foley@gmail.com, Feb 12, 2007.

  1. Guest

    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
    , Feb 12, 2007
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Fredje
    Replies:
    0
    Views:
    333
    Fredje
    Sep 23, 2003
  2. =?Utf-8?B?SmVmZnJleQ==?=

    Upgrading ASP w/SQLserver 2000 to ASP.NET w/ SQLserver 2005

    =?Utf-8?B?SmVmZnJleQ==?=, Apr 6, 2007, in forum: ASP .Net
    Replies:
    2
    Views:
    464
    sloan
    Apr 27, 2007
  3. exiquio
    Replies:
    2
    Views:
    520
    exiquio
    Oct 7, 2008
  4. John Crichton
    Replies:
    6
    Views:
    253
    John Crichton
    Jul 12, 2010
  5. Ulrich Eckhardt
    Replies:
    6
    Views:
    94
    Peter Otten
    Jul 12, 2013
Loading...

Share This Page