Getting "Failed to obtain DB connection from data source" on misfire

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Getting "Failed to obtain DB connection from data source" on misfire

popianovka
Hi,

I'm getting this exception when a job misfires:

SEVERE: MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source 'myDS': java.lang.NullPointerException
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.lang.NullPointerException [See nested exception: java.lang.NullPointerException]
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:640)
        at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3011)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3789)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:3809)
Caused by: java.lang.NullPointerException
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:633)
        ... 4 more

The funny thing is that it works flawlessly on my localhost (desktop PC) but not from our webapp server (Linux)

After a little reading, I switched my org.quartz.jobStore.class property from org.quartz.impl.jdbcjobstoreJobStoreTX to org.quartz.impl.jdbcjobstoreJobStoreCMT, and I get the identical exception.

Here are my properties:

#============================================================================
# Configure JobStore  
#============================================================================

org.quartz.jobStore.misfireThreshold = 30000

org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreCMT
org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
org.quartz.jobStore.useProperties=true
org.quartz.jobStore.dataSource=myDS
org.quartz.jobStore.nonManagedTXDataSource=myDS
org.quartz.jobStore.tablePrefix=QRTZ_
org.quartz.jobStore.isClustered=false

org.quartz.dataSource.myDS.driver = com.mysql.jdbc.Driver
org.quartz.dataSource.myDS.URL = jdbc:mysql://icptlacptdblx01:3306/jobsystem?autoReconnect=true
org.quartz.dataSource.myDS.user = ******
org.quartz.dataSource.myDS.password = *****
org.quartz.dataSource.myDS.maxConnections = 5
org.quartz.dataSource.myDS.validationQuery=

Help!!!
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=94060&messageID=161911#161911

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Getting "Failed to obtain DB connection from data source" on misfire

popianovka
false alarm.... database permissions issue.  please disperse, nothing to see here.
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=94060&messageID=161959#161959

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Getting "Failed to obtain DB connection from data source" on misfire

popianovka
I am having a similar issue :

with no dBase concerns :already checked that

stacktrace is:

[27/06/07 18:42:00:712 IST] 60c160c1 FreePool      E J2CA0046E: Method createManagedConnectionWithMCWrapper caught an exception during creation of the ManagedConnection for resource jdbc/quartz, throwing ResourceAllocationException.  Original exception: java.lang.NullPointerException
        at java.lang.Throwable.<init>(Throwable.java:54)
        at java.lang.Throwable.<init>(Throwable.java)
        at java.lang.NullPointerException.<init>(NullPointerException.java:63)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:172)
        at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:149)
        at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:95)
        at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:63)
        at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:676)
        at java.security.AccessController.doPrivileged(AccessController.java:189)
        at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:671)
        at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:440)
        at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:566)
        at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1244)
        at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1030)
        at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:1590)
        at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:658)
        at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:446)
        at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:215)
        at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:190)
        at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:160)
        at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:633)
        at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:72)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3652)
        at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3586)
        at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:971)
        at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:703)
        at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:255)
        at com.nucleus.cls.scheduler.bean.SchedulerDetailBean.makeWeeklyExpression(SchedulerDetailBean.java)
        at com.nucleus.cls.scheduler.ejb.sessionBean.SchedulerBean.schedulerAuthor(SchedulerBean.java:674)
        at com.nucleus.cls.scheduler.ejb.sessionBean.EJSLocalStatelessScheduler_e4d40fec.schedulerAuthor(EJSLocalStatelessScheduler_e4d40fec.java:407)


Please help...
---------------------------------------------------------------------
Posted via Jive Forums
http://forums.opensymphony.com/thread.jspa?threadID=94060&messageID=162220#162220

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]