Hi,

I'm newbie to salesforce.com.

I'm trying to export data from salesforce.com to SQL Server 2005 through

the Apex Data Loader.

When I run the process through command line I get this error:

FATAL [databaseExportAccountVeryShort] controller.Controller createDao (Controller.java:186) - Error creating data access object

Here is my database-conf.xml:

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
  <bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
    <property name="url" value="jdbc:sqlserver://Localhost:1433;databaseName=MyDatabase;"/>
    <property name="username" value="MyUser"/>
    <property name="password" value="MyPassword"/>
  </bean>
  <bean id="Account_DataLoader"
      class="com.salesforce.lexiloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="insertAccountVeryShort"/>
    <property name="dataSource" ref="dbDataSource"/>
  </bean>
  <bean id="insertAccountVeryShort"
      class="com.salesforce.lexiloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            INSERT INTO dbo.Account_DataLoader (Id,Account_Open_Date__c)
            VALUES (@Id@, @Account_Open_Date__c@)
        </value>
    </property>
    <property name="sqlParams">
        <map>
            <entry key="Id" value="java.lang.String"/>
            <entry key="Account_Open_Date__c"  value="java.lang.String"/>
        </map>
    </property>
  </bean>
</beans>

I have a matching part in process-conf.xml with dataAccess.type=databaseWrite

and in my command line the process name is insertAccountVeryShort.

Can anyone help me with that?

Thanks,

Omshi.