Geek Answers Handbook

Getting Started with Oracle Database

I was assigned the task of making our Java application work with Oracle Database. I don’t know where to start. I was hoping for an experience similar to working with MySQL or PostgreSQL, but there wasn’t such luck.

The answer to this question is a list of steps for installing and deploying an Oracle database for development, basic operations such as starting and stopping, creating and deleting schemas, and possibly even JDBC connection parameters.

A little about my project (although ideally the answer to this question will be as general as possible, and not tied to the specifics of my environment):

  • Java (and Scala) web applications deployed in Tomcat
  • Hibernate (currently connected to PostgreSQL and MySQL)
  • Developer workstations run OS X; for deployment to Red Hat Enterprise Linux
+5
source share
3 answers

First, don’t think about Oracle on OS X. You will need Linux (or Windows), possibly in a virtual machine /

Then decide whether you will use Oracle 10g or 11g. 10g has the free Express Edition , which is relatively easy to install on Linux or Windows. However, if you want 11g or bug fixes up to 10g or some additional options (compression, split ...), you will need a fully licensed version of Oracle. Depending on your workload, but you may have one physical machine that is licensed for Oracle, with several virtual machines (one for each developer).

XE , . , - .

+6

, Oracle, XE . , , Oracle .

, , oracle - ( ), . - , Oracle SQL Developer, , pgAdmin.

Oracle (10g ), .

: ( , Oracle ), .

+3

MySQL Oracle . , SQL. , , . DBA.

  • SQLDeveloper Oracle. . , SQL ..

  • " " "". , , SO. , .

  • JNDI. Tomcat, . QA prod .

  • - ! ! . DAO (), .

  • , Hibernate. , PK Oracle . FK, . .

  • Use Ant or Maven for your builds. Do not do anything manually.

  • Use SVN or similar.

What is now really.

+3
source

More articles:


All Articles