Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ddlutils-dev@db.apache.org
Message-ID: <5966924.1152772713059.JavaMail.jira@brutus>
Date: Thu, 13 Jul 2006 06:38:33 +0000 (GMT+00:00)
From: "Thomas Dudziak (JIRA)" <jira@apache.org>
To: ddlutils-dev@db.apache.org
Subject: [jira] Updated: (DDLUTILS-96) Db2 database cannot extract table
 definition from database with schema
In-Reply-To: <16269256.1145296997581.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

     [ http://issues.apache.org/jira/browse/DDLUTILS-96?page=all ]

Thomas Dudziak updated DDLUTILS-96:
-----------------------------------

    Fix Version: 1.1

Full schema support (both ways: reading & writing) is one of the key things scheduled for 1.1

> Db2 database cannot extract table definition from database with schema
> ----------------------------------------------------------------------
>
>          Key: DDLUTILS-96
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-96
>      Project: DdlUtils
>         Type: Bug

>   Components: Core
>  Environment: DB2 database with schema and userid does not match schema name
>     Reporter: jim vester
>     Assignee: Thomas Dudziak
>      Fix For: 1.1

>
> Using a db2 database with a schema a stack trace occurs when trying to extract the ddl from the datbase.
> the stack trace point to 
> org.apache.ddlutils.platform.JdbcModelReader.determineAutoIncrementFromResultSetMetaData(...)
>  ...
>          query.append (" FROM ");
>          if (getPlatform().isDelimitedIdentifierModeOn())
>          {
>              query.append(getPlatformInfo().getDelimiterToken());
>          }
>          query.append(table.getName());
> the schema is missing in the generated sql.
>  I hacked it by checking if a schemaName existed in the table
> object and appending the table.getSchema() [?] +"." then the table name.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira