Apex Code Development You need to sign in to do that
Don't have an account?
Nilove How to Load data from SFDC into SQL Server using command line?
hi,
I am trying to Load data from Salesforce into SQL Server 2005 using command line. Here are my settings for SQL Server in database-conf file
----------------------------------
<property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
<property name="url" value="jdbc:sqlserver://MyServerName:1433:databasename=MyDatabase;"/>
----------------------------------
I have installed MSSQL Server jdbc2.0 on my machine at this location
"C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\sqljdbc_2.0\enu"
When I run the integration it gives me following error.
**************************************
2438 [AccountExtractDB] ERROR com.salesforce.lexiloader.dao.database.DatabaseCon
text - Database error encountered during connecting for database configuration:
DBAccountInsert. Sql error: Cannot load JDBC driver class 'com.microsoft.sqlse
rver.jdbc.SQLServerDriver'.
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'com.m
icrosoft.sqlserver.jdbc.SQLServerDriver'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:766)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:540)
at com.salesforce.lexiloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:89)
at com.salesforce.lexiloader.dao.database.DatabaseContext.checkConnectio
n(DatabaseContext.java:81)
at com.salesforce.lexiloader.dao.database.DatabaseWriter.checkConnection
(DatabaseWriter.java:92)
at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:121)
at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.ja
va:228)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLSer
verDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:760)
... 6 more
2485 [AccountExtractDB] FATAL com.salesforce.lexiloader.process.ProcessRunner -
Database error encountered during connecting for database configuration: DBAcco
untInsert. Sql error: Cannot load JDBC driver class 'com.microsoft.sqlserver.jd
bc.SQLServerDriver'.
Exception in thread "main" java.lang.RuntimeException: com.salesforce.lexiloader
.exception.DataAccessObjectInitializationException: Database error encountered d
uring connecting for database configuration: DBAccountInsert. Sql error: Cannot
load JDBC driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver'.
at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:154)
at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.ja
va:228)
Caused by: com.salesforce.lexiloader.exception.DataAccessObjectInitializationExc
eption: Database error encountered during connecting for database configuration:
DBAccountInsert. Sql error: Cannot load JDBC driver class 'com.microsoft.sqlse
rver.jdbc.SQLServerDriver'.
at com.salesforce.lexiloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:97)
at com.salesforce.lexiloader.dao.database.DatabaseContext.checkConnectio
n(DatabaseContext.java:81)
at com.salesforce.lexiloader.dao.database.DatabaseWriter.checkConnection
(DatabaseWriter.java:92)
at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:121)
... 1 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver c
lass 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:766)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource
.java:540)
at com.salesforce.lexiloader.dao.database.DatabaseContext.initConnection
(DatabaseContext.java:89)
... 4 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLSer
verDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:760)
... 6 more
Press any key to continue . . .
**************************************
Expecting a positive response from this forum :smileyhappy:
Nilove
Its seems java classpath error. Run time is not able to find the driver class
Put .SQLServerDriver related jars in the classpath before running the load.
I am not sure how you are running it but you can add classpath entry at global level
right click the My computer > click on properties > click on Advanced tab > click on Environment Variables button
in the user variable section click on new button
put variable name as CLASSPATH
put variable value as the path to your jar - example - c:/lib/jar1.jar;c:/lib/jar2.jar
Click ok and apply this setting.
Now try to run your load
See if it works for you
cheers
Hi,
I am currently using CLI push the data.
When I run the file in command prompt its show me following error.
D:\Apex Dataloader\bin>process conf accountMasterProcess
2011-08-29 09:20:34,653 INFO [main] controller.Controller initLog (Controller.j
ava:367) - The log has been initialized
2011-08-29 09:20:34,663 INFO [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:78) - Loading process configuration from config file: D:\Apex Data
loader\bin\conf\process-conf.xml
2011-08-29 09:20:34,718 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file
[D:\Apex Dataloader\bin\conf\process-conf.xml]
2011-08-29 09:20:34,740 INFO [main] core.CollectionFactory <clinit> (Collection
Factory.java:66) - JDK 1.4+ collections available
2011-08-29 09:20:34,746 INFO [main] core.CollectionFactory <clinit> (Collection
Factory.java:71) - Commons Collections 3.x available
2011-08-29 09:20:34,785 INFO [accountMasterProcess] controller.Controller initC
onfig (Controller.java:328) - The controller config has been initialized
2011-08-29 09:20:34,790 INFO [accountMasterProcess] process.ProcessRunner run (
ProcessRunner.java:90) - Initializing process engine
2011-08-29 09:20:34,790 INFO [accountMasterProcess] process.ProcessRunner run (
ProcessRunner.java:93) - Loading parameters
2011-08-29 09:20:35,572 INFO [accountMasterProcess] config.LastRun load (LastRu
n.java:101) - Last run info will be saved in file: D:\Apex Dataloader\bin\conf\a
ccountMasterProcess_lastRun.properties
2011-08-29 09:20:35,597 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:211) - Unable to run process accountMasterProcess
java.lang.RuntimeException: java.lang.IllegalArgumentException: No enum const cl
ass com.salesforce.dataloader.action.OperationInfo.
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:136)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:74)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:226)
Caused by: java.lang.IllegalArgumentException: No enum const class com.salesforc
e.dataloader.action.OperationInfo.
at java.lang.Enum.valueOf(Enum.java:192)
at com.salesforce.dataloader.config.Config.getEnum(Config.java:441)
at com.salesforce.dataloader.config.Config.getOperationInfo(Config.java:
981)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:97)
... 2 more
D:\Apex Dataloader\bin>
My process.config file is below.
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="accountMasterProcess"
class="com.salesforce.dataloader.process.ProcessRunner"
singleton="false">
<description>LOGIN</description>
<property name="name" value="accountMasterProcess"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="true"/>
<entry key="sfdc.debugMessagesFile" value="D:\Apex Dataloader\samples\status\accountMasterSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
<entry key="sfdc.username" value="sm_miky@gmail.com"/>
<!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
<entry key="sfdc.password" value="0a2aeb7885e668e6f80a8187cf4eec85"/>
<!-- <entry key="process.encryptionKeyFile" value="D:\Apex Dataloader\samples\conf\sample.key"/>-->
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="dataAccess.type" value="databaseRead"/>
<entry key="process.initialLastRunDate" value="2005-12-01T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>
Any one know the solution let me know please.iT bit urgent:mansad:
Regards
Niky