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. Advertisements

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. Neil Zanella
    Replies:
    8
    Views:
    1,460
    mfmehdi
    Oct 20, 2006
  2. Fredje
    Replies:
    0
    Views:
    419
    Fredje
    Sep 23, 2003
  3. Harry George
    Replies:
    6
    Views:
    656
    Bart Nessux
    Feb 23, 2004
  4. =?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:
    670
    sloan
    Apr 27, 2007
  5. Vince
    Replies:
    12
    Views:
    960
    Martin Gregorie
    Jan 21, 2008
  6. exiquio
    Replies:
    2
    Views:
    702
    exiquio
    Oct 7, 2008
  7. John Crichton
    Replies:
    6
    Views:
    446
    John Crichton
    Jul 12, 2010
  8. Ulrich Eckhardt
    Replies:
    6
    Views:
    341
    Peter Otten
    Jul 12, 2013
Loading...