[Opensource] min/max db connections?

larry hamel expresso at codeguild.com
Wed Jul 10 11:20:07 PDT 2002


sorry if these are dumb questions: 

expresso-config.xml has a <jdbc> tag which contains connection-pool information.  however, this tag doesn't seem to have min/max settings for the number of connections, though these limits are mentioned in the edg.pdf doc pg. 14 (see <jdbc> attribute list quoted at bottom).  

meanwhile, the unused <data-sources> tag in struts-config.xml does have min/max attributes, but expresso doesn't use this, right?

** how can I control the DB connection pool min/max number of connections?  

** what are the defaults? (I ran into a problem that after 3 days of no hits, my DB connection pool could not instantiate a connection.)


thanks,

larry


--------------------

<!ATTLIST jdbc
        driver CDATA #REQUIRED
        url CDATA #REQUIRED
        connectFormat %ConnectFormat; #REQUIRED
        login CDATA #REQUIRED
        password CDATA #REQUIRED
        cache %Boolean; #REQUIRED
        dbTest CDATA #IMPLIED
        dateSelectFormat CDATA #IMPLIED
        dateSelectFunction CDATA #IMPLIED
        dateUpdateFormat CDATA #IMPLIED
        dateUpdateFunction CDATA #IMPLIED
        timeSelectFormat CDATA #IMPLIED
        timeSelectFunction CDATA #IMPLIED
        timeUpdateFormat CDATA #IMPLIED
        timeUpdateFunction CDATA #IMPLIED
        dateTimeSelectFormat CDATA #IMPLIED
        dateTimeSelectFunction CDATA #IMPLIED
        dateTimeUpdateFormat CDATA #IMPLIED
        dateTimeUpdateFunction CDATA #IMPLIED
        dbStats %Boolean; #IMPLIED
        createTableIndicies %Boolean; #IMPLIED
        limitationPosition CDATA #IMPLIED
        limitationSyntax CDATA #IMPLIED
        uniqueRowKeyword CDATA #IMPLIED
        checkZeroUpdate %Boolean; #IMPLIED
        useNullOnCreate %Boolean; #IMPLIED
        hasBooleanType %Boolean; #IMPLIED
>




More information about the Opensource mailing list