Apex Code Development You need to sign in to do that
Don't have an account?
gv007 Class path is not find SQL Server Dataloder commandline
Hi have issue with connecting SQL server 2000 in commandline dataloder
I added sqljdbc4.jar,sqljdbc.jar file in process.bat file and in the path even tho it says class not found exception
Also here is my bean property
<property name="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<property name="url" value="jdbc:sqlserver:\\localhost;databaseName=DB;user = uname;password=pwd"/>
Still it is not loading.I am wondering which jar file support sqlserver 2000
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver c
lass 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
DataSource.java:1429)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:1371)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:1044)
at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:80)
... 5 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLSer
verDriver
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 sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
DataSource.java:1420)
... 8 more
I added sqljdbc4.jar,sqljdbc.jar file in process.bat file and in the path even tho it says class not found exception
Also here is my bean property
<property name="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<property name="url" value="jdbc:sqlserver:\\localhost;databaseName=DB;user = uname;password=pwd"/>
Still it is not loading.I am wondering which jar file support sqlserver 2000
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver c
lass 'com.microsoft.jdbc.sqlserver.SQLServerDriver'
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
DataSource.java:1429)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:1371)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:1044)
at com.salesforce.dataloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:80)
... 5 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLSer
verDriver
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 sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic
DataSource.java:1420)
... 8 more
Please see if these links help:
https://developer.salesforce.com/forums?id=906F00000008p7TIAQ
https://help.salesforce.com/apex/HTViewHelpDoc?id=loader_dbaccess.htm&language=en_US
Thanks,
Shashank
sqljdbc4.jar,sqljdbc.jar drivers wont work for SQL Server 2000.
Add msbase.jar,mssqlserver.jar,msutil.jar file in process.bat files or your path
<property name="driverClassName" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
You need to use above class path.
Thats is the fun still u need to deal with not updated DBs,
thanks