Tomcat connection pooling, and changing the DB -


having little trouble tomcat. have tomcat application exposing soap interface data needs soap interface. far. in test working fine.

when install there issue. want change db connection point live db box. have edited context.xml , reloaded application. in fact have shutdown , restarted tomcat, in case.

here origonal context

    <context>    <resource name="jdbc/tclsms" auth="container" type="oracle.jdbc.pool.oracledatasource"                maxactive="20" maxidle="10" maxwait="100"                user="***" password="***" driverclassname="oracle.jdbc.oracledriver"                url="jdbc:oracle:thin:@tcl-sms:1521:smf"                factory="oracle.jdbc.pool.oracledatasourcefactory"                />    <!-- factory="org.apache.commons.dbcp.basicdatasourcefactory" -->             </context> 

then change

<context>    <resource name="jdbc/tclsms" auth="container" type="oracle.jdbc.pool.oracledatasource"                maxactive="20" maxidle="10" maxwait="100"                user="***" password="***" driverclassname="oracle.jdbc.oracledriver"                url="jdbc:oracle:thin:@10.40.125.150:1521:smf"                factory="oracle.jdbc.pool.oracledatasourcefactory"                />    <!-- factory="org.apache.commons.dbcp.basicdatasourcefactory" -->             </context> 

(passwords , users not * in real setup)

any way after making change , doing reload. error , in error telling me can't resolve tcl-sms.

is there reason tomcat not loading new context.xml

more info have deployed via war file has origonal context.xml. after deploying have gone webapps folder , edited context.

the test system ubuntu , live system solaris (if makes difference)

found problem. thought i'd better post here in-case 1 else runs same thing.

here happened. after deployment tomcat created folder in webapps. folder named after app , had meta-inf , web-inf folders. in there found context.xml , happily began editing.

yet still looking wrong db host. did next grep host in tomcat dir. nothing thought file must not defined other in war file. wrong. there context.xml app did not have read permissions grep failed.

then found http://tomcat.10.x6.nabble.com/context-xml-not-read-td2116658.html. turns out there pre-existing context.xml webapp in $catalina_base/conf///.xml

edited file , it's working. not sure why tomcat this....


Comments

Popular posts from this blog

python - How to create a legend for 3D bar in matplotlib? -

java - Multi-Label Document Classification -

php - Dynamic url re-writing using htaccess -