Performance Vows ?
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 ))
