function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

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

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>
 
Thanks
Sue


lamayclamayc
<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


OIOI
Thanks lamayc. I will try this.