Connection to DB via JNDI

To connect to DB using JNDI you have to perform the following steps:

  • Log onto CirrusGrid dashboard
  • Create an environment
  • Add database node into your environment
  • Modify some configuration files in a web-app
  • Create a connection in a java-class

Let’s do it step-by-step:

1. Create environment with database (MySQL in our case):connection to db via jndi env

2. Create a new user in a database:
How to create new user – click here

Database name : cirrusgridDb
User_name : cirrusgrid
Password : cirrusgrid

3. Modify configuration files in your web-application:

<Context antiJARLocking="true" path="/JNDI">
    <Resource name="jdbc/cirrusgridDb" auth="Container" type="javax.sql.DataSource"
               maxActive="100" maxIdle="30" maxWait="10000"
               username="cirrusgrid" password="cirrusgrid" driverClassName="com.mysql.jdbc.Driver"


 <description>MySQL Datasource example</description>

4. Create connection in java-class

public class MyConnection {

    private DataSource dataSource;

    public MyConnection() {
        try {

            InitialContext context = new InitialContext();
            dataSource = (DataSource) context.lookup("java:comp/env/jdbc/cirrusgridDb");

        } catch (NamingException ex) {
            Logger.getLogger(MyConnection.class.getName()).log(Level.SEVERE, null, ex);

    public Connection getConnection() {
        Connection conn = null;
        try {
            conn = dataSource.getConnection();
        } catch (SQLException ex) {
            Logger.getLogger(MyConnection.class.getName()).log(Level.SEVERE, null, ex);
        return conn;

Powered by BetterDocs