Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Hi,

I am getting below error, I have downloaded and sqljdbc4-2.0.jar but still getting same error

I am using JRE 7

Error:

******Setting-up a session to CMS Server********************

******Successfully created session to CMS Server********************

******Creating connection to CMS Server********************

- Create new connection

  - Save connection locally into "C:\Users\10602773\AppData\Local\Temp\SPL_Warehouse_Connection.cnx"

  - Publish connection into "/Connections/SPL_Warehouse_Connection.cnx" and retrieve a shortcut

- Create new data foundation

  - Add tables PURCHASE, PRODUCT, CUSTOMER_CALL, CUSTOMER, SO_HEADER

Exception in thread "main" com.sap.tools.commons.exception.NestedException: com.microsoft.sqlserver.jdbc.SQLServerDriver

  at com.sap.sl.sdk.authoring.datafoundation.internal.services.DataFoundationFactoryImpl.createDatabaseTable(DataFoundationFactoryImpl.java:175)

  at com.sap.sl.sdk.authoring.samples.util.CreateUniverseTest1.createMonoSourceUniverse(CreateUniverseTest1.java:180)

  at com.sap.sl.sdk.authoring.samples.util.CreateUniverseTest1.main(CreateUniverseTest1.java:137)

Caused by: com.sap.connectivity.cs.java.drivers.CSDriverError: com.microsoft.sqlserver.jdbc.SQLServerDriver

  at com.sap.connectivity.cs.java.drivers.DDKExceptionImpl.convertToCSException(DDKExceptionImpl.java:156)

  at com.sap.connectivity.cs.java.JAVAGenericJob.<init>(JAVAGenericJob.java:75)

  at com.sap.connectivity.cs.java.JAVADictionary.<init>(JAVADictionary.java:28)

  at com.sap.connectivity.cs.java.JAVAOpenDictionary.<init>(JAVAOpenDictionary.java:41)

  at com.sap.connectivity.cs.java.JAVARDBMSDictionary.<init>(JAVARDBMSDictionary.java:40)

  at com.sap.connectivity.cs.java.RDBMSDictionary.<init>(RDBMSDictionary.java:52)

  at com.sap.connectivity.cs.java.ConnectionServer.getDictionary(ConnectionServer.java:422)

  at com.sap.connectivity.cs.core.ConnectionServer.CreateDictionary(ConnectionServer.java:234)

  at com.sap.connectivity.cs.api.trace.EnvironmentLogger.CreateDictionary(EnvironmentLogger.java:1721)

  at com.sap.connectivity.cs.extended.ConnectionServer.CreateDictionary(ConnectionServer.java:1025)

  at com.sap.connectivity.cs.api.trace.EnvironmentLogger.CreateDictionary(EnvironmentLogger.java:1721)

  at com.businessobjects.mds.services.relational.CsService.createSafeDictionary(CsService.java:652)

  at com.businessobjects.mds.services.relational.CsService.createDictionary(CsService.java:607)

  at com.businessobjects.mds.services.relational.SolverCsProvider.getDictionary(SolverCsProvider.java:90)

  at com.businessobjects.mds.services.relational.CsService.getConnectionInfo(CsService.java:893)

  at com.sap.sl.sdk.authoring.datafoundation.internal.services.DataFoundationFactoryImpl.createDatabaseTable(DataFoundationFactoryImpl.java:165)

  ... 2 more

Caused by: com.sap.connectivity.cs.java.drivers.DDKExceptionImpl: com.microsoft.sqlserver.jdbc.SQLServerDriver

  at com.sap.connectivity.cs.java.CSError.getInstance(CSError.java:49)

  at com.sap.connectivity.cs.java.ErrorManager.getError(ErrorManager.java:130)

  at com.sap.connectivity.cs.java.drivers.jdbc.JDBCDriver.getJDBCDriver(JDBCDriver.java:1019)

  at com.sap.connectivity.cs.java.drivers.jdbc.JDBCDriver.createJavaJDBCConnection(JDBCDriver.java:1223)

  at com.sap.connectivity.cs.java.drivers.jdbc.mssql.MSSQLDriver.createJavaJDBCConnection(MSSQLDriver.java:239)

  at com.sap.connectivity.cs.java.drivers.jdbc.JDBCDriver.createCSJDBCConnection(JDBCDriver.java:1200)

  at com.sap.connectivity.cs.java.drivers.jdbc.JDBCDriver.createConnection(JDBCDriver.java:1161)

  at com.sap.connectivity.cs.java.drivers.jdbc.JDBCDriver.connect(JDBCDriver.java:1385)

  at com.sap.connectivity.cs.java.JAVAGenericJob.<init>(JAVAGenericJob.java:71)

  ... 16 more

Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

  at java.net.URLClassLoader$1.run(Unknown Source)

  at java.net.URLClassLoader$1.run(Unknown Source)

  at java.security.AccessController.doPrivileged(Native Method)

  at java.net.URLClassLoader.findClass(Unknown Source)

  at java.lang.ClassLoader.loadClass(Unknown Source)

  at java.lang.ClassLoader.loadClass(Unknown Source)

  at java.lang.Class.forName0(Native Method)

  at java.lang.Class.forName(Unknown Source)

  at com.sap.connectivity.cs.java.drivers.jdbc.wrapper.JDBCWrapper.initialize(JDBCWrapper.java:45)

  at com.sap.connectivity.cs.java.drivers.jdbc.JDBCDriver.getJDBCDriver(JDBCDriver.java:1014)

  ... 22 more

Former Member
Not what you were looking for? View more on this topic or Ask a question