Hello all,
I'm attempting to learn DataDeploy with the OD 6.1.1 install we have, and I'm getting a ClassNotFoundException.
Here are the outputted logs.
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Begin logfile [F:\Interwoven\OpenDeploy\OpenDeployNG\log\src.ddconfig.deployment1.hamilton.to.database.log] ---------
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Job ID=m119 Deployment=ddconfig
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 DataDeploy Version is 6.1.1.0.0
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Owner started the deployment is BCBST\m68009p
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 DD args iwdd="deployment1" cfg=F:\Interwoven\OpenDeploy\OpenDeployNG\conf\ddconfig.xml need-result=yes depuuid=fab55d00-44ed-11dc-914f-f2ee91abe079 leglabel=database
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Proceed to execute the database deployment
DBD: Deployment : deployment1
DBD: Database Vendor set to microsoft-microsoft
DBD: Max Identifier length set to 128 characters.
DBD: SQL datatype for column deptId is VARCHAR(250)
DBD: SQL datatype for column name is VARCHAR(250)
DBD: # of columns: 2
DBD: # of primary key columns specified: 1
DBD: WARNING:Assuming group name as the table name for [deptRecords].
DBD: SQL datatype for column name is VARCHAR(250)
DBD: SQL datatype for column id is VARCHAR(250)
DBD: SQL datatype for column deptId is VARCHAR(250)
DBD: # of columns: 3
DBD: # of primary key columns specified: 2
DBD: # of foreign key columns specified: 1
DBD: WARNING:Assuming group name as the table name for [employee].
DBD: # of groups defined in element: 2
DBD: [Tue Aug 07 09:56:21 EDT 2007] Begin executing deployment1
DBD: Begin Set up the publisher thread
DBD: End Set up the publisher thread
DBD: Area VPath:F:\Interwoven\OpenDeploy\OpenDeployNG\examples\conf-dd\tutorial\data
DBD: Setting up TDbSchemaAgent.
DBD: Loading com.microsoft.jdbc.sqlserver.SQLServerDriver
DBD: ERROR
BD07001:JDBC jar/zip not found in the drivers directory
DBD: ERROR:ERROR: Loading drivers : com.microsoft.jdbc.sqlserver.SQLServerDriver
DBD: ERROR:ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
DBD: ERROR:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at com.interwoven.deploy.cdmain.IWCDClassLoader.loadClass(IWCDClassLoader.java:577)
at com.interwoven.deploy.cdmain.IWCDClassLoader.loadClass(IWCDClassLoader.java:448)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at com.interwoven.dd100.dd.JdbcCheckup.registerDriverWithDriverManager(JdbcCheckup.java:165)
at com.interwoven.dd100.dd.JdbcCheckup.LoadThirdPartyJDBCDriver(JdbcCheckup.java:126)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:555)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:549)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:271)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:547)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: ERROR:Unable to connect to ...;...
DBD: ERROR:TDbAgent constructor failed.
DBD: Error occured in TDbSchemaAgent
DBD: Stat for group [deptRecords]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Stat for group [employee]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Rollback database [...;...]...
DBD: Deployment[deployment1]
DBD: ERROR:TDbSchemaAgent create failure.
DBD: Started : Tue Aug 07 09:56:21 EDT 2007
DBD: Shutting down DDD PublisherThread
DBD: Finished: Tue Aug 07 09:56:21 EDT 2007
DBD:
### IWDataDeploy FAILED ###
DBD:
### Sending result ###
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Database deployment execution returned 1
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 <<< Completed database deployment Invocation>>>
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Manifest path is F:/Interwoven/OpenDeploy/OpenDeployNG/log/src.ddconfig.deployment1.hamilton.to.database.log.mf
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Got Manifest object com.interwoven.od.adapter.delivery.base.IWODManifest@6abc19
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 fHasFailedItems is set to true
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Published leg event depUuid=[fab55d00-44ed-11dc-914f-f2ee91abe079] legLabel=[database] nextUuid=[null] nextDep=[null]
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 Job ID=m119 Deployment leg=database Elapsed Time=16 ms <<<
ENG: 2007-08-07 09:56:21 EDT GMT-04:00 End logfile [F:\Interwoven\OpenDeploy\OpenDeployNG\log\src.ddconfig.deployment1.hamilton.to.database.log]
Here is the deployment I'm trying to execute.
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<data-deploy-configuration>
<client>
<deployment name="deployment1">
<source>
<xml-source options="wide" area="F:\Interwoven\OpenDeploy\OpenDeployNG\examples\conf-dd\tutorial\data" area-type="os-filesystem" xml-type="custom">
<path name="." visit-directory="deep"/>
</xml-source>
</source>
<destinations>
<database
db = "...;database=..."
user = "..."
password = "..."
vendor = "microsoft-microsoft"
max-id-length = "128"
update-type="standalone" state-field="state"
delete-tracker="yes" enforce-ri="no">
<dbschema>
<group name="deptRecords" root-group="yes">
<attrmap>
<column name="deptId" data-type="VARCHAR(250)" value-from-element="deptRecords/0/dept/0/deptId/0" allows-null="no" is-url="no"/>
<column name="name" data-type="VARCHAR(250)" value-from-attribute="deptRecords/0/dept/0/description/0/name" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="deptId"/>
</primary-key>
</keys>
</group>
<group name="employee" root-group="no">
<attrmap>
<column name="name" data-type="VARCHAR(250)" value-from-attribute="deptRecords/0/employees/0/employee/[0-5]/name" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="id" data-type="VARCHAR(250)" value-from-attribute="deptRecords/0/employees/0/employee/[0-5]/id" is-replicant="yes" allows-null="no" is-url="no"/>
<column name="deptId" data-type="VARCHAR(250)" value-from-element="deptRecords/0/dept/0/deptId/0" allows-null="no" is-url="no"/>
</attrmap>
<keys>
<primary-key>
<key-column name="name"/>
<key-column name="deptId"/>
</primary-key>
<foreign-key parent-group="deptRecords">
<column-pair parent-column="deptId" child-column="deptId"/>
</foreign-key>
</keys>
</group>
</dbschema>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>
I've placed the following JAR files into the
drivers and lib directory:
- msbase.jar
- mssqlserver.jar
- msutil.jar
The OD 6.1.1 install is running on a Win2k3 Professional Server. I found a registry key that attaches a class path variable to the command line at startup, but I'm hoping there is a better solution than editing registry keys.
Any help would be appreciated. And if I need to RTFM, please direct me to a manual with a page number. I've searched what I have, and its not giving me much help.
NOTE: I've had to comment out the database server and its database for security reasons.
