<%@ page language="java" pageEncoding="UTF-8"%>
...
...
		<logic:present name="AllLanguageCategories" scope="request">
			<logic:notEmpty name="AllLanguageCategories" scope="request">
				<table width="100%" border="0">
					<tr>
					
					
						<%@ page  import ="com.cecito.beans.*"%>
						<%  LanguageCategoryBean[] langCatBean = (LanguageCategoryBean[])request.getAttribute("AllLanguageCategories"); %>

						<%	 int  tdCounter =  0 ;
							
							 for  ( int  i =  0 ; i < langCatBean.length; i++) {	%>
						<%  		 int  val = i - (i/ 3 )* 3 ;
						        
									 if  (val ==  0 ) { %>
										<tr>
						<% 			} %>
									<td width="33%" height="60">
									<html:link page="/welcome.jsp#">
									<%=langCatBean[i].getCategoryName() %>
									</html:link> (xx)<br>	
									<%=langCatBean[i].getCategoryDescription() %><br>	
									</td>
								<%	
									tdCounter = tdCounter +  1 ;
							}
							 if  (tdCounter< 3 ) {
								 for  ( int  i =  0 ; i <  3  - tdCounter; i++) { 
									%>
									<td> </td>
									<% 
								}
							}
						%>
						
						
						
    				</tr>
				</table>
				
</logic:notEmpty>
		</logic:present>

 public   static  LanguageCategoryBean[] getAllLanguageCategories(String langId)
         throws  SQLException {
    Connection connection =  null ;
    PreparedStatement statement =  null ;
    ResultSet resultSet =  null ;
    ArrayList languageCategoryBeans =  new  ArrayList();
     try  {

        connection = DbUtils.getConnection(Constants.DS_XXXX);

        statement = connection.prepareStatement(selAll,
                ResultSet.TYPE_SCROLL_INSENSITIVE,
                ResultSet.CONCUR_READ_ONLY);
        statement.setString( 1 , langId);

        resultSet = statement.executeQuery();

         while  (resultSet.next()) {
            LanguageCategoryBean languageCategoryBean =  new  LanguageCategoryBean(
                    resultSet);
            languageCategoryBeans.add(languageCategoryBean);
        }
    }  finally  {
         if  (resultSet !=  null )
            resultSet.close();
         if  (statement !=  null )
            statement.close();
         if  (connection !=  null )
            connection.close();
    }
    LanguageCategoryBean[] arrayLanguageCategoryBeans =  new  LanguageCategoryBean[languageCategoryBeans
            .size()];
     return  (LanguageCategoryBean[]) languageCategoryBeans
            .toArray(arrayLanguageCategoryBeans);
}

   public   static  Connection getConnection(String jdbcResourceName) {
      Connection conn =  null ;  
       try  {
          Context initCtx =  new  InitialContext();
          Context envCtx = (Context) initCtx.lookup("java:comp/env");
          oracle.jdbc.pool.OracleDataSource dss = (oracle.jdbc.pool.OracleDataSource) envCtx.lookup(jdbcResourceName);
          conn = dss.getConnection();
          

      }  catch  (Exception e) {
          e.printStackTrace();
      }
       return  conn;
  } 

<Context crossContext="true" debug="5" displayName="Xxxxx" 
         docBase="D:/JavaProjects/Project/WebRoot" path="/xxxx" reloadable="true">
  <Logger className="org.apache.catalina.logger.FileLogger" 
          prefix="localhost_xxxx." suffix=".txt" timestamp="true"/>

  <Resource name="jdbc/xxxx" auth="Container"
              type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
              url="jdbc:oracle:thin:@10.10.10.205:1521:XXXX"
              username="...." password="...." maxActive="20" maxIdle="10"
              maxWait="-1"/> 

</Context>

  <resource-ref>
      <res-ref-name>jdbc/xxxx</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>

   public   static  Connection getConnection(String jdbcResourceName) {
      Connection conn =  null ;  
       try  {
          Context initCtx =  new  InitialContext();
          Context envCtx = (Context) initCtx.lookup("java:comp/env");
          DataSource dss = (DataSource) envCtx.lookup(jdbcResourceName);
          conn = dss.getConnection();
          

      }  catch  (Exception e) {
          e.printStackTrace();
      }
       return  conn;
  }