[jira] Updated: (DDLUTILS-156) Support for MS SQLServer 2005

2007-03-07 Thread Thomas Dudziak (JIRA)
[ https://issues.apache.org/jira/browse/DDLUTILS-156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Dudziak updated DDLUTILS-156: Fix Version/s: 1.1 Support for MS SQLServer 2005 -

[jira] Resolved: (DDLUTILS-158) verification of changed row number fails during data import

2007-03-07 Thread Thomas Dudziak (JIRA)
[ https://issues.apache.org/jira/browse/DDLUTILS-158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Dudziak resolved DDLUTILS-158. - Resolution: Fixed verification of changed row number fails during data import

[jira] Commented: (DDLUTILS-161) PostgreSQL Blob type mapping should be OID in v8

2007-03-06 Thread Thomas Dudziak (JIRA)
[ https://issues.apache.org/jira/browse/DDLUTILS-161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12478693 ] Thomas Dudziak commented on DDLUTILS-161: - Mhmm, AFAICT bytea is the correct type (see e.g.

[jira] Commented: (DDLUTILS-154) Autoincrementing columns broken on Oracle10?

2007-02-06 Thread Thomas Dudziak (JIRA)
[ https://issues.apache.org/jira/browse/DDLUTILS-154?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12470826 ] Thomas Dudziak commented on DDLUTILS-154: - Are you sure that this happens while DdlUtils runs ? This error

[jira] Commented: (DDLUTILS-152) Value out of range on an unsigned integer

2007-01-29 Thread Thomas Dudziak (JIRA)
[ https://issues.apache.org/jira/browse/DDLUTILS-152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12468512 ] Thomas Dudziak commented on DDLUTILS-152: - The problem is that if you map the column to a wider Java type,

[jira] Commented: (DDLUTILS-152) Value out of range on an unsigned integer

2007-01-26 Thread Thomas Dudziak (JIRA)
[ https://issues.apache.org/jira/browse/DDLUTILS-152?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12467940 ] Thomas Dudziak commented on DDLUTILS-152: - DdlUtils relies on the JDBC driver to provide a correct mapping

[jira] Commented: (DDLUTILS-151) Can not export data if multiple schemas from PostgreSQL

2007-01-22 Thread Thomas Dudziak (JIRA)
[ https://issues.apache.org/jira/browse/DDLUTILS-151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12466648 ] Thomas Dudziak commented on DDLUTILS-151: - Please provide some more info, e.g. the parameters of the ant

[jira] Updated: (DDLUTILS-138) writeschematofile - Database model fails to find column names of indices with qualifiers (postgres)

2006-12-21 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-138?page=all ] Thomas Dudziak updated DDLUTILS-138: Issue Type: Improvement (was: Bug) Fix Version/s: 1.1 DdlUtils currently only supports indexes on columns, not on functions (i.e. LOWER in

[jira] Commented: (DDLUTILS-127) MsSqlBuilder does not drop foreign keys to a table before dropping the table.

2006-12-02 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-127?page=comments#action_12455153 ] Thomas Dudziak commented on DDLUTILS-127: - Could you please post the SQL in the database and the target model that you used ? Also, please note that

[jira] Created: (DDLUTILS-137) Check that the alteration to the target model is valid

2006-12-02 Thread Thomas Dudziak (JIRA)
Check that the alteration to the target model is valid -- Key: DDLUTILS-137 URL: http://issues.apache.org/jira/browse/DDLUTILS-137 Project: DdlUtils Issue Type: Improvement

[jira] Updated: (DDLUTILS-125) Add support for START WITH

2006-11-30 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-125?page=all ] Thomas Dudziak updated DDLUTILS-125: Fix Version/s: 1.1 Add support for START WITH Key: DDLUTILS-125 URL:

[jira] Updated: (DDLUTILS-135) mergeWith in Database needs to handle existing tables correctly

2006-11-30 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-135?page=all ] Thomas Dudziak updated DDLUTILS-135: Fix Version/s: 1.1 mergeWith in Database needs to handle existing tables correctly ---

[jira] Resolved: (DDLUTILS-136) Importing a model from a file previously created with the DatabaseIO.write function fails due to missing XML declaration

2006-11-30 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-136?page=all ] Thomas Dudziak resolved DDLUTILS-136. - Resolution: Fixed Importing a model from a file previously created with the DatabaseIO.write function fails due to missing XML declaration

[jira] Resolved: (DDLUTILS-126) errors about the sequence with postgresql

2006-11-30 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-126?page=all ] Thomas Dudziak resolved DDLUTILS-126. - Resolution: Fixed errors about the sequence with postgresql - Key: DDLUTILS-126

[jira] Updated: (DDLUTILS-133) Command-Line Invoker

2006-11-23 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-133?page=all ] Thomas Dudziak updated DDLUTILS-133: Fix Version/s: 1.1 Sounds good too me ! Please check out whether you can use commons-cli (http://jakarta.apache.org/commons/cli/) to do the

[jira] Commented: (DDLUTILS-128) Clean up the exceptions used in DdlUtils

2006-10-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-128?page=comments#action_12442075 ] Thomas Dudziak commented on DDLUTILS-128: - Yeah, I've had some trouble with subversion so not all files did get commited. This should be fixed now.

[jira] Resolved: (DDLUTILS-129) Update to the new license header scheme

2006-10-12 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-129?page=all ] Thomas Dudziak resolved DDLUTILS-129. - Resolution: Fixed Update to the new license header scheme --- Key: DDLUTILS-129

[jira] Resolved: (DDLUTILS-128) Clean up the exceptions used in DdlUtils

2006-10-12 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-128?page=all ] Thomas Dudziak resolved DDLUTILS-128. - Resolution: Fixed Clean up the exceptions used in DdlUtils Key: DDLUTILS-128

[jira] Created: (DDLUTILS-130) Run unit tests on all supported databases and create doc with the results

2006-10-12 Thread Thomas Dudziak (JIRA)
Run unit tests on all supported databases and create doc with the results - Key: DDLUTILS-130 URL: http://issues.apache.org/jira/browse/DDLUTILS-130 Project: DdlUtils

[jira] Resolved: (DDLUTILS-40) Numeric formatting in MS SQL Server

2006-10-11 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-40?page=all ] Thomas Dudziak resolved DDLUTILS-40. Resolution: Fixed Is applied, though I used the CAST function instead for the dates/times because this should also work with other JDBC drivers (as

[jira] Resolved: (DDLUTILS-54) Column comparison does not check on native types

2006-10-11 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-54?page=all ] Thomas Dudziak resolved DDLUTILS-54. Resolution: Fixed I've added a unit test for this (testIssue54 in org.apache.ddlutils.io.TestAlteration) and apparently this is already fixed.

