[Spacewalk-list] Problems starting tomcat/taskomatic

[Jesus Rodriguez]

On Wed, Jul 23, 2008 at 03:53:48PM -0700, David Patterson wrote:
> I'm pretty sure I have everything installed correctly.   However, things 
> aren't starting as they should.
>
> Here are some errros from the rhn_taskomatic_daemon.log log:
>
> [Thread-0] FATAL org.hibernate.connection.C3P0ConnectionProvider - JDBC 
> Driver class not found: oracle.jdbc.driver.OracleDriver
>

[error snipped]

> However:
> [root at undertaker tomcat5]# rpm -qa | grep oracle
> oracle-instantclient-odbc-10.2.0.4-1
> oracle-instantclient-basic-10.2.0.4-1
> oracle-instantclient-sqlplus-10.2.0.4-1
> oracle-instantclient-devel-10.2.0.4-1
> oracle-lib-compat-10.2-3.fc9
> rhn-oracle-jdbc-1.0-14.fc9
> oracle-instantclient-jdbc-10.2.0.4-1
> rhn-oracle-jdbc-tomcat5-1.0-14.fc9
>
> I made sure the ojdbc14.jar link was pointing to my oracle-instantclient 
> ojdbc14.jar file.   The oracle db is on a seperate server, however, and 
> not OracleXE.
>
>
> This is a RHEL5.2 fully updated on x86.    I'm lost at this point.

So we're dealing with an external Oracle database on a 32-bit RHEL 5.2.
That's good. We'll need to verify a few things:

ls -l /var/lib/tomcat5/webapps/rhn/WEB-INF/lib/ojdbc14.jar

mine points to: 

lrwxrwxrwx 1 root root 45 Jul 16 10:54
/var/lib/tomcat5/webapps/rhn/WEB-INF/lib/ojdbc14.jar ->
/usr/lib/oracle/10.2.0/client/lib/ojdbc14.jar

rpm -q --whatprovides /usr/lib/oracle/10.2.0/client/lib/ojdbc14.jar
oracle-instantclient-basic-10.2.0.4-1.i386

Also ensure there are no other odjbc*.jar files under /var/lib/tomcat5/
directory like in common/lib or server/lib.

-- 
jesus m. rodriguez     | jesusr at redhat.com
sr. software engineer  | irc: zeus
red hat network        | 919.754.4413 (w)
rhce # 805008586930012 | 919.623.0080 (c)
+-------------------------------------------+
|  "Those who cannot learn from history     |
|   are doomed to repeat it."               |
|                       -- George Santayana |
+-------------------------------------------+