2 Replies Latest reply on Jul 19, 2007 7:25 AM by Adrian Brock

    Performance Vows ?

    Jasdeep Newbie

      Hi All...

      I have built a web-application , which connects to the Oracle 10g Express edition at the backend..

      I have set the maximum connection pool size to 1500 connections ..

      But while load testing according to the client requirements ,1200 requests per minute.

      The connection breaks up , which makes some requests unprocessed ..
      I have set my oracle processes to 400 ...

      Help me in performance tuning my application

      My Database Connection file is :


      
      public class Database {
      
      
       public Database() {
       }
      
      
       private static InitialContext ic=null;
       private static Context ctx=null;
       private static DataSource ds=null;
       private static Connection con=null;
       private static int makeCount=0;
       private static int dropCount=0;
      
       /**
       *Makes Connection with database Returns Connection Object
       */
      
       public synchronized static Connection makeConnection() throws Exception {
       try{
      
       InitialContext ctx = new InitialContext();
       ds = (DataSource)ctx.lookup("java:mydatasource");
       con =ds.getConnection();
      
       log.info("Data Base Connection Created Sucessfully" + ds + con);
       makeCount++;
       log.info("Connections Made"+makeCount);
       } catch (Exception e) {
       log.error("Can not create Connection :"+ e);
       }
       return con;
       }
      
       /**
       * @param Connection Object
       * Closes the database Connection
       */
      
       public synchronized static void dropConnection(Connection con) {
       try {
      
       log.info("Closing Connection");
      
       dropCount++;
       log.info("Connections Dropped"+dropCount);
      
       if ( con != null) {
       con.close();
       }
       } catch (Exception e) {
       // Could not drop connection
       e.printStackTrace();
       } finally {
       con = null;
       }
       }
      
      }
      


      I ecounter this problem ... for some requests i f i icrease the requests more than 1200 per minute ....
      ; - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Listener refused the connection with the following error:
      ORA-12519, TNS:no appropriate service handler found
      The Connection descriptor used by the client was:
      localhost:1521:XE
      ))