+ Start a Discussion

Help needed using Dataloader to connect to Mysql database

I am very new at this. I am trying to use Apex dataloader to synchronize records from Salesforce to Mysql database. I started with the examples in samples folder which comes with Apex data loader installation. Can any of you please tell me what will be the driverclass name and url value for mysql in database-conf.xml.


<bean id="dbDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/> <property name="url" value="jdbc:oracle:thin:@my.server.com:1521:dataBaseName"/> <property name="username" value="user"/> <property name="password" value="password"/> </bean>





<property name="driverClassName" value="com.mysql.jdbc.Driver"/>

<property name="url" value="jdbc:mysql://localhost:3306/dbname"/> (this is of course dependent on your setup)


don't forget to put the location of the jar file (ie mysql-connector-java-5.1.7-bin.jar) in the classpath on the command line

Thanks lamayc. I will try this.