Manually upload JDBC drivers

[JLehr]

For IT Advisor on-premises only

This example uses MySQL8 and the MySQL JDBC driver version 8.2.0.

• Download the JDBC driver.
• SSH to the server. Navigate to /opt/jboss-as/modules/com/apc/etl/
• Create the directory mysql-8_2_0 with the command:
  

  mkdir mysql-8_2_0​

• Navigate to mysql-8_2_0 and create the directory main with the command:
  

  mkdir main​

• Navigate to main and create the module.xml file with the command:
  

  vi module.xml​

• Save the module.xml file and exit.
  
  
• Paste the following into the module.xml file:
  Note: This is the contents of the module.xml file from postgresql, in the directory /opt/jboss-as/modules/com/apc/etl/postgresql/main/
  
  

  <?xml version="1.0" encoding="UTF-8"?>

                 <module xmlns="urn:jboss:module:1.0" name="com.apc.etl.postgresql">

                                <main-class name="org.postgresql.Driver"/>

                                <properties>

                                               <property name="dialect" value="org.hibernate.dialect.PostgreSQL94Dialect"/>

                                               <property name="driverclass" value="org.postgresql.Driver"/>

                                </properties>

                                <dependencies>

                                              <system/>

                                              <module name="javaee.api"/>

                                </dependencies>

                 </module>

• Change all properties where the postgresql driver is mentioned. And also make sure to add the .jar file path line in "<resources> <resource-root path="mysql-connector-java-8.2.0.jar"/> </resources>".  When you are finished, your module.xml file should look like this:
  
  

  <?xml version="1.0" encoding="UTF-8"?>               

                  <module xmlns="urn:jboss:module:1.0" name="com.apc.etl.mysql-8_2_0">

                                <main-class name="com.mysql.cj.jdbc.Driver"/>

                             <resources>

                                           <resource-root path="mysql-connector-java-8.2.0.jar"/>

                             </resources>

                                <properties>

                                               <property name="dialect" value="org.hibernate.dialect.MySQL8Dialect"/>

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

                                </properties>

                                <dependencies>

                                               <system/>

                                               <module name="javaee.api"/>

                                </dependencies>

                 </module>

  If you use MYSQL5, change

  <property name="dialect" value="org.hibernate.dialect.MySQL8Dialect"/>

  to
  

  <property name="dialect" value="org.hibernate.dialect.MySQL5Dialect"/>

• Copy the JDBC driver .jar file from the downloaded location to the server.
  You can use the scp command, for example, <download location>/mysql-connector-java-8.2.0/mysql-connector-java-8.2.0.jar <username>@<SERVERIP>:/tmp
  
  
• Move the .jar file from the /tmp folder to /opt/jboss-as/modules/com/apc/etl/mysql-8_2_0/main/
  
  
• Navigate to /opt/jboss-as/modules/com/apc/etl/main/
• Open the module.xml file.
  
  
• Add <property name="mysql-8_2_0"/> to the <properties> section.

• Add <module export="true" name="com.apc.etl.mysql-8_2_0"/> to the dependencies section.
  When you are finished, your module.xml file should look like this:
  
  

  <?xml version="1.0" ?>                              

                  <module xmlns="urn:jboss:module:1.1" name="com.apc.etl">

                                <properties>

                                               <property name="postgresql"/>

                                               <property name="jtds-1_3_1"/>

                                               <property name="mysql-8_2_0"/>

                                </properties>

                                <resources/>

                                <dependencies>

                                               <module export="true" name="com.apc.etl.jtds-1_3_1"/>

                                               <module export="true" name="com.apc.etl.mysql-8_2_0"/>

                                </dependencies>

                 </module>

• Restart the IT Advisor server with the command:

  systemctl restart operations