Brilliant, I didn't see this in any of the documentation that read.
Thanks for the help
Francis
Mark Thomas wrote:
Francis Judge wrote:
I'm editing the context.xml in the application's MET-INF directory. The
following is what it contains:
Resource name="*DB/TMS*" auth="*Container*"
type="*javax.sql.DataSource*" username="*********" password="*********"
driverClassName="*net.sourceforge.jtds.jdbcx.JtdsDataSource*"
url="*jdbc:jtds:sqlserver://localhost:1433;DatabaseName=TMS*"
maxActive="*8*" maxIdle="*1*" removeAbandoned="*true*"
I have not set the 'unpackWARs' option anywhere but I deploy through the
tomcat administrative console.
You are editing the wrong file. When a web application is first
deployed, any META-INF/context.xml is copied to
CATALINA_BASE/conf/<enginename>/<hostname> (usually
CATALINA_BASE/conf/Catalina/localhost) and renamed to appName.xml. Eg
for a war file named myapp.war a META-INF/context.xml would be renamed
to myapp.xml#
Edit the copy of the context.xml file and all will work as you expect.
Mark
Mark Thomas wrote:
Francis Judge wrote:
I am using Tomcat 6.0.18 and am using jTDS to connect to SQL Server
2005. The application is working fine in development (I'm using Netbeans
6.5) and I build the WAR from the IDE at the moment. When I deploy the
WAR to the test server
How do you deploy your WAR? Is unpackWARs true or false?
I update the context.xml to point the database
Exactly which file do you edit?
connection URL to the testing SQL Server, and restart the application
server. But, the DataSource is still using the settings from the WAR
that I deployed and not reading the new values that I changed in the
context.xml. If I put the testing details into the context.xml before I
build the WAR then they are the ones used and everything works
correctly. Surely this is not how Tomcat is intended to behave?
It may not be how you intended Tomcat to behave. How Tomcat should
behave will depend on the answers to the questions above.
Mark
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