[jira] Created: (DDLUTILS-128) Clean up the exceptions used in DdlUtils

2006-10-11 Thread Thomas Dudziak (JIRA)
Clean up the exceptions used in DdlUtils Key: DDLUTILS-128 URL: http://issues.apache.org/jira/browse/DDLUTILS-128 Project: DdlUtils Issue Type: Improvement Affects Versions: 1.0

[jira] Created: (DDLUTILS-129) Update to the new license header scheme

2006-10-11 Thread Thomas Dudziak (JIRA)
Update to the new license header scheme --- Key: DDLUTILS-129 URL: http://issues.apache.org/jira/browse/DDLUTILS-129 Project: DdlUtils Issue Type: Improvement Reporter: Thomas Dudziak

[jira] Resolved: (DDLUTILS-46) Schemas dumped from DB2/400 tries twice to create primary key when loaded to Derby

2006-10-10 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-46?page=all ] Thomas Dudziak resolved DDLUTILS-46. Resolution: Fixed I think the problem was fixed during the re-work of the platforms. If it is still there though, then please re-open the bug.

[jira] Resolved: (DDLUTILS-61) column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)

2006-10-10 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=all ] Thomas Dudziak resolved DDLUTILS-61. Resolution: Fixed This should be fixed (as noted in my previous comment). column DEFAULT - SQL error during create table in ddlToDatabase( to

[jira] Resolved: (DDLUTILS-62) column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)

2006-10-10 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-62?page=all ] Thomas Dudziak resolved DDLUTILS-62. Resolution: Fixed This should be fixed (similar to DDLUTILS-61). column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL)

[jira] Resolved: (DDLUTILS-63) ddltoDatabase errors due to specific string values in table rows of data.xml -- ddltoDatabase(to MySQL) using files produced by databaseToDdl(from MSSQL)

