I have an issue where my db connection (to Oracle 9i) times out after 90 minutes of inactivity due to a firewall. I've found a workaround by scheduling a cron job that pings my datasource. However, it only pings my connection pool, but my JDBCRealm. For my connection pool, my JDBC Driver is:
oracle.jdbc.pool.OracleConnectionPoolDataSource I tried to use this in my JDBCRealm as the driverName, but no dice. WARN [main] SessionFactoryImpl.<init>(163) | Could not obtain connection metadata java.sql.SQLException: Cannot load JDBC driver class 'null' The only thing I seem to be able to use is: oracle.jdbc.driver.OracleDriver Therefore, my realm is timeing out, whereas my pool stays active. I can't login to verify this, but it is my suspicion, especially since my DBPing can still be run, and it hits the same table as the JDBCRealm. Any ideas? Thanks, Matt --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
