Advertisement
Guest User

Untitled

a guest
Feb 17th, 2017
171
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.87 KB | None | 0 0
  1. public Connection getConnectionFromLocation(String dbType, int incr) {
  2. Connection con = null;
  3. try {
  4. if (dbType.equalsIgnoreCase("hyd1")) {
  5. Class.forName("net.sourceforge.jtds.jdbc.Driver");
  6. con = DriverManager.getConnection("jdbc:jtds:sqlserver://1xx.xx.0.xx/chvNew2015", "ccc", "sdfds");
  7. }
  8. } catch (Exception e) {
  9. logger.error("Exception:", e);
  10. if ((e.toString().contains("No suitable driver found") || e.toString().contains("Cannot open database")|| e.toString().contains("Communications link failure") || e.toString().contains("Deadlock found when trying to get lock")|| e.toString().contains("Connection reset")) && incr < 20) {
  11. logger.info("Again trying to load driver for " + dbType + " and attempt is " + incr);
  12. con = null;
  13. try{
  14. DriverManager.deregisterDriver(new net.sourceforge.jtds.jdbc.Driver());
  15. logger.info("Successfully deregisterDriver..... ");
  16. DriverManager.registerDriver(new net.sourceforge.jtds.jdbc.Driver());
  17. logger.info("Successfully registerDriver..... ");
  18. }catch(Exception exx){
  19. logger.error("Not Successfully deregisterDriver..... ",exx);
  20. }
  21. incr++;
  22. try{
  23. TimeUnit.SECONDS.sleep(30);
  24. }catch(Exception exp){}
  25. getConnectionFromLocation(dbType, incr);
  26. } else {
  27. logger.info("Connection issue triggered......please check connection details.");
  28. con = null;
  29. }
  30. }
  31. return con;
  32. }
  33.  
  34. 19086332 16 Feb 2017 22:31:00,667 - ERROR prg.db.SourceConn:483 -getConnectionFromLocation - Exception:
  35. java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://1xx.xx.0.xx/chvNew2015
  36. at java.sql.DriverManager.getConnection(DriverManager.java:689)
  37. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  38. at prg.db.SourceConn.getConnectionFromLocation(SourceConn.java:459)
  39. at com.progen.execution.EtlLoadForJKP.LoadForGMCData(EtlLoadForJKP.java:2252)
  40. at prg.reportscheduler.LoadSchedulerJob$24.run(LoadSchedulerJob.java:2270)
  41. at java.util.TimerThread.mainLoop(Timer.java:555)
  42. at java.util.TimerThread.run(Timer.java:505)
  43. 19086333 16 Feb 2017 22:31:00,668 - ERROR prg.db.SourceConn:485 -getConnectionFromLocation - Again trying to load driver for gmchims2015 and attempt is 0
  44. 19116333 16 Feb 2017 22:31:30,668 - ERROR prg.db.SourceConn:483 -getConnectionFromLocation - Exception:
  45. java.sql.SQLException: No suitable driver found for jdbc:jtds:sqlserver://1xx.xx.0.xx/chvNew2015
  46. at java.sql.DriverManager.getConnection(DriverManager.java:689)
  47. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  48. at prg.db.SourceConn.getConnectionFromLocation(SourceConn.java:459)
  49. at prg.db.SourceConn.getConnectionFromLocation(SourceConn.java:490)
  50. at com.progen.execution.EtlLoadForJKP.LoadForGMCData(EtlLoadForJKP.java:2252)
  51. at prg.reportscheduler.LoadSchedulerJob$24.run(LoadSchedulerJob.java:2270)
  52. at java.util.TimerThread.mainLoop(Timer.java:555)
  53. at java.util.TimerThread.run(Timer.java:505)
  54.  
  55. 19686362 16 Feb 2017 22:41:00,697 - ERROR prg.db.SourceConn:492 -getConnectionFromLocation - Connection issue triggered......please check connection details.
  56. Feb 16, 2017 10:41:00 PM org.apache.catalina.loader.WebappClassLoaderBase findResourceInternal
  57. INFO: Illegal access: this web application instance has been stopped already. Could not load META-INF/javamail.providers. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
  58. 19686417 16 Feb 2017 22:41:00,752 - ERROR prg.reportscheduler.LoadSchedulerJob:3238 -sendSchedulerEtlFailedMail - Exception:
  59. java.lang.NullPointerException
  60. at org.apache.catalina.loader.WebappClassLoaderBase.getResourceAsStream(WebappClassLoaderBase.java:1672)
  61. at java.lang.Class.getResourceAsStream(Class.java:2223)
  62. at javax.mail.Session$4.run(Session.java:1193)
  63. at java.security.AccessController.doPrivileged(Native Method)
  64. at javax.mail.Session.getResourceAsStream(Session.java:1190)
  65. at javax.mail.Session.loadResource(Session.java:1082)
  66. at javax.mail.Session.loadAllResources(Session.java:1162)
  67. at javax.mail.Session.loadProviders(Session.java:886)
  68. at javax.mail.Session.<init>(Session.java:210)
  69. at javax.mail.Session.getInstance(Session.java:232)
  70. at prg.util.PbMail.sendMail(PbMail.java:136)
  71. at prg.reportscheduler.LoadSchedulerJob.sendSchedulerEtlFailedMail(LoadSchedulerJob.java:3223)
  72. at com.progen.execution.EtlLoadForJKP.LoadForGMCData(EtlLoadForJKP.java:2719)
  73. at prg.reportscheduler.LoadSchedulerJob$24.run(LoadSchedulerJob.java:2270)
  74. at java.util.TimerThread.mainLoop(Timer.java:555)
  75. at java.util.TimerThread.run(Timer.java:505)
  76. Feb 16, 2017 10:41:00 PM org.apache.catalina.loader.WebappClassLoaderBase loadClass
  77. INFO: Illegal access: this web application instance has been stopped already. Could not load com.progen.scheduler.ScheduleLogger. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to attempt to terminate the thread which caused the illegal access, and has no functional impact.
  78. java.lang.IllegalStateException
  79. at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1743)
  80. at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1701)
  81. at prg.reportscheduler.LoadSchedulerJob.sendSchedulerEtlFailedMail(LoadSchedulerJob.java:3239)
  82. at com.progen.execution.EtlLoadForJKP.LoadForGMCData(EtlLoadForJKP.java:2719)
  83. at prg.reportscheduler.LoadSchedulerJob$24.run(LoadSchedulerJob.java:2270)
  84. at java.util.TimerThread.mainLoop(Timer.java:555)
  85. at java.util.TimerThread.run(Timer.java:505)
  86.  
  87. Exception in thread "Timer-8" java.lang.NoClassDefFoundError: com/progen/scheduler/ScheduleLogger
  88. at prg.reportscheduler.LoadSchedulerJob.sendSchedulerEtlFailedMail(LoadSchedulerJob.java:3239)
  89. at com.progen.execution.EtlLoadForJKP.LoadForGMCData(EtlLoadForJKP.java:2719)
  90. at prg.reportscheduler.LoadSchedulerJob$24.run(LoadSchedulerJob.java:2270)
  91. at java.util.TimerThread.mainLoop(Timer.java:555)
  92. at java.util.TimerThread.run(Timer.java:505)
  93. Caused by: java.lang.ClassNotFoundException: com.progen.scheduler.ScheduleLogger
  94. at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1858)
  95. at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1701)
  96. ... 5 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement