org.dbunit.database.AmbiguousTableNameException (I have set schema name and also tried qualifiedTableNames and enabling skipOracleRecylceBins

View: New views
2 Messages — Rating Filter:   Alert me  

org.dbunit.database.AmbiguousTableNameException (I have set schema name and also tried qualifiedTableNames and enabling skipOracleRecylceBins

by steven.hicks :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

org.dbunit.database.AmbiguousTableNameException (I have set schema name and also tried qualifiedTableNames and enabling skipOracleRecylceBins

I am using Oracle 10g and DbUnit 2.2 (using ojdbc14.jar)

This works fine on my PC but fails on our UNIX CI machine with:

org.dbunit.database.AmbiguousTableNameException: CAPLAC_CI.BIN$TM0mP9HfSMXgRAAUT0yp+Q==$0

I have tried both adding a schema to the iDatabaseConnection and also qualifiedTableNames but still get this error!

In addition I enabled skipOracleRecylceBins (which from the error seems to be what the problem is) but to no avail


I use Spring to get the datasource, then put this in the iDatabaseConnection

        iDatabaseConnection = new DatabaseDataSourceConnection( getDataSource(),schema);

        String id = "http://www.dbunit.org/features/qualifiedTableNames";

        DatabaseConfig config = iDatabaseConnection.getConfig();

        config.setFeature(id, true);

        String binId = "http://www.dbunit.org/features/skipOracleRecycleBinTables";

        config.setFeature(binId, true);

Error thrown in actualTable statement:

    IDataSet databaseDataSet = getConnection().createDataSet();

    ITable actualTable = databaseDataSet.getTable(getSchema() + ".ZONE");



Steve Hicks


office: +44-(0)117 3024378

mobile: +44-(0)7720 425253

email: steven.hicks@...

British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 1800000

This electronic message contains information from British Telecommunications plc which may be privileged and confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or e-mail (to the number or address above) immediately


-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user

Re: org.dbunit.database.AmbiguousTableNameException (Ihave set schema name and also tried qualifiedTableNames andenabling skipOracleRecylceBins

by Ostermueller, Erik-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

org.dbunit.database.AmbiguousTableNameException (I have set schema name and also tried qualifiedTableNames and enabling skipOracleRecylceBins
 
 
 
According to the above link, upgrading to the latest dbUnit should fix this.
 
--Erik Ostermueller
 

From: dbunit-user-bounces@... [mailto:dbunit-user-bounces@...] On Behalf Of steven.hicks@...
Sent: Friday, May 09, 2008 10:07 AM
To: dbunit-user@...
Subject: [dbunit-user] org.dbunit.database.AmbiguousTableNameException (Ihave set schema name and also tried qualifiedTableNames andenabling skipOracleRecylceBins

I am using Oracle 10g and DbUnit 2.2 (using ojdbc14.jar)

This works fine on my PC but fails on our UNIX CI machine with:

org.dbunit.database.AmbiguousTableNameException: CAPLAC_CI.BIN$TM0mP9HfSMXgRAAUT0yp+Q==$0

I have tried both adding a schema to the iDatabaseConnection and also qualifiedTableNames but still get this error!

In addition I enabled skipOracleRecylceBins (which from the error seems to be what the problem is) but to no avail


I use Spring to get the datasource, then put this in the iDatabaseConnection

        iDatabaseConnection = new DatabaseDataSourceConnection( getDataSource(),schema);

        String id = "http://www.dbunit.org/features/qualifiedTableNames";

        DatabaseConfig config = iDatabaseConnection.getConfig();

        config.setFeature(id, true);

        String binId = "http://www.dbunit.org/features/skipOracleRecycleBinTables";

        config.setFeature(binId, true);

Error thrown in actualTable statement:

    IDataSet databaseDataSet = getConnection().createDataSet();

    ITable actualTable = databaseDataSet.getTable(getSchema() + ".ZONE");



Steve Hicks


office: +44-(0)117 3024378

mobile: +44-(0)7720 425253

email: steven.hicks@...

British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 1800000

This electronic message contains information from British Telecommunications plc which may be privileged and confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or e-mail (to the number or address above) immediately

______________

The information contained in this message is proprietary and/or confidential. If you are not the
intended recipient, please: (i) delete the message and all copies; (ii) do not disclose,
distribute or use the message in any manner; and (iii) notify the sender immediately. In addition,
please be aware that any message addressed to our domain is subject to archiving and review by
persons other than the intended recipient. Thank you.
_____________

-------------------------------------------------------------------------
This SF.net email is sponsored by the 2008 JavaOne(SM) Conference
Don't miss this year's exciting event. There's still time to save $100.
Use priority code J8TL2D2.
http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone
_______________________________________________
dbunit-user mailing list
dbunit-user@...
https://lists.sourceforge.net/lists/listinfo/dbunit-user