DataDeploy : ERROR: Loading drivers

Hi,

OD Version 7.3.1.0.0 Build 3 Interwoven 20111005
MSSQL SERVER 2005

I am getting the following error message during the DataDeploy:

DBD: Loading com.microsoft.jdbc.sqlserver.SQLServerDriver
DBD: ERRORBD07001: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

Drivers that I am using are : sqljdbc4.jar, sqljdbc.jar & Una2000.jar
I have copied the drivers into the following directories and restarted OD.
OD-HOME/drivers/
OD-HOME/lib/
OD-HOME/userlib/

I have given "microsoft-microsoft" as Vendor on the database.xml file for the connection.

But the DD is working if I change the vendor to "microsoft-inetuna", but still again, I am having issue with BIT DataType.

Please help to resolve the issue to work for MS SQL.

Thank you.

Find more posts tagged with

Comments

Adam Stoller

After you copied the library files into place - did you stop and start OD?

jstephan

After you copied the library files into place - did you stop and start OD?

I didn't stop & start. I ran restart command. Does that make difference?

Adam Stoller

I didn't stop & start. I ran restart command. Does that make difference?

Try stopping and starting - that will tell you if it makes any difference ... Empirical evidence is king.

jstephan

Stopping and starting didn't fix the issue.
Removed the unwanted jdbc driver and that fixed the issue.

Migrateduser

Hi Stephen,

We are also having this problem.
When you say you removed the unwanted files do you mean the jars? In which case which jar and which entry did you have left? e.g sqljdbc.jar and microsoft-microsoft?
We want to deploy to both MySQL and SQLServer and I'm starting to worry that this is impossible

Thanks Nick

Rick Poulin

In this case, I suspect the problem was in having both sqljdbc.jar (v3) and sqljdbc4.jar in the same classpath. There should be no issues configuring DD to work with your two database vendors simultaneously. If you have specific issues, I suggest you create a new thread and clearly describe your environment, along with any error messages and/or unexpected behaviour.