How do i connect with Oracle database using java?
The java can be connected to oracle database by using JDBC(JAVA DATABASE CONNECTIVITY). The essential software's needed are Windows XP sp-II or higher, java development kit,oracle database and oracle JDBC driver.At first,java development kit and oracle database are to be installed.Place oracle JDBC driver (*.jar file) in java runtime folder and java development kit folder.
Create a Data Source Name (DSN) required for database connectivity in windows. For DSN go to Start > Control panel > Administrative Tool > Data Sources(ODBC). Then ODBC Data Source Administrator will open. Click on the add button to create and select Microsoft ODBC for Oracle and click next.
Fill the Data Source Name – name for the data source,description.
Now, the system is configured to any java oracle connectivity program.