2006-10-10 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-63?page=all ] Thomas Dudziak resolved DDLUTILS-63. Resolution: Fixed Values that contain such characters are now always written to sub elements, and Base64-encoded. ddltoDatabase errors due to

[jira] Resolved: (DDLUTILS-100) WriteDataToFile command not handling BLOBs correctly

2006-10-10 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-100?page=all ] Thomas Dudziak resolved DDLUTILS-100. - Resolution: Fixed WriteDataToFile command not handling BLOBs correctly

[jira] Commented: (DDLUTILS-122) Foreign keys not generated in SQL

2006-08-16 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-122?page=comments#action_12428569 ] Thomas Dudziak commented on DDLUTILS-122: - I'm not sure what you mean ? The attached SQL script includes plenty of foreign keys (47 to be precise) at

[jira] Updated: (DDLUTILS-124) Patch to fix Maven 2 build

2006-08-16 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-124?page=all ] Thomas Dudziak updated DDLUTILS-124: Fix Version/s: 1.0 Patch to fix Maven 2 build -- Key: DDLUTILS-124 URL:

[jira] Assigned: (DDLUTILS-124) Patch to fix Maven 2 build

2006-08-16 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-124?page=all ] Thomas Dudziak reassigned DDLUTILS-124: --- Assignee: Martin van den Bemt (was: Thomas Dudziak) Patch to fix Maven 2 build -- Key:

[jira] Commented: (DDLUTILS-122) Foreign keys not generated in SQL

2006-08-16 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-122?page=comments#action_12428571 ] Thomas Dudziak commented on DDLUTILS-122: - No need to feel idiotic, we all make such mistakes :-) Though you might bring things like this up on the

[jira] Resolved: (DDLUTILS-118) Modifying columns generates wrong SQL statement

2006-07-28 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-118?page=all ] Thomas Dudziak resolved DDLUTILS-118. - Resolution: Fixed This only appeared when using writeSchemaSqlToFile, which for some reason used the old alteration algorithm. I've removed this

[jira] Resolved: (DDLUTILS-120) Update the alterTable signature

2006-07-28 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-120?page=all ] Thomas Dudziak resolved DDLUTILS-120. - Resolution: Fixed Update the alterTable signature --- Key: DDLUTILS-120 URL:

[jira] Commented: (DDLUTILS-118) Modifying columns generates wrong SQL statement

2006-07-21 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-118?page=comments#action_12422775 ] Thomas Dudziak commented on DDLUTILS-118: - Are you sure that you're using the correct platform and/or current version of DdlUtils ? The PostgreSQL

[jira] Resolved: (DDLUTILS-89) Add support for ordering of foreign keys when reading from a live database

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-89?page=all ] Thomas Dudziak resolved DDLUTILS-89. Resolution: Fixed The platform interface has a new property foreignKeysSorted, and the two tasks (DatabaseToDdl, DdlToDatabase) have a related

[jira] Resolved: (DDLUTILS-114) decimal scale never gets written to schema-file in WriteSchema* Tasks

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-114?page=all ] Thomas Dudziak resolved DDLUTILS-114. - Resolution: Fixed decimal scale never gets written to schema-file in WriteSchema* Tasks

[jira] Resolved: (DDLUTILS-43) jdbc model reader does not set the database name

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-43?page=all ] Thomas Dudziak resolved DDLUTILS-43. Resolution: Fixed The name is now taken from the catalog read from the database metadata, or it can be supplied to both the API and the Ant task. If

[jira] Resolved: (DDLUTILS-20) Oracle FLOAT and DOUBLE type mappings have zero scale

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-20?page=all ] Thomas Dudziak resolved DDLUTILS-20. Resolution: Fixed DdlUtils now uses DOUBLE PRECISION, FLOAT and REAL respectively for these types as these are available at least in Oracle 8 and

[jira] Resolved: (DDLUTILS-18) DB2 autoincrement

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-18?page=all ] Thomas Dudziak resolved DDLUTILS-18. Resolution: Fixed A table defined as CREATE TABLE Test ( PK INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY, PRIMARY KEY (PK) ) is now

[jira] Commented: (DDLUTILS-63) ddltoDatabase errors due to specific string values in table rows of data.xml -- ddltoDatabase(to MySQL) using files produced by databaseToDdl(from MSSQL)

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-63?page=comments#action_12422035 ] Thomas Dudziak commented on DDLUTILS-63: Could you state the row as it is in the database (e.g. copied from a sql tool) ? I'm not quite sure whether the

