Using Created Databases/Database Users in Applications

Introduction

This sample demonstrates how to use databases and database users created through WSO2 Storage Server, in a typical Java application that accesses a database via JDBC.

Building sample application

1. Extract the JDBC URL of the created database. 
2. Set the user name and the password of a user who is attached to the database.

3. Select appropriate JDBC Driver class based on the backend RDBMS.

   Connection connection = null;
   
   String driverClass = "com.mysql.jdbc.Driver";
   String dbUser =  "user123";
   String dbPassword = "user123";
   String jdbcUrl = "jdbc:mysql://localhost:3306/testDB";
   
   BasicDataSource ds = new BasicDataSource();
   ds.setDriverClassName(driverClass);
   ds.setUrl(jdbcUrl);
   ds.setUsername(dbUser);
   ds.setPassword(dbPassword);
   
   try {
       connection = ds.getConnection(); 
       //your code goes here
   } catch (SQLException e) {
      log.error(e);
   } finally {
      try {
           if (connection != null) {
               connection.close();
           }
       } catch (SQLException e) {
           log.error(e);
       }
   }