LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  MariaDB Connection

    Employee
    Posted 09-11-2017 07:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: Gildenstern

    Hi everyone,

    one of our business partners would like to provide us data through MariaDB. Has anyone of you experience to connect with this kind of Database?? The MariaDB Homepage offers some java-connectors (https://downloads.mariadb.org/connector-java/). I would download the latest version and copy to "C:\Program Files (x86)\Lavastorm\LAE5.1\lib\java\ext". Then I would use the JDBC Query Node to connect.

    Is it the right way? And how the node has to be set up? I can't really do some testings before. First I have to know/answer if this kind of connection is possible in LAE and then they will set up the Server where I can test.

    Thank you!!

    Cheers,
    Dimitry


  • 2.  RE: MariaDB Connection

    Employee
    Posted 09-13-2017 04:04

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    Hi Dimitry,

    I have not tried this myself and I do not have access to a LAE 5.1 instance, but what you describe appears to be correct - the mariadb-java-client-1.x.y.jar needs to be in the <LAE install Dir>\lib\java\ext folder.

    Note that you will have to use a 1.x version of the driver as it needs to be compatible with the version of Java used by LAE (1.7).

    You will need to configure the DbDriver property with the driver class name e.g. "org.mariadb.jdbc.Driver" and the DbUrl property e.g. "jdbc:mariadb://myserverhost:3306/db"

    This page has some useful information on compatibility and usage of the driver:

    https://mariadb.com/kb/en/library/ab...b-connector-j/