How to connect MySql database in java using eclipse || MySql jdbc connection in eclipse

Sdílet
Vložit
  • čas přidán 7. 06. 2023
  • In this video we will learn how to connect this MySql database in eclipse IDe.
    #codingtips #technology #jdbctutorial #eclipseide #java #database #connectivitywithdatabase #mysql #mysqljdbc #jdbc #eclipseide
    1.Subscribe for more free programming videos :
    youtube.com/@ranktech1023?si=...

Komentáře • 100

  • @dattatone3640
    @dattatone3640 Před měsícem +2

    Easily understanding and good teaching video....thank you😇💯👍

    • @RankoJunction
      @RankoJunction  Před měsícem

      Thank you so much for your kind words! I'm thrilled to hear that you found the video clear and educational. If you enjoyed the content, please consider subscribing to my CZcams channel and supporting me🙏😊. Your support helps me create more helpful videos. Happy coding! 🚀

  • @vivekhalder2974
    @vivekhalder2974 Před 3 měsíci +4

    Jai Shree Ram didi. I have been stuck because of this error for the last 5 hours. Finally your video helped me out. Thanks a lot.

    • @RankoJunction
      @RankoJunction  Před 3 měsíci

      Jai shree shyam 😊 your most welcome 🤩 please subscribe and share my CZcams channel ☺️

  • @user-fm6dx9no9q
    @user-fm6dx9no9q Před 7 měsíci +2

    To me this video was very helpful. Thank you 🌹🌹🌹

  • @user-up3cc4wo6t
    @user-up3cc4wo6t Před 7 měsíci +2

    your presentation was simply superb and steps are easy to understand.

  • @shirishmistari9035
    @shirishmistari9035 Před 4 měsíci

    Really Helpful thanks for helping

  • @shubhamkenjale526
    @shubhamkenjale526 Před 4 měsíci +1

    Really Helpful Video..!

  • @_choudharishraddha
    @_choudharishraddha Před 7 měsíci +2

    It was so helpful for me thanks a lot

  • @khushteradeeb
    @khushteradeeb Před 2 měsíci +1

    really helpful..👍👍👍

  • @user-op5yx5pi2f
    @user-op5yx5pi2f Před 7 měsíci +1

    Your video is simply super..and helpful really! Thanks

  • @HemanthKumarSomavarapati
    @HemanthKumarSomavarapati Před 2 měsíci

    Very useful for me , No one is saying about cj(connector jar) in class loading , I think u only said it. Thanks🤗🤗❤

    • @RankoJunction
      @RankoJunction  Před 2 měsíci +1

      Thank you for your kind words💕 I am glad that you found the video helpful. please subscribe my CZcams channel for more valuable content.your support means a lot to us🤩 . stay tuned for upcoming videos

  • @user-ix4tm4ux5p
    @user-ix4tm4ux5p Před 6 měsíci +2

    It was so helpful for me thanks a lot...❤keep going

    • @RankoJunction
      @RankoJunction  Před 6 měsíci

      Thank you so much, your words mean a lot to me🤩

  • @enoughgame1006
    @enoughgame1006 Před 7 měsíci +2

    Alhamdulillah Alhamdulillah
    ❤my sister

  • @vishwanath7094
    @vishwanath7094 Před 4 měsíci +1

    It was helpful

  • @user-ts8to6th7y
    @user-ts8to6th7y Před 4 měsíci

    ilove your videos its so esy

  • @ShyamPrakash.Kuntla
    @ShyamPrakash.Kuntla Před 25 dny +1

    thanks

  • @hamedghafouri5451
    @hamedghafouri5451 Před 6 měsíci +1

    perfect

  • @POTATOMAN-gi9ce
    @POTATOMAN-gi9ce Před 6 měsíci

    You slay queen😎😎😎.... Thanks for the video

  • @lipikalipi6089
    @lipikalipi6089 Před 4 měsíci

    Tqsm🤗🤗

  • @rachamallidorasrivignesh4499

    Thank you madam this vedeo helps us to understand very well. I am requesting you to please appload some spring boot basic concepts .Please , Thank you have a great day bye madam.

    • @RankoJunction
      @RankoJunction  Před 5 měsíci

      Your welcome and yes definitely we are going to upload the complete spring boot tutorial

  • @Pavankalyan....
    @Pavankalyan.... Před 2 měsíci

    hii your making as well keep going on yaaar🥰

    • @RankoJunction
      @RankoJunction  Před 2 měsíci

      Thanks for the encouragement! I'll keep pushing forward and doing my best. If you enjoy my content, please consider subscribing to my channel and supporting me. It means a lot!🤩

  • @debasisbarik5444
    @debasisbarik5444 Před 5 měsíci +1

    Thank you mam ❤

    • @RankoJunction
      @RankoJunction  Před 5 měsíci +1

      you're welcome😊

    • @debasisbarik5444
      @debasisbarik5444 Před 5 měsíci

      Mam there's is some problem showing that
      Establishing SSL connection without server's identity verification is not recommended. According to mysql Exception in thread "main" Java. Sql. SQLException:
      Mam please could u give me the solution plz 🙏

    • @RankoJunction
      @RankoJunction  Před 5 měsíci +1

      your url should be like this jdbc:jdbc:mysql://localhost:3306/datbasename?autoReconnect=true&useSSL=false

    • @RankoJunction
      @RankoJunction  Před 5 měsíci

      and please write your database name properly

    • @debasisbarik5444
      @debasisbarik5444 Před 5 měsíci

      Mam after doing that now it's showing
      Exception in thread "main" Java. sql. SQLException no suit able driver found for jdbc :: mysql://localhost:3306/database name? AutoReconnect=true&use SSL= false

  • @rohanhere12
    @rohanhere12 Před měsícem

    Thanks mam ❤

    • @RankoJunction
      @RankoJunction  Před měsícem +1

      Thank you for watching☺️☺️! If you found this content helpful, please consider subscribing to my channel for more tips and updates. Your support really motivates me to keep creating valuable content😊😊

    • @rohanhere12
      @rohanhere12 Před měsícem

      @@RankoJunction Sure 🙌💯

    • @RankoJunction
      @RankoJunction  Před měsícem +1

      Thank you so much🤩🤩

  • @Jagannathvlog495
    @Jagannathvlog495 Před 3 měsíci

    Explanation is Awesome Connection is created got the output in Eclipse but my Query How to retrieve database from mysql to eclipse???

    • @RankoJunction
      @RankoJunction  Před 3 měsíci +1

      we don't retrieve the database we get the data stored in the table but we can get the database name using eclipse .

    • @Jagannathvlog495
      @Jagannathvlog495 Před 3 měsíci

      @@RankoJunction Then how to get database name??

    • @RankoJunction
      @RankoJunction  Před 3 měsíci +1

      DatabaseMetaData metaData = con.getMetaData();
      //retrieving the name of the database
      String name= metaData.getDatabaseProductName();
      System.out.println("Name of the underlying database: "+name);
      this is how we retrieve the database name

    • @Jagannathvlog495
      @Jagannathvlog495 Před 3 měsíci

      @@RankoJunction Thanks for the reply Yesterday I practiced mysql Crud: create read update & delete operations Today I plan to practice Mysql Database Connectivity in Eclipse When I search in youtube Jdbc Mysql Connectivity to Eclipse I found your Video so helpful..

  • @rosaahmed9157
    @rosaahmed9157 Před 5 měsíci +1

    the import option didnot come for me when i clicked connection

    • @RankoJunction
      @RankoJunction  Před 5 měsíci

      Go to Preferences » Java » Editor » Content Assist » Advanced.
      Make sure Other Java Proposals is ticked/checked.
      If that does not work simply close the project and reopen it.

  • @rahulranesh5561
    @rahulranesh5561 Před 7 měsíci +2

    When I run ,it shows class not found exception
    Pls say what to do

    • @RankoJunction
      @RankoJunction  Před 7 měsíci +2

      add the mysql driver as shown in the vdo and check for typos in your code .

  • @pratibhanevhare2757
    @pratibhanevhare2757 Před 6 měsíci

    I face this issue while connectivity java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist please solve this problem

    • @RankoJunction
      @RankoJunction  Před 6 měsíci +1

      First create the table using the statement interface and then try to insert the values

  • @dheerajharale7955
    @dheerajharale7955 Před 5 měsíci

    Error: Main method not found in class JdbcExample, please define the main method as:
    public static void main(String[] args)
    or a JavaFX application class must extend javafx.application.Application
    I getting these error after run it can you please help me out with these.

    • @RankoJunction
      @RankoJunction  Před 5 měsíci

      This error comes due to many possibilities.
      1.chck your main method , is it written properly
      2. In eclipse file name and class name mst be same . or else
      it will be easier for me to chck if u gave me the complete code here.

  • @Jagannathvlog495
    @Jagannathvlog495 Před 3 měsíci

    Jdbc is connected But How to retrieve Database in Mysql to Eclipse? Can Any one reply please

  • @kollidharani
    @kollidharani Před měsícem

    What is unisoft where can i get the schema name i am not that

    • @RankoJunction
      @RankoJunction  Před měsícem

      yes , i created my schema and u cn use the default schema provided by mysql tool such as world

    • @RankoJunction
      @RankoJunction  Před měsícem

      jst open ur mysqlwork bench its there in the schemas

  • @VivekKumar-el6hf
    @VivekKumar-el6hf Před 2 měsíci

    what is unisoft here..... when im providing my db name it is showing error

    • @RankoJunction
      @RankoJunction  Před 2 měsíci

      its the schema name , which we create inside our mysql workbench

    • @RankoJunction
      @RankoJunction  Před 2 měsíci

      you cn also use the world schema

  • @sakeenabanu7783
    @sakeenabanu7783 Před 8 dny

    Mam in my system there is no modulepath wt should do mam 😢 plz reply mam

    • @RankoJunction
      @RankoJunction  Před 8 dny

      np , use the classpath instead

    • @sakeenabanu7783
      @sakeenabanu7783 Před 7 dny

      ​@@RankoJunction in that also it's not coming mam

    • @RankoJunction
      @RankoJunction  Před 7 dny

      click on the project and go to the build path and libraries

    • @sakeenabanu7783
      @sakeenabanu7783 Před 7 dny

      @@RankoJunction in library module is not there mam that's the problem 😞

  • @sanskarchhajed9397
    @sanskarchhajed9397 Před 5 měsíci

    Connection establish hone ke bad database me data kese insert kre

    • @RankoJunction
      @RankoJunction  Před 5 měsíci

      czcams.com/video/iqFc5TyElM0/video.htmlsi=aIfsPfwcDQkhZh1e
      Yeh video mein diya hai

  • @cutino_16
    @cutino_16 Před 2 měsíci

    I am getting communication failure what to do

    • @RankoJunction
      @RankoJunction  Před 2 měsíci

      check your databases property like username , password, and specially the url

  • @pothulapoojitha2788
    @pothulapoojitha2788 Před 4 měsíci

    When i run it comes like selection does not contain a main type what to do

    • @RankoJunction
      @RankoJunction  Před 4 měsíci

      cn you give me the code as the error may be on ur main method

    • @pothulapoojitha2788
      @pothulapoojitha2788 Před 4 měsíci

      @@RankoJunction then what to do

    • @RankoJunction
      @RankoJunction  Před 4 měsíci

      fix it by right click on the package -> properties -> Java Build Path -> Add folder (select the folder your code resides in). This is one of the solutions and the most come one is remove the main and write it again properly

    • @RankoJunction
      @RankoJunction  Před 4 měsíci

      or else you have to mail me ur project

    • @pothulapoojitha2788
      @pothulapoojitha2788 Před 4 měsíci

      @@RankoJunction ur mail id

  • @undna
    @undna Před 2 měsíci +1

    my imports are underlined

    • @RankoJunction
      @RankoJunction  Před 2 měsíci +1

      if its a yellow line then they are known as unused imports.

    • @undna
      @undna Před 2 měsíci

      @@RankoJunction no they were red. i found the fix. it was the module-info.java
      Had to delete it to recreate it

  • @anuragkumawat4008
    @anuragkumawat4008 Před 2 měsíci

    Still getting an error Access denied for user 'root'@'localhost'(using password: YES)

    • @RankoJunction
      @RankoJunction  Před 2 měsíci

      Can u connect to your mysql workbench with the username and password which you are using for connection in java

  • @Jagannathvlog495
    @Jagannathvlog495 Před 3 měsíci

    Connection created Done but How to retrieve Data from mysql Database..

    • @RankoJunction
      @RankoJunction  Před 3 měsíci

      using result set interface i have also create the video on tht as well

  • @karthickragav
    @karthickragav Před 2 měsíci

    Pathi than iruku meethi enga😮

    • @RankoJunction
      @RankoJunction  Před 2 měsíci

      if you are saying tht its half only then we also have a full playlist on jdbc

    • @karthickragav
      @karthickragav Před 2 měsíci

      @@RankoJunction can u please share the link then

    • @RankoJunction
      @RankoJunction  Před 2 měsíci

      czcams.com/play/PL6cRnBq_4WgAP2i5kls87PqbvwM4UC5cu.html&si=-gc2E9cV3b2FO4ax

    • @RankoJunction
      @RankoJunction  Před 2 měsíci

      hope this helps you

    • @karthickragav
      @karthickragav Před 2 měsíci

      @@RankoJunction thank u so much