HomeОбразованиеRelated VideosMore From: Jiri Pinkas

Database connection in Eclipse (Oracle) : javavids

210 ratings | 85411 views
How to connect Oracle database in Eclipse? Part of Java online video tutorials: http://www.javavids.com
Html code for embedding videos on your blog
Text Comments (44)
Rahul Sharma (1 month ago)
When I browse jar file it shows not responding...any solution?
Tarun kumar (3 months ago)
Done thanks sir
Shrey Bishnoi (3 months ago)
kaun se jila ka horo tu ?
Member Berry (4 months ago)
Cequl aha
shubhada pulse (7 months ago)
thank you.
Dileep Mundrathi (11 months ago)
ghada chebbi (1 year ago)
thank youuuuuuuuuuuu
Paulo Victor Sobrinho (1 year ago)
I using a correct username and password. I have unsolved error: java.sql.SQLException: ORA-01017: invalid username/password; logon denied how i solve this?
Arvina Kori (1 year ago)
In my case it says Ping Failed
Etukala Surendra (1 year ago)
one quick question, Is Data Set reusable in one report to another report in eclipse Birt
mystiquegirl4 (1 year ago)
I always get a ping failure message - the network adapter could not establish the connection
Mithun Kalvala (1 year ago)
I am a dumb fucking ass, entered orcal , instead of orcl for SID and wasted whole night. It's not XE coz I installed 11g. I made sure that the listener was listening and if I'm doing correctly or not as per some crazy .ora file's code. then I realized and rectified my mistake. I didn't waste all night for only this thing, I listened to ED Sheeran's Shape of the you and then the following recommendations. peace
sania parveen (8 months ago)
if its not XE then what for 11g oracle
Lesedi Matli (1 year ago)
What exactly should be entered for 11g?
Peace (1 year ago)
If you don't know anything you need to enter in this last screen when you got the message Ping Successful then how can you get that information. Thanks
DANTDM diamondminecart (2 years ago)
I downloaded ojdbc6.jar and pasted it on my java jre lib but I cant see the 'Datebase Connections' button HELP PLEASE Im working on my project :(
Oupa Nyide (2 years ago)
jiri thank you very much it working
Oupa Nyide (2 years ago)
sorry under name/type
Oupa Nyide (2 years ago)
Hi Jiri if I have oracle12c which jar file i have to download and under name/ which system vesion to choose?
Jiri Pinkas (2 years ago)
Download ojdbc7.jar: http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html The rest is the same.
IN THIS WORLD (2 years ago)
Thanks a lot
Shalini Jadala (2 years ago)
Success!! Helped a lot :) Thanks!
Marie Zig (2 years ago)
how to know the hostname of oracle db ??i mean there is a command sql to know the hostname ?
dante358 (2 years ago)
It worked for me, thanks Jiri. One issue I initially ran into was that Eclipse populates the Host name with "server", once I changed that to "localhost" to match my connection URL it worked. Thanks again.
Shiva Survase (3 years ago)
It gives mi ping failed and just like that java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver at java.net.URLClassLoader$1.run(Unknown Source) at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.net.FactoryURLClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:213) at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105) at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54) at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:73) at org.eclipse.datatools.enablement.internal.oracle.JDBCOracleConnectionFactory.createConnection(JDBCOracleConnectionFactory.java:27) at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83) at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359) at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76) at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:53)
Shiva Survase (3 years ago)
+Jiri Pinkas (javavids) ok sir I will try...
Jiri Pinkas (3 years ago)
+Shiva Survase If you get that stacktrace when you run you application, you need to add the library to your project. If you see it when creating the database connection in Eclipse (presented in this video), then maybe you should download the JAR file again and try all the steps from the beginning, because you either have wrong JAR file, or the file is corrupt.
Shiva Survase (3 years ago)
+Jiri Pinkas (javavids) what can I do for that?
Jiri Pinkas (3 years ago)
+Shiva Survase Because from the stacktrace it doesn't seem like it. Also when do you get that stacktrace?
Shiva Survase (3 years ago)
+Jiri Pinkas (javavids) yes...
Andrianto Silaban (3 years ago)
Thanks it works..
Farah Alani (3 years ago)
that was exactly what I need,  I just need to know how I can insert ,delete or update my tables from java? I tried to wrie the same Oracle codes insie (SQL Scrapbook) but I couldn't get a result.. If you can help me I will be very thankful :)
somendra prakash (3 years ago)
while testing connection ping failes  :(
Jiri Pinkas (3 years ago)
+somendra prakash then something is wrong, double check your connection properties, maybe you have made some typo. Or maybe you have between your computer and a database a firewall?
Dexter Morgan (3 years ago)
why did u put XE in SID ?
Dexter Morgan (3 years ago)
aha thank you , i have found out my SID using this request "select instance from v$thread"
Jiri Pinkas (3 years ago)
because I used Oracle Express Edition, which has SID = XE
Casey Gould (4 years ago)
Why did you choose 6 instead of the 14? 
Jiri Pinkas (4 years ago)
if you mean ojdbc14.jar vs. ojdbc6.jar, then the reason is, that you should use appropriate JDBC driver for the database you use. ojdbc14.jar is for Oracle 10gR2. ojdbc6.jar is for Oracle 11gR2 etc. Also you may be mistaken to think that 14 is greater than 6, so why use lower version, right? Because 14 means Java 1.4 and 6 means Java 6 (using old naming it would be 1.6, so the jar file would be ojdbc16.jar) ;-)
mayank sharma (4 years ago)
Thank you so much. This was exactly what I was looking for :) 
Soumitra Singhai (4 years ago)
Your Video is very helpful ! Exactly What i wanted to know. Thanks a ton !!
Nithiyananthan Mgp (4 years ago)
Priya Nayak (4 years ago)
Thank u soo much . It helped me lot

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.