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

This part shows how to setup Oracle database, create new user/schema, and establish the connection between DB and application.

Source code:

[didarulalamrahat]

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]

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

[zape]

Arthur, thank you for your very good work!!, I am with sinur3 and dahadex agree, great Stuff.

[spirusotinanai]

Congrats on your hard work and sharing the knowledge..

[crimsonpenguins]

Thank you so much for making these good tutorial videos :) They really have been a great help.

[MikePavlov]

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 JREs"->Selecting JRE->"Edit"->Default VM arguments".
Maybe this would help someone later.. Good luck!

[sinur]

For the Part12, please primefaces login security

[gettingthereslowly]

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.

[umarani]

Hey!
I got the following error.
ERROR SchemaUpdate:201 - HHH000319: Could not get database metadata
How to solve this?

[benheniameriem]

Good tutorial, but i have error when i start tomcat:  Error creating bean with name 'dataSource' defined in ServletContext resource Initialization of bean failed; nested exception is java.lang.NoSuchMethodError:
please help me!

[dimkinbel]

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

[dimkinbel]

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

[suntossh]

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