Architecture question: apache –>Tomcat—>Oracle DB

[Hanry Zhou]

If I understand it correctly, Tomcat is the server engine, and is to create the connection to Oracle db at the back end. My question is, how tomcat is configured to piont to a Oracle db server? and then an Oracle instance running on the server? From SA perspective,
I want to know how the configuration is done.

Do I need to install JDBC on the server where tomcat resides on?

[Steven E. Protter]

Shalom,

tomcat is a java bases server engine that can point to a back end database. It is integrated out of the box as par of hpws to connect to mysql.

It needs to be configured to connect to the Oracle database. Some kind of oracle client is required to do this. JDBC is an option as is Oracle Client for HP-UX.

SEP

[Hanry Zhou]

I would like to know the detail configuration on how tomcan can point to the database server, and the instance?

Thanks!

[Dinesh MIshra]

hi

first check the following :

# swlist | grep Tomcat
# swlist | grep JDK

if both patches are installed then it will work.
start the webcachectl

see also wheather listner is running or not

regards
Dinesh