How do i connect with Oracle database using java?

Asked By anonymous 7060 points N/A Posted on - 09/18/2011

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

• Status: Open
• Question Views: 848
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Java

Answered By ashish9596 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.

 

 

About ashish9596

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/04/2011
• Question Category: Java