Java Connect to Oracle database Made Easy
Ғылым және технология
Learn to write Java code that connects to Oracle database, insert a new row and get all rows from a table in Oracle database.
What you will learn:
- Create a table in Oracle Database XE using Oracle SQL Developer.
- Code the first Java project that connects to Oracle database express server, then insert a new row to a table. Use Oracle JDBC driver as a referenced Jar file in the classpath. Then close the connection
- Code the second project based on Maven. Make connection to Oracle database; get all rows from a table. Declare a Maven dependency for Oracle JDBC driver.
In addition, you will also learn:
- Understand how a Java program talks to a database server via JDBC API and JDBC driver.
- Understand Oracle JDBC driver (OJDBC): versions, database URL and driver types.
- Use Oracle SQL Developer tool to create a table with sequence and trigger for the primary column.
For text-based tutorial about Java Connect to Oracle database: www.codejava.net/java-se/jdbc...
Пікірлер: 66
Thank you very much! Perfect explanation with code example, helped me a lot! Wish all the best!
@CodeJava
17 күн бұрын
You are welcome! Glad it helped.
Thank you! This was a great tutorial, very easy to follow!
@CodeJava
2 жыл бұрын
Glad it was helpful!
Great instruction, thanks for your effort.
@CodeJava
2 жыл бұрын
Glad it was helpful!
Thank you very much! Special for resolve exceptions with JDBC driver
@CodeJava
2 жыл бұрын
You are welcome!
thanks mate, it really worked for me!
@CodeJava
Жыл бұрын
you're welcome. Glad it helped :)
thank you for this tutorial. I was able to perform on my own code and it works very easy. I will suscribe
@CodeJava
Жыл бұрын
Glad it helped!
thankyou this helps me even if im not a java developer
@CodeJava
2 жыл бұрын
glad it helped.
Really I couldn't find any place this information , thanks
@CodeJava
3 жыл бұрын
Glad I could help:)
My English is poor. I am using Intellij IDEA and and my DB. But still I did it. Thank you so much. I have not found this information anywhere else.
@CodeJava
3 жыл бұрын
Glad this video helped. Are you from Russia?
I have subscribed your channel and expecting more videos
@CodeJava
3 жыл бұрын
thank you, bro!
thank you bro, ramadan karim
@CodeJava
4 жыл бұрын
You're welcome. Glad it helped. Why don't subscribe?
@ephraimzachariah5921
3 жыл бұрын
pro tip: watch movies at kaldroStream. I've been using them for watching all kinds of movies during the lockdown.
@davisconner240
3 жыл бұрын
@Ephraim Zachariah definitely, been using Flixzone} for months myself :D
thanku so much! this vedio has solve my problem.
@CodeJava
2 жыл бұрын
Happy to help
Please create more videos how to fetch particular record at run time and particular column value write into excel sheet .
@CodeJava
3 жыл бұрын
For writing data from database to Excel, I recommend you to check this tutorial: www.codejava.net/coding/java-code-example-to-export-data-from-database-to-excel-file
I am getting java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist But i have created emp table is oracle sql
good job 👍
@CodeJava
4 жыл бұрын
Thank you! Cheers!
Create some videos how to write database particular cell data in Excel file and selenium automation testing with Java videos .
@CodeJava
3 жыл бұрын
Noted.
thank you
@CodeJava
3 жыл бұрын
You're welcome. Glad it helped. Subscribed?
How to fetch particular column cell value and how to validate database record data in eclipse
@CodeJava
3 жыл бұрын
I think you will find this video helpful: kzread.info/dash/bejne/Y6R1mJZmltLPqps.html
Nice an easy tyvm
@CodeJava
2 жыл бұрын
Glad it helped.
Sir while modifying program, i got error "ORA-01008: not all variables bound" Please help me.
@CodeJava
4 жыл бұрын
Hmm. I have no idea about that error.
For the past week, I am unable to clear the error " ORA-00942: table or view does not exist". I have followed the exact same procedures via the tutorial.
@CodeJava
4 жыл бұрын
perhaps you are connecting to the wrong database, or using wrong table name.
@robertb5357
4 жыл бұрын
@@CodeJavaThanks for your response. I figured out the problem. The SQL Developer prefers the table names to be in all CAPS.
@robertb5357
4 жыл бұрын
@@CodeJava Can I ask one more question? Why does one needs to create a new Maven dependency project and class to extract all rows from a table? I was able to write a method in the initial project class and extract the table data?
@CodeJava
4 жыл бұрын
@@robertb5357 because it is essential to code a program/app that needs to get information from a database.
Thanks
@CodeJava
Жыл бұрын
Welcome
great bro
@CodeJava
3 жыл бұрын
Thank you so much 😀
I m facing prblem while using Sql developer tool i am not able to expand my connection nor can see the query results does someone know what can be the possible reason?
@CodeJava
4 жыл бұрын
Did you provide username and password to connect? It's probably the credentials are invalid.
I downloaded the.jar file. But I dont know how t include it in my eclipse workspace
@CodeJava
10 ай бұрын
go to project properties > Java Build Path > Libraries > add your .jar file.
If the voice over is precise and clear this would be an great tutorial
Still I'm getting "java.sql.sqlsyntaxErrorEcception: ORQ-00942:table or view does not exist " This error please help me resolve this I'm stuck on this problem for last 3-4 days
@CodeJava
Жыл бұрын
check typos and table name your SQL statement.
I don't understand why you use Maven, can you explain please?
@CodeJava
3 жыл бұрын
Maven is very useful when your project requires many external libraries (dependencies) as it manages the dependencies for you.
Sir, I am using ubuntu then how can i used jdbc please tell to me
@CodeJava
2 жыл бұрын
did you follow this video? what did you try? The steps to use JDBC is as same as on Windows.
@DharmendraKrGupta-ts8lj
2 жыл бұрын
@@CodeJava thank you sir
anh là người việt đúng k :v?
@CodeJava
3 жыл бұрын
đúng rồi em.
very useful!!!!
@CodeJava
Жыл бұрын
Glad it was helpful!