Failed to obtain database connection using quartz

[Nav een]

Hi Everyone,
I have a strange issue where i am able to connect to the database via JDBC code but not able to connect to the DB through quartz configuration. Below is the quartz configuration made for DB and also JDBC code used to connect for your reference.

Quartz Config :

org.quartz.jobStore.dataSource = myDS

org.quartz.dataSource.myDS.driver = oracle.jdbc.driver.OracleDriver
org.quartz.dataSource.myDS.URL = jdbc:oracle:thin:@<host>:<port>:<db_name>
org.quartz.dataSource.myDS.user = <user name>
org.quartz.dataSource.myDS.password = <password>
org.quartz.dataSource.myDS.maxConnections = 5
org.quartz.dataSource.myDS.validationQuery=select 0 from dual

JDBC Code :

Class.forName("oracle.jdbc.driver.OracleDriver");
	    
	        String url = "jdbc:oracle:thin:@<host>:<port>:<db_name>";
	      
	    Connection conn = 
	         DriverManager.getConnection(url,"<username>", "<password>");
	 
	    conn.setAutoCommit(false);
	    Statement stmt = conn.createStatement();
	    ResultSet rset = 
	         stmt.executeQuery("select * from QRTZ_CRON_TRIGGERS");
	    while (rset.next()) {
	         System.out.println (rset.getString(1));  
	    }
	    stmt.close();
	    System.out.println ("Ok.");  

Note : I am not displaying the db URL, username & password for security reasons. But, the URL,username & password used in the both cases are same.

[Vijitha Kumara]

Moved to "Other Open Source Projects" forum (Quartz specific).