dbunit-developer

[dbunit-developer] [ dbunit-Bugs-3358500 ] NoSuchTableException when working on multi-schema database

[SourceForge.net <no...@so...>]

Bugs item #3358500, was opened at 2011-07-08 17:08
Message generated for change (Comment added) made by njouffre
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3358500&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: v2.4.*
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: enji (njouffre)
Assigned to: matthias g (gommma)
Summary: NoSuchTableException when working on multi-schema database

Initial Comment:
Hi,

Environment : Unitils 3.1, DbUnit 2.4.3, MySQL database
Test case : crash when unitils try to insert data using xml dataset before running a test
Stack trace :

Caused by: org.dbunit.dataset.NoSuchTableException: my_table_in_second_schema
	at org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:278)
	at org.dbunit.operation.DeleteAllOperation.execute(DeleteAllOperation.java:109)
	at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:79)
	at org.unitils.dbunit.datasetloadstrategy.impl.CleanInsertLoadStrategy.doExecute(CleanInsertLoadStrategy.java:45)
	at org.unitils.dbunit.datasetloadstrategy.impl.BaseDataSetLoadStrategy.execute(BaseDataSetLoadStrategy.java:44)
	... 20 more

Explanation : this bug is due to the way mysql implement catalog, schema and database notions to some "illogical" compatibility reasons
see http://forums.mysql.com/read.php?39,137564,137564
in several dbunit methods, parameter catalog is passed as null when trying to retrieve tables, columns or primary keys from DatabaseMetaData object

Bug fix :

in org.dbunit.util.SQLHelper add method

public static boolean isMySQLDb(DatabaseMetaData metaData) throws SQLException 
{
        String dbProductName = metaData.getDatabaseProductName();
        boolean isMySQL = (dbProductName != null && dbProductName.equals(DB_PRODUCT_MYSQL));
        return isMySQL;
}

in org.dbunit.database.DatabaseDataSet modify method initialize()

            Connection jdbcConnection = _connection.getConnection();
            DatabaseMetaData databaseMetaData = jdbcConnection.getMetaData();

            String schema = _connection.getSchema();
            
            if(SQLHelper.isSybaseDb(jdbcConnection.getMetaData()) && !jdbcConnection.getMetaData().getUserName().equals(schema) ){
                logger.warn("For sybase the schema name should be equal to the user name. " +
                		"Otherwise the DatabaseMetaData#getTables() method might not return any columns. " +
                		"See dbunit tracker #1628896 and http://issues.apache.org/jira/browse/TORQUE-40?page=all");
            }
            
            // Bug fix specific when using MySQL SGBD
            // see http://forums.mysql.com/read.php?39,137564,137564#msg-137564
            String catalog = null;
            if (SQLHelper.isMySQLDb(databaseMetaData)) {
            	logger.warn("For MySQL the catalog name should not be null. It should be equal to the schema name. " +
                		"Otherwise the DatabaseMetaData#getTables() method might not return any columns when testing multiple schema database. " +
                		"See http://forums.mysql.com/read.php?39,137564,137564#msg-137564");
            	catalog = schema;
            }
            
            DatabaseConfig config = _connection.getConfig();
            String[] tableType = (String[])config.getProperty(DatabaseConfig.PROPERTY_TABLE_TYPE);

            ResultSet resultSet = databaseMetaData.getTables(
            		catalog, schema, "%", tableType);
			
	    // end bug fix

in org.dbunit.database.DatabaseDataSet.DatabaseTableMetaData modify method getPrimaryKeyNames()

        Connection connection = _connection.getConnection();
        DatabaseMetaData databaseMetaData = connection.getMetaData();
        
        // Bug fix specific when using MySQL SGBD
        // see http://forums.mysql.com/read.php?39,137564,137564#msg-137564
        String catalog = null;
        if (SQLHelper.isMySQLDb(databaseMetaData)) {
        	logger.warn("For MySQL the catalog name should not be null. It should be equal to the schema name. " +
            		"Otherwise the DatabaseMetaData#getTables() method might not return any columns when testing multiple schema database. " +
            		"See http://forums.mysql.com/read.php?39,137564,137564#msg-137564");
        	catalog = schemaName;
        }
                
        ResultSet resultSet = databaseMetaData.getPrimaryKeys(
        		catalog, schemaName, tableName);
        // end bug fix	

in org.dbunit.database.DatabaseDataSet.DatabaseTableMetaData modify method tableExists(DatabaseMetaData metaData, String schema, String tableName) 		

        // Bug fix specific when using MySQL SGBD
        // see http://forums.mysql.com/read.php?39,137564,137564#msg-137564
        String catalog = null;
        if (SQLHelper.isMySQLDb(metaData)) {
        	logger.warn("For MySQL the catalog name should not be null. It should be equal to the schema name. " +
            		"Otherwise the DatabaseMetaData#getTables() method might not return any columns when testing multiple schema database. " +
            		"See http://forums.mysql.com/read.php?39,137564,137564#msg-137564");
        	catalog = schema;
        }
        
    	ResultSet tableRs = metaData.getTables(catalog, schema, tableName, null);
    	// end bug fix	

Until know I found only theses 3 pieces of code where catalog parameter was required to make it work with MySQL database, but I'm not sure they are the only ones.

----------------------------------------------------------------------

>Comment By: enji (njouffre)
Date: 2011-07-08 17:40

Message:
sorry, I copy/paste wrong things in my post
the last bug fix is correct bug method tableExists() is in
org.dbunit.util.SQLHelper
and method getPrimaryKeyNames in org.dbunit.database.DatabaseTableMetaData

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3358500&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3358500 ] NoSuchTableException when working on multi-schema database

[SourceForge.net <no...@so...>]

Bugs item #3358500, was opened at 2011-07-08 17:08
Message generated for change (Tracker Item Submitted) made by njouffre
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3358500&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: v2.4.*
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: enji (njouffre)
Assigned to: matthias g (gommma)
Summary: NoSuchTableException when working on multi-schema database

Initial Comment:
Hi,

Environment : Unitils 3.1, DbUnit 2.4.3, MySQL database
Test case : crash when unitils try to insert data using xml dataset before running a test
Stack trace :

Caused by: org.dbunit.dataset.NoSuchTableException: my_table_in_second_schema
	at org.dbunit.database.DatabaseDataSet.getTableMetaData(DatabaseDataSet.java:278)
	at org.dbunit.operation.DeleteAllOperation.execute(DeleteAllOperation.java:109)
	at org.dbunit.operation.CompositeOperation.execute(CompositeOperation.java:79)
	at org.unitils.dbunit.datasetloadstrategy.impl.CleanInsertLoadStrategy.doExecute(CleanInsertLoadStrategy.java:45)
	at org.unitils.dbunit.datasetloadstrategy.impl.BaseDataSetLoadStrategy.execute(BaseDataSetLoadStrategy.java:44)
	... 20 more

