Guest User

Untitled

a guest
Jun 1st, 2018
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.96 KB | None | 0 0
  1. atlas-mvn install:install-file -Dfile=D:jdbcojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.4 -Dpackaging=jar
  2.  
  3. <dependency>
  4. <groupId>com.oracle</groupId>
  5. <artifactId>ojdbc6</artifactId>
  6. <version>11.2.0.4</version>
  7. <scope>provided</scope>
  8. </dependency>
  9.  
  10. public Connection getNewConnection() {
  11. Connection connection = null;
  12. try {
  13. Class.forName("oracle.jdbc.OracleDriver");
  14. }
  15. catch (Exception exception) {
  16. logger.error("class DataBaseMethod function getNewConnection(): exception = " + exception);
  17. }
  18. try {
  19. Class.forName("oracle.jdbc.driver.OracleDriver");
  20. }
  21. catch (Exception exception) {
  22. logger.error("class DataBaseMethod function getNewConnection(): exception = " + exception);
  23. }
  24. try {
  25. logger.debug("class DataBaseMethod function getNewConnection(): isDriversRegistered() = " + isDriversRegistered());
  26. }
  27. catch (Exception exception) {
  28. logger.error("class DataBaseMethod function getNewConnection(): exception = " + exception);
  29. }
  30. try {
  31. String url = "..";
  32. String login = "..";
  33. String password = "..";
  34. connection = DriverManager.getConnection(url, login, password);
  35. } catch (Exception exception) {
  36. logger.error("class DataBaseMethod function getNewConnection(): exception.getStackTrace()[0].getLineNumber() = " + exception.getStackTrace()[0].getLineNumber());
  37. logger.error("class DataBaseMethod function getNewConnection(): exception = " + exception);
  38. }
  39. return connection;
  40. }
  41.  
  42. private boolean isDriversRegistered(){
  43. boolean isRegistered = false;
  44. Enumeration<Driver> loadedDrivers = DriverManager.getDrivers();
  45. while(loadedDrivers.hasMoreElements()){
  46. Driver driver = loadedDrivers.nextElement();
  47. logger.debug("class DataBaseMethod function isDriverRegistered: driver.getClass().getName " + driver .getClass().getName(), log);
  48. isRegistered = true;
  49. }
  50. return isRegistered;
  51. }
  52.  
  53. 2018-06-01 21:03:10.296 [ERROR]: class DataBaseMethod function getNewConnection(): exception = java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver not found by com.test.test [276]
  54. 2018-06-01 21:03:10.296 [ERROR]: class DataBaseMethod function getNewConnection(): exception = java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver not found by com.test.test [276]
  55. 2018-06-01 21:03:10.311 [ERROR]: class DataBaseMethod function getNewConnection(): isDriverRegistered() = false
  56. 2018-06-01 21:03:10.311 [ERROR]: class DataBaseMethod function getNewConnection(): exception.getStackTrace()[0].getLineNumber() = 689
  57. 2018-06-01 21:03:10.311 [ERROR]: class DataBaseMethod function getNewConnection(): exception = java.sql.SQLException: No suitable driver found for jdbc:oracle:thin://..
Add Comment
Please, Sign In to add comment