I'm not sure this explains your problem, but the property "maxIdol" should
probably be "maxIdle".
On Wed, 5 Mar 2003, Chris Allen wrote:
> All,
>
> I am having trouble utilizing DBCP in Struts 1.0.2.
>
> My datasource tag in struts-config.xml looks something
> like this:
>
> ------------
>
> <data-source key="conPool"
> type="org.apache.commons.dbcp.BasicDataSource">
> <set-property
> property="driverClassName"
> value="oracle.jdbc.driver.OracleDriver" />
> <set-property
> property="url"
> value="jdbc:oracle:thin:@{mydomain
> here}:1521:{my sid here}" />
> <set-property
> property="username"
> value="xxxxxxx" />
> <set-property
> property="password"
> value="xxxxxxx" />
> <set-property
> property="maxActive"
> value="25" />
> <set-property
> property="maxIdol"
> value="6" />
> <set-property
> property="maxWait"
> value="-1" />
> <set-property
> property="removeAbandoned"
> value="true" />
> <set-property
> property="removeAbandonedTimeout"
> value="60" />
> <set-property
> property="defaultAutoCommit"
> value="false" />
> <set-property
> property="defaultReadOnly"
> value="false" />
> <set-property
> property="validationQuery"
> value="select SYSDATE from dual" />
>
> </data-source>
>
> ---------------
>
> I access the datasource by doing the following:
>
> +++++++++++++++
>
> // all of my actions have this equivalent
> DataSource ds = servlet.findDataSource("conPool");
>
> try {
> con = ds.getConnection();
> LogonDAO logonDAO = new LogonDAO(con);
> // the DAO object use the con for
> PreparedStatements
> user = logonDAO.logon(pUser);
> }
> catch(Exception e) {
> throw e;
> }
> finally {
> try {
> con.close()
> }
> catch(SQLException sqle) {
> throw sqle;
> }
> }
>
> +++++++++++++++
>
> When I loadtest with JMeter, and assign 3 Virtual
> Users, it will open no more than 1 db connection per
> user (3 conns). Needless to say, its slow, and their
> doesn't seem to be much pooling going on.
>
> It must be a config issue. Where is a standard
> dbcp/struts example?
>
> Thanks in advance,
>
> Chris
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