[jira] Resolved: (DDLUTILS-14) Sybase autoincrement column

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-14?page=all ] Thomas Dudziak resolved DDLUTILS-14. Resolution: Fixed Sybase auto-increment reading should work now. Could you perhaps run that again (I don't have a Sybase installation at the moment)

[jira] Commented: (DDLUTILS-61) column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=comments#action_12422037 ] Thomas Dudziak commented on DDLUTILS-61: Could you state the row as it is in the database, e.g by copying from some SQL tool ? I'm interested in the

[jira] Resolved: (DDLUTILS-50) FK Constraints Failing on Merge in MS-SQL

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-50?page=all ] Thomas Dudziak resolved DDLUTILS-50. Resolution: Fixed This now works (with the revised database alteration algorithm). Actually, now there won't be any SQL executed (as it should be

[jira] Resolved: (DDLUTILS-51) BOOLEANINT for MS-SQL desires TINYINT, but uses SMALLINT

2006-07-18 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-51?page=all ] Thomas Dudziak resolved DDLUTILS-51. Resolution: Fixed This works now, DdlUtils will not change the column if you run the schema against the database again: [ddlToDatabase] INFO:

[jira] Resolved: (DDLUTILS-47) The PK constraint should be generated even if a column is an identity column (except for Hsqldb)

2006-07-17 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-47?page=all ] Thomas Dudziak resolved DDLUTILS-47. Resolution: Fixed As tested via TestConstraints#testPrimaryKeyAutoIncrementColumn() The PK constraint should be generated even if a column is an

[jira] Resolved: (DDLUTILS-52) MS-SQL errors with DEFAULTs in Alter Statements

2006-07-17 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-52?page=all ] Thomas Dudziak resolved DDLUTILS-52. Resolution: Fixed Yes, the default has to be added manually via ALTER TABLE ADD CONSTRAINT (and a previous default must be dropped before) MS-SQL

[jira] Resolved: (DDLUTILS-8) MsSqlBuilder can't alter a table to make a column autoincremented (identity)

2006-07-17 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-8?page=all ] Thomas Dudziak resolved DDLUTILS-8. --- Resolution: Fixed The table copy approach is now implemented, and in the case of Sql Builder, for tables with identity columns, a full table rebuild

[jira] Updated: (DDLUTILS-47) The PK constraint should be generated even if a column is an identity column (except for Hsqldb)

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-47?page=all ] Thomas Dudziak updated DDLUTILS-47: --- Fix Version: 1.0 The PK constraint should be generated even if a column is an identity column (except for Hsqldb)

[jira] Updated: (DDLUTILS-75) Add support for On Delete and On Update in schema XML for foreign keys

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-75?page=all ] Thomas Dudziak updated DDLUTILS-75: --- Fix Version: 1.1 Add support for On Delete and On Update in schema XML for foreign keys

[jira] Updated: (DDLUTILS-8) MsSqlBuilder can't alter a table to make a column autoincremented (identity)

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-8?page=all ] Thomas Dudziak updated DDLUTILS-8: -- Fix Version: 1.0 MsSqlBuilder can't alter a table to make a column autoincremented (identity)

[jira] Updated: (DDLUTILS-14) Sybase autoincrement column

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-14?page=all ] Thomas Dudziak updated DDLUTILS-14: --- Fix Version: 1.0 Sybase autoincrement column --- Key: DDLUTILS-14 URL:

[jira] Updated: (DDLUTILS-43) jdbc model reader does not set the database name

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-43?page=all ] Thomas Dudziak updated DDLUTILS-43: --- Fix Version: 1.0 jdbc model reader does not set the database name Key: DDLUTILS-43

[jira] Updated: (DDLUTILS-38) Support for international date/time format in MSSQL

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-38?page=all ] Thomas Dudziak updated DDLUTILS-38: --- Fix Version: 1.1 Support for international date/time format in MSSQL --- Key: DDLUTILS-38

[jira] Resolved: (DDLUTILS-36) Getting tables from connection metadata has not homogeneous behaviour depending on products

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-36?page=all ] Thomas Dudziak resolved DDLUTILS-36: Resolution: Fixed Getting tables from connection metadata has not homogeneous behaviour depending on products

