{"id":41829,"date":"2024-05-22T11:09:57","date_gmt":"2024-05-22T11:09:57","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&#038;p=41829"},"modified":"2026-02-19T05:15:22","modified_gmt":"2026-02-19T05:15:22","slug":"java-connection-to-mysql-mariadb","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb","title":{"rendered":"How to Connect a Java with MariaDB\/MySQL\/Percona?"},"content":{"rendered":"<h2 class=\"ack-h2\">How to Connect Java with MariaDB\/MySQL\/Percona?<\/h2>\n<p><a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/database\/mariadb-hosting\" target=\"_blank\" rel=\"noopener\">MariaDB<\/a>, MySQL, and Percona are very popular databases used by developers all around the world. In this guide, we&#8217;ll show you how to connect your <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/application\/java-hosting\" target=\"_blank\" rel=\"noopener\">Java<\/a> application to these databases, whether it&#8217;s a single server or a clustered setup.<\/p>\n<p><strong>Step 1.<\/strong> <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/login\" target=\"_blank\" rel=\"noopener\">Log in<\/a> to your Accuweb.cloud dashboard and create an environment with either MariaDB or MySQL.<\/p>\n<p>You can choose between setting up a <strong>standalone database server<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-01.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41899 size-full\" title=\"Connect Your Java Application\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-01.jpg\" alt=\"Connect Your Java Application\" width=\"1078\" height=\"668\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-01.jpg 1078w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-01-300x186.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-01-1024x635.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-01-768x476.jpg 768w\" sizes=\"(max-width: 1078px) 100vw, 1078px\" \/><\/a><\/p>\n<p>or an <strong>Auto-Clustering solution.<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-02.jpg\"><img decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41898 size-full\" title=\"Auto-Clustering solution.\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-02.jpg\" alt=\"Auto-Clustering solution.\" width=\"1075\" height=\"669\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-02.jpg 1075w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-02-300x187.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-02-1024x637.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-02-768x478.jpg 768w\" sizes=\"(max-width: 1075px) 100vw, 1075px\" \/><\/a><\/p>\n<p>We&#8217;ve also included a Tomcat node to demonstrate how to connect your application server to the database.<\/p>\n<p><strong>Step 2.<\/strong> Check your email inbox for the administration details of the <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/database\/mariadb-hosting\" target=\"_blank\" rel=\"noopener\">MariaDB<\/a> or MySQL server you created. If you&#8217;re using a clustered solution, you&#8217;ll connect to a ProxySQL load balancer.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-03.jpg\"><img decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41897 size-full\" title=\"MariaDB or MySQL Server You Created.\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-03.jpg\" alt=\"MariaDB or MySQL Server You Created.\" width=\"877\" height=\"825\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-03.jpg 877w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-03-300x282.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-03-768x722.jpg 768w\" sizes=\"(max-width: 877px) 100vw, 877px\" \/><\/a><\/p>\n<p><strong>Step 3.<\/strong> Go back to the dashboard and click <strong>&#8220;Open in Browser&#8221;<\/strong> for your MariaDB or <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/database\/mysql-hosting\" target=\"_blank\" rel=\"noopener\">MySQL<\/a> node. If you&#8217;re using a clustered solution, click on <strong>&#8220;Open in Browser&#8221;<\/strong> next to the master database node (marked as M). Log in using the credentials provided in the email.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-04.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41896 size-full\" title=\"Open in Browser\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-04.jpg\" alt=\"Open in Browser\" width=\"1091\" height=\"704\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-04.jpg 1091w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-04-300x194.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-04-1024x661.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-04-768x496.jpg 768w\" sizes=\"(max-width: 1091px) 100vw, 1091px\" \/><\/a><\/p>\n<p><strong>Step 4.<\/strong> Choose an existing database (test) or create a new one.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-05.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41895 size-full\" title=\"Existing Database\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-05.jpg\" alt=\"Existing Database\" width=\"1077\" height=\"498\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-05.jpg 1077w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-05-300x139.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-05-1024x473.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-05-768x355.jpg 768w\" sizes=\"(max-width: 1077px) 100vw, 1077px\" \/><\/a><\/p>\n<p><strong>Step 5.<\/strong> Create a file with the name mydb.cfg and paste the following php code.<\/p>\n<ul class=\"ack-ul\">\n<li><strong>Host:<\/strong> jdbc:mysql:\/\/{host}\/{db_name}<\/li>\n<li><strong>Username:<\/strong> {user}<\/li>\n<li><strong>Password:<\/strong> {password}<\/li>\n<li><strong>Driver:<\/strong> com.mysql.jdbc.Driver<\/li>\n<\/ul>\n<p><strong>You can find all this info in the email you got from MariaDB or MySQL:<\/strong><\/p>\n<ul class=\"ack-ul\">\n<li><strong>{host}:<\/strong> The link to your database without the http part<\/li>\n<li><strong>{db_name}:<\/strong> The name of your database (we used <strong>&#8220;test&#8221;<\/strong> in our example)<\/li>\n<li><strong>{user} and {password}:<\/strong> Your admin login details (for security, it&#8217;s best to use a special account with the right permissions)<\/li>\n<\/ul>\n<p>If you&#8217;re connecting to a cluster, you&#8217;ll use ProxySQL as the entry point, and each database type has its own connector. Put this info in the mydb.cfg file:<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-06.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41894 size-full\" title=\"Connecting to a Cluster\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-06.jpg\" alt=\"Connecting to a Cluster\" width=\"867\" height=\"311\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-06.jpg 867w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-06-300x108.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-06-768x275.jpg 768w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><\/a><\/p>\n<h2 class=\"ack-h2\">For MariaDB<\/h2>\n<ul class=\"ack-ul\">\n<li><strong>Host:<\/strong> jdbc:mariadb:\/\/{hostname}\/{db_name}?usePipelineAuth=false<\/li>\n<li><strong>Username:<\/strong> {user}<\/li>\n<li><strong>Password:<\/strong> {password}<\/li>\n<li><strong>Driver:<\/strong> org.mariadb.jdbc.Driver<\/li>\n<\/ul>\n<h3>You&#8217;ll find this info in your email:<\/h3>\n<ul class=\"ack-ul\">\n<li><strong>{hostname}:<\/strong> The link to your database cluster&#8217;s load balancer (ProxySQL)<\/li>\n<li><strong>{db_name}:<\/strong> The name of your database (we used &#8220;test&#8221; earlier)<\/li>\n<li><strong>usePipelineAuth:<\/strong> This should be set to false for ProxySQL to work properly.<\/li>\n<\/ul>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-07.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41893 size-full\" title=\"MariaDB Connection\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-07.jpg\" alt=\"MariaDB Connection\" width=\"859\" height=\"394\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-07.jpg 859w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-07-300x138.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-07-768x352.jpg 768w\" sizes=\"(max-width: 859px) 100vw, 859px\" \/><\/a><\/p>\n<h2 class=\"ack-h2\">For MySQL<\/h2>\n<ul class=\"ack-ul\">\n<li><strong>Host:<\/strong> jdbc:mysql:\/\/{host}\/{db_name}<\/li>\n<li><strong>Username:<\/strong> {user}<\/li>\n<li><strong>Password:<\/strong> {password}<\/li>\n<li><strong>Driver:<\/strong> com.mysql.jdbc.Driver<\/li>\n<\/ul>\n<p>You&#8217;ll find this info in your email too:<\/p>\n<ul class=\"ack-ul\">\n<li><strong>{host}:<\/strong> The link to your database cluster&#8217;s load balancer (ProxySQL)<\/li>\n<li><strong>{db_name}:<\/strong> The name of your database (we used <strong>&#8220;test&#8221;<\/strong> earlier)<\/li>\n<li><strong>{user} and {password}:<\/strong> Your admin login details (again, it&#8217;s best to use a special account)<\/li>\n<\/ul>\n<p>This way, all the connection settings are in one file, and your application can read them easily.<\/p>\n<div class=\"article-space\"><\/div>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"38668\" class=\"elementor elementor-38668\" data-elementor-settings=\"{&quot;ha_cmc_init_switcher&quot;:&quot;no&quot;}\" data-elementor-post-type=\"elementor_library\">\n\t\t\t        <section class=\"elementor-section elementor-top-section elementor-element elementor-element-882321f elementor-section-boxed elementor-section-height-default elementor-section-height-default ct-header-fixed-none ct-row-max-none\" data-id=\"882321f\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n            \n                        <div class=\"elementor-container elementor-column-gap-default \">\n                    <div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7cc79cc\" data-id=\"7cc79cc\" data-element_type=\"column\">\n        <div class=\"elementor-widget-wrap elementor-element-populated\">\n                    \n        \t\t<div class=\"elementor-element elementor-element-e31b40f elementor-widget elementor-widget-shortcode\" data-id=\"e31b40f\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t            <\/div>\n        <\/div>\n                    <\/div>\n        <\/section>\n        \t\t<\/div>\n\t\t\n<div class=\"article-space\"><\/div>\n<p><strong>Step 6.<\/strong> Go to the <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/\" target=\"_blank\" rel=\"noopener\">Accuweb.cloud<\/a><br \/>\ndashboard and choose the environment where you want to check the database connection.<\/p>\n<p><strong>Step 7.<\/strong> Select the Application Server and the Node server. Then click on Config next to the Node server.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-08.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41892 size-full\" title=\"Config next\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-08.jpg\" alt=\"Config next\" width=\"1036\" height=\"698\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-08.jpg 1036w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-08-300x202.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-08-1024x690.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-08-768x517.jpg 768w\" sizes=\"(max-width: 1036px) 100vw, 1036px\" \/><\/a><\/p>\n<p><strong>Step 8.<\/strong> Navigate to the temp path <strong>(\/var\/www\/webroot\/ROOT).<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-09.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41891 size-full\" title=\"Navigate to The Temp Path\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-09.jpg\" alt=\"Navigate to The Temp Path\" width=\"1029\" height=\"516\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-09.jpg 1029w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-09-300x150.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-09-1024x513.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-09-768x385.jpg 768w\" sizes=\"(max-width: 1029px) 100vw, 1029px\" \/><\/a><\/p>\n<p>Then click on the <strong>Settings<\/strong> icon and choose <strong>Upload.<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-10.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-41890\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-10.jpg\" alt=\"\" width=\"1032\" height=\"477\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-10.jpg 1032w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-10-300x139.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-10-1024x473.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-10-768x355.jpg 768w\" sizes=\"(max-width: 1032px) 100vw, 1032px\" \/><\/a><\/p>\n<p><strong>Step 9.<\/strong> In the Upload Files window, go to Local Files and select the file from your computer. Click Upload to add the file to the <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/\" target=\"_blank\" rel=\"noopener\">Accuweb.cloud<\/a> environment.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-11.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-41889\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-11.jpg\" alt=\"\" width=\"1034\" height=\"405\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-11.jpg 1034w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-11-300x118.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-11-1024x401.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-11-768x301.jpg 768w\" sizes=\"(max-width: 1034px) 100vw, 1034px\" \/><\/a><\/p>\n<p><strong>Step 10.<\/strong> Once the file is successfully uploaded, you will get the file in the temp path.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-12.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41888 size-full\" title=\"temp path\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-12.jpg\" alt=\"temp path\" width=\"1032\" height=\"482\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-12.jpg 1032w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-12-300x140.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-12-1024x478.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-12-768x359.jpg 768w\" sizes=\"(max-width: 1032px) 100vw, 1032px\" \/><\/a><\/p>\n<p><strong>Step 11.<\/strong> We&#8217;ll use a sample application to deploy and connect. This application helps us connect to databases. It sets up a table with a unique name based on the current date and time.<\/p>\n<div class=\"article-space\"><\/div>\n<div class=\"ack-br-tage\">\n<pre><code class=\"language-javascript\">\r\npackage connection;\r\nimport java.io.IOException;\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.SQLException;\r\nimport java.sql.Statement;\r\nimport java.text.SimpleDateFormat;\r\nimport java.util.Date;\r\nimport java.util.Properties;\r\nimport java.util.logging.Level;\r\nimport java.util.logging.Logger;\r\npublic class DbManager {\r\npublic String date = new SimpleDateFormat(\"dd-MM-yyyy-HH-mm\").format(new Date());\r\nprivate final String createTable = \"CREATE TABLE `\" + date + \"` (id INT, data VARCHAR(100));\";\r\nprivate static final int LoginTimeout = 10;\r\npublic DbManager() {}\r\npublic Connection createConnection() throws IOException, ClassNotFoundException, SQLException {\r\nProperties prop = new Properties();\r\nSystem.out.println(\"\\n\\n=======================\\nJDBC Connector Test \" + date);\r\nSystem.out.println(\"User home directory: \" + System.getProperty(\"user.home\"));\r\nString host;\r\nString username;\r\nString password;\r\nString driver;\r\ntry {\r\nprop.load(new java.io.FileInputStream(System.getProperty(\"user.home\") + \"\/mydb.cfg\"));\r\nhost = prop.getProperty(\"host\").toString();\r\nusername = prop.getProperty(\"username\").toString();\r\npassword = prop.getProperty(\"password\").toString();\r\ndriver = prop.getProperty(\"driver\").toString();\r\n} catch (IOException e) {\r\nSystem.out.println(\"Unable to find mydb.cfg in \" + System.getProperty(\"user.home\") + \"\\n Please make sure that configuration file created in this folder.\")\r\nhost = \"Unknown HOST\";\r\nusername = \"Unknown USER\";\r\npassword = \"Unknown PASSWORD\";\r\ndriver = \"Unknown DRIVER\";\r\n}\r\nSystem.out.println(\"host: \" + host + \"\\nusername: \" + username + \"\\npassword: \" + password + \"\\ndriver: \" + driver);\r\nClass.forName(driver);\r\nSystem.out.println(\"--------------------------\");\r\nSystem.out.println(\"DRIVER: \" + driver);\r\nSystem.out.println(\"Set Login Timeout: \" + LoginTimeout);\r\nDriverManager.setLoginTimeout(LoginTimeout);\r\nConnection connection = DriverManager.getConnection(host, username, password);\r\nSystem.out.println(\"CONNECTION: \" + connection);\r\nreturn connection;\r\n}\r\npublic String runSqlStatement() {\r\nString result = \"\";\r\ntry {\r\nStatement statement = createConnection().createStatement();\r\nSystem.out.println(\"SQL query: \" + createTable);\r\nstatement.execute(createTable);\r\n} catch (IOException | ClassNotFoundException ex) {\r\nLogger.getLogger(DbManager.class.getName()).log(Level.SEVERE, null, ex);\r\nSystem.out.println(\"Exception occurred: \" + ex);\r\nresult = ex.getMessage();\r\n} catch (SQLException ex) {\r\nex.printStackTrace();\r\nresult = ex.getMessage();\r\n}\r\nreturn result;\r\n}\r\n}&lt;\/<\/code><\/pre>\n<\/div>\n<div class=\"article-extra-space\"><\/div>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"38668\" class=\"elementor elementor-38668\" data-elementor-settings=\"{&quot;ha_cmc_init_switcher&quot;:&quot;no&quot;}\" data-elementor-post-type=\"elementor_library\">\n\t\t\t        <section class=\"elementor-section elementor-top-section elementor-element elementor-element-882321f elementor-section-boxed elementor-section-height-default elementor-section-height-default ct-header-fixed-none ct-row-max-none\" data-id=\"882321f\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n            \n                        <div class=\"elementor-container elementor-column-gap-default \">\n                    <div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7cc79cc\" data-id=\"7cc79cc\" data-element_type=\"column\">\n        <div class=\"elementor-widget-wrap elementor-element-populated\">\n                    \n        \t\t<div class=\"elementor-element elementor-element-e31b40f elementor-widget elementor-widget-shortcode\" data-id=\"e31b40f\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t            <\/div>\n        <\/div>\n                    <\/div>\n        <\/section>\n        \t\t<\/div>\n\t\t\n<div class=\"article-space\"><\/div>\n<p><strong>Step 12.<\/strong> Deploy our sample application to your Tomcat server using this link:<\/p>\n<div class=\"article-space\"><\/div>\n<div class=\"ack-formula\">\n<a style=\"color:#000;\" href=\"https:\/\/download.jelastic.com\/public.php?service=files&amp;t=b2c6e4e01d487dfd5af953ba31dac848&amp;download\">Click here to Download the File<\/a><\/div>\n<div class=\"article-space\"><\/div>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-13.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41887 size-full\" title=\"Deploy Application Server\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-13.jpg\" alt=\"Deploy Application Server\" width=\"1018\" height=\"659\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-13.jpg 1018w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-13-300x194.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-13-768x497.jpg 768w\" sizes=\"(max-width: 1018px) 100vw, 1018px\" \/><\/a><\/p>\n<div class=\"article-extra-space\"><\/div>\n<div class=\"ack-formula\">\n<p><strong>Notes:<\/strong>&#8211; The sample app already has the necessary connectors for MariaDB\/MySQL.<\/p>\n<p>&#8211; For your own project, you&#8217;ll need to upload these connectors to the webapps\/{app_context}\/WEB-INF\/lib folder on your server.<\/p>\n<p>Remember to restart your server after making changes to mydb.cfg by pressing the Restart Node button.<\/p>\n<\/div>\n<div class=\"article-space\"><\/div>\n<p><strong>Step 13.<\/strong> After deployment, click <strong>&#8220;Open in Browser&#8221;<\/strong> next to your application server.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-14.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-41900 size-full\" title=\"Open in Browser\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-14.jpg\" alt=\"Open in Browser\" width=\"1031\" height=\"471\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-14.jpg 1031w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-14-300x137.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-14-1024x468.jpg 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-14-768x351.jpg 768w\" sizes=\"(max-width: 1031px) 100vw, 1031px\" \/><\/a><\/p>\n<p><strong>Step 14.<\/strong> In the browser tab that opens, click <strong>&#8220;Create test table in your database.&#8221;<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-1.5.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-41901 ack-article-image\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-1.5.jpg\" alt=\"\" width=\"998\" height=\"540\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-1.5.jpg 998w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-1.5-300x162.jpg 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/java-img-1.5-768x416.jpg 768w\" sizes=\"(max-width: 998px) 100vw, 998px\" \/><\/a><\/p>\n<p><strong>Step 15.<\/strong> To make sure everything&#8217;s working, go back to the phpMyAdmin panel and find the test database. You&#8217;ll see a new table with a name based on the creation date and time. This means the Java app successfully accessed and modified the database. It&#8217;s that simple!<\/p>\n<div class=\"article-space\"><\/div>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"38668\" class=\"elementor elementor-38668\" data-elementor-settings=\"{&quot;ha_cmc_init_switcher&quot;:&quot;no&quot;}\" data-elementor-post-type=\"elementor_library\">\n\t\t\t        <section class=\"elementor-section elementor-top-section elementor-element elementor-element-882321f elementor-section-boxed elementor-section-height-default elementor-section-height-default ct-header-fixed-none ct-row-max-none\" data-id=\"882321f\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n            \n                        <div class=\"elementor-container elementor-column-gap-default \">\n                    <div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7cc79cc\" data-id=\"7cc79cc\" data-element_type=\"column\">\n        <div class=\"elementor-widget-wrap elementor-element-populated\">\n                    \n        \t\t<div class=\"elementor-element elementor-element-e31b40f elementor-widget elementor-widget-shortcode\" data-id=\"e31b40f\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t            <\/div>\n        <\/div>\n                    <\/div>\n        <\/section>\n        \t\t<\/div>\n\t\t\n<div class=\"article-space\"><\/div>\n<h2 class=\"ack-h2\">Conclusion<\/h2>\n<p>In summary, connecting a <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/application\/java-hosting\" target=\"_blank\" rel=\"noopener\">Java<\/a> app to MySQL\/MariaDB\/Percona is crucial for working with databases. By setting up JDBC drivers and connection details, you enable smooth communication between your Java app and the database.<\/p>\n<p>Make sure to handle errors and use secure authentication for a successful connection. Once connected, your <a class=\"ack-link-color\" href=\"https:\/\/accuweb.cloud\/application\/java-hosting\" target=\"_blank\" rel=\"noopener\">Java<\/a> app can perform different database tasks, helping you retrieve, edit, and organize data effectively.<\/p>\n<div class=\"cta-btn-top-space\"><\/div>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"38668\" class=\"elementor elementor-38668\" data-elementor-settings=\"{&quot;ha_cmc_init_switcher&quot;:&quot;no&quot;}\" data-elementor-post-type=\"elementor_library\">\n\t\t\t        <section class=\"elementor-section elementor-top-section elementor-element elementor-element-882321f elementor-section-boxed elementor-section-height-default elementor-section-height-default ct-header-fixed-none ct-row-max-none\" data-id=\"882321f\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n            \n                        <div class=\"elementor-container elementor-column-gap-default \">\n                    <div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7cc79cc\" data-id=\"7cc79cc\" data-element_type=\"column\">\n        <div class=\"elementor-widget-wrap elementor-element-populated\">\n                    \n        \t\t<div class=\"elementor-element elementor-element-e31b40f elementor-widget elementor-widget-shortcode\" data-id=\"e31b40f\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t            <\/div>\n        <\/div>\n                    <\/div>\n        <\/section>\n        \t\t<\/div>\n\t\t\n<div class=\"cta-btn-bottom-space\"><\/div>\n","protected":false},"author":1,"featured_media":52879,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","class_list":["post-41829","faq","type-faq","status-publish","has-post-thumbnail","hentry","faq_topics-connection-to-application","faq_topics-databases","faq_topics-java-connection","faq_topics-kb","faq_topics-mysql-mariadb-percona","faq_topics-product-documentation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.10 (Yoast SEO v24.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Connect Java to MySQL and MariaDB | AccuWeb.Cloud guide<\/title>\n<meta name=\"description\" content=\"Learn how to connect your Java application to MariaDB, MySQL, and Percona databases, whether it&#039;s a standalone server or a clustered setup.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Connect a Java with MariaDB\/MySQL\/Percona?\" \/>\n<meta property=\"og:description\" content=\"Learn how to connect your Java application to MariaDB, MySQL, and Percona databases, whether it&#039;s a standalone server or a clustered setup.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb\" \/>\n<meta property=\"og:site_name\" content=\"AccuWeb Cloud\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-19T05:15:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#article\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb\"},\"author\":{\"name\":\"Jilesh Patadiya\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\"},\"headline\":\"How to Connect a Java with MariaDB\/MySQL\/Percona?\",\"datePublished\":\"2024-05-22T11:09:57+00:00\",\"dateModified\":\"2026-02-19T05:15:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb\"},\"wordCount\":814,\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"inLanguage\":\"en-US\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb\",\"url\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb\",\"name\":\"Connect Java to MySQL and MariaDB | AccuWeb.Cloud guide\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#primaryimage\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"datePublished\":\"2024-05-22T11:09:57+00:00\",\"dateModified\":\"2026-02-19T05:15:22+00:00\",\"description\":\"Learn how to connect your Java application to MariaDB, MySQL, and Percona databases, whether it's a standalone server or a clustered setup.\",\"breadcrumb\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#primaryimage\",\"url\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"contentUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accuweb.cloud\/resource\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Connect a Java with MariaDB\/MySQL\/Percona?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\",\"url\":\"https:\/\/accuweb.cloud\/resource\/\",\"name\":\"AccuWeb Cloud\",\"description\":\"Cutting Edge Cloud Computing\",\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accuweb.cloud\/resource\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\",\"name\":\"AccuWeb.Cloud\",\"url\":\"https:\/\/accuweb.cloud\/resource\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg\",\"contentUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg\",\"width\":156,\"height\":87,\"caption\":\"AccuWeb.Cloud\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\",\"name\":\"Jilesh Patadiya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g\",\"caption\":\"Jilesh Patadiya\"},\"description\":\"Jilesh Patadiya, the visionary Co-Founder and Chief Technology Officer (CTO) behind AccuWeb.Cloud. Founder &amp; CTO at AccuWebHosting.com. He shares his web hosting insights on the AccuWeb.Cloud blog. He mostly writes on the latest web hosting trends, WordPress, storage technologies, and Windows and Linux hosting platforms.\",\"sameAs\":[\"https:\/\/accuweb.cloud\/resource\",\"https:\/\/www.facebook.com\/accuwebhosting\",\"https:\/\/www.instagram.com\/accuwebhosting\/\",\"https:\/\/www.linkedin.com\/company\/accuwebhosting\/\",\"https:\/\/x.com\/accuwebhosting\",\"https:\/\/www.youtube.com\/c\/Accuwebhosting\"],\"url\":\"https:\/\/accuweb.cloud\/resource\/author\/accuwebadmin\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Connect Java to MySQL and MariaDB | AccuWeb.Cloud guide","description":"Learn how to connect your Java application to MariaDB, MySQL, and Percona databases, whether it's a standalone server or a clustered setup.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb","og_locale":"en_US","og_type":"article","og_title":"How to Connect a Java with MariaDB\/MySQL\/Percona?","og_description":"Learn how to connect your Java application to MariaDB, MySQL, and Percona databases, whether it's a standalone server or a clustered setup.","og_url":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb","og_site_name":"AccuWeb Cloud","article_modified_time":"2026-02-19T05:15:22+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#article","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb"},"author":{"name":"Jilesh Patadiya","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58"},"headline":"How to Connect a Java with MariaDB\/MySQL\/Percona?","datePublished":"2024-05-22T11:09:57+00:00","dateModified":"2026-02-19T05:15:22+00:00","mainEntityOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb"},"wordCount":814,"publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","inLanguage":"en-US"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb","url":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb","name":"Connect Java to MySQL and MariaDB | AccuWeb.Cloud guide","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/#website"},"primaryImageOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#primaryimage"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","datePublished":"2024-05-22T11:09:57+00:00","dateModified":"2026-02-19T05:15:22+00:00","description":"Learn how to connect your Java application to MariaDB, MySQL, and Percona databases, whether it's a standalone server or a clustered setup.","breadcrumb":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#primaryimage","url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","contentUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/accuweb.cloud\/resource\/articles\/java-connection-to-mysql-mariadb#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accuweb.cloud\/resource\/"},{"@type":"ListItem","position":2,"name":"How to Connect a Java with MariaDB\/MySQL\/Percona?"}]},{"@type":"WebSite","@id":"https:\/\/accuweb.cloud\/resource\/#website","url":"https:\/\/accuweb.cloud\/resource\/","name":"AccuWeb Cloud","description":"Cutting Edge Cloud Computing","publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accuweb.cloud\/resource\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/accuweb.cloud\/resource\/#organization","name":"AccuWeb.Cloud","url":"https:\/\/accuweb.cloud\/resource\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/","url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg","contentUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg","width":156,"height":87,"caption":"AccuWeb.Cloud"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58","name":"Jilesh Patadiya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g","caption":"Jilesh Patadiya"},"description":"Jilesh Patadiya, the visionary Co-Founder and Chief Technology Officer (CTO) behind AccuWeb.Cloud. Founder &amp; CTO at AccuWebHosting.com. He shares his web hosting insights on the AccuWeb.Cloud blog. He mostly writes on the latest web hosting trends, WordPress, storage technologies, and Windows and Linux hosting platforms.","sameAs":["https:\/\/accuweb.cloud\/resource","https:\/\/www.facebook.com\/accuwebhosting","https:\/\/www.instagram.com\/accuwebhosting\/","https:\/\/www.linkedin.com\/company\/accuwebhosting\/","https:\/\/x.com\/accuwebhosting","https:\/\/www.youtube.com\/c\/Accuwebhosting"],"url":"https:\/\/accuweb.cloud\/resource\/author\/accuwebadmin"}]}},"_links":{"self":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/41829","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/types\/faq"}],"author":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/comments?post=41829"}],"version-history":[{"count":16,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/41829\/revisions"}],"predecessor-version":[{"id":53229,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/41829\/revisions\/53229"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/media\/52879"}],"wp:attachment":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/media?parent=41829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}