How to start JAVA training for use with Oracle RDBMS?

Question

I’m looking for some tips on how to focus my efforts to get the necessary skills to become a Java developer for Oracle applications. I'm a little confused as there are many technologies in the Java world. Where to begin? What should i avoid? Is JDeveloper a good IDE for beginners?

Answer 1

To become an Oracle developer, you need to learn more than jdbc. You should take a look at the Oracle website. It is rather slow and not very intuitive, but has a lot of good information. There are OUGs who also have good info.

If you just want to access Oracle through JAVA, you should use a framework like Spring. Relieves pain jdbc. Allows you to write sql and map it to objects.

If you do not know PL / SQL, it may be good to know what it is.

My two cents from working with Oracle over the past 7 years.

Answer 2

Your question is too vague to give the correct answer ...

If you plan to query the Oracle database from an external Java program (either in the Swing Application or in the Application Server), you need to learn two main APIs:

• JDBC (Java Database Connection)

• JPA (Java Persistence API)

JDBC is the main API that allows a Java program to interact with any RDBMS, so you should at least know how it works, so when you have to dig into low-level code, you really know what happens.

JPA is the latest Java API for Persistence, which basically allows you to map a regular static Java object (AKA PoJo) with RDBMS table structures. There are several well-known implementations, but I would recommend Hibernate or TopLink as a starting point.

After that, you can start digging into other well-known frameworks, such as the Spring Framework, for some other RDBMS-related APIs.

Answer 3

You should be able to do everything related to Oracle using JDBC , so make sure you switch to this API. Other than that, it depends on the type of application. Standalone applications can use Swing (the Java UI toolkit) or in the future JavaFX, which is supposed to make Swing obsolete and can do this in a few years. Web / enterpriseisey applications will use Java Enterprise Edition, so look at the servlet API, and if the application uses Enterprise JavaBeans, look at the Java Persistence API , which you will probably use instead of JDBC.

I did not use JDeveloper, but I did not find anything wrong with free IDEs like Eclipse or Netbeans , and my personal favorite is the JetBrains IntelliJ IDEA .

Answer 4

Actually there is nothing concrete that you need to learn to be the oracle-scout as such. Obviously, you need to learn Oracle's sql syntax and the entire standard rdbms theory, which combines with database programming in general. Java libraries for database support are pretty easy to pick up and run. I'm sure you can find google quick search tutorial online.

Regarding the IDE, I would recommend Eclipse. It's a bit cumbersome at times, but the number of available plugins varies, and it has excellent support for refactoring and code completion.

Answer 5

Oracle Expert JDBC Programming is a book specifically for developers who want to use Java with Oracle. Before you make even a small investment, you can check out the JDBC tutorial published by Sun.

Answer 6

You can use JDeveloper and try to find some tutorials for it (I actually had some from my university). It integrates well with the rest of the Oracle package (db and application server). Down is that although you can download some developer releases to run for personal use by running Oracle db + Oracle + JDeveloper application server on a machine with less than 4 GB of RAM, and one core is not really a peasant.

Answer 7

Your question is very simple, so I have listed a few simple steps to get started developing a Java application using Oracle technologies.

• Install Oracle XE Database.
• Install [JDeveloper]. Choose an installation using Weblogic if you are developing a J2EE application.
• Build and run the jdbc application using the [sample code] code or use the wizard in JDeveloper.
• Install SQL Developer to record stored procedures.

Steps 3. and 4. are optional. Now you have everything you need to build either a proof of concept or an enterprise-level database application using simple wizards and not reinventing the wheel.

You mentioned Oracle application development. It's best to leave the development of an Oracle application for Oracle directly, but if you want to integrate your custom Java application into an Oracle package application, use the Oracle SOA Suite.

Greetings

KB