Explanation : this bug is due to the way mysql implement catalog, schema and database notions to some "illogical" compatibility reasons
see http://forums.mysql.com/read.php?39,137564,137564
in several dbunit methods, parameter catalog is passed as null when trying to retrieve tables, columns or primary keys from DatabaseMetaData object

Bug fix :

in org.dbunit.util.SQLHelper add method

public static boolean isMySQLDb(DatabaseMetaData metaData) throws SQLException 
{
        String dbProductName = metaData.getDatabaseProductName();
        boolean isMySQL = (dbProductName != null && dbProductName.equals(DB_PRODUCT_MYSQL));
        return isMySQL;
}

in org.dbunit.database.DatabaseDataSet modify method initialize()

            Connection jdbcConnection = _connection.getConnection();
            DatabaseMetaData databaseMetaData = jdbcConnection.getMetaData();

            String schema = _connection.getSchema();
            
            if(SQLHelper.isSybaseDb(jdbcConnection.getMetaData()) && !jdbcConnection.getMetaData().getUserName().equals(schema) ){
                logger.warn("For sybase the schema name should be equal to the user name. " +
                		"Otherwise the DatabaseMetaData#getTables() method might not return any columns. " +
                		"See dbunit tracker #1628896 and http://issues.apache.org/jira/browse/TORQUE-40?page=all");
            }
            
            // Bug fix specific when using MySQL SGBD
            // see http://forums.mysql.com/read.php?39,137564,137564#msg-137564
            String catalog = null;
            if (SQLHelper.isMySQLDb(databaseMetaData)) {
            	logger.warn("For MySQL the catalog name should not be null. It should be equal to the schema name. " +
                		"Otherwise the DatabaseMetaData#getTables() method might not return any columns when testing multiple schema database. " +
                		"See http://forums.mysql.com/read.php?39,137564,137564#msg-137564");
            	catalog = schema;
            }
            
            DatabaseConfig config = _connection.getConfig();
            String[] tableType = (String[])config.getProperty(DatabaseConfig.PROPERTY_TABLE_TYPE);

            ResultSet resultSet = databaseMetaData.getTables(
            		catalog, schema, "%", tableType);
			
	    // end bug fix

in org.dbunit.database.DatabaseDataSet.DatabaseTableMetaData modify method getPrimaryKeyNames()

        Connection connection = _connection.getConnection();
        DatabaseMetaData databaseMetaData = connection.getMetaData();
        
        // Bug fix specific when using MySQL SGBD
        // see http://forums.mysql.com/read.php?39,137564,137564#msg-137564
        String catalog = null;
        if (SQLHelper.isMySQLDb(databaseMetaData)) {
        	logger.warn("For MySQL the catalog name should not be null. It should be equal to the schema name. " +
            		"Otherwise the DatabaseMetaData#getTables() method might not return any columns when testing multiple schema database. " +
            		"See http://forums.mysql.com/read.php?39,137564,137564#msg-137564");
        	catalog = schemaName;
        }
                
        ResultSet resultSet = databaseMetaData.getPrimaryKeys(
        		catalog, schemaName, tableName);
        // end bug fix	

in org.dbunit.database.DatabaseDataSet.DatabaseTableMetaData modify method tableExists(DatabaseMetaData metaData, String schema, String tableName) 		

        // Bug fix specific when using MySQL SGBD
        // see http://forums.mysql.com/read.php?39,137564,137564#msg-137564
        String catalog = null;
        if (SQLHelper.isMySQLDb(metaData)) {
        	logger.warn("For MySQL the catalog name should not be null. It should be equal to the schema name. " +
            		"Otherwise the DatabaseMetaData#getTables() method might not return any columns when testing multiple schema database. " +
            		"See http://forums.mysql.com/read.php?39,137564,137564#msg-137564");
        	catalog = schema;
        }
        
    	ResultSet tableRs = metaData.getTables(catalog, schema, tableName, null);
    	// end bug fix	

Until know I found only theses 3 pieces of code where catalog parameter was required to make it work with MySQL database, but I'm not sure they are the only ones.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3358500&group_id=47439

[dbunit-developer] [ dbunit-Feature Requests-3325645 ] Patch: Support phpMyAdmin (v3.xx) XML export format.

[SourceForge.net <no...@so...>]

Feature Requests item #3325645, was opened at 2011-06-24 03:58
Message generated for change (Settings changed) made by laxkin
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3325645&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Pavel Larkin (laxkin)
Assigned to: Nobody/Anonymous (nobody)
>Summary: Patch: Support phpMyAdmin (v3.xx) XML export format. 

Initial Comment:
Support phpMyAdmin (v3.xx) XML export format. You can describe dataSet as:
<dataset>
	<TEST_TABLE>
		<COLUMN0>row 0 col 0</COLUMN0>
		<COLUMN1>row 0 col 1</COLUMN1>
		<COLUMN2>row 0 col 2</COLUMN2>
		<COLUMN3>row 0 col 3</COLUMN3>
	</TEST_TABLE>
</dataset>


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3325645&group_id=47439

[dbunit-developer] [ dbunit-Feature Requests-3325645 ] Support phpMyAdmin (v3.xx) XML export format.

[SourceForge.net <no...@so...>]

Feature Requests item #3325645, was opened at 2011-06-24 03:58
Message generated for change (Tracker Item Submitted) made by laxkin
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3325645&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Pavel Larkin (laxkin)
Assigned to: Nobody/Anonymous (nobody)
Summary: Support phpMyAdmin (v3.xx) XML export format. 

Initial Comment:
Support phpMyAdmin (v3.xx) XML export format. You can describe dataSet as:
<dataset>
	<TEST_TABLE>
		<COLUMN0>row 0 col 0</COLUMN0>
		<COLUMN1>row 0 col 1</COLUMN1>
		<COLUMN2>row 0 col 2</COLUMN2>
		<COLUMN3>row 0 col 3</COLUMN3>
	</TEST_TABLE>
</dataset>


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3325645&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3298237 ] DefaultDataTypeFactory does not support Types.Double

[SourceForge.net <no...@so...>]

Bugs item #3298237, was opened at 2011-05-06 11:30
Message generated for change (Comment added) made by sf-robot
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3298237&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: v2.4.*
>Status: Closed
Resolution: None
Priority: 5
Private: No
Submitted By: Michiel De Smet (mdesmet)
Assigned to: Jeff Jensen (jeffjensen)
Summary: DefaultDataTypeFactory does not support Types.Double

Initial Comment:
public DataType createDataType(int sqlType, String sqlTypeName, String tableName, String columnName) in org.dbunit.dataset.datatype.DefaultDataTypeFactory does not support Types.Double. This results in ToleratedDelta's not being evaluated (tested on MySQL with DOUBLE column type).

if (sqlType == Types.NUMERIC || sqlType == Types.DECIMAL)

Needs to be changed in:

if (sqlType == Types.NUMERIC || sqlType == Types.DECIMAL || sqlType == Types.DOUBLE)

