Zayin Krige

Firstly, create a method to get a connection from the pool

    private static Connection getJNDIConnection(){
        String DATASOURCE_CONTEXT = "java:comp/env/jdbc/airtime";
 
        Connection result = null;
        try {
          Context initialContext = new InitialContext();
          if ( initialContext == null){
            errorMsg = "ERROR: JNDI problem. Cannot get InitialContext.";
            return null;
          }
          DataSource datasource = (DataSource)initialContext.lookup(DATASOURCE_CONTEXT);
          if (datasource != null) {
            result = datasource.getConnection();
          }
          else {
            errorMsg = "ERROR: Failed to lookup datasource.";
            return null;
          }
        }
        catch ( Exception ex ) {
          errorMsg = "ERROR: Cannot get connection: " + ex;
          return null;
        }
        return result;
    }

Secondly, in your “sun-web.xml” and “web.xml” deployment descriptors, add a reference to the resource

sun-web.xml :

  <resource-ref>
    <res-ref-name>jdbc/airtime</res-ref-name>
    <jndi-name>jdbc/airtime</jndi-name> 
  </resource-ref>

web.xml :

    <resource-ref>
        <res-ref-name>jdbc/airtime</res-ref-name> 
        <res-type>javax.sql.DataSource</res-type> 
          <res-auth>Container</res-auth> 
          <res-sharing-scope>Shareable</res-sharing-scope> 
    </resource-ref>

Bookmark It

Hide Sites

1. Jim says:

   July 1, 2010 at 3:27 am

   Doesn’t appear to work. When the …lookup(DATASOURCE_CONTEXT) line executes, it throws this error:

   javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file: java.naming.factory.initial
2. Zayin says:

   July 1, 2010 at 6:01 am

   heres the method i created to get a connection

   ^?View Code JAVA

   private Connection getConnection() { DataSource datasource = null; try { String DATASOURCE_CONTEXT = "java:comp/env/jdbc/airtime"; javax.naming.Context initialContext = new InitialContext(); if ( initialContext == null) { errorMsg = em.MakeErrorMessage(101, null, ""); return null; } datasource = (DataSource)initialContext.lookup(DATASOURCE_CONTEXT); return datasource.getConnection(); } catch ( Exception e ) { errorMsg = em.MakeErrorMessage(102, e, ""); return null; } }