How do i connect with Oracle database using java?

Asked By 7060 points N/A Posted on -

Could someone help me to explain how do i connect with oracle database using java?

Answered By 0 points N/A #80464

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.


Login/Register to Answer

Related Questions