Hello, when you click on the page to specify the driver and you click on the mySQL JDBC Driver I don not have any versions being displayed. I went into prefrences and looked there too but the only drivers that are available are for ubuntu and linux. Is there more software I need to download in order to access the JDBC drivers?. I cannot add the jar file until I click on a version but there are no versions to click. Thank you.
No more software needed. If you don't see any MySQL JDBC version, you can create a new generic JDBC driver and specify the database properties as shown in the video.
which password should we use @ 6:00 min. While giving test connection I am getting as ping failed. Please say what will the error, why I am getting as ping failed.
hi, thanks for this informative video but ı have an issue when ı try to make a conncection profile ı cannot see database development option in the open perspective part. How can ı fix it?
Is the ping failed due to Mysql not running on a server. Our user is trying to connect to it over VPN. Assuming we can cmd prompt ping the same server's hostname. Wasn't sure about other factors such as Db name, user/pass or port #. I never used the eclipse ide so I'm flying blind in support for the user.
Hi, thank you for uploading this. It is very helpful, but I have an issue whenever I try to test the connection, the ping always failed. How can i fix it? thank you
I think it's not possible because H2 memory database runs in the same process of the application, whereas Eclipse database tool runs in another process.
What is the password required for the root username? Is it my system password or do I need to separately set a new password for mysql? Everytime I'm giving my system password , it is showing error in connection. Please help🙏
@@CodeJava i had installed eclipse ide initially then for connecting to mysql i installed the sql connector only...do i need to install anything else apart from it? i don't have any other installations related to sql in my system...
@@CodeJavano no I don't have any remote one to connect...then I need to install mysql server...thank you for helping 😊 will come back for help if I face further problems😅
Thank you for your time. I have a question what is the difference if I connect database by using Query as Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","Password");
Thank you for taking out your time and patiently explaining everything in detail.
Glad it was helpful!
Thank u for this video , from long time am using eclipse I was not knowing , now I learned this
You are most welcome. I also know it recently.
Thank you for your sharing. Your video is very helpful. I have successfully set up the connection in my Eclipse.
Glad it helped
I am not finding that database development in an open-perspective path
so you need to install database development tools via menu Help > Eclipse marketplace
Hi! after I added JPA, my schema folder is not opening in the Data Source Explorer. please help me
Nice to see the name Rani Kumar Krishna :)
it's a nice name, right?
hey bro now i feel in love whit your knowledge
So nice of you. Thanks for watching :)
Hello, when you click on the page to specify the driver and you click on the mySQL JDBC Driver I don not have any versions being displayed. I went into prefrences and looked there too but the only drivers that are available are for ubuntu and linux. Is there more software I need to download in order to access the JDBC drivers?. I cannot add the jar file until I click on a version but there are no versions to click. Thank you.
No more software needed. If you don't see any MySQL JDBC version, you can create a new generic JDBC driver and specify the database properties as shown in the video.
I am not getting database development option in open perspective
Any tips please?
kindly follow this video: ua-cam.com/video/fx7-bEm0jT0/v-deo.html
In the JAR list, it doesn't let me add JAR/zip. Do I need to have JDBC drivers in the Name/Type tab?
yes, you should see some JDBC drivers in that tab.
i'm using Eclipse IDE for Java Developer and it doesn't have Database Connection, so must I download the Eclipse Enterprise to use this function?
Yes, or you can install a plugin. Follow this video: ua-cam.com/video/fx7-bEm0jT0/v-deo.html
Thank you very very much !!! Great video, you helped me a lot!! 👏👏👏
Glad it helped!
which password should we use @ 6:00 min. While giving test connection I am getting as ping failed. Please say what will the error, why I am getting as ping failed.
that error means MySQL server is not running. So make sure it is running first.
Sir in my mysql open perspective no database development file there
Pls reply sir🙏🏻
kindly follow this video: ua-cam.com/video/fx7-bEm0jT0/v-deo.html
Test connection throwing error: Ping failed,java.net.ConnectException
MESSAGE: Connection refused: connect
How come the database have tables ...was it created by you ?
please explain
yes, that's right. Suppose that we have an existing database before.
5:49 it shows ''ping failed'' for me, pls help
check MySQL server, make sure it is running and listening on the port you expect. Also check username and password, which maybe incorrect.
@@CodeJava thanks for the reply, i only had MySQL workbench open, later on realized i need to have MySQL server open
i have mysql version6.3 can i still connect it? with this connector?
it depends on the version of JDBC driver. Check compatibility on MySQL website.
@@CodeJava im using mysql workbench 6.3 ce i hope its compatible
anyway thank you for the video its good!
good tank you my teacher
You are welcome
But connection is empty sir in new ->data resource
when i go to the open perspective portion i dont have any option for database development. what other option can i use to do this?
check this video: ua-cam.com/video/fx7-bEm0jT0/v-deo.html
hi, thanks for this informative video but ı have an issue when ı try to make a conncection profile ı cannot see database development option in the open perspective part. How can ı fix it?
you need to install it. Follow this video: ua-cam.com/video/fx7-bEm0jT0/v-deo.html
Is the ping failed due to Mysql not running on a server. Our user is trying to connect to it over VPN. Assuming we can cmd prompt ping the same server's hostname. Wasn't sure about other factors such as Db name, user/pass or port #. I never used the eclipse ide so I'm flying blind in support for the user.
I think it would be firewall, network config issues in your case.
@@CodeJava how to solve it sir?
Hi, thank you for uploading this. It is very helpful, but I have an issue whenever I try to test the connection, the ping always failed. How can i fix it? thank you
is MySQL server actually running? Also check typos in JDBC URL, username, password...
my option for database management in perspective is not showing
you need to install DB tools first. Follow this video: ua-cam.com/video/fx7-bEm0jT0/v-deo.html
Sao nhiều người dùng MySQL để kết nối với Java mà ko dùng Microsoft SQL Sever vậy ạ??? Mong a giải thích
đơn giản vì MySQL là mã nguồn mở, nhẹ, nhanh nên phổ biến hơn SQL Server, vốn chủ yếu dùng trong doanh nghiệp.
Sir database development show hi nhi ho raha h
kindly follow this video: ua-cam.com/video/fx7-bEm0jT0/v-deo.html
Thanks for this video.
You are welcome.
5:48 it shows "ping failed" while testing.
Is the MySQL server running? Check JDBC URL (host, port, schema). Check username & password. One of this information is incorrect.
@@CodeJava 👍
Ping failed while testing
After specifying the driver connection details, in the test connection process Iam getting the ping failed .what to do?
Check if MySQL server is running or not.
How to check mysql is running??
@@niktacgaming6493 if you're on Windows, open Task Manager, go to Services, look for MySQL
No database development option is coming while opening open perspective
perhaps your Eclipse version is not for Java EE developers. You can install database development from eclipse marketplace (Help > Eclipse marketplace)
@@CodeJava no it's not. You need to follow @Shaun Pusey's comment here.
What is the next step? how are we going to write the queries and java code?
kindly follow this video: ua-cam.com/video/duEkh8ZsFGs/v-deo.html
and this one: ua-cam.com/video/1pA64-foiz8/v-deo.html
Hi , how to connect to h2:mem database from eclipse? 😁
I think it's not possible because H2 memory database runs in the same process of the application, whereas Eclipse database tool runs in another process.
@@CodeJava may be like this it's possible : eclipse.github.io/kura/builtin/h2-database.html
What is the password required for the root username? Is it my system password or do I need to separately set a new password for mysql? Everytime I'm giving my system password , it is showing error in connection. Please help🙏
the root password is the one you set when installing MySQL server. If you don't remember, you can reset it.
@@CodeJava i had installed eclipse ide initially then for connecting to mysql i installed the sql connector only...do i need to install anything else apart from it? i don't have any other installations related to sql in my system...
@@User45823 oh, you need to have MySQL server installed on your computer. Or do you have a remote one to connect to?
@@CodeJavano no I don't have any remote one to connect...then I need to install mysql server...thank you for helping 😊 will come back for help if I face further problems😅
I didn't know that I can use Eclipse like MySQL workbench in this way :O
yeah, that's the power of an IDE (integrated development environment).
I've tried for many times but it was always Ping Failed, could anyone give me a reason why??
is MySQL running?
@@CodeJava oh yes, thank you. I've fixed my problem. your video is so great. thank you so much
Thanks dude
Happy to help
Thank you for your time. I have a question what is the difference if I connect database by using Query as Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","Password");
the syntax may differ, yet the purpose is the same.
@@CodeJava Thank you, Sir
Thank u my man
Happy to help
Yeah, Yea! :)
what if i forget my mysql password
then you have to reset your root password. reference: stackoverflow.com/questions/16556497/mysql-how-to-reset-or-change-the-mysql-root-password
I having a problem (ping fail)
Something wrong with JDBC URL (port, user, pass.. incorrect). Or the server is not running.
my ping fails why is that?
ensure that MySQL server is running.
My ping is getting failed please help
Make sure MySQL server is running. Also check JDBC URL, username and password.
what is the password given
it's the password you set when installing MySQL.
Zlatan? ..
what do you mean?