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
_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user