@Manikandan Ramachandranโ
JDBC does support running update and delete commands against a database, so it should be possible to execute those commands against your AWS RDS system using JDBC.
If you are encountering an SSL certificate error when trying to connect to your RDS instance, you may need to configure SSL for your JDBC connection. To do this, you will need to obtain the SSL certificate for your RDS instance and configure your JDBC connection to use it.
Here are the steps you can follow to configure SSL for your JDBC connection:
- Download the SSL certificate for your RDS instance. You can do this by navigating to the RDS console in the AWS Management Console, selecting your instance, and clicking the "Download RDS Certificate" button.
- Save the SSL certificate to a file on your local machine.
- Update your JDBC connection URL to include the SSL properties. Here is an example URL:
jdbc:mysql://your-rds-instance-endpoint:3306/your-database-name?useSSL=true&requireSSL=true&verifyServerCertificate=true&sslMode=REQUIRED&trustCertificateKeyStoreUrl=file:///path/to/certificate.pem&trustCertificateKeyStorePassword=your_keystore_password
Replace your-rds-instance-endpoint with the endpoint of your RDS instance, and your-database-name
with the name of your database.
Replace /path/to/certificate.pem with the path to the SSL certificate file you downloaded in step 1.
Replace your_keystore_password with a password of your choice.
Use the updated JDBC connection URL to connect to your RDS instance and execute your update and delete commands.
Note that you may need to configure other SSL properties based on your specific RDS configuration. You can refer to the MySQL JDBC driver documentation for more information on the available SSL properties.