DbUnit: Problem in getting data from excel sheet

[Vinayak patil]

Hi,

I want to create a dataset using an xls file.

Since excel does not allow a "." in the sheet name, I use [schema_tableName] as the sheet name.

DbUnit cribs that the table name does not exist.

I tried to get data into xls and that worked .

I did the following:

 
IDatabaseConnection conn = getConnection();
QueryDataSet dataSet = new QueryDataSet(conn);
dataSet.addTable([schema.table],"Select * from table ");
XlsDataSet.write(dataSet,new FileOutputStream("myTestXls.xls"));

It is creating the table with the sheet name as [schema_table].

But it throws an exception when trying to do a CLEAN_INSERT using this xls file.

If anybody has done this, pls let me know.

Thanks,
Vinayak

[Mohandoss Ilangovan]

Hi Vinayak,

I hope you found the answer for the question you asked :-), is it so then leave this one. Otherwise try this one. I hope this one will help you.

IDatabaseConnection conn = getConnection();
QueryDataSet dataSet = new QueryDataSet(conn);
String schema = //your schema name;
String tableName = //your table name;
dataSet.addTable(tableName,"Select * "+schema+"."+tableName+" from table ");
XlsDataSet.write(dataSet,new FileOutputStream("myTestXls.xls"));

This one worked for me, that is while performing CLEAN_INSERT, DatabaseOperation it will try to clear the table using the <b>schema</b> name. That is why I think your code is throwing exception.

Try this, and If it works let me know.

Thanks and Regards
Mohandoss Ilangovan.


//Hi,
//I want to create a dataset using an xls file.

//Thanks,
//Vinayak

[Mohandoss Ilangovan]

and one more think to say, while getting your connection using dbconnection, pass your schema name also with the connection.