java oracle connectivity

Replies

• 

  sookie

  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
  
  
  
  STEP 4: Output like following will be shown when above program will be run
  
  
  
  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