[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: --- Component: Core (No specific database) ddltoDatabase errors due to specific string values in table rows of data.xml -- ddltoDatabase(to MySQL) using

[jira] Updated: (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 updated DDLUTILS-60: --- Component: Core - Firebird Core - Interbase JDBC Type BIGINT in Firebird Key: DDLUTILS-60

[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: --- Component: Core (No specific database) Replace DateConverter's and TimeConverter's use of deprecated constructors

[jira] Updated: (DDLUTILS-62) 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: --- Component: Core (No specific database) Summary: column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced

[jira] Updated: (DDLUTILS-55) HsqlDb PlatformInfo should not use delimited identifiers

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-55?page=all ] Thomas Dudziak updated DDLUTILS-55: --- Component: Core - HSQLDB HsqlDb PlatformInfo should not use delimited identifiers

[jira] Updated: (DDLUTILS-53) Incorrect syntax for modifying columns in Derby

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-53?page=all ] Thomas Dudziak updated DDLUTILS-53: --- Component: Core - Derby/Cloudscape/JavaDB Incorrect syntax for modifying columns in Derby

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

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-52?page=all ] Thomas Dudziak updated DDLUTILS-52: --- Component: Core - SqlServer MS-SQL errors with DEFAULTs in Alter Statements - Key: DDLUTILS

[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: --- Component: Core - SqlServer BOOLEANINT for MS-SQL desires TINYINT, but uses SMALLINT

[jira] Updated: (DDLUTILS-49) Problem Delimiter in Postgres (8.1)

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-49?page=all ] Thomas Dudziak updated DDLUTILS-49: --- Component: Core - PostgreSql Problem Delimiter in Postgres (8.1) --- Key: DDLUTILS-49 URL: http

[jira] Updated: (DDLUTILS-45) createDatabase and alterDatabase should give access to the generated SQL.

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-45?page=all ] Thomas Dudziak updated DDLUTILS-45: --- Component: Core (No specific database) createDatabase and alterDatabase should give access to the generated SQL

[jira] Updated: (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 updated DDLUTILS-44: --- Component: Core (No specific database) Column remarks are not stored in JdbcModelReader.getColumnsForTable

[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: --- Component: Core (No specific database) jdbc model reader does not set the database name

[jira] Updated: (DDLUTILS-42) Index information is not read

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-42?page=all ] Thomas Dudziak updated DDLUTILS-42: --- Component: Core (No specific database) Index information is not read - Key: DDLUTILS-42 URL: http

[jira] Updated: (DDLUTILS-41) dropDatabase requires schema file for DdlToDatabaseTask

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-41?page=all ] Thomas Dudziak updated DDLUTILS-41: --- Component: Ant Tasks dropDatabase requires schema file for DdlToDatabaseTask --- Key

[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: --- Component: Core - SqlServer Support for international date/time format in MSSQL --- Key

[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: --- Component: Core - PostgreSql Creating Foreign Keys before creating the matching Tables

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

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-40?page=all ] Thomas Dudziak updated DDLUTILS-40: --- Component: Core - SqlServer Numeric formatting in MS SQL Server --- Key: DDLUTILS-40 URL: http

[jira] Updated: (DDLUTILS-37) org.apache.ddlutils.model.Database implements Serializable but it's not

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-37?page=all ] Thomas Dudziak updated DDLUTILS-37: --- Component: Core (No specific database) org.apache.ddlutils.model.Database implements Serializable but it's

[jira] Updated: (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 updated DDLUTILS-36: --- Component: Core (No specific database) Getting tables from connection metadata has not homogeneous behaviour depending on products

[jira] Updated: (DDLUTILS-34) Credentials needed when using a DataSource

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-34?page=all ] Thomas Dudziak updated DDLUTILS-34: --- Component: Core (No specific database) Credentials needed when using a DataSource -- Key: DDLUTILS

[jira] Updated: (DDLUTILS-32) I want to be able to specify the table type/engine when i create tables in mysql.

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-32?page=all ] Thomas Dudziak updated DDLUTILS-32: --- Component: Core - MySql I want to be able to specify the table type/engine when i create tables in mysql

[jira] Updated: (DDLUTILS-31) Generated XML data dump is invalid

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-31?page=all ] Thomas Dudziak updated DDLUTILS-31: --- Component: Core (No specific database) Generated XML data dump is invalid -- Key: DDLUTILS-31 URL

