Please Help with Use of Octopus
| Newsgroups | gmane.comp.java.enhydra.general |
|---|---|
| Message-ID | <[email protected]> |
HI,
The input XML file is attached.
I am trying to use it as a data migration tool. Both source database and
destination database reside on the same MS SQL server, on the same machine.
I specified:
dbVendor: mssql
jdbcDriver: com.internetcds.jdbc.tds.Driver
in the input XML file. All configurations are taken default values (therefore
no configuration fiel)
After start running the application by saying:
java org.webdocwf.util.loader.Loader <input XML file>
Destination database is accessed OK by creating two tables. I am having
trouble accessing source database. Error messages are listed below. I
specified the same jdbc driver for both source database and destination
database.
========================
Import definition CategoryTable is started at Aug 7, 2003 11:03:01 AM.
java.sql.SQLException: No suitable driver
loadSource method is finished.
org.webdocwf.util.loader.LoaderException: SQLException:
org.webdocwf.util.loader.LoaderException: ClassNotFoundException:
at org.webdocwf.util.loader.Loader.load(Unknown Source)
at org.webdocwf.util.loader.Loader.main(Unknown Source)
Caused by: org.webdocwf.util.loader.LoaderException: SQLException:
at org.webdocwf.util.loader.Loader.loadSource(Unknown Source)
... 2 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
... 3 more
java.lang.Throwable
at org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown
Source)
at java.lang.Throwable.printStackTrace(Unknown Source)
at org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown
Source)
at org.webdocwf.util.loader.Loader.main(Unknown Source)
java.lang.Throwable
at org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown
Source)
at org.webdocwf.util.loader.Loader.main(Unknown Source)
====================================================
Any help is appreciated.
peng li