----------------------------------------------------------------------

>Comment By: SourceForge Robot (sf-robot)
Date: 2011-05-20 12:20

Message:
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

----------------------------------------------------------------------

Comment By: Jeff Jensen (jeffjensen)
Date: 2011-05-06 11:41

Message:
Are you able to attach a test that fails without the change and passes with
the change?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3298237&group_id=47439

[dbunit-developer] [ dbunit-Feature Requests-3299855 ] Patch: Insert Binary data in VARCHAR and BYTE fields

[SourceForge.net <no...@so...>]

Feature Requests item #3299855, was opened at 2011-05-10 11:46
Message generated for change (Comment added) made by bluecarat
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3299855&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By:  blueCarat AG (bluecarat)
Assigned to: Nobody/Anonymous (nobody)
Summary: Patch: Insert Binary data in VARCHAR and BYTE fields

Initial Comment:
We have implemented some code to describe binary data for BYTE and VARCHAR. This is useful for siutations in which you want to store non readable characters in fields with these types.

One example would be binary coded decimal (BCD) fields in CHAR FOR BITDATA columns which is e.g. supported by DB2.

Currently it only supports values up to 64 Bits and uses a hardcoded prefix to distinguish a normal String from a String with a binary sequence.

A patch with the change and corresponding tests is appendet.

Cheers,
 Chris Stahlhut for the BLUECARAT developement team.

----------------------------------------------------------------------

>Comment By:  blueCarat AG (bluecarat)
Date: 2011-05-13 18:02

Message:
Update: Unfortunately there where some errors in the file headers and
unnecessary todos. This is now fixed. :)

Cheers,
Chris Stahlhut

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3299855&group_id=47439

[dbunit-developer] [ dbunit-Feature Requests-3299855 ] Patch: Insert Binary data in VARCHAR and BYTE fields

[SourceForge.net <no...@so...>]

Feature Requests item #3299855, was opened at 2011-05-10 11:46
Message generated for change (Tracker Item Submitted) made by bluecarat
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3299855&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By:  blueCarat AG (bluecarat)
Assigned to: Nobody/Anonymous (nobody)
Summary: Patch: Insert Binary data in VARCHAR and BYTE fields

Initial Comment:
We have implemented some code to describe binary data for BYTE and VARCHAR. This is useful for siutations in which you want to store non readable characters in fields with these types.

One example would be binary coded decimal (BCD) fields in CHAR FOR BITDATA columns which is e.g. supported by DB2.

Currently it only supports values up to 64 Bits and uses a hardcoded prefix to distinguish a normal String from a String with a binary sequence.

A patch with the change and corresponding tests is appendet.

Cheers,
 Chris Stahlhut for the BLUECARAT developement team.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3299855&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3299551 ] Provide a way to set data type factory with database tester

[SourceForge.net <no...@so...>]

Bugs item #3299551, was opened at 2011-05-09 17:17
Message generated for change (Tracker Item Submitted) made by pioterj
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3299551&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Feature Request
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Piotr (pioterj)
Assigned to: Roberto Lo Giacco (rlogiacco)
Summary: Provide a way to set data type factory with database tester

Initial Comment:
I'm getting the following error described in FAQ: The configured data type factory 'class org.dbunit.dataset.datatype.DefaultDataTypeFactory' might cause problems with the current database ..
I'd like to set the data type factory to MySQL but it seems that it cannot be currently done with IDatabaseTester interface. I ended up overriding JdbcDatabaseTester and its getConnection() method but it's an ugly workaround.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3299551&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3298237 ] DefaultDataTypeFactory does not support Types.Double

[SourceForge.net <no...@so...>]

Bugs item #3298237, was opened at 2011-05-06 06:30
Message generated for change (Comment added) made by jeffjensen
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3298237&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: v2.4.*
>Status: Pending
Resolution: None
Priority: 5
Private: No
Submitted By: Michiel De Smet (mdesmet)
>Assigned to: Jeff Jensen (jeffjensen)
Summary: DefaultDataTypeFactory does not support Types.Double

Initial Comment:
public DataType createDataType(int sqlType, String sqlTypeName, String tableName, String columnName) in org.dbunit.dataset.datatype.DefaultDataTypeFactory does not support Types.Double. This results in ToleratedDelta's not being evaluated (tested on MySQL with DOUBLE column type).

if (sqlType == Types.NUMERIC || sqlType == Types.DECIMAL)

Needs to be changed in:

if (sqlType == Types.NUMERIC || sqlType == Types.DECIMAL || sqlType == Types.DOUBLE)

----------------------------------------------------------------------

>Comment By: Jeff Jensen (jeffjensen)
Date: 2011-05-06 06:41

Message:
Are you able to attach a test that fails without the change and passes with
the change?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3298237&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3298237 ] DefaultDataTypeFactory does not support Types.Double

[SourceForge.net <no...@so...>]

Bugs item #3298237, was opened at 2011-05-06 13:30
Message generated for change (Tracker Item Submitted) made by mdesmet
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3298237&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: v2.4.*
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Michiel De Smet (mdesmet)
Assigned to: matthias g (gommma)
Summary: DefaultDataTypeFactory does not support Types.Double

Initial Comment:
public DataType createDataType(int sqlType, String sqlTypeName, String tableName, String columnName) in org.dbunit.dataset.datatype.DefaultDataTypeFactory does not support Types.Double. This results in ToleratedDelta's not being evaluated (tested on MySQL with DOUBLE column type).

if (sqlType == Types.NUMERIC || sqlType == Types.DECIMAL)

Needs to be changed in:

if (sqlType == Types.NUMERIC || sqlType == Types.DECIMAL || sqlType == Types.DOUBLE)

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3298237&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3291151 ] TablesDependencyHelper confuses "depends on" and "dependent"

[SourceForge.net <no...@so...>]

Bugs item #3291151, was opened at 2011-04-21 17:58
Message generated for change (Tracker Item Submitted) made by cmuboy
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3291151&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: v2.4.*
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Joseph (cmuboy)
Assigned to: matthias g (gommma)
Summary: TablesDependencyHelper confuses "depends on" and "dependent"

Initial Comment:
Behavior of TablesDependencyHelper.getDependsOnTables() and TablesDependencyHelper.getDependentTables() are reversed.

I have a table A that depends on tables X, Y, and Z. getDependsOnTables() returns all tables that depends on A, while getDependentTables() returns tables X, Y, and Z.

getDependsOnTables() should return tables X, Y, and Z.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3291151&group_id=47439

[dbunit-developer] Problem in deleting or updating rows with null value in where clause

[Cherry Y. <che...@gm...>]

Hello all,
I've been having problems with using DBUnit in deleting data which have null
value in one of the primary keys. Not sure if this problem has been
encountered before or if any proposed solution already exists...

Upon debugging, I found that in
/src/org/dbunit/operation/DeleteOperation.java file
getOperationData(ITableMetaData metaData, BitSet ignoreMapping,
IDatabaseConnection connection) , the sql is constructed with only handling
non-value in mind.

