Skip to main content

ADF: the oci driver

Ok so we had a requirement to check if the oci driver would work with ADF. So here are the steps I followed to get it working quite simple I think. Will post here if there are any problems with using the driver but with a quick scan test everything looks ok.

1) Installed the oracle client on our weblogic box.
2) Replaced the ojdbcdms.jar reference in the weblogic classpath with the exact version that comes with the client (VERY important)
3) changed my connection string to jdbc:oracle:oci:@127.0.0.1:1521:SID.


Things that will be investigated : Client side caching, speed tests, amount of connections


Notes: UnsatisfiedLinkError - ocijdbc11.dll not found
Change your path on your system to have your client library location as the first in the list - ie for me I installed my client to C:\Oracle\11.2.0\client64 so that dir must be the first entry in my path.


java.lang.UnsatisfiedLinkError: oracle.jdbc.driver.T2CConnection.getLibraryVersionNumber()IYou are using the incorrect version of the ojdbc driver make sure you are using the one that came with the client and it is the first driver weblogic loads.

Shortcut to test :
Rename this file to  ojdbc6dms.back
[your middleware install location]oracle_common\modules\oracle.jdbc_11.1.1\ojdbc6dms.jar

Copy your ojdbc6dms.jar from your client (or download from Oracle)  to the above location. Restart weblogic.
Labels:

Comments

  1. Divya GopalakrishnanMarch 13, 2012 at 7:47 PM

    Hi Donovan,

    Do you have any idea what could be the problem if I'm getting this error:
    java.lang.UnsatisfiedLinkError: orageneric10 (Not found in java.library.path)

    This is happening when I'm executing the below code:
    String temp = oracle.xdb.XMLType.createXML((OPAQUE)rs.getObject(1));

    Also, I downloaded INSTANT CLIENT, could that be the problem?

    ReplyDelete
    Replies
    1. Donovan SherriffsMarch 13, 2012 at 10:23 PM

      Hi,

      Any UnsatisfiedLinkError mostly have to do with dll/so files not being on the path. (I assume you are running on windows - linux is a bit different let me know if you are running linux)

      I have the full client installed (on my forms installation) and my dll is in the C:\DevSuiteHome\BIN directory.

      I dont know much about the INSTANT CLIENT but step one would be to do a search on your drive for orageneric10.dll and pop that directory on the PATH (Enviroment variable). If you dont have the dll try the full client.

      Hope this helps.
      Donovan

      Delete
  2. Valdez V.June 24, 2016 at 7:51 PM

    Thanks for posting this!
    It really helped me out.
    Hails from Mexico!

    ReplyDelete

Post a Comment

Popular posts from this blog

ADF sort of generic screen for tables with the same structure

We have a couple (about a hundred) of tables with the same structure (Code, Description, Create Date, Update Date). So I wanted to do something simple so that I did not have to create all these screens 1) EO   I created the EO based on one of the tables I had that had the above columns. I then Added a transient attribute called table name to my EO based on a groovy expression. (the expression needs to change as I am reading web tier stuff from the model layer but I will fix this later) I then generated a java class for my EO. And added the following overriden method to my newly created java class. protected StringBuffer buildDMLStatement(int i, AttributeDefImpl[] attributeDefImpl,   AttributeDefImpl[] attributeDefImpl2, AttributeDefImpl[] attributeDefImpl3, boolean b) {   StringBuffer statement = super.buildDMLStatement(   i, attributeDefImpl, attributeDefImpl2, attributeDefImpl3, b); return new StringBuffer(StringUtils.replace(statement.to...
Post a Comment
Read more

OJDeploy: Documentation for the tool

Real DOCS:  http://docs.oracle.com/cd/E26098_01/user.1112/e17455/deploying_apps.htm#OJDUG645 OJDeploy Documentation if you run it from the command line - I keep looking for this so I though I would post it here so I remeber. Oracle JDeveloper Deploy 11.1.2.1.0.6081 Copyright (c) 2003, 2010, Oracle and/or its affiliates. All rights reserved. Usage:   ojdeploy -profile <name> -workspace <jws> [ -project <name> ] [ <options> ]   ojdeploy -buildfile <ojbuild.xml> [ <options> ]   ojdeploy -buildfileschema Arguments:   -profile               the name of the Profile to deploy   -workspace      full path to the JDeveloper Workspace file(.jws)   -project              name of the JDeveloper Project within the .jws where the Profile can be...
4 comments
Read more

Util code

public static MethodExpression getMethodExpression( String expr, Class returnType, Class[] argTypes){ FacesContext fc = FacesContext.getCurrentInstance(); ELContext elctx = fc.getELContext(); ExpressionFactory elFactory = fc.getApplication().getExpressionFactory(); return elFactory.createMethodExpression( elctx, expr, returnType, argTypes); } public static javax.faces.el.MethodBinding getMethodBinding( String expr, Class[] argTypes){ FacesContext fc = FacesContext.getCurrentInstance(); ELContext elctx = fc.getELContext(); return fc.getApplication().createMethodBinding(expr, argTypes); } SetPropertyListener listener = new SetPropertyListener( ActionEvent.class.getName()); listener.setFrom(link.getRoute()); listener.setValueExpression("to", JSFUtils.getValueExpression("#{pageFlowScope.route}", String.class)); action.addActionListener(listener); AdfFacesContext.getCurrentInstance().getPageFlowScope() .put("route", lin...
Post a Comment
Read more