HomeОбразованиеRelated VideosMore From: Vishnu Kyatannawar

How to connect to oracle database in java (using Eclipse)

424 ratings | 103703 views
How to connect to oracle database in java (using Eclipse) Database: Oracle 10g Enterprise Edition Download jar: Steps 1.Go to Link : http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html 2. Accept the licence agreement. 3. Select ojdbc6.jar
Html code for embedding videos on your blog
Text Comments (76)
mohammed abdul quadir (24 days ago)
Exception aa rhi hai?
Trish Navarro (27 days ago)
Why cant I download the jar?? It always say to sign in first
mohammed abdul quadir (24 days ago)
Without registring in oracle u cant download it.
sachin pal (1 month ago)
Bhn k lode phle bolna Sikh le......... Gandu
Diogo Santos (2 months ago)
Deu certo amigo... Thank's!!!
Akshay Maity (3 months ago)
how to insert a value
Vignesh Muralidoss (3 months ago)
nice voice.. good content ... keep it up.. your voice is awwwwwwwwwwwwwwwwwwwwwwwesome
harshini hari (4 months ago)
Add more vedio for jdbc with oracle
srikanth annaram (4 months ago)
nice job Vishnu ,voice is crystal clear
Rokuu (4 months ago)
I love you <3
Akhil G (5 months ago)
I am getting null pointer exception...What to do now????
Jonas Gomes (5 months ago)
fuck you with this VOICE MAN!!
Hammad Ahmed (5 months ago)
IO Error: The Network Adapter could not establish the connection this happen to me after doing all the work.. kindly if you know any solution for this so share that with me.. Thanks
antonius stanley (6 months ago)
this is going to be helpful, but your voice is just annoying... anyway this works well thanks... but why you put con.close() on while condition? for me it will prevent next row fetching... so it has to be moved outside while condition
Versatile (6 months ago)
Thank you very much and well done.
Jayson Levin Piquero (7 months ago)
There's something really annoying what how you say "username" at 3:07 lol nice vid though thanks!
Kaustubh Dange (7 months ago)
Thank for the video ..!! help me a lot xD
jai prakash (8 months ago)
thank you so much.....sir
Rajini Nirmal (8 months ago)
Where to find those " jdbc... " kind of things in creating object for connection class please help me to find
Sahil Shaikh (9 months ago)
Funny voice 😂
S RAJSEKHAR (10 months ago)
Xe means Xpress edition not enterprises edition
BlackAnimis (11 months ago)
nice, thanks
Warda Tariq (11 months ago)
I added ojdbc 6 but still it is showing that you have no suitable drivers for jdbc. i have tried every ojdbc jar file but still no use. please guide.
Wajahat Ali (1 year ago)
HOW TO FIND THE SID ? -
pranavi chikkavarapu (1 year ago)
helped a lot... thanks for sharing
Anusha Gullipilli (1 year ago)
irritating voice
xheme xheme (1 year ago)
Too good...
Saikat Pramanik (1 year ago)
in JDBC I have taken values in variable "cell". Now I want to run sql : INSERT INTO myTable (PhNo) VALUES (cell); How can I do that? Actually I have extracted values from excel using apache poi. Now I want to export that database into Oracle using JDBC.
Chady ATAALLAH (1 year ago)
thx a lot ! execpt the voice was vry difficult to follow even with automatic subtitles :p
anurag modi (1 year ago)
your voice is so irritating
Shiv Shakti (1 year ago)
I just wanna ask you a question that i am a starter in jdbc & i have installed oracle jdbc 10g express edition. And i want to make connectivity with my database by using notepad & cmd. And i am getting java.lang.classNotFoundException:oracle.jdbc.OracleDriver pls solve my problem.
hello world (1 year ago)
download the jdbc driver smh
Vani Gandhi (1 year ago)
i used the same procedure but i m getting problem in connection url .... plz help me
Vinod kakumanu (1 year ago)
hi Vishnu Kyatannawar i also traing same program but it shows an error, like Exception in thread "main" java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver (wrong name: oracle/jdbc/driver/oracledriver) at java.lang.ClassLoader.defineClass1(Native Method) at java.lang.ClassLoader.defineClass(Unknown Source) at java.security.SecureClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.defineClass(Unknown Source) at java.net.URLClassLoader.access$100(Unknown Source) 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 sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at com.vinod_jdbc.Stconnect.main(Stconnect.java:12) please give me solution, thank you
In the video you are showing how to connect to a database but how do you create the actual database?
grey christian (1 year ago)
awesome voice dude
Neel Pandya (1 year ago)
what will be schema for oracle12c?
Kumar Ashish (1 year ago)
What will be the jar file for 10g?
Mayank Neema (1 year ago)
Thank you. Nice explanation. Btw i'm a One Piece fan too :D
Filip Vujic (1 year ago)
I don't get any results, just "build successful". Help?
chethan kumar (1 year ago)
very clear and simple explanation .....ty vishnu
chase buttons (1 year ago)
Not working. Not sure why, but my error is complaining about the Class.forName("oracle.jdbc.driver.OracleDriver"); I have the jar, and imported the package, created the OracleDriver class, nada. My Oracle UI connects to the server successfully, selects from tables fine... Bad day. Any suggestions? Thanks!
Tonu Pramanik (1 year ago)
Hi Vishnu , the idea of changing the voice modulation is super cool. Because it is so clear and understandable. Please create small demonstration for mini projects also. It will help the final year students to get the idea for Projects.
Srinivas Kuchana (1 year ago)
Thank you its very clear
jhonnyer orozco (1 year ago)
gracias, lo justo sin tanta vuelta
Ashish Kamble (2 years ago)
Thankxx Bro Keep It Uppppppppppppppp
sunny singh (2 years ago)
very good teach very clean very clearly thanks
Abhilash Pareek (2 years ago)
Hi, I want to create new database and want to set new password and username so for that what should i do? When i tried your method my code went to catch statement after DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:xe", "system", "oracle");
Nagag Salka (2 years ago)
Thank you so much, I liked the way you explain the whole thing very simple and easy Thanks once again
Subhrima Bhadury (2 years ago)
This was a huge help!! Very well explained! Thanks a ton :)
ibntofail kenitra (2 years ago)
thanks vary much , I have question ho i can know my port of my database ?
n o i d (2 years ago)
neat
Pranav Kumar (2 years ago)
i have an error : java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver how i solve it ?
shrihari sanganal (2 years ago)
http://stackoverflow.com/questions/6792197/how-to-add-jar-libraries-to-war-project-without-facing-java-lang-classnotfoundex The link might help you
Ravivarma K (2 years ago)
Error: Could not find or load main class my code is: package db; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class jdbcconnection { public static void main(String[] args){ try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","SYSTEM","server1"); Statement st = conn.createStatement(); String sql = "select * from tbl_emp"; ResultSet rs=st.executeQuery(sql); while(rs.next()) System.out.println(rs.getInt(1)+" "+rs.getShort(2)); conn.close(); }catch (Exception e){ System.out.println(e); } } }
Pawan Lakhera (2 years ago)
I am currently using 64 bit Window Is there any change that I have to made since I have tried it in Netbeans and the program does not run successfully despite of successful connection???? And Is there any blog of this video..........
Sara SOLO (2 years ago)
i have an error : java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver how i solve it ? thnks :)
Trish Navarro (27 days ago)
Sara SOLO this is also my problem
Syed Sarmad Hussain (2 years ago)
Thankx. its too good , clear easy to understand. Thanx again
arvin kumar (3 years ago)
I am getting an error of : java.sql.SQLException: The Network Adapter could not establish the connection. Please help me to resolve this issue.
Saurabh Khare (3 years ago)
Excellent walk-through. Success on first try. :D. Thank You. BTW is xe enterprise or xpress edition...coz I have express edition 11g installed and xe worked. I guess the instance name for the enterprise edition is orcl...not sure though. Are you planning on doing more tutorials in JDBC?
Ram Siddu (3 years ago)
Great. Flow of explain is good. Thank you very much. I want more tutorials from u....
Anudeep Syam Prasad (3 years ago)
Very helpful Thankyou Vishnu...........
Ishita Jain (3 years ago)
Thank you soo much.
nitin kumar (3 years ago)
no errors in my program but still no out put...running successfully but no output...it showing an empty screen
Am Siri (2 years ago)
+nitin kumar me too Can u help me pls? reply me for your solution pls
Amarjit Singh (3 years ago)
thats exactly "to the point" thanks
Who made Who (3 years ago)
Im trying to do this but using servlets.. and i keep getting errors..i use the same code..or should i change something?
Vishnu Kyatannawar (3 years ago)
+Who made Who No this code wont work on servlets. Need some modifications
Who made Who (3 years ago)
Im trying to do this but using servlets.. and i keep getting errors..i use the same code..or should i change something?
mas gru (3 years ago)
can you make a video how i can get that maked table in oracle database to eclipse windowbuilder and show what are in it?
MariettoChannel 76 (3 years ago)
from Ecuador,  giving you d thanks , this work very well with enterprise edition thanks.
naveen dhanalakota (3 years ago)
i not able to get  the out put ,my db is oracle 10g. i got this exception java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521:xe
Vikas Kyatannawar (3 years ago)
+naveen dhanalakota is it enterprise edition?
Vlad Bilenko (3 years ago)
Thanks very much: short and clear!!!
Vishnu Kyatannawar (3 years ago)
Thank You

Would you like to comment?

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