🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #395

Re: Database Pilot issues analyze statement

#395
From: Tim Truman
Date: Wed, 19 Oct 2005 19:13
32 lines
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-mail
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>

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