[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