<Resource name="jdbc/tzdev10g" 
                  auth="Container"
                  type="oracle.jdbc.pool.OracleDataSource"
                  factory="oracle.jdbc.pool.OracleDataSourceFactory"
                  url="jdbc:oracle:thin:@anubis:1521:md"
                  user="tzdev"
                  password="tzdev"
                  connectionProperties="SetBigStringTryClob=true"
                  connectionCachingEnabled="true"
                  connectionCacheProperties="InactivityTimeout=1000, MinLimit=5, MaxLimit=25, InitialLimit=5, AbandonedConnectionTimeout=900, ValidateConnection=true, TimeToLiveTimeout=300, InactivityTimeout=1800, PropertyCheckInterval=60"
    />

   InitialContext iniContext =  new  InitialContext();
   Context enContext  = (Context)iniContext.lookup("java:/comp/env");
   DataSource ds = (DataSource)enContext.lookup("jdbc/tzdev10g");

   Connection connect= null ;
   PreparedStatement ps =  null ;
   ResultSet rs =  null ;

    try  { 
      Connection connect = ds.getConnection();
      ps = connection.prepareStatement("select * from D01_TREE_TYPE");
      rs = ps.executeQuery();

       while (rs.next()) {
          out.println(rs.getLong( 1 )+ " .... " + rs.getString( 2 ));
      } 
   }  catch  (Exception e) {e.printStackTrace(out);}
   }  finally  { 
             if  (rs !=  null ) {
                 try  { rs.close(); }  catch  (SQLException e) { ; }
                rs =  null ;
            }
             if  (ps !=  null ) {
                 try  { ps.close(); }  catch  (SQLException e) { ; }
                ps =  null ;
            }
             if  (connection !=  null ) {
                 try  { connection.close(); }  catch  (SQLException e) { ; }
                connection =  null ;
            }
   }

DT	EV
 09 . 08 . 2007   10 : 48 : 10 	logon
 09 . 08 . 2007   10 : 48 : 10 	logoff
 09 . 08 . 2007   10 : 48 : 10 	logon
 09 . 08 . 2007   10 : 48 : 10 	logoff
 09 . 08 . 2007   10 : 48 : 10 	logon
 09 . 08 . 2007   10 : 48 : 10 	logoff