Discussions

EJB programming & troubleshooting: How many SQL calls will the weblogic container makes ?

Bookmark and Share Get thread feed

  1. How many SQL calls will the weblogic container makes ? (2 messages)

    • Posted by: Mayank Nain
    • Posted on: August 25 2000 11:38 EDT
    How many SQL calls will the weblogic conatiner makes to the database if there is one entity beans having six CMP fields,
    while creating the bean?

    The reason I am asking this question.
    The number of connection in DB pool in Properties files is one and when I start Creating Bean from the client two more connection are created. Wondering Why??

    Mayank
    Reply to this

    Threaded Messages (2)

  2. How many SQL calls will the weblogic container makes ?[ Go to top ]

    Mayank,

    You might want to read the article that Floyd found:

    CMP Performace problems.

    You'd be surprised...

    Robert
    Reply to this Reply to original

  3. How many SQL calls will the weblogic container makes ?[ Go to top ]

    To answer the question about why weblogic makes two more connections, your weblogic.properties file probably has the capacityIncrement set as follows:

    weblogic.jdbc.connectionPool.oraclePool=\
            url=jdbc:weblogic:oracle,\
            driver=weblogic.jdbc.oci.Driver,\
            loginDelaySecs=1,\
            initialCapacity=4,\
            maxCapacity=10,\
            capacityIncrement=2,\
            allowShrinking=true,\
            shrinkPeriodMins=15,\
            refreshMinutes=10,\
            testTable=dual,\
            props=user=UserName;password=password;server=DBName
    Reply to this Reply to original