Created attachment 105802 [details]
patch against dbschema

Hey,

when generating entity beans from database I noticed wrongly generated composited keys. I could track this issue down to the dbschama in which the indices are queried from the jdbc metadata. So far so good, but then rows marked as statistics are considered valid index data.

I had a similar problem when building a db visualisier.

Please see the attached patch. It just skips the statistics rows. A further going patch making use of the corresponing functions in jdbc might be good, but this fix should be valid in the current logic.

This is a small example:

CREATE  TABLE  Antwort_element (

  id serial NOT NULL ,

  text LVARCHAR(1024) ,

  Fragebogen_element_id INT NOT NULL ,

  zahl INT ,

  Antwort_fragebogen_id INT NOT NULL ,

  PRIMARY KEY (id))

;


This created on an informix 11.5/11.7 database produces an entity with a composite primary key. With the attached patch the primary key is correctly reproduced.