How many SQL calls will the weblogic container makes ?

Discussions

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

  1. 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
  2. Mayank,

    You might want to read the article that Floyd found:

    CMP Performace problems.

    You'd be surprised...

    Robert
  3. 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