LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  JDBC Quey - unable to load db driver: oci

    Employee
    Posted 09-23-2009 05:02

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: henk01

    Hello,

    I'm hoping to query an Oracle database using a JDBC query. First question, do I have to define the "SqlQueyFieldBindings" field?

    Second question, I have defined "oci" for "DbDriver" as suggested in the BRAIN training guide, is this correct?

    The error message I get is "Unable to load db driver: oci". Do I need to install this driver?

    Many thanks,

    Henk


  • 2.  RE: JDBC Quey - unable to load db driver: oci

    Employee
    Posted 09-23-2009 06:20

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rabbott

    Hello Henk,

    Unless you have a specific reason for using JDBC to connect to Oracle, you should use the DB Query node instead. You would then set the DbInterface to OCI. Oracle Call Interface (OCI) is the most comprehensive, high performance, native 'C' language based interface to the Oracle Database that exposes the full power of the Oracle Database.

    Once you've defined the default parameters for the DB Query node, and provided your SQL query is valid, the node should work without further configuration.

    - Bob


  • 3.  RE: JDBC Quey - unable to load db driver: oci

    Employee
    Posted 09-23-2009 18:53

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: mermacora

    Hi Henk

    One other point to note. If you are using Lavastorm Desktop and you want to use OCI as the DbInterface for your DB Query node(s), you'll need to install an Oracle Client and configure it to connect to the Oracle DB you intend to use.
    If you don't already have an Oracle Client installed on your PC, I suggest you download and install the Oracle Instant Client:
    http://www.oracle.com/technetwork/da...ex-100365.html

    Hope this helps
    Mario


  • 4.  RE: JDBC Quey - unable to load db driver: oci

    Employee
    Posted 09-24-2009 09:24

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rabbott

    Of course, don't forget to install the Oracle Client.

    My apologies for the oversight.


  • 5.  RE: JDBC Quey - unable to load db driver: oci

    Employee
    Posted 10-13-2009 01:30

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: henk01

    Many thanks for all suggestions, all is working.

    Just to confirm the steps followed:
    1. downloaded Oracle Instant Client, extract all files in a Oracle directory
    2. updated the �Path� environment variable to include the Oracle Instant Client directory
    3. used �OCI� as DbInterface

    Then I had some issues with defining the DbService:
    "Unable to attach to server 'mdsale01.mdsuk.com': ORA-12154: TNS:could not resolve the connect identifier specified"

    3. created a tnsnames.ora file (e.g. in the directory of the Oracle Instant Client)
    (to define the server, port number and service name)
    4. created an environment variable TNS_ADMIN to point to the directory where
    tnsnames.ora can be found.

    When installing the full client you will have the SQL*Net Easy Configurator (or other tools) to generate or update the tnsnames.ora file. When using the Oracle Instant Client you will have to create this file using a text editor, but it is very straight forward.

    And that was all.

    Many thanks,

    Henk