[jira] Updated: (DDLUTILS-50) FK Constraints Failing on Merge in MS-SQL

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-50?page=all ] Thomas Dudziak updated DDLUTILS-50: --- Fix Version: 1.0 FK Constraints Failing on Merge in MS-SQL - Key: DDLUTILS-50 URL:

[jira] Updated: (DDLUTILS-57) Replace DateConverter's and TimeConverter's use of deprecated constructors

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-57?page=all ] Thomas Dudziak updated DDLUTILS-57: --- Fix Version: 1.0 Replace DateConverter's and TimeConverter's use of deprecated constructors

[jira] Resolved: (DDLUTILS-60) JDBC Type BIGINT in Firebird

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-60?page=all ] Thomas Dudziak resolved DDLUTILS-60: Resolution: Fixed The Firebird platform now uses the BIGINT native type as it is supposed to support Firebird 1.5 and newer. For Firebird 1.0,

[jira] Updated: (DDLUTILS-61) column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=all ] Thomas Dudziak updated DDLUTILS-61: --- Fix Version: 1.0 column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)

[jira] Updated: (DDLUTILS-62) CLONE -column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from MSSQL)

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-62?page=all ] Thomas Dudziak updated DDLUTILS-62: --- Fix Version: 1.0 CLONE -column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from

[jira] Updated: (DDLUTILS-63) ddltoDatabase errors due to specific string values in table rows of data.xml -- ddltoDatabase(to MySQL) using files produced by databaseToDdl(from MSSQL)

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-63?page=all ] Thomas Dudziak updated DDLUTILS-63: --- Fix Version: 1.0 ddltoDatabase errors due to specific string values in table rows of data.xml -- ddltoDatabase(to MySQL) using files produced by

[jira] Resolved: (DDLUTILS-67) Derby drop index statement should not include ON tablename

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-67?page=all ] Thomas Dudziak resolved DDLUTILS-67: Resolution: Fixed Derby drop index statement should not include ON tablename --

[jira] Resolved: (DDLUTILS-68) CLONE -Firebird drop index statement should not include ON tablename

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-68?page=all ] Thomas Dudziak resolved DDLUTILS-68: Resolution: Fixed CLONE -Firebird drop index statement should not include ON tablename

[jira] Resolved: (DDLUTILS-73) SQL syntax bug in PostgreSQL 8.1 for ALTER COLUMN

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-73?page=all ] Thomas Dudziak resolved DDLUTILS-73: Resolution: Fixed SQL syntax bug in PostgreSQL 8.1 for ALTER COLUMN - Key:

[jira] Updated: (DDLUTILS-80) nativeDefault attribute for column, which is not interpreted by DdlUtils at all

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-80?page=all ] Thomas Dudziak updated DDLUTILS-80: --- Fix Version: 1.1 nativeDefault attribute for column, which is not interpreted by DdlUtils at all

[jira] Updated: (DDLUTILS-85) Add support for unique constraints

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-85?page=all ] Thomas Dudziak updated DDLUTILS-85: --- Fix Version: 1.1 Add support for unique constraints -- Key: DDLUTILS-85 URL:

[jira] Updated: (DDLUTILS-82) FOREIGN KEY .... ON UPDATE .... ON DELETE ...

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-82?page=all ] Thomas Dudziak updated DDLUTILS-82: --- Fix Version: 1.1 FOREIGN KEY ON UPDATE ON DELETE ... - Key: DDLUTILS-82

[jira] Updated: (DDLUTILS-89) Add support for ordering of foreign keys when reading from a live database

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-89?page=all ] Thomas Dudziak updated DDLUTILS-89: --- Fix Version: 1.0 Add support for ordering of foreign keys when reading from a live database

[jira] Updated: (DDLUTILS-83) Name of Primary Key

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-83?page=all ] Thomas Dudziak updated DDLUTILS-83: --- Fix Version: 1.1 Name of Primary Key --- Key: DDLUTILS-83 URL: http://issues.apache.org/jira/browse/DDLUTILS-83

[jira] Updated: (DDLUTILS-92) writeSchemaSqlToFile should just test if a connection has been established

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-92?page=all ] Thomas Dudziak updated DDLUTILS-92: --- Fix Version: 1.0 writeSchemaSqlToFile should just test if a connection has been established

