Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Need help supporting AS400 using DTP
Need help supporting AS400 using DTP [message #586774] Mon, 23 July 2007 16:24
Neil Hauge is currently offline Neil HaugeFriend
Messages: 475
Registered: July 2009
Senior Member
We use the DTP DB Definition Model to generically support reading database
metadata for object mapping purposes. We currently have a problem
supporting AS/400, resulting in bug 193013
( Ideally I would
like to rely on DTP to figure out how to get metadata from different DB
types, but we are not doing this as a result of DTP bug 182415

So, I suppose there are a couple of different ways to resolve this issue,
but looking at the current code and our current problem, I'm hoping that
someone can help us figure out how to support AS400 DB with the DTP model

Currently we are trying to match the default catalog name from any
database type to try and get a hold of the schemas. We have a few
different cases to get the right catalog to get the schemas, but none of
these seem to support
AS400. The DTP DSE does manage to display the tables for AS400, so it
seems you guys are getting it right. It also worked in RDB.

This is what we currently have:

public String getDefaultCatalogName() {
if( !this.supportsCatalogs()) { // this database doesn't
support catalogs
return "";
String userName = this.profile.getUserName();
for (org.eclipse.datatools.modelbase.sql.schema.Catalog dtpCatalog
: this.dtpCatalogs()) {
if( dtpCatalog.getName().length() == 0) { // special catalog
that contains all schemata
return "";
else if( dtpCatalog.getName().equals( userName)) {
return userName; // returns user name as default
else if( dtpCatalog.getName().equals( this.getName())) {
return this.getName(); // special catalog with same
name as DB (PostgreSQL)

Are we missing the hook for AS400's "catalog" or lack thereof?

Previous Topic:Driver Definition uncompletable
Next Topic:Authentication
Goto Forum:

Current Time: Wed May 23 11:24:12 GMT 2018

Powered by FUDForum. Page generated in 0.02396 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top