Menu
▾
▴
RE: [dbunit-user] org.dbunit.dataset.DataSetException: java.sql.SQLException: ORA-00942: table or view does not exist
|
From: Manuel L. <mla...@us...> - 2003-04-18 15:29:59
|
Try to specify the schema name like this:
<target name="extractDatabase" depends="init">
<dbunit driver="${DRIVER}"
url="${URL}"
schema="${SCHEMA}"
userid="${USER}"
password="${PASSWD}">
<export dest="${DEST_FILE}" format="xml"/>
</dbunit>
</target>
I also recommend you to use the flat XML format, which is less verbose than
the original XML format.
Manuel
> -----Original Message-----
> From: dbu...@li...
> [mailto:dbu...@li...]On Behalf Of Kashyap
> Parikh
> Sent: Friday, April 18, 2003 10:52 AM
> To: dbu...@li...
> Subject: [dbunit-user] org.dbunit.dataset.DataSetException:
> java.sql.SQLException: ORA-00942: table or view does not exist
>
>
> Hi,
>
> I am getting following exception when I try to extract the
> database to an xml file using dbunit target. Any help is appreciated.
>
> Here is my target:
>
> <target name="extractDatabase" depends="init">
> <dbunit driver="${DRIVER}"
> url="${URL}"
> userid="${USER}"
> password="${PASSWD}">
> <export dest="${DEST_FILE}" format="xml"/>
> </dbunit>
> </target>
>
>
> And this is the stack I get when I run above target
> .
> BUILD FAILED
>
> C:\projects\tools\build.xml:334:
> org.dbunit.dataset.DataSetException: java.sql.SQLException:
> ORA-00942: table or view does not exist
>
> at org.dbunit.ant.DbUnitTask.execute(DbUnitTask.java:319)
> at org.apache.tools.ant.Task.perform(Task.java:217)
> at org.apache.tools.ant.Target.execute(Target.java:184)
> at org.apache.tools.ant.Target.performTasks(Target.java:202)
> at org.apache.tools.ant.Project.executeTarget(Project.java:601)
> at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
> at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
> at org.apache.tools.ant.Task.perform(Task.java:217)
> at org.apache.tools.ant.Target.execute(Target.java:184)
> at org.apache.tools.ant.Target.performTasks(Target.java:202)
> at org.apache.tools.ant.Project.executeTarget(Project.java:601)
> at org.apache.tools.ant.Project.executeTargets(Project.java:560)
> at org.apache.tools.ant.Main.runBuild(Main.java:454)
> at org.apache.tools.ant.Main.start(Main.java:153)
> at org.apache.tools.ant.Main.main(Main.java:176)
> --- Nested Exception ---
> org.dbunit.dataset.DataSetException: java.sql.SQLException:
> ORA-00942: table or view does not exist
>
> at
> org.dbunit.database.DatabaseDataSet.getTable(DatabaseDataSet.java:227)
> at
> org.dbunit.database.DatabaseDataSet.getTables(DatabaseDataSet.java:237)
> at
> org.dbunit.dataset.xml.XmlDataSet.buildDocument(XmlDataSet.java:149)
> at org.dbunit.dataset.xml.XmlDataSet.write(XmlDataSet.java:126)
> at org.dbunit.ant.Export.execute(Export.java:160)
> at org.dbunit.ant.DbUnitTask.execute(DbUnitTask.java:314)
> at org.apache.tools.ant.Task.perform(Task.java:217)
> at org.apache.tools.ant.Target.execute(Target.java:184)
> at org.apache.tools.ant.Target.performTasks(Target.java:202)
> at org.apache.tools.ant.Project.executeTarget(Project.java:601)
> at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
> at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
> at org.apache.tools.ant.Task.perform(Task.java:217)
> at org.apache.tools.ant.Target.execute(Target.java:184)
> at org.apache.tools.ant.Target.performTasks(Target.java:202)
> at org.apache.tools.ant.Project.executeTarget(Project.java:601)
> at org.apache.tools.ant.Project.executeTargets(Project.java:560)
> at org.apache.tools.ant.Main.runBuild(Main.java:454)
> at org.apache.tools.ant.Main.start(Main.java:153)
> at org.apache.tools.ant.Main.main(Main.java:176)
> java.sql.SQLException: ORA-00942: table or view does not exist
>
> at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1892)
> at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.
> java:2488)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStat
> ement.java:2832)
> at
> oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:621)
> at
> org.dbunit.database.DatabaseDataSet.getTable(DatabaseDataSet.java:210)
> at
> org.dbunit.database.DatabaseDataSet.getTables(DatabaseDataSet.java:237)
> at
> org.dbunit.dataset.xml.XmlDataSet.buildDocument(XmlDataSet.java:149)
> at org.dbunit.dataset.xml.XmlDataSet.write(XmlDataSet.java:126)
> at org.dbunit.ant.Export.execute(Export.java:160)
> at org.dbunit.ant.DbUnitTask.execute(DbUnitTask.java:314)
> at org.apache.tools.ant.Task.perform(Task.java:217)
> at org.apache.tools.ant.Target.execute(Target.java:184)
> at org.apache.tools.ant.Target.performTasks(Target.java:202)
> at org.apache.tools.ant.Project.executeTarget(Project.java:601)
> at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:266)
> at
> org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:120)
> at org.apache.tools.ant.Task.perform(Task.java:217)
> at org.apache.tools.ant.Target.execute(Target.java:184)
> at org.apache.tools.ant.Target.performTasks(Target.java:202)
> at org.apache.tools.ant.Project.executeTarget(Project.java:601)
> at org.apache.tools.ant.Project.executeTargets(Project.java:560)
> at org.apache.tools.ant.Main.runBuild(Main.java:454)
> at org.apache.tools.ant.Main.start(Main.java:153)
> at org.apache.tools.ant.Main.main(Main.java:176)
>
> Total time: 56 seconds
>
>
> Thanks,
> Kashyap
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> dbunit-user mailing list
> dbu...@li...
> https://lists.sourceforge.net/lists/listinfo/dbunit-user
>
|