Configure Oozie to use MySQL

0 votes
Hi. I have recently installed Oozie and MySQL and I want to set up oozie such that it used MySQL database. How to do this?
Jun 4, 2019 in Big Data Hadoop by Rajat
1,408 views

1 answer to this question.

0 votes

To configure Oozie to use MySQL, open the oozie-site.xml file and add the following properties:

    <property>
        <name>oozie.service.JPAService.jdbc.driver</name>
        <value>com.mysql.jdbc.Driver</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.url</name>
        <value>jdbc:mysql://localhost:3306/oozie</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.username</name>
        <value>oozie</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.password</name>
        <value>oozie</value>
    </property>
answered Jun 4, 2019 by Karan

Related Questions In Big Data Hadoop

0 votes
1 answer

Configure Oozie to use PostgreSQL

To configure Oozie to use PostgreSQL, add ...READ MORE

answered Jun 4, 2019 in Big Data Hadoop by Rajan
1,106 views
0 votes
1 answer

How to configure the metastore service to communicate with the MySQL database in Hive?

Hey, This step shows the configuration properties you ...READ MORE

answered May 29, 2019 in Big Data Hadoop by Gitika
• 65,770 points
756 views
0 votes
1 answer

How to configure the Hadoop cluster with proxyuser for the Oozie process?

Hey, The following two properties are required in ...READ MORE

answered Jun 10, 2019 in Big Data Hadoop by Gitika
• 65,770 points
954 views
0 votes
1 answer
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27, 2019 in Big Data Hadoop by Omkar
• 69,220 points
784 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Configure Oozie to use MariaDB

Add the following properties in the oozie-site.xml file, it ...READ MORE

answered Jun 4, 2019 in Big Data Hadoop by Esha
748 views
0 votes
1 answer

How to configure Oozie to use Oracle?

You have to mention the following properties ...READ MORE

answered Jun 6, 2019 in Big Data Hadoop by Rishi
949 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP