1. Due to Oracle licensing issues, MAVEN3 does not provide Oracle JDBC driver, and in order to apply the Oracle JDBC driver in a MAVEN project, it must be manually added to the local warehouse , which uses Oracle 11g. obtained from the installation directory of Oracle, located under: E:\app\zhaoheng\product\11.2.0\dbhome_1\jdbc\lib:
This is using the Ojdbc6.jar
2. know what version of Oracle you have installed
You can enter it in the SQL window: SELECT * from v$instance the following results
Discover my Oracle version number is:11.2.0.1.0 , Note that the first two jar package must be copied to the C:\Documentsand settings\${user} directory, at first I did not copy, Just looking for a directory, always found to fail
3. to be placed in the local library via maven command:
MVN install:install-file-dgroupid=com.oracle-dartifactid=ojdbc6-dversion=11.2.0.1.0-dpackaging=jar-dfile= Ojdbc6.jar
Finally, the JDBC driver is added to the project.
Original address: http://blog.csdn.net/ronaldozh/article/details/50060511
Go: Add Oracle JDBC Driver (11g) to Maven repository