Monday, 17 August 2015

How to add Oracle JDBC Driver in Your Maven local repository

In this post i am going to show you how to install ojdbc.jar under maven local repository.

Due to Oracle license restriction, there is NO public Maven repository provides Oracle JDBC driver. To use Oracle jdbc drive with Maven, you have to install it manually into your Maven local repository.

Step 1: How to get ojdbc.jar?

  • Download ojdbc.jar from oracle website or any other websites.
  • Or you can use the ojdbc.jar from your oracle database installed directory.
Step 2: Install ojdbc.jar in Maven local Repository.

    mvn install:install-file -Dfile={Path/to/your/ojdbc.jar} 
   -DartifactId=ojdbc6 -Dversion= -Dpackaging=jar

So, For me the directory is D:\ojdbc6- So the maven install look like
mvn install:install-file -Dfile=D:\ojdbc6- 
-DartifactId=ojdbc6 -Dversion= -Dpackaging=jar

Once Your build success check the ojdbc.jar under your maven local repository.

Step 3: pom.xml

<project ...>
  <!-- ORACLE database driver -->

That's all Folks..

Monday, 4 May 2015

The service did not start due to a logon failure

Hi Guys,

In this post i am going to write some thing related to windows Services. In windows some services related with our system username and password and that service's do start based on the  credentials provided for e.g Oracle database services. So before the service get start's it will check for username and password that we initially used to install the services(software).

After some period of time if we changed the password it wont get update to the services which are using the system credentials. So lets see how to resolve this issue in windows.

The service did not start due to a logon failure - Windows Service error.

Step 1:

Go to ControlPanel --> Administrative Tools --> View local services

Step 2:

Select the service you need to update with current credentials and select properties. Go to Log On Tab shown in-below screen shot. Update the password which currently used as system password. click on apply and then ok. 

We are done.. Now go to task manager select the service you want to start.

That's All Folks..

Hope you guys got idea on how to solve the above window service issue.