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.
