[dbunit-developer] [ dbunit-Bugs-3046689 ] does not support multiple schemas in HSQLDB

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

Bugs item #3046689, was opened at 2010-08-16 18:58
Message generated for change (Comment added) made by chikkubhai
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=449491&aid=3046689&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: 7
Private: No
Submitted By: wecansolveit.org (chikkubhai)
Assigned to: matthias g (gommma)
Summary: does not support multiple schemas in HSQLDB

Initial Comment:
If HsqlDB had multiple schemas as 
Catalogs
  !- PUBLIC
     !- Schemas
        !- SCHEMA1
        !- SCHEMA2
        ... 

QueryDataSet partialDataSet = new QueryDataSet(getDatabaseConnection(SCHEMA_NAME));
partialDataSet.addTable(TABLE_NAME, (" SELECT * FROM SCHEMA1.TABLE1");
FlatXmlDataSet.write(partialDataSet, new FileOutputStream(TABLE1.xml")

exports as

<?xml version='1.0' encoding='UTF-8'?>
<dataset>
  <TABLE1 COL1="1" ...>
</dataset>

Where is the schema information here??? No wonder, the following fails:

IDatabaseConnection connection = getDatabaseConnection("SCHEMA1");
DatabaseOperation.CLEAN_INSERT.execute(connection, IDataSet dataSet);

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

>Comment By: wecansolveit.org (chikkubhai)
Date: 2010-09-21 14:44

Message:
Is there no solution to this yet? What is the workaround for using hsqldb?

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

Comment By: wecansolveit.org (chikkubhai)
Date: 2010-08-16 18:59

Message:
saying the table does not exist, had to include patch works in classes like
operation.AbstractOperation.getOperationMetaData(IDatabaseConnection,
ITableMetaData) and so on.. to check 

ITableMetaData tableMetaData= null;
        if(((IDataTypeFactory)(connection.getConfig().getProperty(
        		DatabaseConfig.PROPERTY_DATATYPE_FACTORY))) instanceof
HsqldbDataTypeFactory
        		&& connection.getSchema() != null) {
(databaseConfig.getProperty(DatabaseConfig.FEATURE_QUALIFIED_TABLE_NAMES))).booleanValue())
{
        	tableMetaData =
databaseDataSet.getTableMetaData(connection.getSchema().concat("." +
tableName));
        }
        else{
        	tableMetaData = databaseDataSet.getTableMetaData(tableName);
        

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

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