Connect Spring Hibernate and C3p0 application to Mariadb through SSL certificate authentication. - Source

Revision: 33403
User: Ashish Jagtap
Date: 2015-01-05 08:36

I have created application in Spring,Hibernate and c3p0 which is now connecting to Mysql database. now we are migrating our application to MariaDB (Server version: 5.5.5-10.0.7-MariaDB Source distribution) through SSL.

following is the configuration file that we are using to connect to Mysql database

JDBC.properties

jdbc.initialPoolSize=10
jdbc.maxPoolSize=30
jdbc.minPoolSize=5
jdbc.acquireIncrement=3
jdbc.acquireRetryAttempts=0
jdbc.preferredTestQuery=SELECT 1
jdbc.idleConnectionTestPeriod=600
jdbc.numHelperThreads=10
jdbc.debugUnreturnedConnectionStackTraces=true
jdbc.mydbUrl=jdbc:mysql://myhost.com:3306/mydb?verifyServerCertificate=true&useSSL=true&requireSSL=true&characterEncoding=utf8
jdbc.mydbUsername=myuser

datasource-context.xml

we are able to connect to DB server through command line using following command

mysql -h myhost.com -P3306 -umyuser --ssl-ca ca.crt --ssl-cert app.crt --ssl-key my-key.key

now how can I specify --ssl-ca,--ssl-cert and --ssl-cert files while connecting to MariaDB through Hibernate and c3p0. or what is the steps to connect to MariaDB database through SSL using c3p0 and hibernate.

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Connect Spring Hibernate and C3p0 application to Mariadb through SSL certificate authentication. - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB