db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: A question regarding RuntimeStatistics()
Date Fri, 12 May 2006 18:24:18 GMT
That worked for me.  - Thanks

Daniel John Debrunner wrote:

>>Ateesh_Verma@rapid7.com 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));
>>>      
>>>
>
>  ADD  --   rs.close();
>  
>
>>>         rs = stmt.executeQuery("VALUES
>>>SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS()");
>>>
>>>         if (rs.next())
>>>           System.out.println(rs.getString(1));
>>>
>>>      
>>>
>
>  
>
>>>When I executed the query as a regular Statement, it worked fine.
>>>
>>>Any ideas ? 
>>>      
>>>
>
>I think you need to close the result set for the select statement.
>See above.
>
>Dan.
>
>
>
>  
>



Mime
View raw message