java oracle connectivity

keerthi22

keerthi22

@keerthi22-6Sxli5 • Oct 9, 2024
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
Like 0 Replies 1

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

Sign up Log in

CrazyEngineers powered by Jatra Community Platform

  • sookie

    sookie

    @sookie-T06sFW • 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
    0