[jboss-user] [JCA/JBoss] - Performance Vows ?

jsbhangra do-not-reply at jboss.com
Thu Jul 19 00:59:34 EDT 2007


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
  | ))




View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4065637#4065637

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4065637



More information about the jboss-user mailing list