Rick,
On 3/29/24 14:05, Rick Noel wrote:
Chris,
I found I could use a ResourceLink element and put it in my context.xml file.
The name in that ResourceLink is the name of resource that I have fully defined
in my server.xml.
Sot the context.xml points to the fully define resource which is in my
server.xml
That's definitely a possibility as well.
I work on a small team and so separating the JDBC definition from the
link doesn't make much sense so we don't do it. We also don't like
polluting our server.xml file so everything goes into META-INF/context.xml.
You really should never change CATALINA_BASE/conf/context.xml, though.
-chris
So snippet from my context.xml file is.............
<Context >
<Resources allowLinking="true" />
<ResourceLink
name="jdbc/app-pool"
global="jdbc/app-pool"
type="javax.sql.DataSource" />
And snippet from my server.xml is.........
<Server port="18105" shutdown="SHUTDOWN">
<GlobalNamingResources>
<Resource name="jdbc/app-pool" auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://xxxxxxxxx"
username="xxxxx" password="xxxxxx"
maxTotal="30" maxIdle="30" maxWaitMillis="-1"
removeAbandonedOnBorrow="true"
removeAbandonedTimeout="90"
testOnBorrow="true" validationQuery="select 1"
validationQueryTimeout="30000"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="60000"
testOnReturn="true" />
Rick Noel
Systems Programmer | Westwood One
rn...@westwoodone.com
-----Original Message-----
From: Rick Noel
Sent: Friday, March 29, 2024 11:57 AM
To: Tomcat Users List <users@tomcat.apache.org>
Subject: RE: [EXT]Re: how to define database resource in just context.xml or
server.xml
If have the resource defined in
CATALINA_BASE/conf/context.xml
And
CATALINA_BASE/conf/server.xml
Rick Noel
Systems Programmer | Westwood One
rn...@westwoodone.com
-----Original Message-----
From: Christopher Schultz <ch...@christopherschultz.net>
Sent: Friday, March 29, 2024 11:47 AM
To: users@tomcat.apache.org
Subject: [EXT]Re: how to define database resource in just context.xml or
server.xml
Rick,
On 3/29/24 09:48, Rick Noel wrote:
Can someone tell me why I need to have my database source defined in
both my context.xml and server.xml? I thought we are suppose to define
it in only one location?
It's definitely not a requirement to specify it in both places.
I can only log into my app if I have it defined in both my context.xml
and server.xml
Below is my database resource as defined in server.xml..........
I have xxx out postgres URL for security reasons
<GlobalNamingResources>
<Resource name="jdbc/app-pool" auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://xxxxxxxxxxx"
username="postgres"
password="postgres4now"
maxTotal="30" maxIdle="30"
maxWaitMillis="-1"
removeAbandonedOnBorrow="true"
removeAbandonedTimeout="90"
testOnBorrow="true" validationQuery="select 1"
validationQueryTimeout="30000"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="60000"
testOnReturn="true"
/>
</GlobalNamingResources>
Below is my database resource as defined in context.xml
<Context >
<Resources allowLinking="true" />
<Resource name="jdbc/app-pool" auth="Container"
type="javax.sql.DataSource"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://xxxxxxxxxx
username="postgres" password="postgres4now"
maxTotal="30" maxIdle="30" maxWaitMillis="-1"
removeAbandonedOnBorrow="true"
removeAbandonedTimeout="90"
testOnBorrow="true" validationQuery="select 1"
validationQueryTimeout="30000"
testWhileIdle="true"
timeBetweenEvictionRunsMillis="60000"
testOnReturn="true"
/>
Which context.xml are you talking about? The one in CATALINA_BASE/context.xml
or the one in your application's META-INF/context.xml?
Have you defined your <Context> in CATALINA_BASE/conf/server.xml, or are you
using only META-INF/context.xml?
-chris
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
CAUTION: This email originated from outside of the organization. Do not click
links or open attachments unless you know the sender and you are sure the
content is safe. Please report the message using the Report Message feature in
your email client if you believe the email is suspicious.
---------------------------------------------------------------------
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
