Re: [wtp-dev] RDB components and indexes

[Lawrence Mandel <lmandel@xxxxxxxxxx>]

Thanks for the contribution Haris. Please
open a bug report and submit a patch with your fix.

Lawrence Mandel

Software Developer
IBM Rational Software
Phone: 905 - 413 - 3814   Fax: 905 - 413 - 4920
lmandel@xxxxxxxxxx

snpe <snpe@xxxxxxxxxx>
Sent by: wtp-dev-bounces@xxxxxxxxxxx

04/14/2005 11:33 AM

Please respond to
"General discussion of project-wide or architectural issues."

To	wtp-dev@xxxxxxxxxxx
cc
Subject	[wtp-dev] RDB components and indexes

Hello,
  I find bug and fix for problem with indexes in database explorer
Oracle (8 and 9) retrun first row with inde_name = null and webtools
skip other indexes .
Probelm is in method :

org.eclipse.wst.rdb.internal.core.rte.jdbc.JDBCTTable#loadIndexes(Connection
connection, EList indexList, Table table)

line 246

except

ResultSet r = metaData.getIndexInfo(null,null,table.getName(),false,false);

this

ResultSet r = metaData.getIndexInfo(null,schema.getName(),table.getName(),false,false);


line 251

except 

if (indName == null) break;

this

if (indName == null) continue;

regards
Haris Peco
_______________________________________________
wtp-dev mailing list
wtp-dev@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/wtp-dev