OctopusGenerator sdb Excel: no tables

[jiliang.zhang]

Hi All,

I'm a newbie of Octopus.
Now I want import excel file to oracle.

first,
call ..\bin\OctopusGenerator.cmd -m copy -o GeneratorOutput -sdb "Driver={Microsoft Excel Driver (*.xls)};DBQ=excelfile.xls;READONLY=true" -su "" -sp "" -st Excel -sdn jdbc-odbc -tdb 1.1.1.1:1521:ora -tt Oracle -tdn oracle -du ORA -tp ora -gdoml true -pack com.octopus -sqlCT true -sqlDT true -fm true -xml

....
createIncludeFiles method is started.
org...LoaderException: Exception in method generate() in LoaderGenerator class!
A exception displaied
java.lang.Exception: There is no tables in specified source database(Driver={Microsoft Excel Driver (*.xls)};DBQ=excelfile.xls;READONLY=true). Check input parameters.

Any error in my "-sdb"?

Thank you and best regards



--
You receive this message as a subscriber of the octopus@... mailing list.
To unsubscribe: mailto:octopus-unsubscribe@...
For general help: mailto:sympa@...?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws

[jiliang.zhang]

 Hi all,

I have downloaded source code from cvs, and trace to the createIncludeFiles
method of CreateIncludeFiles class.
line 194,
String[] accessType = { "TABLE" };
String accessDbName = generatorParameters.getSourceDataBase();
ResultSet rs = conn.getMetaData().getTables(accessDbName, null, "%",
accessType);

I write a small program to test Connection.GetMetaData().getTables(),
the row number of rs is zero.

With Connection.GetMetaData().getTableType(),
if I connect to a excel file with default sheet name 'Sheet1$', the table
type is 'SYSTEM TABLE';
then i connect to a excel file with renamed sheet name 'abc$', the table
type is 'TABLE'.

I googled, then change parameters of getTables to getTables(null, null,
null, null),
the table name is returned from the getTables().

Any suggestion is welcome.
 
Thank you and best regards
 
-----邮件原件-----
发件人: jiliang.zhang@... [mailto:jiliang.zhang@...]
发送时间: 2008年1月24日 18:12
收件人: octopus@...
主题: [octopus] OctopusGenerator sdb Excel: no tables

Hi All,

I'm a newbie of Octopus.
Now I want import excel file to oracle.

first,
call ..\bin\OctopusGenerator.cmd -m copy -o GeneratorOutput -sdb
"Driver={Microsoft Excel Driver (*.xls)};DBQ=excelfile.xls;READONLY=true"
-su "" -sp "" -st Excel -sdn jdbc-odbc -tdb 1.1.1.1:1521:ora -tt Oracle -tdn
oracle -du ORA -tp ora -gdoml true -pack com.octopus -sqlCT true -sqlDT true
-fm true -xml

....
createIncludeFiles method is started.
org...LoaderException: Exception in method generate() in LoaderGenerator
class!
A exception displaied
java.lang.Exception: There is no tables in specified source
database(Driver={Microsoft Excel Driver
(*.xls)};DBQ=excelfile.xls;READONLY=true). Check input parameters.

Any error in my "-sdb"?

Thank you and best regards




--
You receive this message as a subscriber of the octopus@... mailing list.
To unsubscribe: mailto:octopus-unsubscribe@...
For general help: mailto:sympa@...?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws