Thanks Stan! I really appreciate it. Do you think it should be added to JIRA buglist ?
-Ateesh
| Stanley Bradbury <[EMAIL PROTECTED]>
05/12/2006 10:08 AM
|
To: Derby Discussion <[email protected]> cc: Subject: Re: A question regarding RuntimeStatistics() |
Hi Ateesh -
I am looking into this. I have gotten the same results as you and will
investigating how to obtain runtime statistics output form a JDCB program.
Stan [EOM]
[EMAIL PROTECTED] wrote:
>
> Hi,
>
> I am trying to get runtimestatistics for a PreparedStatement on a jdbc
> connection. Looks like the RUNTIMESTATISTICS() function completely
> ignores PreparedStatement(s).
> Here is the code snippet:
>
> conn = DBManager.getConnection();
> Statement stmt = conn.createStatement();
>
> stmt.executeUpdate("CALL
> SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1)");
> stmt.executeUpdate("CALL
> SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1)");
>
> PreparedStatement pstmt1 = conn.prepareStatement("SELECT
> user_name FROM users");
> rs = pstmt1.executeQuery();
>
> while (rs.next())
> System.out.println(rs.getString(1));
>
> rs = stmt.executeQuery("VALUES
> SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()");
>
> if (rs.next())
> System.out.println(rs.getString(1));
>
>
> Here is the output I get:
>
> Statement Name:
> null
> Statement Text:
> CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1)
> Parse Time: 0
> Bind Time: 0
> Optimize Time: 0
> Generate Time: 0
> Compile Time: 0
> Execute Time: 0
> Begin Compilation Timestamp : null
> End Compilation Timestamp : null
> Begin Execution Timestamp : null
> End Execution Timestamp : null
> Statement Execution Plan Text:
> null)
>
> When I executed the query as a regular Statement, it worked fine.
>
> Any ideas ?
