Guest User

Untitled

a guest
Oct 30th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.26 KB | None | 0 0
  1. [LMWJobScheduler_QuartzSchedulerThread] ERROR org.quartz.core.ErrorLogger - An error occurred while scanning for the next triggers to fire.
  2. org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [lastAcquisitionFailureDefaultUser] ] has been closed() -- you can no longer use it. [See nested exception: java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [lastAcquisitionFailureDefaultUser] ] has been closed() -- you can no longer use it.]
  3. at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:778)
  4. at org.quartz.impl.jdbcjobstore.JobStoreTX.getNonManagedTXConnection(JobStoreTX.java:71)
  5. at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3784)
  6. at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756)
  7. at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)
  8. Caused by: java.sql.SQLException: com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans.IntrospectionException: java.lang.reflect.InvocationTargetException [lastAcquisitionFailureDefaultUser] ] has been closed() -- you can no longer use it.
  9. at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.assertCpds(AbstractPoolBackedDataSource.java:447)
  10. at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(AbstractPoolBackedDataSource.java:459)
  11. at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
  12. at org.quartz.utils.PoolingConnectionProvider.getConnection(PoolingConnectionProvider.java:247)
  13. at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:108)
  14. at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:775)
  15. ... 4 more
  16.  
  17. org.quartz.scheduler.instanceName: JobScheduler
  18. org.quartz.scheduler.instanceId: AUTO
  19. org.quartz.scheduler.skipUpdateCheck: true
  20.  
  21. org.quartz.plugin.jobInitializer.class =org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin
  22. org.quartz.plugin.jobInitializer.fileNames = quartz-config.xml
  23. org.quartz.plugin.jobInitializer.failOnFileNotFound = true
  24. org.quartz.plugin.jobInitializer.wrapInUserTransaction = false
  25.  
  26. org.quartz.threadPool.class: org.quartz.simpl.SimpleThreadPool
  27. org.quartz.threadPool.threadCount: 20
  28. org.quartz.threadPool.threadPriority: 5
  29.  
  30. org.quartz.jobStore.class=org.quartz.impl.jdbcjobstore.JobStoreTX
  31. org.quartz.jobStore.driverDelegateClass=org.quartz.impl.jdbcjobstore.StdJDBCDelegate
  32. org.quartz.jobStore.useProperties=false
  33. org.quartz.jobStore.dataSource=myDS
  34. org.quartz.jobStore.tablePrefix=QRTZ_
  35. org.quartz.jobStore.isClustered=true
  36.  
  37. org.quartz.dataSource.myDS.driver: com.mysql.jdbc.Driver
  38. org.quartz.dataSource.myDS.URL: jdbc:mysql://localhost:3306/quartz
  39. org.quartz.dataSource.myDS.user: root
  40. org.quartz.dataSource.myDS.password: password
  41. org.quartz.dataSource.myDS.maxConnections: 5
  42.  
  43. <schedule>
  44. <job>
  45. <name>Hello</name>
  46. <group>HelloGroup</group>
  47.  
  48. <description>The job description</description>
  49. <job-class>HelloJob</job-class>
  50. </job>
  51. <trigger>
  52. <cron>
  53. <name>hello-trigger</name>
  54. <group>Hello_Group</group>
  55. <job-name>Hello</job-name>
  56.  
  57. <job-group>HelloGroup</job-group>
  58. <cron-expression>0/30 0/1 * 1/1 * ?</cron-expression>
  59.  
  60. </cron>
  61. </trigger>
  62. </schedule>
  63.  
  64. import org.quartz.Scheduler;
  65. import org.quartz.SchedulerException;
  66. import org.quartz.impl.StdSchedulerFactory;
  67.  
  68. public class QuartzTest {
  69. public static void main(String[] args) {
  70.  
  71. try {
  72. // Grab the Scheduler instance from the Factory
  73. Scheduler scheduler = StdSchedulerFactory.getDefaultScheduler();
  74.  
  75. // and start it off
  76. scheduler.start();
  77.  
  78. scheduler.shutdown();
  79.  
  80. } catch (SchedulerException se) {
  81. se.printStackTrace();
  82. }
  83. }
  84. }
  85.  
  86. import org.quartz.Job;
  87. import org.quartz.JobExecutionContext;
  88.  
  89. public class HelloJob implements Job {
  90. public void execute(JobExecutionContext context){
  91. System.out.println("Hello World !!!");
  92. }
  93. }
Add Comment
Please, Sign In to add comment