• Sunday , 18 November 2018

16.2 Java Database Connectivity Practical

Code Canyon



this video tells about steps to follow for connecting java program to mysql database. Java JDBC is a java API to connect and execute query with the database.

Original source

3d Ocean

Related Posts

34 Comments

  1. kumar abhishek
    October 29, 2018 at 21:41

    i am getting this error : Cannot establish a connection to jdbc:mysql://localhost:3306/bank using com.mysql.jdbc.Driver (CLIENT_PLUGIN_AUTH is required) on netbeans. what to do?

  2. shriekant
    October 29, 2018 at 21:41

    please upload video of connecting Java application to Microsoft SqlServer

  3. Dhivya Viswanathan
    October 29, 2018 at 21:41

    am getting MySQLNonTransientConnectionException error

  4. Dhivya Viswanathan
    October 29, 2018 at 21:41

    When i am trying to execute in my eclipse .It is showing Could not create connection to database server.Anyone p
    lease help me to solve this

  5. Michele_Laino
    October 29, 2018 at 21:41

    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

  6. Akhilesh Yaduwanshi
    October 29, 2018 at 21:41

    Awesome Explanation Navin

  7. Sumit Kumar
    October 29, 2018 at 21:41

    java.sql.SqlException ——- this is the error i am getting

  8. sai sushma nukala
    October 29, 2018 at 21:41

    Sir please tell me the supported driver for oracle10g express edition ….and the code which I should have to write class.forname() code….Pls…….Pls…….sir

  9. ajay debata
    October 29, 2018 at 21:41

    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 .

  10. Fin chutney
    October 29, 2018 at 21:41

    Navin in this video 16.2 u used a statement that is con.creatstatement() please explain because conection object con is created in the same class then why i need to use the object in the same class

  11. yadapalli gopi
    October 29, 2018 at 21:41

    steve jobs

  12. The Blend Shed
    October 29, 2018 at 21:41

    This will help me alot for a School project i am working on thanks… and keep up the good work

  13. akash verma
    October 29, 2018 at 21:41

    Steve Jobs

  14. easywayto u
    October 29, 2018 at 21:41

    you are great teacher thanks sir

  15. anwar hussain
    October 29, 2018 at 21:41

    I write exactly the same code and also made one table in Mysql Workbench but I am getting an error :
    Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create a connection to the database server.
    Caused by: java.lang.NullPointerException
    please help me.
    and my password is correct.

  16. gagan sharma
    October 29, 2018 at 21:41

    @Telusko Learnings You have not taught about Reference Libraries. which jars we need to import in our project.

  17. Choegyel Norbu
    October 29, 2018 at 21:41

    I did the exact same s u did……but I get" Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. " errorwhat would probably the issue be here…. !! thank you   …

  18. ck3908
    October 29, 2018 at 21:41

    how do you get the hyperlink help on key words to pop up those help libraries? do I have to install some help file libraries? if so which ones?

  19. Adam Araru
    October 29, 2018 at 21:41

    Does it matter what version of JDBC I download if I want to use Microsoft SQL server 2017?

  20. Khetha Mngadi
    October 29, 2018 at 21:41

    I really liked this video. Very helpful. Had to use the line below for my url

    "jdbc:mysql://localhost:3306/db_assignment_two?autoReconnect=true&useSSL=false"

  21. Savio Jay Sengupta
    October 29, 2018 at 21:41

    sir what will be the url structure and Driver for sql???

  22. Jegan Muthu
    October 29, 2018 at 21:41

    Sir, how to use scrap book in java instead going for workbench and what should be given in URL if scarp book is used

  23. Get Technical Information & Top5
    October 29, 2018 at 21:41

    Sir i Followed from A-Z but i am facing this Error: 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.

  24. RAVIPUDI YASHWANTH
    October 29, 2018 at 21:41

    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.

  25. Enamul Haque
    October 29, 2018 at 21:41

    steve Jobs

  26. Karthik Assassin
    October 29, 2018 at 21:41

    Tim Cook

  27. Amit Sharma
    October 29, 2018 at 21:41

    Sir you are my super hero..If I am the owner of DC I will definitely cast you as Superman

  28. B Lokanath Patro
    October 29, 2018 at 21:41

    Steve jobs

  29. sparsh kothare
    October 29, 2018 at 21:41

    wozniak and steve jobs

  30. Manisha Yadav
    October 29, 2018 at 21:41

    How to do it in mac

  31. Aakash Verma
    October 29, 2018 at 21:41

    Would you please shot a video on how to install and set up mysql database on mac and then connect to java.

  32. shubham gaikwad
    October 29, 2018 at 21:41

    I am not able to download mysql through maven so how can i download it??

  33. Jan Hrattis
    October 29, 2018 at 21:41

    Great tutorial! Which macOS are you using?

  34. prashanth gopi
    October 29, 2018 at 21:41

    my oracle is installed in to two drives c and g .
    in c disk oracle folder is there. and in G disk app folder is installed .
    in that G disk where app folder is installed in that i have jar file.but in app folder G:appPrashanthproduct11.2.0dbhome_1jdbclib…here i have total 9 jar files with the name of ojdbc5,5g,5dms,6,6g,6dms,simplefan. these are the jar files in my folder . but i added the ojdbc 6 only but i still getting error.
    ……… so please resolve this issuse..
    and at the same time in my encliipse its not showing add external jar file… when am click the librarie folder .it shows module path AND class path … when i am click module path it will show the add external jar file…. sooo please

Leave A Comment

You must be logged in to post a comment.