SQL parsing library

From: Chris Smith (cdsmith_at_twu.net)
Date: 01/15/04 

Date: Thu, 15 Jan 2004 06:51:04 -0700

Good evening,

I'm hunting for an SQL parsing library. Specifically, the task I have
in mind is as follows: take an SQL query (which may already contain some
'?' characters for parameterized values), and replace ALL literal values
with the '?' character, while not touching anything else in the query.

I want to do this because I'm instrumenting a JDBC driver to provide
metrics on the frequency and average running time of queries in the
application, and I want to treat all queries of the same general form as
being identical to each other when counting frequency and average
running time.

Thanks in advance, 

-- 
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.
Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation

Relevant Pages

  • Re: SQL parsing library
    ... > in mind is as follows: take an SQL query (which may already contain some ... > metrics on the frequency and average running time of queries in the ... and I want to treat all queries of the same general form as ...
    (comp.lang.java.databases)
  • Index server Performance issues
    ... file types in the catalog. ... The SQL query we issue for this is: ... decreases to 15 seconds for 10 concurrent queries. ... The MaxActiveQueryThreads entry is the maximum number of active threads to ...
    (microsoft.public.inetserver.indexserver)
  • C# Excel multiple cell/column/row SQL Query Question
    ... I am trying to select a range of data within an excel spreadsheet using ... a SQL query. ... The two queries below do the trick but I was wondering if ... there's any way to combine both of these SQL queries into one query? ...
    (microsoft.public.dotnet.languages.csharp)
  • Combining Queries
    ... I have several Queries that count field entries from last month and the prior ... They seem to work great but I would like to combine these Queries ... SQL Query One ... ...
    (microsoft.public.access.queries)