Can we enhance the SQL to the following form so it'll handle both null and
non-null? Of course, we'll need to make this change across all the classes
that generate a SQL with where clause. Granted, we'll need to do call the
statement.setValue twice in all the places because of this change...

delete * from tableName where (fieldName= ? or (fieldNameis null and ? is
null))

It's possible that this was discussed before but I missed in searching and I
only started using DBUnit recently...

Thank you for any insights you might have on this!

Best,
Coco

[dbunit-developer] [ dbunit-Feature Requests-3170998 ] Provides support for the uniqueidentifer column type...

[SourceForge.net <no...@so...>]

Feature Requests item #3170998, was opened at 2011-02-02 17:02
Message generated for change (Comment added) made by jeffjensen
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3170998&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
>Resolution: Accepted
Priority: 5
Private: No
Submitted By: Darryl Pierce (mcpierceaim)
Assigned to: Jeff Jensen (jeffjensen)
Summary: Provides support for the uniqueidentifer column type...

Initial Comment:
The attached patch provides support for the uniqueidentifier type in Microsoft SQLServer. The commit message is:

    Provides support for the uniqueidentifier column type in SQLServer.
    
    The column type is handled via the UniqueIdentierType provided by the
    patch. This type marshalls a UUID value into a uniqueidentifier column
    and back.
    
    Modified the MsSqlDataTypeFactory to correctly return this new type when
    it detects a UUID.
    
    Also included are unit tests to verify all new code.

----------------------------------------------------------------------

>Comment By: Jeff Jensen (jeffjensen)
Date: 2011-04-10 21:38

Message:
Committed revision 1217 (svn).

Thanks for the patch.


----------------------------------------------------------------------

Comment By: Darryl Pierce (mcpierceaim)
Date: 2011-03-23 09:34

Message:
I've attached an updated patch. Fixed the NPE error and moved
"uniqueidentifier" to a public constant on UniqueIdentifierType. Tests all
pass.

----------------------------------------------------------------------

Comment By: Jeff Jensen (jeffjensen)
Date: 2011-03-12 08:34

Message:
Thanks for redoing the patch with svn diff.

The simple issue with applying the patch is with UniqueIdentifierTypeTest:
tearDown() has statement.verify(), and statement is never initialized;
therefore a NPE.

That's a pretty simple thing (you would have definitely encountered it
running the test) which leads me to think something is incomplete/erroneous
with the patch.  So regretfully I need to ask you to fix and regen a patch.
 :-/

One minor improvement: "uniqueidentifier" is hardcoded in a few places and
I would appreciate if you extracted a "type name" public constant on the
new UniqueIdentifierType class for it.


----------------------------------------------------------------------

Comment By: Darryl Pierce (mcpierceaim)
Date: 2011-03-01 14:36

Message:
I've added a newer version of the patch generated using svn diff.

----------------------------------------------------------------------

Comment By: Jeff Jensen (jeffjensen)
Date: 2011-02-21 21:41

Message:
Darryl, I'm using Eclipse apply patch feature and the patch is not lining
up.  Perhaps you need to gen the patch without the git syntax option?  Do
you have other suggestion?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3170998&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3277635 ] Can not set PROPERTY_IDENTITY_COLUMN_FILTER

[SourceForge.net <no...@so...>]

Bugs item #3277635, was opened at 2011-04-06 16:32
Message generated for change (Comment added) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3277635&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: https://www.google.com/accounts ()
Assigned to: Nobody/Anonymous (nobody)
Summary: Can not set PROPERTY_IDENTITY_COLUMN_FILTER

Initial Comment:
DatabaseConfig default constructor does not set a default value so convertIfNeeded throws a IllegalArgumentException.

----------------------------------------------------------------------

>Comment By: https://www.google.com/accounts ()
Date: 2011-04-06 16:37

Message:
Missing from ALL_PROPERTIES that is

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3277635&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3277635 ] Can not set PROPERTY_IDENTITY_COLUMN_FILTER

[SourceForge.net <no...@so...>]

Bugs item #3277635, was opened at 2011-04-06 16:32
Message generated for change (Tracker Item Submitted) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3277635&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: https://www.google.com/accounts ()
Assigned to: Nobody/Anonymous (nobody)
Summary: Can not set PROPERTY_IDENTITY_COLUMN_FILTER

Initial Comment:
DatabaseConfig default constructor does not set a default value so convertIfNeeded throws a IllegalArgumentException.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3277635&group_id=47439

Re: [dbunit-developer] Another stall?

[Roberto Lo G. <rlo...@us...>]

Hi John,
it is good to read you again after so long time.

On Tue, Mar 29, 2011 at 11:25, John Hurst <joh...@gm...> wrote:
> Roberto,
> Sorry for the lack of reply on this. (I really need to get on to the new
> lists on Codehaus.)

Well, it is more than probable that we'll not use the codehaus mailing
lists so don't be in hurry to register ;-)

> I've been really busy, usual story. (My back is better, but I have a
> full-time client, a part-time client, a Java User Group and other projects
> on the go.)

I'm really glad your back is getting better, I hope you are heading
for a full recover, and I'm glad you are busy on business. Me and
Sebastien got both new jobs in the same company so we are busy as
well, but we are struggling to find the time for dbUnit anyway.

> I would like to help, but I don't have a clear picture of where we're going
> with it. For example, I haven't yet understood any point to non-tabular data
> formats. Or the annotations examples so far. My interests are:
>   - Clean up code base (consistent brace/indentation standard)

This is part of the `refactor` process

>   - Improve test structure

If you mean implement integration tests against real databases than
this is definitely part of the goal

>   - More modular?

We have thoughts about that and for sure we will drop the "no external
dependencies" directive as now build tools are smart enough to deal
with dependencies (ant + ivy or maven)

>   - Spring integration/support

Definitely part of the goal, but it is not clear to us right now what
are the implications, if you can give us more details on this we
surely appreciate

>   - More expressive ways of putting test data into tests (e.g. scripted
> value replacement)

Have you seen the proposed extensions to the xml data set format? May
be you want to give a look a this example
http://svn.codehaus.org/dbunit/trunk/core/src/test/resources/flat-xml/extended.xml
which has not been fully described but I think it is self explanatory
(if it is not, then it is my fault!).

>   - Better assertions?

The idea is to simplify the API while improving its expressiveness,
but we definitely need your help and ideas on this

I really hope this wiki page
(http://docs.codehaus.org/display/DBUNIT/WishList) and this archived
email (http://sourceforge.net/mailarchive/message.php?msg_id=27043119)
can give you a clearer picture of the current direction and get you
hungry to get involved ;-)

Regards,
   Roberto

Re: [dbunit-developer] Another stall?

[John H. <joh...@gm...>]

Roberto,

Sorry for the lack of reply on this. (I really need to get on to the new
lists on Codehaus.)

I've been really busy, usual story. (My back is better, but I have a
full-time client, a part-time client, a Java User Group and other projects
on the go.)

