get Connection via JNDI and Properties - Java JNDI

Java examples for JNDI:Context

  1. HOME
  2. Java
  3. JNDI
  4. Context

Description

get Connection via JNDI and Properties

Demo Code


//package com.java2s;
import java.sql.Connection;
import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.Properties;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;

public class Main {

    public static Connection getConn(String classDriver, String url,
            String user, String pwd) {
        try {/* ww  w  . j a  v a  2s .c o m*/
            Class.forName(classDriver);
            return DriverManager.getConnection(url, user, pwd);
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return null;
    }

    public static Connection getConn(DataSource dataSource) {
        try {
            return dataSource.getConnection();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return null;
    }

    public static Connection getConn(String jndiName) {
        try {
            Context ctx;
            ctx = new InitialContext();
            DataSource dataSource = (DataSource) ctx
                    .lookup("java:comp/env/" + jndiName);
            return dataSource.getConnection();
        } catch (NamingException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return null;
    }

    public static Connection getConn(Properties properties) {
        try {
            String driver = properties.getProperty("jdbc.driverClassName");
            String url = properties.getProperty("jdbc.url");
            String user = properties.getProperty("jdbc.username");
            String password = properties.getProperty("jdbc.password");
            Class.forName(driver);
            return DriverManager.getConnection(url, user, password);
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
        return null;
    }
}

Related Tutorials