Results 1 to 2 of 2
  1. #1
    nathan is offline Member
    Join Date
    Sep 2008
    Posts
    1
    Rep Power
    0

    Default Sql string with callable statement..

    Hi All,

    How do i get a dump of a stored procedure (the exact call that is being made ).. When i use AS400JDBCCallableStatement and have a call something like
    call procedureA(?,?,?) and i pass in the in and out parameters and what i need is something which gives me a dump of the sql statement something
    call procedureA(val1,val2,val3) which i can then directly copy and paste it to an sql editor. i tried toString on the CallableStatement but it wouldnt work .

    I am using AS400JDBCCallableStatement object and am registering the in and out parameters but was expecting either toString to give me the dump or for the CallableStatement to have a method called "dump" which dumps the actual SQL String but it did not have any.

    Thx a zillion
    Nathan

  2. #2
    racerxadam is offline Member
    Join Date
    Jul 2008
    Posts
    68
    Rep Power
    0

    Default

    I'm not sure if there is an easier way but check out P6spy. It basically offers a way to proxy your sql calls. So your app uses the P6spy driver, P6spy logs the sql, then P6spy calls the database driver and passes your query along.

Similar Threads

  1. import statement.
    By diRisig in forum New To Java
    Replies: 2
    Last Post: 02-08-2008, 12:34 AM
  2. Replies: 0
    Last Post: 11-20-2007, 04:59 PM
  3. Help with if statement
    By carl in forum New To Java
    Replies: 1
    Last Post: 08-06-2007, 07:53 AM
  4. Statement or Prepared Statement ?
    By paty in forum JDBC
    Replies: 3
    Last Post: 08-01-2007, 04:45 PM
  5. If Statement
    By aDrizzle in forum New To Java
    Replies: 4
    Last Post: 07-08-2007, 08:55 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •