Jeff, I dont use JNDI for dbs, got my own, but its sounds like you just not
configuring some xml somewhere...
On your system have a look at this link...
http://localhost:8080/tomcat-docs/jndi-datasource-examples-howto.html
As I said, no expert, but you can see that in the server.xml, thats where
the pool is actually
setup. So those setting will say create 20 dB connections. This is done so
that your app reacts quickly.
Then in Web.xml, just looks like a mapping of the pool objects to a database
object...
and then finally your application will get the context, which really just
grabs a connection from the pool, and returns it as a javax.sql.DataSource
to your application.
Anyway have a look at that and if you think you have it all, post the equiv
snippets of your config, and I'm sure the guru's will spot the problem.
If I had to guess, I think your problem is in server.xml, because when you
do it yourself, thats where it should have happened.
ie when the server starts up, it will make the pool.... and thats probably
why it kills the pool every time its started.
good luck...
----- Original Message -----
From: "Jeffrey C. Baldwin" <[EMAIL PROTECTED]>
To: <users@tomcat.apache.org>
Sent: Thursday, June 14, 2007 4:46 PM
Subject: Data Sources Overwritten
(Tomcat 5.0.28 running on CentOS 4.4 using Java 1.4.2_14-b05)
Hello All,
I have a problem with my understanding of data sources within Tomcat.
I have an application (MRS). I deploy MRS using the Tomcat Manager. I
then open up Tomcat Administration and I see MRS under:
Tomcat Server - Service (Catalina) - Host (localhost) - Context (mrs)
I then open up Resources -> Data Sources, and I 2 data source entries
have been crated (mssql & db2), however their configuration information
(url, driver class, etc..) is complete empty. And, of course, the
application doesn't work because the JDBC calls are broken.
I go in, using the Administration tool again, configure the data
sources, providing URL, driver class, etc.. commit the changes and
everything works great.
THIS IS WHERE THE PROBLEM comes in, it all works great until we deploy
the application again. Then the application, when deployed, just
overwrites all the data source information and I'm forced to enter it
all again for the app to work.
I, using the Administration tool, tried putting the data source entries
in for the entire Tomcat Server (Tomcat Server - Resources - Data
Sources) versus putting them in for the specific application. However,
the app. still dosen't work.
My question is, how do I make these data source entires 'stay put', so
that when the app is redeployed it can still make the JDBC calls?
Obviously I don't want to have to keep putting these in every time the
app is deployed.
All help is appreciated.
-jeff
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
