Tomcat doubts

[André Vila Cova <an...@gmail.com>]

Hi!

Do you have 2 minutes of your time to explain me some doubts?
Well, first of all:

I'm trying to understand diffent configuration files. What's exactly the
goal of ROOT.xml, database.properties and datasource.properties?

../conf/Catalina/localhost/ROOT.xml


<Context  docBase="/alert/production/apps/teste"  path="" >
   <Resource name="ehr" auth="Container" type="
oracle.jdbc.pool.OracleDataSource"
      factory="oracle.jdbc.pool.OracleDataSourceFactory"
      driverClassName="oracle.jdbc.OracleDriver"

url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(protocol=tcp)(host=xxxx)(port=1521))(ADDRESS=(protocol=tcp)(host=xxxxx)(port=1521))(load_balance=on)(connect_data=(service_name=xxx)))"
      user="xxx" password="xxx" connectionCachingEnabled="true"/>
 <Manager className="org.apache.catalina.session.StandardManager"
maxActiveSessions="-1" maxInactiveInterval="1800"
processExpiresFrequency="6" />
</Context>

../WEB-INF/classes/database.properties


#Database configuration parameters
cache = true
user = aol
pass = goose
url = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(protocol=tcp)(host=
192.168.40.17)(port=1521))(ADDRESS=(protocol=tcp)(host=192.168.40.18
)(port=1521))(load_balance=on)(connect_data=(service_name=EHR)))

../WEB-INF/classes/datasource.properties

#DataSource configuration parameters
InitialLimit = 10
MinLimit = 10
MaxLimit = 50
PropertyCheckInterval = 120

What's the best way to connect to Oracle? Using jdbc connection like I use?
and about connection poolling? How can I setup a pool of connections?

If a Oracle package be invalid I need to reset connections???

What's the best free tool to monitor tomcat? I want to monitor time of
executions...

Thanks for your time...
A.

Re: Tomcat doubts

[David Smith <dn...@cornell.edu>]

ROOT.xml defines the ROOT context to tomcat for deployment.  ROOT is a 
special context referring to the default context accepting requests when 
no other webapp handles it.

The other two files (database.properties and datasource.properties) are 
specific to your ROOT webapp by all appearances. 

I highly recommend you get a good current, book on tomcat and checkout 
the tomcat website for further docs.


--David

André Vila Cova wrote:

>Hi!
>
>Do you have 2 minutes of your time to explain me some doubts?
>Well, first of all:
>
>I'm trying to understand diffent configuration files. What's exactly the
>goal of ROOT.xml, database.properties and datasource.properties?
>
>../conf/Catalina/localhost/ROOT.xml
>
>
><Context  docBase="/alert/production/apps/teste"  path="" >
>   <Resource name="ehr" auth="Container" type="
>oracle.jdbc.pool.OracleDataSource"
>      factory="oracle.jdbc.pool.OracleDataSourceFactory"
>      driverClassName="oracle.jdbc.OracleDriver"
>
>url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(protocol=tcp)(host=xxxx)(port=1521))(ADDRESS=(protocol=tcp)(host=xxxxx)(port=1521))(load_balance=on)(connect_data=(service_name=xxx)))"
>      user="xxx" password="xxx" connectionCachingEnabled="true"/>
> <Manager className="org.apache.catalina.session.StandardManager"
>maxActiveSessions="-1" maxInactiveInterval="1800"
>processExpiresFrequency="6" />
></Context>
>
>../WEB-INF/classes/database.properties
>
>
>#Database configuration parameters
>cache = true
>user = aol
>pass = goose
>url = jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(protocol=tcp)(host=
>192.168.40.17)(port=1521))(ADDRESS=(protocol=tcp)(host=192.168.40.18
>)(port=1521))(load_balance=on)(connect_data=(service_name=EHR)))
>
>../WEB-INF/classes/datasource.properties
>
>#DataSource configuration parameters
>InitialLimit = 10
>MinLimit = 10
>MaxLimit = 50
>PropertyCheckInterval = 120
>
>What's the best way to connect to Oracle? Using jdbc connection like I use?
>and about connection poolling? How can I setup a pool of connections?
>
>If a Oracle package be invalid I need to reset connections???
>
>What's the best free tool to monitor tomcat? I want to monitor time of
>executions...
>
>Thanks for your time...
>A.
>
>  
>


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org