CrazyEngineers
CrazyEngineers

  • java oracle connectivity

    keerthi22

    keerthi22

    @keerthi22-6Sxli5
    Updated: May 29, 2010
    Views: 988
    hi friends did anybody know java with oracle connectivity.. please help.. did i need to change any modification in control panel for java oracle connectivity like other connectivity
    please give full details
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • sookie

    Member • May 31, 2010

    Hi keerthi22,

    As far as I know, you need to import ojdbc14.jar into your java application and then using JDBC, you can directly connect to Oracle Database.

    STEP 1: Download ojdbc14.jar file from #-Link-Snipped-#

    STEP 2: Add ojdbc14.jar to the build path of you project.

    STEP 3: Create a Java Program JDBCConnectDemo.java like following

    [​IMG]

    STEP 4: Output like following will be shown when above program will be run

    [​IMG]

    In above program,
    URL= Connection String including HOSTNAME, PORT NO, SID.
    DRIVER = Name of the driver used.

    Note: In above case OracleDriver is used. You can connect to any other driver also in similar way.
    Username = username used to connect to the database
    Password = password used to connect to the database
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register