wesupport

Need help?

Our experts have had an average response time of 13.14 minutes in February 2024 to fix urgent issues.

We will keep your servers stable, secure, and fast at all times for one fixed price.

Installing Java Database Connectivity (JDBC) database drivers : AWS SCT

by | Aug 4, 2021

Are you looking to installing JDBC database drivers for AWS SCT? We can help you!

For the proper working of AWS SCT, we must install the JCBC database drivers.

As part of our AWS Support Services, we assist our customers with similar AWS queries.

Today, let see the steps followed by our Support Engineers to install the JDBC database drivers.

JDBC Drivers

Java Database Connectivity (JDBC) is an API for Java, which enables java applications to interact with the database.

For the proper working of AWS SCT, we must install the JDBC database drivers for source and target database engines.

Before installing, we have to download the database drivers. We can download the database drivers from the following locations:

MySQL: https://www.mysql.com/products/connector/

Oracle: https://www.oracle.com/database/technologies/jdbc-ucp-122-downloads.html

Amazon Aurora (MySQL compatible): https://www.mysql.com/products/connector/
Microsoft SQL Server: https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 Maria DB: https://mariadb.com/downloads/#connectors

Always make sure to install the latest version of the driver available.

Installing JDBC database drivers

Now, let see the steps followed by our Support Techs to install the JDBC drivers on the Linux system for AWS SCT.

  1. Firstly, create a directory/folder for storing JDBC drivers.
>sudo mkdir –p /usr/local/jdbc-drivers

2. Then, we can install the JDBC database driver using the following commands:

MySQL : mysql prompt> cd /usr/local/jdbc-drivers
mysql prompt> sudo tar xzvf /tmp/mysql-connector-java-X.X.X.tar.gz

PostgreSQL: PostgreSQL prompt> cd /usr/local/jdbc-drivers
PostgreSQL prompt> sudo cp -a /tmp/postgresql-X.X.X.jre7.tar .

Oracle: From the Oracle prompt, > cd /usr/local/jdbc-drivers
>sudo mkdir oracle-jdbc-drivers
>cd oracle-jdbc-drivers
>sudo cp -a /tmp/ojdbc8.jar .

Amazon Aurora (MySQL compatible): Aurora prompt> cd /usr/local/jdbc-drivers
Aurora prompt> sudo tar xzvf /tmp/mysql-connector-java-X.X.X.tar.gz

Amazon Aurora (PostgreSQL compatible): Aurora prompt> cd /usr/local/jdbc-drivers
Aurora prompt> sudo cp -a /tmp/postgresql-X.X.X.jre7.tar .

Microsoft SQL Server: prompt> cd /usr/local/jdbc-drivers
prompt> sudo tar xzvf /tmp/sqljdbc_X.X.X_enu.tar.gz

After completing the installation of the JDBC driver, we can set the location of the drivers globally in the AWS SCT settings.

If we don’t set this globally, every time, the application asks for the driver’s location when connecting to the database.

Therefore, it is always better to set the driver location globally in the AWS SCT settings.

Setting driver location globally

Let’s the steps for setting the driver location globally:

  1. Firstly, from AWS SCT select Settings.
  2. Then select Global Settings.
  3. Select Drivers.
  4. Then, add the JDBC driver path for the source and target database engine.
  5. Finally, click OK.

[Need assistance with more AWS queries? We can help you]

Conclusion

To conclude, today we saw the steps followed by our Support Techs for installing JDBC database drivers for AWS.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *

Categories

Tags