[jira] Updated: (DDLUTILS-94) Create nice looking Documentation from database.xml

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-94?page=all ] Thomas Dudziak updated DDLUTILS-94: --- Fix Version: 1.1 Create nice looking Documentation from database.xml --- Key: DDLUTILS-94

[jira] Updated: (DDLUTILS-96) Db2 database cannot extract table definition from database with schema

2006-07-13 Thread Thomas Dudziak (JIRA)
[ 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

[jira] Updated: (DDLUTILS-101) Support the dumping of data from a database into an XML file for each table.

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-101?page=all ] Thomas Dudziak updated DDLUTILS-101: Fix Version: 1.1 Support the dumping of data from a database into an XML file for each table.

[jira] Resolved: (DDLUTILS-112) Tests failed on several DBs

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-112?page=all ] Thomas Dudziak resolved DDLUTILS-112: - Resolution: Invalid Please file individual bug reports instead of creating a generic one. Also, the unit tests may not run smoothly depending

[jira] Updated: (DDLUTILS-108) Unicode text fields (NTEXT, NVARCHAR, and NCHAR) for MSSQL

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-108?page=all ] Thomas Dudziak updated DDLUTILS-108: Fix Version: 1.1 Unicode text fields (NTEXT, NVARCHAR, and NCHAR) for MSSQL --

[jira] Commented: (DDLUTILS-46) Schemas dumped from DB2/400 tries twice to create primary key when loaded to Derby

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-46?page=comments#action_12420800 ] Thomas Dudziak commented on DDLUTILS-46: Could you try that again with the current SVN source ? The problem is that DdlUtils has to manually filter the unique

[jira] Updated: (DDLUTILS-46) Schemas dumped from DB2/400 tries twice to create primary key when loaded to Derby

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-46?page=all ] Thomas Dudziak updated DDLUTILS-46: --- Fix Version: 1.0 Schemas dumped from DB2/400 tries twice to create primary key when loaded to Derby

[jira] Resolved: (DDLUTILS-44) Column remarks are not stored in JdbcModelReader.getColumnsForTable

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-44?page=all ] Thomas Dudziak resolved DDLUTILS-44: Resolution: Fixed Column remarks are not stored in JdbcModelReader.getColumnsForTable

[jira] Updated: (DDLUTILS-39) Creating Foreign Keys before creating the matching Tables

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-39?page=all ] Thomas Dudziak updated DDLUTILS-39: --- Fix Version: 1.0 Creating Foreign Keys before creating the matching Tables - Key:

[jira] Resolved: (DDLUTILS-17) MS SQL Server DATETIME column

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-17?page=all ] Thomas Dudziak resolved DDLUTILS-17: Resolution: Cannot Reproduce MS SQL Server DATETIME column - Key: DDLUTILS-17 URL:

[jira] Updated: (DDLUTILS-27) Capture and maintenance of column level comment fields

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-27?page=all ] Thomas Dudziak updated DDLUTILS-27: --- Fix Version: 1.1 Capture and maintenance of column level comment fields -- Key:

[jira] Updated: (DDLUTILS-51) BOOLEANINT for MS-SQL desires TINYINT, but uses SMALLINT

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-51?page=all ] Thomas Dudziak updated DDLUTILS-51: --- Fix Version: 1.0 BOOLEANINT for MS-SQL desires TINYINT, but uses SMALLINT Key:

[jira] Updated: (DDLUTILS-54) Column comparison does not check on native types

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-54?page=all ] Thomas Dudziak updated DDLUTILS-54: --- Fix Version: 1.0 Column comparison does not check on native types Key: DDLUTILS-54

[jira] Updated: (DDLUTILS-86) New attribute of Column. Native type is a value of TYPE_NAME in the result set of DataBaseMetadata.getColumns(...).

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-86?page=all ] Thomas Dudziak updated DDLUTILS-86: --- Fix Version: 1.1 New attribute of Column. Native type is a value of TYPE_NAME in the result set of DataBaseMetadata.getColumns(...).

[jira] Updated: (DDLUTILS-97) PropertyChangeSupport for model-classes (Table, Column, ...)

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-97?page=all ] Thomas Dudziak updated DDLUTILS-97: --- Fix Version: 1.1 PropertyChangeSupport for model-classes (Table, Column, ...)

