In the platform, each instance operates as an independent container. To connect your application to a database, you need to configure a connection string. This can be done using:<\/p>\n
Refer to the appropriate section below based on your environment’s engine:<\/p>\n
Refer to the table below to find the appropriate database connection code for your application:<\/p>\n
| DB Type<\/td>\n | Connection code<\/td>\n<\/tr>\n | ||||||||
| MySQL<\/a>\/MariaDB<\/a><\/td>\n | String URL = \u201cjdbc:mysql:\/\/node{node_id}-{environment_name}.{hoster_domain}\/{dbname}”;DriverManager.getConnection(URL, user_name,user_password);<\/td>\n<\/tr>\n | ||||||||
| MySQL Auto-Cluster<\/a><\/td>\n | High-availability connection using scaled dedicated ProxySQL load balancers.<\/p>\n String URL = \u201cjdbc:mysql:\/\/proxy.{environment_name} .{hoster_domain}:3306\/{dbname}”; DriverManager.getConnection(URL, user_name,user_password);<\/td>\n<\/tr>\n | ||||||||
| MariaDB Auto-Cluster<\/a><\/td>\n | High-availability connection using scaled dedicated ProxySQL load balancers.<\/p>\n String URL = \u201cjdbc:mariadb:\/\/proxy.{environment_name} .{hoster_domain}:3306\/{dbname}?usePipelineAuth=false”; DriverManager.getConnection(URL, user_name,user_password);<\/td>\n<\/tr>\n | ||||||||
| PostgreSQL<\/a><\/td>\n | String URL = \u201cjdbc:postgresql:\/\/node{node_id}-{environment_name}.{hoster_domain}\/{dbname}”; DriverManager.getConnection(URL, user_name,user_password);<\/td>\n<\/tr>\n | ||||||||
| MongoDB<\/a><\/td>\n | Mongo m = new Mongo(node{node_id}-{environment_name}.{hoster_domain}); DB db = m.getDB ({database_name}); if(db.authenticate(user_name,user_password.toCharArray())) { System.out.println(\u201cConnected!”); }<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n <\/div>\n For UTF-8 encoding, modify your connection string as follows:<\/p>\n jdbc:{dbtype}:\/\/node{node_id}-{environment_name}.{hoster_domain}\/{dbname}?useUnicode=yes&characterEncoding=UTF-8<\/strong><\/p>\n *hoster_domain:<\/strong> app.cp-accuweb.cloud<\/p>\n Depending on the database type, use the following connection code examples and adjust your application accordingly:<\/p>\n |