Re: [dtp-dev] Primary key is not visualized correct

[rcernich@xxxxxxxxxx]

Hi Dimiter,

> I'm using MAXDB database. I have no troubles to create data tables via
> SQLScrapbookEditor and respectively to create primary key field. The
execution
> passed successfully, but unfortunately I realized that the primary key is
not
> marked with its icon. I tried to create the same table in Derby database,
and
> primary key was visualized correct. Could you explain me what information
from
> the database definition/connection is necessary, in order primary key
field to
> be decorated as such.

The schema, tables, etc. in the data source explorer (DSE) are a
visualization of the SQL model.  The SQL model for a particular DB server
is instantiated via a catalog loader.  The default catalog loader uses JDBC
DatabaseMetaData calls to populate the SQL model.  Depending on the driver,
this works fairly well, not at all or somewhere in between.

That said, you're probably going to have to specialize the catalog loader
for your particular DB.  You can use Derby as an example.  (Note, Derby
relies on the generic functionality for populating primary key information.
However, other areas illustrate how the generic loader can be customized.
If all else fails, you can implement you loader logic from scratch.)

Hope that helps.

Sincerely,
Rob Cernich
DTP Connectivity Project Lead