How to Connect to Oracle Database in Eclipse IDE

preview_player
Показать описание
In this video, I'd like to share with you how to connect and manage a database on Oracle Database Server right inside Eclipse IDE using the Database Development perspective which comes with Eclipse IDE by default. So you can mange Oracle database without having to leave the IDE, or in case you don't have any Oracle client tools like Oracle SQL Develoer.

Here's what you will learn in this video:
- Download Oracle JDBC driver
- Make connection to a local instance of Oracle database server
- Manage data in a table
- Execute SQL statements

Software programs:
- Java Development Kit (JDK)
- Eclipse IDE for Enterprise Java Developers
Oracle Database 18c Express edition
Рекомендации по теме
Комментарии
Автор

Really helpful. But i am unable to view the results in SQL results tab.

eswar
Автор

Can you help us to know how to connect to DB using Kerberos Authentication/ any reference link will be helpful. Thank you

sureshsadanala
Автор

Can I connect in the same way Oracle Database 21c Express edition

MartinaBoskovic-lkem
Автор

Good video. Ping successful. However when run the Tomcat server from within Eclipse my Java Code doesn't connect with Server. It gives me this error: IO Error: The Network Adapter could not establish the connection. Deploying the code directly to Tomcat works just fine, but not from within Eclipse. Same properties.txt file is used in both

AnjumRaheel
Автор

05:58 i am getting ping failed, what to do, please reply

venkat
Автор

I couldn't see the tables what you have showed like ( customer, sales, students) how to get them.

prasanthreddy
Автор

You could do a tutorial explaining how to write a program in Java, with Eclipse, which sends a query to the Oracle database and receives the response displaying the result ? It would be very interesting ...

giorgioguglielmone
Автор

i donot have database development option in perceptive

sreyasreeya
Автор

Operating System                                :                       Windows XP/2003 or Linux/Solaris

User Interface                                      :                       HTML, CSS

Client-side Scripting                            :                       JavaScript

Programming :                       Java

Web Applications                                :                       JDBC, JSP

IDE/Workbench                                   :                       Eclipse with My Eclipse Plug-in

Database                                               :                       Oracle

Server Deployment                             :                       Apache Tomcat 6.0

kanhobazade
Автор

which user Id password we have to use?

sazaljain