|
Hi All,
The problem described in the below EMail was
resolved. It turned out that the URL for making database connection was
wrong, although it complained driver.
I am having another problem though. I am just
trying to migrate data from one database to another(resides on the same SQL
server on the local machine). Here are the error messages I am
getting.
I am attaching the input xml
file.
========================================================================
Import definition ActiveMovie is started at Aug 7,
2003 5:46:13 PM.
constantColumnTypes method is started.
Query
'select SSL from ActiveMovie' will be executed
constantColumnTypes method is finished.
querySource method is started.
querySource method is finished.
Query
'select MovieID, PhChannelID, SubChannelID from ActiveMovie' will
be
executed
sourceColumnTypes method is started.
Query
'select MovieID,phChannelID,SubChannelID from ActiveMovie' will b
e
executed
sourceColumnTypes method is finished.
checkOidLogic method is started.
checkOidLogic method is finished.
Import block is started.
Working... 1. block of 1
-- More --
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: Problem with source table: 1.
row
at
org.webdocwf.util.loader.Loader.cache(Unknown
Source)
... 3
more
java.lang.Throwable
at
org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown
Sour
ce)
at
java.lang.Throwable.printStackTrace(Unknown
Source)
at
org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown
Sour
ce)
at
org.webdocwf.util.loader.Loader.main(Unknown
Source)
java.lang.Throwable
at
org.webdocwf.util.loader.LoaderException.printStackTrace(Unknown
Sour
ce)
at
org.webdocwf.util.loader.Loader.main(Unknown
Source)
Started from the 1.
row.
cache
method is started.
Query
'select MovieID, PhChannelID, SubChannelID from ActiveMovie' will
be
executed
java.sql.SQLException: Problem with source table:
1. row
loadSource method is finished.
org.webdocwf.util.loader.LoaderException:
SQLException:
=============================================
----- Original Message -----
Sent: Thursday, August 07, 2003 3:58 PM
Subject: Fw: Please Help with Use of Octopus
HI,
The input XML file is
attached. Very sorry for the multiple messages. I had something
wrong while attaching the attachment. Hopefully it's right this
time.
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
| 