[jira] Updated: (DDLUTILS-30) Encoding not supported

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-30?page=all ] Thomas Dudziak updated DDLUTILS-30: --- Component: Core (No specific database) Encoding not supported -- Key: DDLUTILS-30 URL: http

[jira] Updated: (DDLUTILS-29) Stream is already closed with Oracle

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-29?page=all ] Thomas Dudziak updated DDLUTILS-29: --- Component: Core - Oracle Stream is already closed with Oracle -- Key: DDLUTILS-29 URL: http

[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: --- Component: Core (No specific database) Capture and maintenance of column level comment fields

[jira] Updated: (DDLUTILS-26) MySQL drop foreign key

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-26?page=all ] Thomas Dudziak updated DDLUTILS-26: --- Component: Core - MySql MySQL drop foreign key -- Key: DDLUTILS-26 URL: http://issues.apache.org/jira/browse

[jira] Updated: (DDLUTILS-24) Insert / update collection of Dynabean

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-24?page=all ] Thomas Dudziak updated DDLUTILS-24: --- Component: Core (No specific database) Insert / update collection of Dynabean -- Key: DDLUTILS-24

[jira] Updated: (DDLUTILS-23) Method write(Iterator beans) in DataWriter class doesn't work

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-23?page=all ] Thomas Dudziak updated DDLUTILS-23: --- Component: Core (No specific database) Method write(Iterator beans) in DataWriter class doesn't work

[jira] Updated: (DDLUTILS-22) DB2 type mapping for BOOLEAN should be SMALLINT?

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-22?page=all ] Thomas Dudziak updated DDLUTILS-22: --- Component: Core - DB2 DB2 type mapping for BOOLEAN should be SMALLINT? Key: DDLUTILS-22

[jira] Updated: (DDLUTILS-21) Sql Server drop statements fail without delimited identifiers

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-21?page=all ] Thomas Dudziak updated DDLUTILS-21: --- Component: Core - SqlServer Sql Server drop statements fail without delimited identifiers

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

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-20?page=all ] Thomas Dudziak updated DDLUTILS-20: --- Component: Core - Oracle Oracle FLOAT and DOUBLE type mappings have zero scale - Key

[jira] Updated: (DDLUTILS-19) index tag and unique tag exists in dtd but DatabaseIO().write generate XML without index and unique elements

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-19?page=all ] Thomas Dudziak updated DDLUTILS-19: --- Component: Core (No specific database) index tag and unique tag exists in dtd but DatabaseIO().write generate XML without index and unique elements

[jira] Updated: (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 updated DDLUTILS-17: --- Component: Core - SqlServer MS SQL Server DATETIME column - Key: DDLUTILS-17 URL: http

[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: --- Component: Core - Sybase Sybase autoincrement column --- Key: DDLUTILS-14 URL: http://issues.apache.org

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

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-18?page=all ] Thomas Dudziak updated DDLUTILS-18: --- Component: Core - DB2 DB2 autoincrement - Key: DDLUTILS-18 URL: http://issues.apache.org/jira/browse/DDLUTILS-18

[jira] Updated: (DDLUTILS-16) Support for options when creating databases

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-16?page=all ] Thomas Dudziak updated DDLUTILS-16: --- Component: Core (No specific database) Support for options when creating databases --- Key

[jira] Updated: (DDLUTILS-12) cache metadata from connection

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-12?page=all ] Thomas Dudziak updated DDLUTILS-12: --- Component: Core (No specific database) cache metadata from connection -- Key: DDLUTILS-12 URL: http

[jira] Updated: (DDLUTILS-9) shouldGeneratePrimaryKeys(List) changed to shouldGeneratePrimaryKeys(Column[]) in SqlBuilder, but not in its subclasses.

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-9?page=all ] Thomas Dudziak updated DDLUTILS-9: -- Component: Core (No specific database) shouldGeneratePrimaryKeys(List) changed to shouldGeneratePrimaryKeys(Column[]) in SqlBuilder, but not in its

