Article View: borland.public.jbuilder.database
Article #395Re: Database Pilot issues analyze statement
From: Tim Truman
Date: Wed, 19 Oct 2005 19:13
Date: Wed, 19 Oct 2005 19:13
32 lines
2380 bytes
2380 bytes
>I am willing to wager that most tools are using the >Connection classes getMetaData() from the java.sql >package, which probably uses only default settings and does >not allow overrides to these methods or accessor methods >(sets) for database vendor specifics (such as those in >Oracle). However, the Oracle drivers may allow for this >directly. Since I am not at work, and I do not have Oracle > at home, I cannot test my theory. I will do so this week >(when I get some time) and let you know what I find, >if you do not beat me to it :) Paul, You were on the right track. I am no Java expert but I managed a small program that connects with the database and gathers metadata. I discovered that databaseMetaData.getIndexInfo causes the Analyze. Even if Connection.getMetaData()is typecast with OracleDatabaseMetaData. // code snip - causes analyze but should not rset = metadata.getIndexInfo(null, "SCOTT","EMP",false,true); With that info I googled 'DatabaseMetaData.getIndexInfo analyze' I found this on OTN: http://forums.oracle.com/forums/thread.jspa?threadID=210782 I looked up the bug number mentioned on MetaLink. It describes the issue exactly but the bug has no resolution and has been dormant since 07-FEB-2003. Good call.
Technical Details
Message-ID:
<43569acb$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mailReferences:
<434d2add$1@newsgroups.borland.com> <434de09f$1@newsgroups.borland.com> <434ec516$1@newsgroups.borland.com> <43502088$1@newsgroups.borland.com> <43550460$1@newsgroups.borland.com> <4355b79f@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,9271f20c522d59c5 X-Google-Attributes: gid1073da,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Tim Truman" <ttruman@nospam.com> Sender: "Tim Truman" <ttruman@nospam.com> Reply-To: "Tim Truman" <ttruman@nospam.com> Subject: Re: Database Pilot issues analyze statement Newsgroups: borland.public.jbuilder.database X-User-Info: 65.75.48.206 References: <434d2add$1@newsgroups.borland.com> <434de09f$1@newsgroups.borland.com> <434ec516$1@newsgroups.borland.com> <43502088$1@newsgroups.borland.com> <43550460$1@newsgroups.borland.com> <4355b79f@newsgroups.borland.com> NNTP-Posting-Host: 207.105.83.66 Message-ID: <43569acb$1@newsgroups.borland.com> Date: 19 Oct 2005 12:13:15 -0700 X-Trace: newsgroups.borland.com 1129749195 207.105.83.66 (19 Oct 2005 12:13:15 -0700) Lines: 34 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!pd7cy2so!shaw.ca!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail