Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- atlas-mvn install:install-file -Dfile=D:jdbcojdbc6.jar -DgroupId=com.oracle -DartifactId=ojdbc6 -Dversion=11.2.0.4 -Dpackaging=jar
- <dependency>
- <groupId>com.oracle</groupId>
- <artifactId>ojdbc6</artifactId>
- <version>11.2.0.4</version>
- <scope>provided</scope>
- </dependency>
- public Connection getNewConnection() {
- Connection connection = null;
- try {
- Class.forName("oracle.jdbc.OracleDriver");
- }
- catch (Exception exception) {
- logger.error("class DataBaseMethod function getNewConnection(): exception = " + exception);
- }
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- }
- catch (Exception exception) {
- logger.error("class DataBaseMethod function getNewConnection(): exception = " + exception);
- }
- try {
- logger.debug("class DataBaseMethod function getNewConnection(): isDriversRegistered() = " + isDriversRegistered());
- }
- catch (Exception exception) {
- logger.error("class DataBaseMethod function getNewConnection(): exception = " + exception);
- }
- try {
- String url = "..";
- String login = "..";
- String password = "..";
- connection = DriverManager.getConnection(url, login, password);
- } catch (Exception exception) {
- logger.error("class DataBaseMethod function getNewConnection(): exception.getStackTrace()[0].getLineNumber() = " + exception.getStackTrace()[0].getLineNumber());
- logger.error("class DataBaseMethod function getNewConnection(): exception = " + exception);
- }
- return connection;
- }
- private boolean isDriversRegistered(){
- boolean isRegistered = false;
- Enumeration<Driver> loadedDrivers = DriverManager.getDrivers();
- while(loadedDrivers.hasMoreElements()){
- Driver driver = loadedDrivers.nextElement();
- logger.debug("class DataBaseMethod function isDriverRegistered: driver.getClass().getName " + driver .getClass().getName(), log);
- isRegistered = true;
- }
- return isRegistered;
- }
- 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]
- 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]
- 2018-06-01 21:03:10.311 [ERROR]: class DataBaseMethod function getNewConnection(): isDriverRegistered() = false
- 2018-06-01 21:03:10.311 [ERROR]: class DataBaseMethod function getNewConnection(): exception.getStackTrace()[0].getLineNumber() = 689
- 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