Hello Robert, unfortunately, we think that you are a victim of a performance-optimization in the JDBC driver :-(.
The JDBC driver sends housekeeping commands together with normal commands when possible, to avoid communication overhead for these simple commands. However, these commands seem to mess up the DIAGNOSE ANALYZE recording, in a way as would currently any other command sent between the execute of the statement and the corresponding fetch commands for the result set. We will fix this limitation of the performance data gathering in a next release, sorry for any inconvenience caused by this. Regards Alexander Schröder SAP DB, SAP Labs Berlin I can send you a JDBC driver that has the feature of adding the housekeeping commands to normal commands disabled, if this would be helpful. -----Original Message----- From: Robert Klemme [mailto:[EMAIL PROTECTED] Sent: Montag, 8. Mai 2006 17:44 To: maxdb Subject: Diagnose Analyzer / Resource Monitor - not with JDBC Hi, we tried to get DIAGNOSE ANALYZE to log SQL statements issued via JDBC. So far we have been able to log only statement and session id but none of the performance characteristics (records returned, duration). The full sett of data is logged when SQL statements are send via SQL Studio. I haven't found any JDBC URL parameter that might be related to this. Any ideas? TIA This is on 7.5.00.18. Kind regards robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
smime.p7s
Description: S/MIME cryptographic signature
