Path: csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail From: markspace <-@.> Newsgroups: comp.lang.java.programmer Subject: Re: Extract String and StringBuffer Date: Thu, 24 May 2012 08:21:28 -0700 Organization: A noiseless patient Spider Lines: 13 Message-ID: References: <34c76a08-4bdb-462b-9178-c8a24d9a5dba@googlegroups.com> <54c296d1-7913-45f0-b1f1-a602a0c34cbf@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Injection-Date: Thu, 24 May 2012 15:21:29 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="2kn9RzOWSe/v/hLnHgGT4Q"; logging-data="19934"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+ny016ESAxOd08Uz674ZeqqpzRbgnmr8M=" User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:12.0) Gecko/20120428 Thunderbird/12.0.1 In-Reply-To: <54c296d1-7913-45f0-b1f1-a602a0c34cbf@googlegroups.com> Cancel-Lock: sha1:QJdcBSBcG6S9icwil85O2Jn+8ak= Xref: csiph.com comp.lang.java.programmer:14774 On 5/24/2012 3:21 AM, mikew01 wrote: > The requirement is to pull out the sql statements and profile them > using the Oracle explain plan which will be executed by Sonar. In my opinion, I better requirement would be to isolate the SQL so that it was no longer part of the code, but was in a separate file where it could be accessed. That way no one has to do this kind of busy work again. Another better requirement would be to produce a decent integration test so that it could be used to as the test bed for performance/Sonar.