I would like to help, but I don't have a clear picture of where we're going
with it. For example, I haven't yet understood any point to non-tabular data
formats. Or the annotations examples so far. My interests are:

  - Clean up code base (consistent brace/indentation standard)
  - Improve test structure
  - More modular?
  - Spring integration/support
  - More expressive ways of putting test data into tests (e.g. scripted
value replacement)
  - Better assertions?

Regards

John Hurst

On Sat, Mar 19, 2011 at 12:18 PM, Roberto Lo Giacco <
rlo...@us...> wrote:

> Hi all,
> recently all the activity on dbUnit has stopped again. I don't really
> know what's the reason of this stall but I feel my responsibility to
> keep this project moving.
>
> There are many unresolved issues and non completed activities pending,
> like the POMs topic, the integration test platform, the new design,
> the codehaus platform and so on. I'm not going to start again those
> conversation, a quick search on the list archive (for the messages
> routed on sourceforge) can provide enough info to participate in the
> discussion.
>
> It is possible someone on the users list could have interest in
> participating too.
>
> The point is I want to inform you all that this is the moment to step
> up and participate if you want to get involved in our project and that
> in the next few days I'll try to get the project out of this stall on
> my own if none has the will to actively and concretely give us an
> hand.
>
> Some stuff has to be done and it will be.
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>



-- 
Life is interfering with my game

[dbunit-developer] [ dbunit-Feature Requests-3170998 ] Provides support for the uniqueidentifer column type...

[SourceForge.net <no...@so...>]

Feature Requests item #3170998, was opened at 2011-02-02 18:02
Message generated for change (Comment added) made by mcpierceaim
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3170998&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Darryl Pierce (mcpierceaim)
Assigned to: Jeff Jensen (jeffjensen)
Summary: Provides support for the uniqueidentifer column type...

Initial Comment:
The attached patch provides support for the uniqueidentifier type in Microsoft SQLServer. The commit message is:

    Provides support for the uniqueidentifier column type in SQLServer.
    
    The column type is handled via the UniqueIdentierType provided by the
    patch. This type marshalls a UUID value into a uniqueidentifier column
    and back.
    
    Modified the MsSqlDataTypeFactory to correctly return this new type when
    it detects a UUID.
    
    Also included are unit tests to verify all new code.

----------------------------------------------------------------------

>Comment By: Darryl Pierce (mcpierceaim)
Date: 2011-03-23 10:34

Message:
I've attached an updated patch. Fixed the NPE error and moved
"uniqueidentifier" to a public constant on UniqueIdentifierType. Tests all
pass.

----------------------------------------------------------------------

Comment By: Jeff Jensen (jeffjensen)
Date: 2011-03-12 09:34

Message:
Thanks for redoing the patch with svn diff.

The simple issue with applying the patch is with UniqueIdentifierTypeTest:
tearDown() has statement.verify(), and statement is never initialized;
therefore a NPE.

That's a pretty simple thing (you would have definitely encountered it
running the test) which leads me to think something is incomplete/erroneous
with the patch.  So regretfully I need to ask you to fix and regen a patch.
 :-/

One minor improvement: "uniqueidentifier" is hardcoded in a few places and
I would appreciate if you extracted a "type name" public constant on the
new UniqueIdentifierType class for it.


----------------------------------------------------------------------

Comment By: Darryl Pierce (mcpierceaim)
Date: 2011-03-01 15:36

Message:
I've added a newer version of the patch generated using svn diff.

----------------------------------------------------------------------

Comment By: Jeff Jensen (jeffjensen)
Date: 2011-02-21 22:41

Message:
Darryl, I'm using Eclipse apply patch feature and the patch is not lining
up.  Perhaps you need to gen the patch without the git syntax option?  Do
you have other suggestion?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3170998&group_id=47439

[dbunit-developer] [ dbunit-Feature Requests-3237043 ] DataFileLoader loads files from temp directory

[SourceForge.net <no...@so...>]

Feature Requests item #3237043, was opened at 2011-03-23 09:44
Message generated for change (Tracker Item Submitted) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3237043&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: Next Release
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: https://www.google.com/accounts ()
Assigned to: Nobody/Anonymous (nobody)
Summary: DataFileLoader loads files from temp directory

Initial Comment:
Current situation: The interface DataFileLoader.load(String fileName) loads only files from the classpath.

Problem: The DataFileLoader can not load from an external directory, e.g. TempDirectory on OS.

Scenario: I exported a xml dataSet with dbUnit from an existing database. This file has a size of 10 MB. We don't want to have files with such a size in our git repository, since this would reduce the performance of git. My integration test unzip the dataSet from an archive and passes the extracted file to the DataFileLoader.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449494&aid=3237043&group_id=47439

[dbunit-developer] [ dbunit-Bugs-1984596 ] Inserting of clobs fails

[SourceForge.net <no...@so...>]

Bugs item #1984596, was opened at 2008-06-04 15:16
Message generated for change (Comment added) made by 
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=1984596&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: v2.2.2
Status: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Bustuila (bustuila)
Assigned to: matthias g (gommma)
Summary: Inserting of clobs fails

Initial Comment:
Since version 2.2.2, the insert operation fails with clobs and Oracle:

java.lang.ClassCastException: java.lang.String cannot be cast to oracle.sql.CLOB
        at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:9229)
        at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:8843)
        at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:9316)
        at org.dbunit.dataset.datatype.ClobDataType.setSqlValue(ClobDataType.java:67)
        at org.dbunit.database.statement.SimplePreparedStatement.addValue(SimplePreparedStatement.java:73)
        at org.dbunit.database.statement.AutomaticPreparedBatchStatement.addValue(AutomaticPreparedBatchStatement.java:63)
        at org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:201)
        at org.dbunit.ant.Operation.execute(Operation.java:212)

The change that triggers this problem seems to come from this:

ClobDataType.getSqlValue(int column, ResultSet resultSet) contains
statement.setObject(column, typeCast(value), getSqlType());

where getSqlType() returns Types.CLOB -> 2005

In version 2.2.1, where it works, it was:
statement.setObject(column, typeCast(value),           DataType.LONGVARCHAR.getSqlType());

where DataType.LONGVARCHAR.getSqlType() -> -1
the same as Types.LONGVARCHAR

Oracle driver: 10.2.0.2.0 and 10.2.0.4.0
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

----------------------------------------------------------------------

Comment By: https://www.google.com/accounts ()
Date: 2011-03-22 13:50

