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;
 }
 }

}

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