Fw: Please Help with Use of Octopus

"Peng Li" <[email protected]> Thu, 7 Aug 2003 15:58:49 -0700

Newsgroups	gmane.comp.java.enhydra.general
Message-ID	<[email protected]>

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/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/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="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/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/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="true"/>
      </tables>
   </importDefinition>
   <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/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/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="true"/>
      </tables>
   </importDefinition>
</loaderJob>