Message:
Same problems here with dbunit 2.4.8 :(

Thx

----------------------------------------------------------------------

Comment By: https://www.google.com/accounts ()
Date: 2010-11-05 17:18

Message:
I'm getting this same error using DbUnit 2.4.8

----------------------------------------------------------------------

Comment By: John MacEnri (johnmacenri)
Date: 2010-05-12 10:59

Message:
Hi, 
I also was hitting the same problem with v2.4.7 and latest Oracle JDBC
driver. I took the easy way out and built 2.4.7 myself with the one line
change shown in this bug, in the
org.dbunit.dataset.datatype.ClobDataType.setSqlValue(...) method.
Works fine now for Oracle CLOBs, but not sure it would work across other
databases. 

In the comments there is a mention of the fix being applied to the v3
branch, but that does not seem to have appeared.

John


----------------------------------------------------------------------

Comment By: Paul P (paulp3210)
Date: 2010-03-11 15:59

Message:
I am using the latest version of DBUnit (2.4.7), on Oracle 11GR2. I'm using
Java 6 (1.6.0_15) and the latest version of Oracle's client jar (jdbc6.jar)

I've been unable to successfully load any data referenced by a CLOB Oracle
field from an XML file into the database.

I've used all sorts of versions of the Oracle JDBC library / Hibernate
library etc...I think the problem lies in DBUnit. 
I've tried: both FlatXmlDataSet and XmlDataset, 
I've tried both OracleDataTypeFactory , Oracle10DataTypeFactory and
Oracle11DataTypeFactory found here:
https://sourceforge.net/tracker/index.php?func=detail&aid=2010567&group_id=47439&atid=449494

I'm fairly convinced that its a DBunit problem as reverting all the way
down to DBunit 2.2.1 seems to fix the problem. Please let me know if you
want any additional info.

The exception being reported is: * Caused by:
java.lang.ClassCastException: java.lang.String cannot be cast to
oracle.sql.CLOB


----------------------------------------------------------------------

Comment By: shai o (go19)
Date: 2008-08-06 13:52

Message:
Logged In: YES 
user_id=2169370
Originator: NO

i tried the latest build from today
the clob problem still  occures

----------------------------------------------------------------------

Comment By: matthias g (gommma)
Date: 2008-08-05 19:13

Message:
Logged In: YES 
user_id=1803108
Originator: NO

Hi there,

I committed the change on rev. 773/trunk for the upcoming 2.3.0 release.
The change affects
OracleNClobDataType/OracleClobDataType/OracleBlobDataType which now load
the classes via the JDBC connection's classloader.

Thanks again and regards,
mat

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-24 08:09

Message:
Logged In: YES 
user_id=711602
Originator: YES

Hello,
sorry for the long pause.
It works with this change :-)

I also had to modify org.dbunit.ant.Operation, to fix a NPE, in
toString():

replace result.append(", src=" + _src == null ? null :
_src.getAbsolutePath());
with result.append(", src=" + _src == null ? "null" :
_src.getAbsolutePath());

Thank you

----------------------------------------------------------------------

Comment By: matthias g (gommma)
Date: 2008-06-08 17:58

Message:
Logged In: YES 
user_id=1803108
Originator: NO

Hi Bustuila,

Thanks a lot for the hints. I think chances are good that your second
exception is a classloader issue since the dbunit ant task uses the
AntClassLoader to load the db driver class.

If you have a couple of minutes you could test this as follows:
- Get dbunit trunk sources from repository
- Replace one line in the file
org.dbunit.ext.oracle.OracleClobDataType#getClob():
      <<<OLD line: Class aClobClass = Class.forName("oracle.sql.CLOB");
      >>>NEW line: Class aClobClass =
connection.getClass().getClassLoader().loadClass("oracle.sql.CLOB");
- Invoke "mvn install" in the dbunit trunk directory

Then try using the newly created 2.3.0-SNAPSHOT version of dbunit.

I think you are right in terms of checking and updating the oracle support
in dbunit. It would be nice to start a discussion on how to do that
(perhaps dbunit could introduce a new Oracle10DataTypeFactory that uses the
newer JDBC API with java.sql.CLOB)

Hope this helps.
Regards,
mat

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-08 12:03

Message:
Logged In: YES 
user_id=711602
Originator: YES

I'm glad the test project was useful, especially since I forgot to put the
schema.sql in it...
I don't run dbunit with the maven plugin in my work project, we're still
using ant.
I just used maven for this example, which indeed works after using the
oracle datatype factory... 
I think the problem with the "oracle.jdbc.driver.T4CConnection cannot be
cast to oracle.jdbc.OracleConnection" comes from the ant classloader,
because I see before that another error:

  [taskdef] log4j:ERROR A "org.apache.log4j.xml.DOMConfigurator" object is
not assignable to a "org.apache.log4j.spi.Configurator" variable.
  [taskdef] log4j:ERROR The class "org.apache.log4j.spi.Configurator" was
loaded by 
  [taskdef] log4j:ERROR [AntClassLoader[...]].
  [taskdef] log4j:ERROR Could not instantiate configurator
[org.apache.log4j.xml.DOMConfigurator].

Another thing... it seems that these newer Oracle drivers are using the
standard way of working with lobs:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14249/adlob_api_overview.htm

"You can make changes to an entire persistent LOB, or to pieces of the
beginning, middle, or end of a persistent LOB in Java by means of the JDBC
API using the classes:

oracle.sql.BLOB

oracle.sql.CLOB

These classes implement java.sql.Blob and java.sql.Clob interfaces
according to the JDBC 3.0 specification, which has methods for LOB
modification. They also include legacy Oracle proprietary methods for LOB
modification. These legacy methods are marked as deprecated and may be
removed in a future release.

If you use JDK 1.4 or higher, then you can use variables typed
java.sql.Blob and java.sql.Clob.

The JDBC 3.0 methods are included in classes12.jar, so that they can be
used in JDK 1.2 or 1.3, but since they are not part of the java.sql.Blob
and java.sql.Clob interfaces in those JDK versions, you must use variables
typed or cast to oracle.sql.BLOB or oracle.sql.CLOB."


When using the application with the spring framework and hibernate, it has
no problem in inserting and updating lobs with
org.springframework.jdbc.support.lob.DefaultLobHandler, so I guess this is
another hint that the new drivers are much improved and they can be used
with the standard jdbc interfaces.
I've tried using org.springframework.jdbc.support.lob.OracleLobHandler,
but it needs another dependency(NativeJdbcExtractor), so, I was very hapy
the default handler worked.

So, I guess something could be improved in dbunit in detecting in some way
that the standard interfaces can be used... spring framework seems to use
java.sql.PreparedStatement.setClob(int i, Clob x) and maybe dbunit could do
it too...

And then, I will try to see what I workaround I can find to make ant not
screw up things..

Thanks for your help.

----------------------------------------------------------------------

Comment By: Sébastien Le Callonnec (slecallonnec)
Date: 2008-06-07 20:15

Message:
Logged In: YES 
user_id=1232035
Originator: NO

Hi Bustuila, 


Thanks a mil for that project, that really helps!  If only all the bug
reports were coming with these packages test cases, life would be so much
easier!

Also, apologies, I hadn't realised you were using dbunit through the maven
plugin.  As mat mentioned below, adding:

