Maven mysql driver | Community
Skip to main content
dilips50359074
Level 2
Sep 13, 2019 5:20 PM UTC
Solved

Maven mysql driver

Hi AEM guru's

i am using AEM Archtype 19 project.

I am using mySQL , I have downloaded https://dev.mysql.com/downloads/connector/j/  the driver from the location and installed it. 

Everything is working fine.

However what I am looking for is automated process when the maven will download the mySQL driver and install it in AEM and it should be visible in the bundles console.

I have copied the dependency (refer below) in the POM.xml.

<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->

<dependency>

    <groupId>mysql</groupId>

    <artifactId>mysql-connector-java</artifactId>

    <version>8.0.17</version>

</dependency>

What is see is the driver folder is downloaded in the following location C:\Users\Administrator\.m2\repository\mysql\mysql-connector-java

but when I install mvn clean install -PautoInstallPackage,   i do not see the driver (Oracle Corporation's JDBC and XDevAPI Driver for MySQLcom.mysql.cj) in the bundles.

am I missing something?

Regards

Dilip

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    joerghoh
    joerghohAccepted solution
    Employee
    Sep 16, 2019 6:31 AM UTC

    As said, you need to include it into your POM.

    Jörg

    View reply

    4 replies

    joerghoh
    joerghohAccepted solution
    Employee
    Sep 16, 2019 6:31 AM UTC

    As said, you need to include it into your POM.

    Jörg

    Translate
    dilips50359074Author
    Level 2
    Sep 16, 2019 1:53 AM UTC

    thanks for the response.

    I am able to manually install the driver in the bundle.  What I am looking for is when I install my AEM archtype project, it should automatically install the mysql jdbc driver.

    The links provided install it manually.  

    Am i missing something?

    Translate
    zonroc
    Level 3
    Sep 15, 2019 10:49 PM UTC

    Wrap the Driver file into an OSGi bundle and deploy. This is shown in many articles:

    Adobe Experience Manager Help | Querying MySQL data using an Adobe Experience Manager 6.4 DataSourcePool

    As Joerg has pointed out - referencing the dependency in the POM file only ensures the build is created successfully - it does not place the driver file into an OSGi bundle and deploy to AEM.

    Translate
    joerghoh
    joerghoh
    Employee
    Sep 13, 2019 5:57 PM UTC

    You just declared the dependency, but you did not use it. If this driver is already bundled as OSGI service, you should add it to your ui.apps/pom.xml and declare it to be embedded into the content-package. Just like [1] but for the mysql driver.

    [aem-project-archetype/pom.xml at aem-project-archetype-19 · adobe/aem-project-archetype · GitHub ]

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...