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

[bu...@apache.org]

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: tomcat-dev@jakarta.apache.org
        ReportedBy: Andrew.Premdas@man.ac.uk


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: tomcat-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-dev-help@jakarta.apache.org