You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by "rick cameron (JIRA)" <ji...@apache.org> on 2008/04/07 21:41:24 UTC
[jira] Created: (DDLUTILS-201) Reading a model from MS SQL Server
2005 only succeeds for tables in the "dbo" schema
Reading a model from MS SQL Server 2005 only succeeds for tables in the "dbo" schema
------------------------------------------------------------------------------------
Key: DDLUTILS-201
URL: https://issues.apache.org/jira/browse/DDLUTILS-201
Project: DdlUtils
Issue Type: Bug
Components: Core - SqlServer
Affects Versions: 1.0
Environment: MS SQL Server 2005
Reporter: rick cameron
Assignee: Thomas Dudziak
When Platform.readModelFromDatabase is used to read the model of a SQL Server 2005 database, it fails for tables that are in a schema other than "dbo".
There are several places in the code where the schema name should be specified, but is not. For example, in JdbcModelReader.determineAutoIncrementFromResultSetMetaData the table name should be qualified by the schema name.
It's also necessary to change the way indices and primary & foreign keys are read in DatabaseMetaDataWrapper. Currently the schema pattern is always null. This works for tables in the "dbo" schema, but not for others.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DDLUTILS-201) Reading a model from MS SQL Server
2005 only succeeds for tables in the "dbo" schema
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DDLUTILS-201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12605193#action_12605193 ]
Thomas Dudziak commented on DDLUTILS-201:
-----------------------------------------
Full support for multiple schemas is covered by DDLUTILS-116, which covers support for e.g. fully qualified table names and handling multiple different schemas in one database model.
However, DdlUtils already supports catalog and schema specification when reading and writing models (both API and Ant tasks), it only cannot handle qualified table names. For Sql Server, I think you have to specify a catalog pattern instead of a schema pattern, but I might be wrong there.
> Reading a model from MS SQL Server 2005 only succeeds for tables in the "dbo" schema
> ------------------------------------------------------------------------------------
>
> Key: DDLUTILS-201
> URL: https://issues.apache.org/jira/browse/DDLUTILS-201
> Project: DdlUtils
> Issue Type: Bug
> Components: Core - SqlServer
> Affects Versions: 1.0
> Environment: MS SQL Server 2005
> Reporter: rick cameron
> Assignee: Thomas Dudziak
>
> When Platform.readModelFromDatabase is used to read the model of a SQL Server 2005 database, it fails for tables that are in a schema other than "dbo".
> There are several places in the code where the schema name should be specified, but is not. For example, in JdbcModelReader.determineAutoIncrementFromResultSetMetaData the table name should be qualified by the schema name.
> It's also necessary to change the way indices and primary & foreign keys are read in DatabaseMetaDataWrapper. Currently the schema pattern is always null. This works for tables in the "dbo" schema, but not for others.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.