HomeОбразованиеRelated VideosMore From: Arthur Vin

Java EE (J2EE) Tutorial for beginners Part11 - Oracle database setup and connection

102 ratings | 53990 views
This part shows how to setup Oracle database, create new user/schema, and establish the connection between DB and application. Source code: https://github.com/ArthurVin/jee-tutorial-youtube
Html code for embedding videos on your blog
Text Comments (24)
Didarul Alam Rahat (2 years ago)
Best Java EE tutorial i have ever seen...just wonder how simply you teach step by step but give it us totally free...you are great Mr Java ..best wishes for you man .
juodux (2 years ago)
If You will be in the same town at the same time as me, I owe You a beer !! These turtorials are very helpful. I have more and more understanding about Java EE
Gettingthere Slowly (2 years ago)
I am getting the same error schemaupdate:201 could not get database metadata! Could anybody solve this error. Not sure if I have missed something.
juodux (2 years ago)
I think You have the same issue as I got. Later oracle databases need diferent OJDBC.jar. I have used OJDBC7.jar( https://gist.github.com/xuan/9281842 ) from oracle on my 12c databse. I ahve also changed sqlnet.ora adding these : SQLNET.AUTHENTICATION_SERVICES = (none) SQLNET.ALLOWED_LOGON_VERSION=10 SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10 SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
suntossh chandrabhan (3 years ago)
https://github.com/suntossh/jsfspringwebflow_series First of all Thanks a Ton for such a wonderful tutorial, really helpful I just created multiple version of Same Project, each version covers Your Video Explanantion , latest code covers till 15th Tutorial. I am using MYSql instead of Oracle
Maryem IDRISSI OUKILI (2 years ago)
hi there , sorry but have you found a way ? like do i need to change a dependency ?
Santoshkumar Pandey (3 years ago)
Hi , you need to download and create a MySQL db from http://dev.MySQL.com/downloads and create a db with same name as used in my checked in code . to connect to the above db via eclipse data source explorer , you will have to download mysql-connector-java-5.1.35.jar.... Apart from that pom file should have all the dependency so you will get those jars. Happy coding
Ben Masih (3 years ago)
+suntossh chandrabhan hey....what do I have to download if i want to use MySql instead of Oracle?
Nice, short and easy...
DMITRY KRYVYI (3 years ago)
Mike Pavlov thanks for hint, it works perfectly for me!
BEN HENIA Meriem (4 years ago)
Good tutorial, but i have error when i start tomcat:  Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/datasource-config.xml]: Initialization of bean failed; nested exception is java.lang.NoSuchMethodError: org.springframework.core.annotation.AnnotationUtils.getAnnotation(Ljava/lang/reflect/AnnotatedElement;Ljava/lang/Class;)Ljava/lang/annotation/Annotation; please help me!
Mikhail Pavlov (4 years ago)
Good tutorials, thanks. But i got the same error as 'dimkinbel' described below. It is caused because apps that use this oracle database must be run in en_US locale. The solution for it is to add Java Virtual Machine's arguments as following: -Duser.language=en -Duser.region=us In Eclipse it can be done by going into "Window"->"Preferences"->"Java"->"Installed JREs"->Selecting JRE->"Edit"->Default VM arguments". Maybe this would help someone later.. Good luck!
Joni Lappalainen (4 years ago)
Thank you so much for making these good tutorial videos :) They really have been a great help.
Spirus Otinanai (4 years ago)
Congrats on your hard work and sharing the knowledge..
uma rani (5 years ago)
Hey! I got the following error. ERROR SchemaUpdate:201 - HHH000319: Could not get database metadata How to solve this?
dimkinbel (5 years ago)
WARN JdbcServicesImpl:169 - HHH000342: Could not obtain connection to query metadata : ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified ERROR SchemaUpdate:201 - HHH000319: Could not get database metadata java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-12705: Cannot access NLS data files or invalid environment specified
dimkinbel (5 years ago)
Arthur Hi. Can you please help in something While performed all SQL PLUS commands and updated the datasource-config.xml file with user and password , i'm getting next Errors on Server start-up Console (See next comment ) . Any ideas ? Thanks in advance
Serge Laflamme (5 years ago)
go Arthur for par 12 :)
Behzad Nazarbakhsh (5 years ago)
waiting for part 12 :p
Antonio Persichini (5 years ago)
Arthur, thank you for your very good work!!, I am with sinur3 and dahadex agree, great Stuff.
TheUzzi786 (5 years ago)
great work on integrating all the frameworks together.hope to see move videos in the future creating more advanced web applications with security etc.
dahadex (5 years ago)
It's nice to see your tutorial project being continued *cheers*. Aside from request that sunur3 is anticipating spring security in the next tutorial I would propose a whole topic on resource loading since it is a very special pain in pajamas if you want to use a modular application and keep views, flows and resources in separate maven modules in this case. Hope to see more on this EE stack soon. Thanks and really great stuff.
Cedric Laflamme (5 years ago)
For the Part12, please primefaces login security
Behzad Nazarbakhsh (5 years ago)
Thanks :-)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.