Re: Please Help with Use of Octopus

"Peng Li" <[email protected]>
Newsgroups gmane.comp.java.enhydra.general
Message-ID <[email protected]> 
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 ----- 
From: Peng Li 
To: [email protected] 
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
21TO23.xml (text/xml, 4.7 KB) 
<loaderJob logMode="full" objectIDIncrement="1" commitCount="1">
   <jdbcDefaultParameters>
      <jdbcSourceParameters dbVendor="mssql">
         <jdbcSourceParameter name="JdbcDriver" value="com.internetcds.jdbc.tds.Driver"/>
         <jdbcSourceParameter name="Connection.Url" value="jdbc:freetds.sqlserver://localhost:1433/PWCCUDatabase"/>
         <jdbcSourceParameter name="User" value="sa"/>
         <jdbcSourceParameter name="Password" value=""/>
      </jdbcSourceParameters>
      <jdbcTargetParameters dbVendor="mssql">
         <jdbcTargetParameter name="JdbcDriver" value="com.internetcds.jdbc.tds.Driver"/>
         <jdbcTargetParameter name="Connection.Url" value="jdbc:freetds:sqlserver://localhost:1433/PWCCUDatabase_2_3"/>
         <jdbcTargetParameter name="User" value="sa"/>
         <jdbcTargetParameter name="Password" value=""/>
      </jdbcTargetParameters>
   </jdbcDefaultParameters>
   <sql name="CreateTables" onErrorContinue="fasle" commit="true" logMode="full">
      <sqlStmt>
         <include href="d:\projects\discovery2.2\DatabaseScripts\NewDatabase\PWCCUDatabase23.sql" parse="text"/>
      </sqlStmt>
   </sql>
   <importDefinition name="ActiveMovie" tableName="ActiveMovie" logMode="full">
      <jdbcParameters>
         <jdbcSourceParameters dbVendor="mssql">
            <jdbcSourceParameter name="jdbcDriver" value="com.internetcds.jdbc.tds.Driver"/>
            <jdbcSourceParameter name="Connection.Url" value="jdbc:freetds:sqlserver://localhost:1433/PWCCUDatabase"/>
            <jdbcSourceParameter name="User" value="sa"/>
            <jdbcSourceParameter name="Password" value=""/>
         </jdbcSourceParameters>
         <jdbcTargetParameters dbVendor="mssql">
            <jdbcTargetParameter name="jdbcDriver" value="com.internetcds.jdbc.tds.Driver"/>
            <jdbcTargetParameter name="Connection.Url" value="jdbc:freetds:sqlserver://localhost:1433/PWCCUDatabase_2_3"/>
            <jdbcTargetParameter name="User" value="sa"/>
            <jdbcTargetParameter name="Password" value=""/>
         </jdbcTargetParameters>
      </jdbcParameters>
      <valueColumns>
         <valueColumn sourceColumnName="MovieID" targetTableName="ActiveMovie" targetColumnName="MovieID" targetTableID="0" valueMode="Key"/>
         <valueColumn sourceColumnName="PhChannelID" targetTableName="ActiveMovie" targetColumnName="phChannelID" targetTableID="0" valueMode="Overwrite"/>
         <valueColumn sourceColumnName="SubChannelID" targetTableName="ActiveMovie" targetColumnName="SubChannelID" targetTableID="0" valueMode="Overwrite"/>
      </valueColumns>
      <variableColumns>
         <timeStampColumn targetTableName="ActiveMovie" targetColumnName="Start" targetTableID="0" valueMode="Key"/>
         <timeStampColumn targetTableName="ActiveMovie" targetColumnName="Finish" targetTableID="0" valueMode="Overwrite"/>
         <timeStampColumn targetTableName="ActiveMovie" targetColumnName="TimeStamp" targetTableID="0" valueMode="Overwrite"/>
      </variableColumns>
      <constantColumns>
         <constantColumn targetTableName="ActiveMovie" targetColumnName="SSL" targetTableID="0" valueMode="Overwrite" constantValue="0"/>
      </constantColumns>
      <tables>
         <table tableName="ActiveMovie" tableID="0" insert="true" tableMode="Query" oidLogic="false"/>
      </tables>
   </importDefinition>
   <importDefinition name="CategoryTable" tableName="CategoryTable" logMode="full">
      <jdbcParameters>
         <jdbcSourceParameters dbVendor="mssql">
            <jdbcSourceParameter name="jdbcDriver" value="com.internetcds.jdbc.tds.Driver"/>
            <jdbcSourceParameter name="Connection.Url" value="jdbc:freetds:sqlserver://localhost:1433/PWCCUDatabase"/>
            <jdbcSourceParameter name="User" value="sa"/>
            <jdbcSourceParameter name="Password" value=""/>
         </jdbcSourceParameters>
         <jdbcTargetParameters dbVendor="mssql">
            <jdbcTargetParameter name="jdbcDriver" value="com.internetcds.jdbc.tds.Driver"/>
            <jdbcTargetParameter name="Connection.Url" value="jdbc:freetds:sqlserver://localhost:1433/PWCCUDatabase_2_3"/>
            <jdbcTargetParameter name="User" value="sa"/>
            <jdbcTargetParameter name="Password" value=""/>
         </jdbcTargetParameters>
      </jdbcParameters>
      <valueColumns>
         <valueColumn sourceColumnName="CategoryID" targetTableName="CategoryTable" targetColumnName="CategoryID" targetTableID="1" valueMode="Overwrite"/>
         <valueColumn sourceColumnName="Category" targetTableName="CategoryTable" targetColumnName="Category" targetTableID="1" valueMode="Overwrite"/>
      </valueColumns>
      <tables>
         <table tableName="CategoryTable" tableID="1" insert="true" tableMode="Cache" oidLogic="false"/>
      </tables>
   </importDefinition>
</loaderJob>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.