Tuesday, October 4, 2016

Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL

Cannot create JDBC driver of class 'oracle.jdbc.driver.OracleDriver' for connect URL 'jdbc:oracle:@devserver.ds.com:1570:APPLICATIOND'
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:278)
at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:85)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:113)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2863)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2859)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
at ......

If you happen to get the above error, it could be that the required Oracle jar might not be in Tomcat lib directory.
In the maven dependencies, I see that Oracle-jdbc-11.2.0.1.0.jar and is exporting to the wtpwebapp's application lib directory.
I fixed the issue by copying the ojdbc6.jar file to tomcat's lib directory.
Hope this helps you.

Thursday, July 21, 2016

How to enable Maven dependencies in eclipse

When I created a new maven project, some how I am not finding the Maven dependencies in the project build path add library console.
If the Maven dependencies were not added to the project, it doesnt resolve the third party jars.
If you have faced the same issue, then add the following dependency into your pom file and do a mvn clean install and the update then update the maven project configuration

How to terminate the tomcat server ports that are already in use

Following are the steps to kill the server process that is already in use in windows
Step 1: netstat -a -o -n and it will bring up a network list,search for the local address like 127.0.0.1:6060 and note the PID (eq 18508)
C:\>netstat -a -o -n or C:\>netstat -ano
Step2 : taskkill /F /PID 18508 . Run this command to kill that process.
C:\>taskkill /F /PID 18508