Must Know JAVA concepts | Selenium Automation | PART - 1 | Working with Databases
Working with databases is one of the most important and critical operations which every selenium automation developers must know. There are variety of databases available on the market like MySQL, Oracle SQL, MS-SQL and so on. Almost all the relational database management systems (RDBMS) are more or less the same. The Java code varies a bit for each database.
What will we learn in this video:
1. Why database testing is important?
2. What is database testing?
3. How to use Java for testing our database?
4. Java MySQL connection.
Installation Reference links:
---------------------------------------------
1)Download URL for XAMPP - bit.ly/1lmUscR
2) How to install Xampp - • How to Install XAMPP S...
3) Create database and table in MySQL - • create a database with...
4) JDBC connector Jar for MySQL - bit.ly/2VXDEl2
#Java #MySQL #SeleniumAutomation #LearnAutomationOnline
Best way to reach me (replies will be faster): KZread comment section
Also, you can follow me on Facebook and Instagram.
Facebook: bit.ly/2TqPlis
Instagram: bit.ly/2Ez36rH
Пікірлер: 71
Thank you very well explained..Easy to understand
U r really a superb teacher bro.....
Really good explanation sir
Thank you so much bro really easy to understand 😊😊😊😊😊😊😊
Vera level bro 🔥🔥🔥
Thank you.
Super bro
Hi bro, i have one dout getconnection la eppdi bro connection wrote paniga and Java connector jar file eppdi add panrathu project la
Hi Sir, How to retrieve whole table using ResultSet Class?
You told in your previous video that we should not print the data inside the loop 😉.. Any how, thank you so much for your great explanation
@LearnAutomationOnline
2 жыл бұрын
For the sake of example I would have done it. Also it depends. If it’s a list then there is no point in printing inside a loop. If it’s a string, and if the value may not be available after coming out of the loop, then we should print or do the necessary action inside the loop itself.
Hi bro,after entering the class.forname it is showing error that- Syntax error on token':';expected and another error as Syntax error on token "class" invalid expression.Can you please provide solution what mistake I did.Thanks bro
Hi bro, need to automate the Database testing .... any best guidence?
please post videos how to write queries in the mysql so it will be useful for all the other concepts
thanks anna
I get ClassNotFoundException how to handle
unknown database error selinium users nu varuthu na
Already i have MYSQL how to connect JDBC sir?
Driver.getconnection path correct ah eduka mudiyala
Sir i have MySQL how set the path for that ..
Connection epdi kudukanum slunga bro
Automation testing ku java fulla learn pannanuma..illa nenga potruka must know java concepts matum learn panna pothuma ? Then I know manual testing concepts..ipo selenium learn pannitu java ku vara va illa enna Panna brother
Hi AP, Index value starts from zero only right, why we are using 1 and 2 as index value instead of 0 and 1?
@LearnAutomationOnline
4 жыл бұрын
This index represents the column number. It's not like an array starting from zero.
@divyavarman5858
4 жыл бұрын
@@LearnAutomationOnline Understood AP :-)
Hi bro… Give a real time example with database testing….
hi sir how to get the url for the class.forname and connection and we have to remember that for all the same url only please tell me that
@LearnAutomationOnline
9 ай бұрын
U don't have to remember that. A simple search will bring that up.
Hi bro. I got the following error. please let me know how to resolve it Exception in thread "main" java.sql.SQLException: The server time zone value 'Eastern Summer Time' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the 'serverTimezone' configuration property) to use a more specifc time zone value if you want to utilize time zone support.
@venkatesh273
4 жыл бұрын
problem solved.
@LearnAutomationOnline
4 жыл бұрын
In your connection string, use time zone property. Pls see this example jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC
@LearnAutomationOnline
4 жыл бұрын
Great
@venkatesh273
4 жыл бұрын
@@LearnAutomationOnline hi brother. got this error when trying to work with MSSQL database. please help com/microsoft/sqlserver/jdbc/SQLServerDriver has been compiled by a more recent version of the Java Runtime (class file version 58.0), this version of the Java Runtime only recognizes class file versions up to 57.0
Bro i have one doubt.LAMP thana ippa XAMPP ? Do ubundu users really need to download xampp? because wouldn't they be inbuild?
@LearnAutomationOnline
2 жыл бұрын
I think for most Linux distribution it’s in built. LAMP and xampp have minute diff cue I guess but more or less same. If I don’t see the download options for Ubuntu see if it’s already installed on your machine
I want to know how to fetch data from database and enter it in the web application ? Can anyone explain.
@venkatasubramaniam3643
2 жыл бұрын
Assume there is sign-up page in the web application. I want to fill all the fields in the application by fetching data for every field from the database. How to do it ?
First of all thanks for the concept. If we want to perform insert/update/delete and group by function means how to do that?
@LearnAutomationOnline
5 жыл бұрын
Same no difference in java part except, SQL queries. Insert into, update and delete queries will work.
@LearnAutomationOnline
5 жыл бұрын
You have dropped some comments and deleted it seems. If how to insert, update and delete records via java is your question, I would like to let you know that For test automation we will only do select operations. However, when covering the SQL concepts, I will take all these.
Hi Sir, i want to learn automation engineering. But my qualification is M.A.,B.ed.,M.phil(English). Am I able to learn this course? If yes, please tell me where to start?
@LearnAutomationOnline
2 жыл бұрын
You can learn irrespective of your educational background as long as you know how to operate a computer. But the question is, if you are learning for IT job, chances are low for your qualifications to get hired. If u are willing to learn start from selenium basics Playlist
@kanmani3894
2 жыл бұрын
@@LearnAutomationOnline Thank you sir.
Bro...ithula epdi bro JOINS use pannurathu.....
@LearnAutomationOnline
4 жыл бұрын
Join has nothing to do with java, if you write the sql query for join then it can be sent to execute query method.
all okay ji. But index for second and third rows needs to be mentioned as which??
@LearnAutomationOnline
4 жыл бұрын
There will be one result set object and it will be used in resultset.next while loop. I means as long as there are records which means rows are present, retrieve the column mentioned. You don't have to iterate rows.
@tamilselvanm7418
2 жыл бұрын
In while loop condition we use Setname.next My doubt is for checking the data available that case why we not use Setname.hasNext Bcz we use this for iterator also
For automation tester how much SQL knowledge need
@LearnAutomationOnline
2 жыл бұрын
For automation testing u don’t need much sql knowledge. Just basic querying, min, max functions and other frequently used functions should be good. If possible, you can master joins.
@prabhuk5902
2 жыл бұрын
@@LearnAutomationOnline thanks bro
Hi Anna , i completed msc computer science in 2017 and due to some reason I working as marketing executive for the last 5 years. Now i want to switch domain and take job in it anna.please guide me...
@LearnAutomationOnline
2 жыл бұрын
start learning agile, jira and manual testing from the playlist tab. finish these first and let me know.
@venkateswarann6659
2 жыл бұрын
@@LearnAutomationOnline ok anna thank you for your response ❤️
@ramyaravi5779
2 жыл бұрын
@@LearnAutomationOnline After finishing this which concepts I have to learn sir?
@LearnAutomationOnline
2 жыл бұрын
Selenium basics, selenium advanced , testng, selenium interview questions
@venkateswarann6659
2 жыл бұрын
@@LearnAutomationOnline 👍
Sir testingku endha java mattum padicha pothuma sir
@rajarathinam1965
Жыл бұрын
Nan ipa fresher job thedumna edhallam padikanuma sir
@LearnAutomationOnline
Жыл бұрын
Agile, jira, manual testing, java, java interview programs, maven, github, rest web services, postman, page object model, keyword driven
Hi Arul, One small doubt . is Xampp is used in industry for database @www.youtube.com/@LearnAutomationOnline
@LearnAutomationOnline
11 ай бұрын
No xamp is not used as database. I showed it as an easy way to get things done.
Itha excel ah panamudiyuma bro
@LearnAutomationOnline
2 жыл бұрын
Database kum excel kum enna connection iruku? Excel and DB are not same
@johnvicky6561
2 жыл бұрын
@@LearnAutomationOnline bro excelworkbook la rows and columns irukum athala some data irukum la atha retrieve pana mudiyatha
@LearnAutomationOnline
2 жыл бұрын
As I said before, excel and db are different. If you want to read or write excel, refer my data driven playlist.
@johnvicky6561
2 жыл бұрын
@@LearnAutomationOnline ok bro thanks bro
Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver error message came. and what will do anna
@vishwanath6929
2 жыл бұрын
Add the Java connector jar file in to your project
@lokiloki1370
Жыл бұрын
@@vishwanath6929 how bro