<dataTypeFactoryName>org.dbunit.ext.oracle.OracleDataTypeFactory</dataTypeFactoryName>

solves the problem for me too.  Is that the case for you too, or is it
what caused your second problem?:

java.lang.ClassCastException: oracle.jdbc.driver.T4CConnection cannot be
cast to oracle.jdbc.OracleConnection

I haven't been able to reproduce that second issue, though (on            
                                                                           
                                     Oracle Database 10g Express Edition
Release 10.2.0.1.0 - Product).  Did you get this my tweaking your maven
config?

Regards,
Sébastien.

----------------------------------------------------------------------

Comment By: matthias g (gommma)
Date: 2008-06-07 17:44

Message:
Logged In: YES 
user_id=1803108
Originator: NO

Hi all,

I tried to reproduce the problem using your testcase and I got the same
exception as you mentioned initially. I added the dataTypeFactory to the
pom.xml and the test was green afterwards.

...
  <configuration>
    <driver>${driver}</driver>
    <url>${url}</url>
    <username>${username}</username>
    <password>${password}</password>
    <skip>${maven.test.skip}</skip>
   
<dataTypeFactoryName>org.dbunit.ext.oracle.OracleDataTypeFactory</dataTypeFactoryName>
  </configuration>
...

Note that if you want to set it in the java code you can do it as
follows:

...
DatabaseConnection dbConnection = new DatabaseConnection(jdbcConnection);
dbConnection.getConfig().setProperty(DatabaseConfig.PROPERTY_DATATYPE_FACTORY,
new OracleDataTypeFactory());
...

I also found that you might get into this problem when you work inside a
Container (Tomcat or J2EE) while having the ojdbc.jar in your deployment
artifact AND in the server lib dir. The cause are the ClassLoader
strategies used by the container. See
http://forums.oracle.com/forums/thread.jspa?threadID=554480&tstart=0 for
further information.
If this would be true (just speculating a bit) the cause could be that
dbunit's OracleClobDataType uses "Class.forName("oracle.sql.CLOB")" instead
of "connection.getClass().getClassLoader().loadClass("oracle.sql.CLOB")"

Regards,
mat

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-06 12:53

Message:
Logged In: YES 
user_id=711602
Originator: YES

Maybe you can get pointers from here:
http://springframework.cvs.sourceforge.net/springframework/spring/src/org/springframework/jdbc/support/lob/OracleLobHandler.java?revision=1.25&view=markup

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-06 10:28

Message:
Logged In: YES 
user_id=711602
Originator: YES

Btw, you would have to use the instructions at
http://maven.apache.org/guides/development/guide-plugin-snapshot-repositories.html
to be able to use the required plugin

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-06 07:34

Message:
Logged In: YES 
user_id=711602
Originator: YES

I've attached a project that demonstrates the problem.
File Added: 1984596.zip

----------------------------------------------------------------------

Comment By: Sébastien Le Callonnec (slecallonnec)
Date: 2008-06-05 17:10

Message:
Logged In: YES 
user_id=1232035
Originator: NO

If you could still provide us with a test case reproducing the issue, that
would help us investigate the problem, as I haven't been able to reproduce
the issue so far.

Thanks,
Sébastien.

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-05 15:33

Message:
Logged In: YES 
user_id=711602
Originator: YES

No problem... If I find the time, I'll try to fix it using your sugestions
and provide a patch.

----------------------------------------------------------------------

Comment By: Roberto Lo Giacco (rlogiacco)
Date: 2008-06-05 15:30

Message:
Logged In: YES 
user_id=57511
Originator: NO

I suggest rollback your dbunit version until we find out a solution or,
in
case you need some of the patches applied after the 2.2.1 release, you
can
rollback the commit relative to the #1806363 issue.

Sorry for the inconvenience, we already know we should set up a multi
rdbms integration test platform, but time and money are needed for such
activities and we actually have none of them :\

----------------------------------------------------------------------

Comment By: Sébastien Le Callonnec (slecallonnec)
Date: 2008-06-05 12:30

Message:
Logged In: YES 
user_id=1232035
Originator: NO

This fix was introduced because LONGVARCHAR was causing issues with other
RSBMSes. Cf.
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=1806363&group_id=47439

Given that we have an Oracle-specific data type, I think that fix is
legitimate since the target is everything but Oracle.  Now as Roberto
indicated, the problem seems to be caused because the OracleDataTypeFactory
should probably support T4CConnection along with OracleConnection.

Regards,
Sébastien.

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-05 12:21

Message:
Logged In: YES 
user_id=711602
Originator: YES

It seems it's because of the fix for 1806363

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-05 11:30

Message:
Logged In: YES 
user_id=711602
Originator: YES

The thing I don't understand is why was the change that broke 2.2 was
required...
It worked perfectly fine.
I've searched Hibernate sources for oracle.sql.CLOB and they don't seem to
used it, so maybe it's not required at all.

----------------------------------------------------------------------

Comment By: Roberto Lo Giacco (rlogiacco)
Date: 2008-06-05 11:07

Message:
Logged In: YES 
user_id=57511
Originator: NO

Oviously the problem is OracleDataTypeFactory is not aware of the pure
JDBC oracle driver and recognizes only the previous classes12.jar driver

I suggest to introduce a new factory or patch the actual one to work with
both (the latter seems a little bit harder to me)

----------------------------------------------------------------------

Comment By: Bustuila (bustuila)
Date: 2008-06-05 08:03

Message:
Logged In: YES 
user_id=711602
Originator: YES

I've tried using OracleDataTypeFactory(with driver class
oracle.jdbc.OracleDriver and oracle.jdbc.driver.OracleDriver), but it
doesn't work:

java.lang.ClassCastException: oracle.jdbc.driver.T4CConnection cannot be
cast to oracle.jdbc.OracleConnection
	at oracle.sql.CLOB.createTemporary(CLOB.java:754)
	at oracle.sql.CLOB.createTemporary(CLOB.java:716)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at
org.dbunit.ext.oracle.OracleClobDataType.getClob(OracleClobDataType.java:70)
	at
org.dbunit.ext.oracle.OracleClobDataType.setSqlValue(OracleClobDataType.java:56)
	at
org.dbunit.database.statement.SimplePreparedStatement.addValue(SimplePreparedStatement.java:62)
	at
org.dbunit.database.statement.AutomaticPreparedBatchStatement.addValue(AutomaticPreparedBatchStatement.java:52)
	at
org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:177)
	at org.dbunit.ant.Operation.execute(Operation.java:183)

I'll try and create a simple test case.

----------------------------------------------------------------------

Comment By: Sébastien Le Callonnec (slecallonnec)
Date: 2008-06-04 16:48

Message:
Logged In: YES 
user_id=1232035
Originator: NO

Hi there, 


Would you have a simple test case reproducing the issue?  If you use an
OracleConnection, OracleClobDataType should be used instead of the "normal"
ClobDataType.

Regards,
Sébastien

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=1984596&group_id=47439