[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: -- Component: Core - SqlServer MsSqlBuilder can't alter a table to make a column autoincremented (identity

[jira] Updated: (DDLUTILS-6) Exception in Table.getPrimaryKeyColumns(), .getNonUniqueIndices(), .getUniqueIndices() because PredicatedList used where CollectionUtils.select() was intended.

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-6?page=all ] Thomas Dudziak updated DDLUTILS-6: -- Component: Core (No specific database) Exception in Table.getPrimaryKeyColumns(), .getNonUniqueIndices(), .getUniqueIndices() because PredicatedList

[jira] Updated: (DDLUTILS-5) I'm unable to specify that i don't want any sql drops generated with WriteSchemaSqlToFileCommand

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-5?page=all ] Thomas Dudziak updated DDLUTILS-5: -- Component: Ant Tasks I'm unable to specify that i don't want any sql drops generated with WriteSchemaSqlToFileCommand

[jira] Updated: (DDLUTILS-1) Added several native type mappings for Hsqldb

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-1?page=all ] Thomas Dudziak updated DDLUTILS-1: -- Component: Core - HSQLDB Added several native type mappings for Hsqldb - Key: DDLUTILS-1

[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: --- Component: Core - SqlServer column DEFAULT - SQL error during create table in ddlToDatabase( to MySQL) using files produced by databaseToDdl(from

[jira] Updated: (DDLUTILS-59) Maven 2 Plugin for DdlToDatabase and DatabaseToDdl

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-59?page=all ] Thomas Dudziak updated DDLUTILS-59: --- Component: Build Maven 2 Plugin for DdlToDatabase and DatabaseToDdl -- Key: DDLUTILS-59

[jira] Created: (DDLUTILS-116) Fully support multiple schemas

2006-07-13 Thread Thomas Dudziak (JIRA)
Fully support multiple schemas -- Key: DDLUTILS-116 URL: http://issues.apache.org/jira/browse/DDLUTILS-116 Project: DdlUtils Type: Improvement Components: Core (No specific database) Reporter: Thomas Dudziak Assigned to: Thomas

[jira] Updated: (DDLUTILS-117) Use an XML schema instead of a DTD

2006-07-13 Thread Thomas Dudziak (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-117?page=all ] Thomas Dudziak updated DDLUTILS-117: Component: Core (No specific database) Priority: Critical (was: Major) Use an XML schema instead of a DTD

[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

[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] 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

[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

[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

[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

[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

[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] Updated: (DDLUTILS-118) Modifying columns generates wrong SQL statement

2006-07-21 Thread Niklas Ekman (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-118?page=all ] Niklas Ekman updated DDLUTILS-118: -- Description: When changing a column size the following SQL statement is generated: ALTER TABLE testtable MODIFY test VARCHAR(100) But according

[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] Commented: (DDLUTILS-118) Modifying columns generates wrong SQL statement

2006-07-23 Thread Niklas Ekman (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-118?page=comments#action_12422923 ] Niklas Ekman commented on DDLUTILS-118: --- I'm using the DdlUtils trunk, newly checked out and built with ant. And also, I've checked

[jira] Created: (DDLUTILS-119) Dropping unique index properly on SQL Server.

2006-07-24 Thread Jun Li (JIRA)
Dropping unique index properly on SQL Server. - Key: DDLUTILS-119 URL: http://issues.apache.org/jira/browse/DDLUTILS-119 Project: DdlUtils Issue Type: Bug Components: Core - SqlServer

[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

[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: http

[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-08-01 Thread Appajee Papolu (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-63?page=all ] Appajee Papolu updated DDLUTILS-63: --- Attachment: RowWithAsciiOneChar.txt This file shows an exported row with one column that has some proprietary encoded text -- which has an ASCII - 1

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

2006-08-16 Thread Mike Perham (JIRA)
Foreign keys not generated in SQL - Key: DDLUTILS-122 URL: http://issues.apache.org/jira/browse/DDLUTILS-122 Project: DdlUtils Issue Type: Bug Components: Core - DB2 Affects Versions: 1.0

[jira] Created: (DDLUTILS-123) Allow long table/column names in DB2 8.0+

2006-08-16 Thread Mike Perham (JIRA)
Allow long table/column names in DB2 8.0+ - Key: DDLUTILS-123 URL: http://issues.apache.org/jira/browse/DDLUTILS-123 Project: DdlUtils Issue Type: Improvement Components: Core - DB2

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

2006-08-16 Thread Mike Perham (JIRA)
Patch to fix Maven 2 build -- Key: DDLUTILS-124 URL: http://issues.apache.org/jira/browse/DDLUTILS-124 Project: DdlUtils Issue Type: Bug Components: Build Affects Versions: 1.0 Reporter

[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

[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: http

[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: DDLUTILS

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

2006-08-16 Thread Mike Perham (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-122?page=comments#action_12428570 ] Mike Perham commented on DDLUTILS-122: -- Wow, I feel idiotic. Ok, you put them at the end so you don't have to worry about ordering. You can close

[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

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

2006-08-18 Thread Mike Perham (JIRA)
Add support for START WITH Key: DDLUTILS-125 URL: http://issues.apache.org/jira/browse/DDLUTILS-125 Project: DdlUtils Issue Type: New Feature Components: Core (No specific database) Affects

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

2006-08-24 Thread Rusty Wright (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-126?page=all ] Rusty Wright updated DDLUTILS-126: -- Description: Ant output: == [ddlToDatabase] Read schema file /local_a/users/rusty/java/jwaitlistd10/sql/waitlist.xml [ddlToDatabase] Aug 24

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

2006-09-25 Thread John Fereira (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-85?page=comments#action_12437610 ] John Fereira commented on DDLUTILS-85: -- I couldn't tell what the resolution status was for this issue... Using a McKoi database I created a database table

[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 MySQL

[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

[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 Key

[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

[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-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] Commented: (DDLUTILS-128) Clean up the exceptions used in DdlUtils

2006-10-13 Thread Daniel Skiles (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-128?page=comments#action_12442061 ] Daniel Skiles commented on DDLUTILS-128: I retrieved the source code after these and was unable to build DdlUtils from a clean state

[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] 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-10-13 Thread Appajee Papolu (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-63?page=comments#action_12442189 ] Appajee Papolu commented on DDLUTILS-63: [[ Old comment, sent by email on Mon, 31 Jul 2006 13:33:30 -0700 ]] Thomas, Unfortunately I am unable

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

2006-10-13 Thread Appajee Papolu (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-61?page=comments#action_12442190 ] Appajee Papolu commented on DDLUTILS-61: [[ Old comment, sent by email on Mon, 31 Jul 2006 13:37:32 -0700 ]] Thomas, Thanks for the note. I

[jira] Updated: (DDLUTILS-131) Wrong path to commons-betwixt.jar in the current maven pom

2006-11-09 Thread Fredrik Westermarck (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-131?page=all ] Fredrik Westermarck updated DDLUTILS-131: - Attachment: pom.xml.patch Wrong path to commons-betwixt.jar in the current maven pom

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

2006-11-23 Thread Alexander Hars (JIRA)
Command-Line Invoker Key: DDLUTILS-133 URL: http://issues.apache.org/jira/browse/DDLUTILS-133 Project: DdlUtils Issue Type: New Feature Components: Ant Tasks Reporter: Alexander Hars

[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

[jira] Created: (DDLUTILS-134) Bad start value when importing identity in Derby

2006-11-27 Thread Laurent ROCHE (JIRA)
Bad start value when importing identity in Derby Key: DDLUTILS-134 URL: http://issues.apache.org/jira/browse/DDLUTILS-134 Project: DdlUtils Issue Type: Bug Affects Versions: 1.1

[jira] Updated: (DDLUTILS-134) Bad start value when importing identity in Derby

2006-11-27 Thread Laurent ROCHE (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-134?page=all ] Laurent ROCHE updated DDLUTILS-134: --- Attachment: test_derby.sql Here is a postgreSQL script which is an example of the table exported Bad start value when importing identity in Derby

[jira] Updated: (DDLUTILS-134) Bad start value when importing identity in Derby

2006-11-27 Thread Laurent ROCHE (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-134?page=all ] Laurent ROCHE updated DDLUTILS-134: --- Attachment: my_build.xml This is the build file used to export (from PostgreSQL) and import (into Derby). Bad start value when importing identity

[jira] Updated: (DDLUTILS-134) Bad start value when importing identity in Derby

2006-11-27 Thread Laurent ROCHE (JIRA)
[ http://issues.apache.org/jira/browse/DDLUTILS-134?page=all ] Laurent ROCHE updated DDLUTILS-134: --- Attachment: Ddlutils-test.zip In case, somebody interested (in fixing this) does not have access to a Postgres server, here are the files produced

<    1   2   3   4   5   6   >