Analytics Software

Hi All,
I am trying to get data from excel sheet through an open source driver *"XlSQL-Y8"* in ODI 10g .I dont want to use SUN jdbc-odbc driver .But I am getting the following error.

*[error]*

See com.borland.dx.dataset.DataSetException error code: BASE+66

com.borland.dx.dataset.DataSetException: Table not found: EmpDetails1 in statement [select * from "EmpDetails"."EmpDetails1"]

at com.borland.dx.dataset.DataSetException.a(Unknown Source)

at com.borland.dx.dataset.DataSetException.throwException(Unknown Source)

at com.borland.dx.dataset.DataSetException.SQLException(Unknown Source)

at com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknown Source)

at com.borland.dx.sql.dataset.o.a(Unknown Source)

at com.borland.dx.sql.dataset.o.d(Unknown Source)

at com.borland.dx.sql.dataset.o.f(Unknown Source)

at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)

at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)

at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)

at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)

at com.sunopsis.graphical.frame.b.ja.dj(ja.java)

at com.sunopsis.graphical.frame.b.ja.<init>(ja.java)

at com.sunopsis.graphical.frame.b.jc.<init>(jc.java)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.sunopsis.graphical.frame.bb.b(bb.java)

at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java)

at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)

at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java)

at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)

at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)

at java.lang.Thread.run(Unknown Source)

Chained exception:

java.sql.SQLException: Table not found: EmpDetails1 in statement [select * from "EmpDetails"."EmpDetails1"]

at org.hsqldb.jdbc.jdbcUtil.throwError(jdbcUtil.java:62)

at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(jdbcPreparedStatement.java:1804)

at org.hsqldb.jdbc.jdbcConnection.prepareStatement(jdbcConnection.java:547)

at com.nilostep.xlsql.jdbc.xlConnection.prepareStatement(xlConnection.java:396)

at com.borland.dx.sql.dataset.Database.createPreparedStatement(Unknown Source)

at com.borland.dx.sql.dataset.o.a(Unknown Source)

at com.borland.dx.sql.dataset.o.d(Unknown Source)

at com.borland.dx.sql.dataset.o.f(Unknown Source)

at com.borland.dx.sql.dataset.QueryProvider.e(Unknown Source)

at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)

at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)

at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)

at com.sunopsis.graphical.frame.b.ja.dj(ja.java)

at com.sunopsis.graphical.frame.b.ja.<init>(ja.java)

at com.sunopsis.graphical.frame.b.jc.<init>(jc.java)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.sunopsis.graphical.frame.bb.b(bb.java)

at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java)

at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)

at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java)

at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)

at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)

at java.lang.Thread.run(Unknown Source)


*[\error]*
can anyone help me out.Thanks in advance.
Regards,
Gnanaprakasam.

Edited by: user13028132 on Oct 19, 2010 3:46 AM