Java – getting started with Oracle Database

I was assigned the task of making Java Web applications work with Oracle databases I don't know where to start I hope to have experience similar to using MySQL or PostgreSQL, but I don't have such luck

The answer to this question will be the list of steps to install and deploy Oracle database for development, basic operations (such as start and stop, create and delete modes, and even JDBC connection parameters)

Some background on my project (although ideally the answer to this question will be as generic as possible, rather than linked to the specific circumstances of my environment):

>Java (and scala) web application deployed in Tomcat > hibernate (currently connected to PostgreSQL and MySQL) > developer workstation running OS X; The production deployment is for Red Hat Enterprise Linux

Solution

First, don't consider oracle on OS X You need Linux (or windows), possibly on a virtual machine/

Then decide whether you want to use Oracle 10g or 11g 10g has a free Express Edition, which is relatively easy to install on Linux or windows However, if you want 11g or bug fix 10g or some additional options (compression, partitioning...), you will need a fully licensed version of Oracle It depends on your load, but you can have an Oracle licensed physical machine with multiple VMS (one per developer)

Xe has a database instance that setup will configure to start when the computer starts If you only use VM for database, using computer to start and shut down database is the easiest way