[jira] Updated: (DDLUTILS-113) Oracle : PlatformFactory.createNewPlatformInstance always detect an Oracle 8 database

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-113?page=all ] Thomas Dudziak updated DDLUTILS-113: Fix Version: 1.1 Oracle : PlatformFactory.createNewPlatformInstance always detect an Oracle 8 database

[jira] Updated: (DDLUTILS-28) Capture and creation of non-table entities - constraints, triggers, stored procedures and others

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-28?page=all ] Thomas Dudziak updated DDLUTILS-28: --- Fix Version: 1.1 Capture and creation of non-table entities - constraints, triggers, stored procedures and others

[jira] Updated: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-115?page=all ] Thomas Dudziak updated DDLUTILS-115: Component: Core - SqlServer SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

[jira] Updated: (DDLUTILS-115) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require IDENTITY_INSERT ON.

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-115?page=all ] Thomas Dudziak updated DDLUTILS-115: Component: (was: Core (No specific database)) SqlBuilder.writeCopyDataStatement(Table, Table) fails on MSSQL tables which require

[jira] Updated: (DDLUTILS-113) Oracle : PlatformFactory.createNewPlatformInstance always detect an Oracle 8 database

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-113?page=all ] Thomas Dudziak updated DDLUTILS-113: Component: Core - Oracle Oracle : PlatformFactory.createNewPlatformInstance always detect an Oracle 8 database

[jira] Updated: (DDLUTILS-110) Updated Maven 2 pom.xml

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-110?page=all ] Thomas Dudziak updated DDLUTILS-110: Component: (was: Core (No specific database)) Updated Maven 2 pom.xml --- Key: DDLUTILS-110 URL:

[jira] Updated: (DDLUTILS-109) MSSqlBuilder can't drop a table with constraints with names longer than 60 characters

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-109?page=all ] Thomas Dudziak updated DDLUTILS-109: Component: Core - SqlServer MSSqlBuilder can't drop a table with constraints with names longer than 60 characters

[jira] Updated: (DDLUTILS-108) Unicode text fields (NTEXT, NVARCHAR, and NCHAR) for MSSQL

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-108?page=all ] Thomas Dudziak updated DDLUTILS-108: Component: Core - SqlServer (was: Core (No specific database)) Unicode text fields (NTEXT, NVARCHAR, and NCHAR) for MSSQL

[jira] Updated: (DDLUTILS-105) When upgrading a database, and the auto-increment for a column is set to 'true' the sequence is not created

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-105?page=all ] Thomas Dudziak updated DDLUTILS-105: Component: Core - Oracle (was: Core (No specific database)) When upgrading a database, and the auto-increment for a column is set

[jira] Updated: (DDLUTILS-101) Support the dumping of data from a database into an XML file for each table.

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-101?page=all ] Thomas Dudziak updated DDLUTILS-101: Component: Ant Tasks Support the dumping of data from a database into an XML file for each table.

[jira] Updated: (DDLUTILS-94) Create nice looking Documentation from database.xml

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-94?page=all ] Thomas Dudziak updated DDLUTILS-94: --- Component: Ant Tasks (was: Core (No specific database)) Create nice looking Documentation from database.xml

[jira] Updated: (DDLUTILS-89) Add support for ordering of foreign keys when reading from a live database

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-89?page=all ] Thomas Dudziak updated DDLUTILS-89: --- Component: Ant Tasks Add support for ordering of foreign keys when reading from a live database

[jira] Updated: (DDLUTILS-81) Capture and creation of sequences

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-81?page=all ] Thomas Dudziak updated DDLUTILS-81: --- Component: Core (No specific database) Capture and creation of sequences - Key: DDLUTILS-81 URL:

[jira] Updated: (DDLUTILS-79) DROP COLUMN doesn't work with firebird and interbase

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-79?page=all ] Thomas Dudziak updated DDLUTILS-79: --- Component: Core - Firebird Core - Interbase (was: Core (No specific database)) DROP COLUMN doesn't work with firebird

[jira] Updated: (DDLUTILS-77) Remove the System.err.println in PlatformImplBase

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-77?page=all ] Thomas Dudziak updated DDLUTILS-77: --- Component: Core (No specific database) Remove the System.err.println in PlatformImplBase -

<    1   2   3   >