DO NOT REPLY [Bug 30117] New: - ResourceParams ignored in default context

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=30117>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=30117

ResourceParams ignored in default context

           Summary: ResourceParams ignored in default context
           Product: Tomcat 5
           Version: 5.0.25
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Webapps:Administration
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


Setting up a DBCP pool. If I place correct <Resource> and <ResourceParams> 
tags in the default context, the params are not loaded.

If I create an application context <context ...> and place the same <Resource> 
and <ResourceParams> tags the params are now correctly loaded.

Bug or feature?

Tags in full are below just in case you need them. Location in server.xml is 
just before the </host> tag at the end of server.xml

---- tags ----

                        <Resource
                                name="jdbc/DataWarehouse"
                                auth="Container"
                                type="javax.sql.DataSource"
                        />
                
                        <ResourceParams name="jdbc/DataWarehouse">
                                <!-- Driver class and URL -->
                                <parameter>
                                   <name>factory</name>
                                   
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                                </parameter>
                                
                                <parameter>
                                   <name>driverClassName</name>
                                   <value>oracle.jdbc.OracleDriver</value>
                                </parameter>
                        
                                <parameter>
                                        <name>url</name>
                                
        <value>jdbc:oracle:thin:@acudw1.acu.man.ac.uk:1521:dw1</value>
                                </parameter>
                         
                                <!-- account details -->
                        
                                <parameter>
                                        <name>username</name>
                                        <value>web_image</value>
                                </parameter>
                        
                                <parameter>
                                        <name>password</name>
                                        <value>pr0ject</value>
                                </parameter>
                        
                                <!-- pooling controls -->
                        
                                <parameter>
                                        <name>maxActive</name>
                                        <value>20</value>
                                </parameter>
                        
                                <parameter>
                                        <name>maxIdle</name>
                                        <value>10</value>
                                </parameter>
                        
                                <parameter>
                                        <name>maxWait</name>
                                        <value>-1</value>
                                </parameter>
                                
                                <!-- prevent pool leaks -->
                                <parameter>
                                        <name>removeAbandoned</name>
                                        <value>true</value>
                                </parameter>
                                
                                <parameter>
                                        <name>removeAbandonedTimeout</name>
                                        <value>60</value>
                                </parameter>
                                
                                <parameter>
                                        <name>logAbandoned</name>
                                        <value>true</value>
                                </parameter>
                                
                        </ResourceParams>

----
put them in this context and they work

<Context 
                        path="/poolSpike" 
                        reloadable="true" 
                        docBase="C:\andy\workspace\poolSpike" 
                        workDir="C:\andy\workspace\poolSpike\work">
        

</Context>

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]