Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
NiloveNilove 

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

SSinghSSingh

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 

 
MunmunMunmun

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