Re: [dbunit-developer] Another stall?

[Roberto Lo G. <rlo...@gm...>]

Hi Matias,
first of all to contribute to dbUnit you do not need to have write
acces to the source repository, all you need to do is to provide a
diff set (http://en.wikipedia.org/wiki/Diff) containing your changes
and unit tests to prove your changes work and do not break anything.

When we speak of tests we mean that you need to write unit tests to
rpove your code works as expected and you need to run the entre dbunit
test suite to prove your code didn't break anything.

About the circular dependencies we are well aware of that problem and
we are looking forward for a solution, but because dbunit is intended
to be used on multiple databases we need a database agnostic
solution....

On Sat, Mar 19, 2011 at 03:27, Matias Fernandez
<rec...@gm...> wrote:
> Hi.
> Some days ago I send a mail telling about bug I was found and I fix, but
> I am un-experimented in the develop of software open-sorce (is the first
> time). In the page said I must have a user to do a commit.
> In response of this someone tell me i have to run test to prove the fix,
> but I need a some to help me, meybe with some time i gone ask to do this.
> Another cuestion is the problem of circular depende of tables, I have a
> DB with this carateristics and i want to solve this in some form.
> If you know some guide of how to start in the development of
> oper-source, please let me know.
>
> Sorry for my english, is realiy bad.:-P
>
>
>
> On 18/03/11 20:18, Roberto Lo Giacco wrote:
>> Hi all,
>> recently all the activity on dbUnit has stopped again. I don't really
>> know what's the reason of this stall but I feel my responsibility to
>> keep this project moving.
>>
>> There are many unresolved issues and non completed activities pending,
>> like the POMs topic, the integration test platform, the new design,
>> the codehaus platform and so on. I'm not going to start again those
>> conversation, a quick search on the list archive (for the messages
>> routed on sourceforge) can provide enough info to participate in the
>> discussion.
>>
>> It is possible someone on the users list could have interest in
>> participating too.
>>
>> The point is I want to inform you all that this is the moment to step
>> up and participate if you want to get involved in our project and that
>> in the next few days I'll try to get the project out of this stall on
>> my own if none has the will to actively and concretely give us an
>> hand.
>>
>> Some stuff has to be done and it will be.
>>
>> ------------------------------------------------------------------------------
>> Colocation vs. Managed Hosting
>> A question and answer guide to determining the best fit
>> for your organization - today and in the future.
>> http://p.sf.net/sfu/internap-sfd2d
>> _______________________________________________
>> dbunit-developer mailing list
>> dbu...@li...
>> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer
>

Re: [dbunit-developer] Another stall?

[Matias F. <rec...@gm...>]

Hi.
Some days ago I send a mail telling about bug I was found and I fix, but 
I am un-experimented in the develop of software open-sorce (is the first 
time). In the page said I must have a user to do a commit.
In response of this someone tell me i have to run test to prove the fix, 
but I need a some to help me, meybe with some time i gone ask to do this.
Another cuestion is the problem of circular depende of tables, I have a 
DB with this carateristics and i want to solve this in some form.
If you know some guide of how to start in the development of 
oper-source, please let me know.

Sorry for my english, is realiy bad.:-P



On 18/03/11 20:18, Roberto Lo Giacco wrote:
> Hi all,
> recently all the activity on dbUnit has stopped again. I don't really
> know what's the reason of this stall but I feel my responsibility to
> keep this project moving.
>
> There are many unresolved issues and non completed activities pending,
> like the POMs topic, the integration test platform, the new design,
> the codehaus platform and so on. I'm not going to start again those
> conversation, a quick search on the list archive (for the messages
> routed on sourceforge) can provide enough info to participate in the
> discussion.
>
> It is possible someone on the users list could have interest in
> participating too.
>
> The point is I want to inform you all that this is the moment to step
> up and participate if you want to get involved in our project and that
> in the next few days I'll try to get the project out of this stall on
> my own if none has the will to actively and concretely give us an
> hand.
>
> Some stuff has to be done and it will be.
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> dbunit-developer mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-developer

[dbunit-developer] Another stall?

[Roberto Lo G. <rlo...@us...>]

Hi all,
recently all the activity on dbUnit has stopped again. I don't really
know what's the reason of this stall but I feel my responsibility to
keep this project moving.

There are many unresolved issues and non completed activities pending,
like the POMs topic, the integration test platform, the new design,
the codehaus platform and so on. I'm not going to start again those
conversation, a quick search on the list archive (for the messages
routed on sourceforge) can provide enough info to participate in the
discussion.

It is possible someone on the users list could have interest in
participating too.

The point is I want to inform you all that this is the moment to step
up and participate if you want to get involved in our project and that
in the next few days I'll try to get the project out of this stall on
my own if none has the will to actively and concretely give us an
hand.

Some stuff has to be done and it will be.

[dbunit-developer] [ dbunit-Bugs-3204703 ] DBUnit doesn't support circular references

[SourceForge.net <no...@so...>]

Bugs item #3204703, was opened at 2011-03-09 23:26
Message generated for change (Comment added) made by rlogiacco
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3204703&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: reuben (reubenfirmin)
Assigned to: matthias g (gommma)
Summary: DBUnit doesn't support circular references

Initial Comment:
If two tables in a database around bound together with circular foreign key references, DBUnit is unable to perform a CLEAN_INSERT - i.e. it is unable to delete from table A when data in table B relies on it, and is unable to delete from table B because data in table A relies on it in turn.

The database design is admittedly questionable; nevertheless, DBUnit should be able to cope with this situation. If you google for "dbunit circular references", you'll find that others have enountered this issue; they've either done truncate with cascade, or turned referential integrity checks off temporarily while DBUnit does the operation.

----------------------------------------------------------------------

>Comment By: Roberto Lo Giacco (rlogiacco)
Date: 2011-03-11 11:19

Message:
We know we have that issue and we are trying to address that on dbUnit 3,
but do you have any idea how to resolve it in a database agnostic way?



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3204703&group_id=47439

[dbunit-developer] [ dbunit-Bugs-3204703 ] DBUnit doesn't support circular references

[SourceForge.net <no...@so...>]

Bugs item #3204703, was opened at 2011-03-09 22:26
Message generated for change (Tracker Item Submitted) made by reubenfirmin
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3204703&group_id=47439

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Bug
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: reuben (reubenfirmin)
Assigned to: matthias g (gommma)
Summary: DBUnit doesn't support circular references

Initial Comment:
If two tables in a database around bound together with circular foreign key references, DBUnit is unable to perform a CLEAN_INSERT - i.e. it is unable to delete from table A when data in table B relies on it, and is unable to delete from table B because data in table A relies on it in turn.

The database design is admittedly questionable; nevertheless, DBUnit should be able to cope with this situation. If you google for "dbunit circular references", you'll find that others have enountered this issue; they've either done truncate with cascade, or turned referential integrity checks off temporarily while DBUnit does the operation.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3204703&group_id=47439