Skip to main content

Find Oracle JDBC driver in Maven repository



I want to add the oracle jdbc driver to my project as dependency (runtime scope) - ojdbc14. In MVNrepository site the dependency to put in the POM is:







<dependency>

<groupId>com.oracle</groupId>

<artifactId>ojdbc14</artifactId>

<version>10.2.0.3.0</version>

</dependency>







of course this does't work as it is not in the central repository used by maven. 2 questions:









  1. How do I find a repository (if any) that contains this artifact?









  2. How do I add it so that Maven will use it?






Comments

  1. How do I find a repository (if any) that contains this artifact?

    Unfortunately due the binary license there is no public repository with the Oracle Driver JAR. This happens with many dependencies but is not Maven's fault. If you happen to find a public repository containing the JAR you can be sure that is illegal.

    How do I add it so that Maven will use it?

    Some JARs that can't be added due to license reasons have a pom entry in the Maven Central repo. Just check it out, it contains the URL to download the file which in this case is
    http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html. Once you've downloaded the JAR just add it to your computer repository with:

    mvn install:install-file -DgroupId=com.oracle -DartifactId=ojdbc14 \
    -Dversion=10.2.0.3.0 -Dpackaging=jar -Dfile=ojdbc.jar -DgeneratePom=true


    The last parameter for generating a POM will save you from pom.xml warnings

    If your team has a local Maven repository this guide might be helpful to upload the JAR there.

    ReplyDelete
  2. Up to now, its not possible to use maven repositories. I'm using ivy as dependency management tool, but also use maven2' s ibiblio repositories. And this is working for ivy:

    <dependency org="oracle" name="ojdbc14" rev="10.2.0.2" conf="*->default"/>


    Maven2' s dependency could be something like that:

    <dependency>
    <groupId>oracle</groupId>
    <artifactId>ojdbc14</artifactId>
    <version>10.2.0.2</version>
    </dependency>


    Notice that i define http://download.java.net/maven/2/ and http://mirrors.ibiblio.org/pub/mirrors/maven/mule/dependencies/maven2/[organisation]/[module]/[revision]/[artifact]-[revision].[ext] as external maven2 repos on my ivy settings.

    ReplyDelete
  3. You can use Nexus to manage 3rd party dependencies as well as dependencies in standard maven repositories.

    ReplyDelete
  4. This worked for me:

    <dependency>
    <groupId>oracle</groupId>
    <artifactId>jdbc</artifactId>
    <version>6</version>
    </dependency>

    ReplyDelete

Post a Comment

Popular posts from this blog

Why is this Javascript much *slower* than its jQuery equivalent?

I have a HTML list of about 500 items and a "filter" box above it. I started by using jQuery to filter the list when I typed a letter (timing code added later): $('#filter').keyup( function() { var jqStart = (new Date).getTime(); var search = $(this).val().toLowerCase(); var $list = $('ul.ablist > li'); $list.each( function() { if ( $(this).text().toLowerCase().indexOf(search) === -1 ) $(this).hide(); else $(this).show(); } ); console.log('Time: ' + ((new Date).getTime() - jqStart)); } ); However, there was a couple of seconds delay after typing each letter (particularly the first letter). So I thought it may be slightly quicker if I used plain Javascript (I read recently that jQuery's each function is particularly slow). Here's my JS equivalent: document.getElementById('filter').addEventListener( 'keyup', function () { var jsStart = (new Date).getTime()...

Is it possible to have IF statement in an Echo statement in PHP

Thanks in advance. I did look at the other questions/answers that were similar and didn't find exactly what I was looking for. I'm trying to do this, am I on the right path? echo " <div id='tabs-".$match."'> <textarea id='".$match."' name='".$match."'>". if ($COLUMN_NAME === $match) { echo $FIELD_WITH_COLUMN_NAME; } else { } ."</textarea> <script type='text/javascript'> CKEDITOR.replace( '".$match."' ); </script> </div>"; I am getting the following error message in the browser: Parse error: syntax error, unexpected T_IF Please let me know if this is the right way to go about nesting an IF statement inside an echo. Thank you.