[Spacewalk-list] Problems starting tomcat/taskomatic

[David Patterson]

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

Which, I believe leads to this from the catalina.out log errors:

INFO: Initializing c3p0 pool...  
com.mchange.v2.c3p0.PoolBackedDataSource at cab854  
[ connectionPoolDataSource ->  
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource at 83020  
[ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay  
-> 1000, autoCommitOnClose -> false, automaticTestTable -> null,  
breakAfterAcquireFailure -> false, checkoutTimeout -> 0,  
connectionTesterClassName ->  
com.mchange.v2.c3p0.impl.DefaultConnectionTester, factoryClassLocation  
-> null, forceIgnoreUnresolvedTransactions -> false, identityToken ->  
83020, idleConnectionTestPeriod -> 300, initialPoolSize -> 5,  
maxIdleTime -> 300, maxPoolSize -> 20, maxStatements -> 0,  
maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource ->  
com.mchange.v2.c3p0.DriverManagerDataSource at d964af [ description ->  
null, driverClass -> null, factoryClassLocation -> null, identityToken  
-> d964af, jdbcUrl -> jdbc:oracle:thin:@racdev2.shamrockfoods.com: 
1521:paulbear, properties -> {user=******, password=******} ],  
preferredTestQuery -> null, propertyCycle -> 300,  
testConnectionOnCheckin -> false, testConnectionOnCheckout -> false,  
usesTraditionalReflectiveProxies -> false ], factoryClassLocation ->  
null, identityToken -> cab854, numHelperThreads -> 3 ]
Jul 23, 2008 3:38:33 PM com.mchange.v2.resourcepool.BasicResourcePool 
$AcquireTask run
WARNING: com.mchange.v2.resourcepool.BasicResourcePool 
$AcquireTask at e2fbeb -- Acquisition Attempt Failed!!! Clearing pending  
acquires. While trying to acquire a needed new resource, we failed to  
succeed more than the maximum number of allowed acquisition attempts  
(30).
2008-07-23 15:38:33,393 [main] WARN  org.hibernate.cfg.SettingsFactory  
- Could not obtain connection metadata
java.sql.SQLException: Connections could not be acquired from the  
underlying database!


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.

Thanks,


David Patterson
System Engineer, Information Services
Shamrock Foods Company
Phone: (602) 477-6128