@@Huffpuffcollection Respect is not a gift that should be given for free, it should be earned. if his professors aren't doing their intended task then he isn't obliged to respect them.
@@Huffpuffcollection it does, you aren't obliged to respect them if they haven't earned. I am tired of explaining this baseless arguement to many "I am entitled" people.
Thanks you Telusko sir , your way of teaching is very understandable , thank you again for sharing your knowledge to millions of people , God Bless you , keep doing it .
Thank you sir!! One of the greatest teachers ! Because of you only people from non CS background also can learn such difficult topics so easily! Your videos guide me in each and every step throughout my career. 🙏🙏
Sir you deserve more views and sunscribers You are definitely one of the best teacher in the world simple, effective and free of cost May God bless you everywhere Love you from the core of my heart 💓
Thank You So Much Navin Sir. In my batch maximum students are tensed just coz of Advance Java . But to be honest I wasn't as my Trainer is also their who is dedicatedly trying his best. The Main Reason I Was Relaxed JUST BECAUSE OF YOU SIR. Feeling so COOOOOOOOOL.
Thank you sir, I already worked with JDBC but I wanted to watch you video, cause I know there's something to learn from your video that others don't teach
Well thanks for all the vids so far i've learned alot especially since i had to look up alot for myself but that's fine since this is how it should be ! Oh and the very first person who found an Apple waaaaas EVA in the garden of Eden ;) !!!!
Thanks for this video. Something is changed now. In the url variable, after the database name, i had to add this code "?autoReconnect=true&useSSL=false". For example, in my case is: String url = "jdbc:mysql://localhost:3306/serra_databaseprova?autoReconnect=true&useSSL=false"; I you don't do this, ssl error will occur. After this, in the Class.ForName i had to modify a little: Class.forName("com.mysql.cj.jdbc.Driver"). I my case, for study database purpose, I don't need ssl security enable, so "?autoReconnect=true&useSSL=false" will disable SSL and also suppress the SSL errors (thanks to stackoverflow). Thanks Telusko for the video
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. bro still am getting this error, pls help me to get out asap
Well you don't have to use SSL and yes telusko is using the old driver which is deprecated. Old Driver "com.mysql.jdbc.Driver" New Driver "com.mysql.cj.jdbc.Driver"
Here, we are using rs. next() only one time, which means the cursor will point to second row(Navin). For getting Mahesh we should use rs.next() one more time right?
Hi sir thanks alot for ur videos. Am 2012 passed out B. Tech with CSE, no job experience till now. I want to start career in IT,recently I completed core java training, I started to attend interviews but everybody is saying we want 2017 to 2019 passed outs, but my friends are suggesting AI and ML, DATA SCIENCE, course worth 3laks at iiit bangalore. What shall I do sir? Please suggest me to start career.
Adding the Class.forName and passing the the com.sql.jdbc is causing the issue. just click new on project go to properties buitpath and add jat and select the jar which was downloades
Thank you so much, this video is so extraordinary helpful !!!!! I was exactly searching for this code-db-connection in Java, and there could not be any better explanation.. thank you so much from Munich, Germany :D
@@Telusko .. and it works! 😁 I have created an input GUI where names of current players of my favorite team (FCBayern) can be inserted into a database, then sorted by shirt number and given back (just as an example..)😆🙃 I owe you so much, not just for this tutorial but for all of them - thanx a million!!! 👍😆
Thank you, i will! 😄 Recently i mainly studied math with Abdul Baris algorithm tutorials.. such outstanding teachers, the two of you!! 👍highly appreciate all of your training and support!!!!!!!!!!!! 😆
Hi...This is Harikrishnan...I got an error for running the java class file...It shows like...Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Hello sir I don't know whether it is complicated or what but I want to run select query only one time and work whith resultset only to search diffrent parameters and avoid SQL queries time is there any way
getInt(), getString() can be used if there are fewer columns and you know the type of columns of the table. What if you want to display 20 or 50 or more columns? How do you iterate the value from a resultSet and display values of all the columns including null?
thnx sir for this great video and for those of you problem in loading and register driver make sure to change the Class.forName("com.mysql.jdbc.Driver"); to Class.forName("com.mysql.cj.jdbc.Driver");
exactly dear. Could you please tell me, after doing all these why My code simply runs and does not print anything? Though I have given print statement.
Exception in thread "main" java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
this is 6 year old video and still most of developers are learning from this video.. that's what quality of teaching ...thank you navin sir.
better than hinduhater
Better than My Professor at my college.
@@Huffpuffcollection Respect is not a gift that should be given for free, it should be earned. if his professors aren't doing their intended task then he isn't obliged to respect them.
@@Huffpuffcollection it does, you aren't obliged to respect them if they haven't earned. I am tired of explaining this baseless arguement to many "I am entitled" people.
My too
@Suraj Kamble pune mere wale attitude khatarnak
@@Huffpuffcollection u r right and little bit wrong too.....giving respect is a quality but there are other qualities too we should use them 🤣😂
Thanks you Telusko sir , your way of teaching is very understandable , thank you again for sharing your knowledge to millions of people , God Bless you , keep doing it .
Hi
Thank you sir!! One of the greatest teachers ! Because of you only people from non CS background also can learn such difficult topics so easily! Your videos guide me in each and every step throughout my career. 🙏🙏
Sir you deserve more views and sunscribers
You are definitely one of the best teacher in the world
simple, effective and free of cost
May God bless you everywhere
Love you from the core of my heart 💓
I resonate with your view.
complex topics are made easy by Naveen sir and I love your way of explanation sir tq
Thank You So Much Navin Sir. In my batch maximum students are tensed just coz of Advance Java . But to be honest I wasn't as my Trainer is also their who is dedicatedly trying his best. The Main Reason I Was Relaxed JUST BECAUSE OF YOU SIR. Feeling so COOOOOOOOOL.
which year student are you ma'am
MAN... the satisfaction when the correct result is printed on your console :)
Thank you sir, I already worked with JDBC but I wanted to watch you video, cause I know there's something to learn from your video that others don't teach
i would make you understand in very less code
Wooww
My course teacher left ths topic for self study (because she can't teach it), but telusko taught me very well.
Thanks a lot
Lol, she left the installation process for self study? Or the whole of Mysql itself? Lmao hahaha 🤣
Telusko, your tutorials are excellent. Thanks, I appreciated your videos.
And Bum "Error" 😄
Best Java Teacher on UA-cam Many Love From Pakistan
🥰
Very clear explanation
Every one easily understood for the JDBC tutorial
Great anna 👏👏keep it up way for more and more videos
i hopefully guessed the error before 18:55 . Your teaching style is awesome sir!!
naveen is a good man he share his own knowledge thousands of people with out nationality from Somalia
10:58 The table named gariblog, extremely relatable!
Steve Jobs!
to let u know i watched it complete
your teaching is very well brother. no one can tell like you
Great tutor!You are so clear in what you are teaching and make the concepts easy to understand.Thank you Navin!
12:26 Navin sir had 14K subs on Apr 2016, and 1.03M subs on 10 Jul 2020.
Great progress sir, all the best, keep it up.
And now 2.22M Subscibers
Sir your way of teaching is imaginable
far far better than professor of my college
I am in class 9. But still I can understand whatever you taught. Thanks a lot.
What are doing you here Amindra
Wowo
Bhai kya kr rha h
chutiya bna raha hai
@@abhishekmaurya9503 lol
You're gonna go a long way boy.
This will help me alot for a School project i am working on thanks... and keep up the good work
Well thanks for all the vids so far i've learned alot especially since i had to look up alot for myself but that's fine since this is how it should be ! Oh and the very first person who found an Apple waaaaas EVA in the garden of Eden ;) !!!!
It's grate education better performance my teacher
Sir you are my super hero..If I am the owner of DC I will definitely cast you as Superman
your videos are very helpful, i wish i could have found your channel sooner
best jdbc tut on utube
Thank You Sir, Steve Jobs, Steve Wozniak, Ronald Wayne are the founders of Apple company.
For those who are getting exception in connecting to database, use latest connector. 5.1.49 worked for me.
sir,your videos are awesome. Whenever i see your videos i will be knowing something new.
Best video on JDBC
Naveen, Can you explain the difference between spring-jdbc and ojdbc jars ? and when one over the other is used.
You !!! Such a blast man... I learned from basic of db connection just becoz of uhh 📈🙌🏻
Very very good explanation
Brilliant explanation...you are JDBC spiderman...
U'RE THE BEST!!!!!
Steve Jobs, Your videos are very easy to understand
Thanks a lot.
Informative session,Brohh
Thanks for this video. Something is changed now.
In the url variable, after the database name, i had to add this code "?autoReconnect=true&useSSL=false".
For example, in my case is:
String url = "jdbc:mysql://localhost:3306/serra_databaseprova?autoReconnect=true&useSSL=false";
I you don't do this, ssl error will occur.
After this, in the Class.ForName i had to modify a little:
Class.forName("com.mysql.cj.jdbc.Driver").
I my case, for study database purpose, I don't need ssl security enable, so "?autoReconnect=true&useSSL=false" will disable SSL and also suppress the SSL errors (thanks to stackoverflow).
Thanks Telusko for the video
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
bro still am getting this error, pls help me to get out asap
Well you don't have to use SSL and yes telusko is using the old driver which is deprecated. Old Driver "com.mysql.jdbc.Driver" New Driver "com.mysql.cj.jdbc.Driver"
I'm getting the same error. Please help me out.
@@DeathBender when I use "com.mysql.cj.jdbc.Driver" I'm getting class not found exception.
@@thahseenfarook4945 ur error got resolved or not.... Bcoz im getting the same error
Explained very well.
thanks for a good tutorial, and i pretend that i didn't see the movies you have downloaded at 5.06 🙈
the legend Steve Job
thanks for this wonderful video.
@Bijendra Rathore bro chill. The OP's comment is itself 4 years old 😂😂
@@siddhantsingh3392 🤣
OP sir ho gya aapki kripa se
i like the way u explain thank you sir............ keep it ahed
Here, we are using rs. next() only one time, which means the cursor will point to second row(Navin). For getting Mahesh we should use rs.next() one more time right?
plz tell what should i install for database clearly
you helped me...thanks so much for these amazing videos
Very well explained. Thankyou Naveen sir! :)
Hi sir thanks alot for ur videos. Am 2012 passed out B. Tech with CSE, no job experience till now. I want to start career in IT,recently I completed core java training, I started to attend interviews but everybody is saying we want 2017 to 2019 passed outs, but my friends are suggesting AI and ML, DATA SCIENCE, course worth 3laks at iiit bangalore. What shall I do sir? Please suggest me to start career.
Thank you so much Telusko! Appreciate a Lot!
Steve Jobs, and founder of great teaching channel @Telusko is Navin Reddy .
which type of project select
Sir can u plz reply that how are u able to open connection.class, Driver.class file???
This video is really helpful. Thank you very much sir.
Adding the Class.forName and passing the the com.sql.jdbc is causing the issue. just click new on project go to properties buitpath and add jat and select the jar which was downloades
What are the sub objects will close when call connection.close. here using connection pool
When u r using maven project..which steps r to be skipped ?
The father of apple is apple tree. Nice video cheers
thank you sir..
Great explanation. Thanks so much.
Would you please shot a video on how to install and set up mysql database on mac and then connect to java.
Awesome Explanation Navin
great explanation thank you
Thank you so much, this video is so extraordinary helpful !!!!! I was exactly searching for this code-db-connection in Java, and there could not be any better explanation.. thank you so much from Munich, Germany :D
Glad it helped!
@@Telusko .. and it works! 😁 I have created an input GUI where names of current players of my favorite team (FCBayern) can be inserted into a database, then sorted by shirt number and given back (just as an example..)😆🙃 I owe you so much, not just for this tutorial but for all of them - thanx a million!!! 👍😆
@@health.upgradedbyscience.7309 Great work :)
Keep Learning, Keep Growing :)
Thank you, i will! 😄 Recently i mainly studied math with Abdul Baris algorithm tutorials.. such outstanding teachers, the two of you!! 👍highly appreciate all of your training and support!!!!!!!!!!!! 😆
YOU ARE A LIFE SAVER.
Hi...This is Harikrishnan...I got an error for running the java class file...It shows like...Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Thank u so much it helped me alot.
Can anyone help me understand , how did Sir underlined DriverManager Class and checked methods inside ? any help would be appreciated
Awesome explanation Navin
Hello sir
I don't know whether it is complicated or what but I want to run select query only one time and work whith resultset only to search diffrent parameters and avoid SQL queries time is there any way
Nice sirji 🔥
getInt(), getString() can be used if there are fewer columns and you know the type of columns of the table. What if you want to display 20 or 50 or more columns? How do you iterate the value from a resultSet and display values of all the columns including null?
bro do you get the answer
resultSet.getNext();
I use IntelliJ IDEA so can you tell anything regarding this
Excellent exaplanation!!! May Jesus bless you.
ricebag
thank you my life saver
Great. Took a while for the set up.
just got what i want . one word for - great.
Best tutorial ever!!!!!!!!!!!!
Awesome sir
Steve Jobs is the founder of Apple .
Thank You very much sir
Founder Apple :- 1. Steven Paul Jobs
2. Stephen Gary Wozniak
3. Ronald Wayne
Sir, how to use scrap book in java instead going for workbench and what should be given in URL if scarp book is used
thank you so much
you are great teacher thanks sir
Great tutorial! Which macOS are you using?
thnx sir for this great video and for those of you problem in loading and register driver make sure to change the
Class.forName("com.mysql.jdbc.Driver");
to
Class.forName("com.mysql.cj.jdbc.Driver");
exactly dear. Could you please tell me, after doing all these why My code simply runs and does not print anything? Though I have given print statement.
Is there a tutorial where you use Data Source instead of Driver Manager?
Good explanation sir,
What is the meaning of "TELUSUKO"?
Know something. In telugu language.
Great sir love u
Sir I used notepad editor then how to load the MySQL driver
Really Thanks man😊
I have done it without using forName method
this man is the real Jesus prove me wrong
Hello sir, i am using sql plus and oracle 11g database so which driver should i use ??
Please let me know fast my project is pending
Exception in thread "main" java.sql.SQLException: Unknown initial character set index '255' received from server. Initial client character set can be forced via the 'characterEncoding' property.
Hw to solve this?
Sir, with out using netbeans and eclipse how can we add a library in notepad++ or codeblocks and how can we run this java program.
Is rs.next necessary to write even in NetBeans?