I consider JDeveloper as a great data base design tool for some reasons:
- It can navigates through the Oracle databases
- It has a very good ER editor.
- It can change the data base schema when you modify the diagram
We can download from Oracle’s web the last JDeveloper version for our operating system. Installing is very easy, you just must have installed the JDK.
Read the rest of this entry »
Oracle XE is the 10g version light Data Base implementation for developers and DBAs who wants to make local tests.
It installs downloading the executable file from the Oracle’s web. I had installed the Windows version, virtualizing my Windows XP over VirtualBox (>>) on my Ubuntu.
For administering the Data Base we have a web application at http://192.168.0.7:8080/apex/:

You can take an idea about the hardware requirements, in my basic installation, the data base fits 605 MB RAM and 880 MB of hard disc. You can see it in the last figure.
Now we will create a data base to host the data of our application. In the web administration application click on Administration > Database Users > Create User, and we create the user school with the same password, checking all the system privileges for it:

Then we have create the school schema, with a user with all the privileges to develop in the data base.
Before access from a remote connection we must activate the option Administration>Manage HTTP Access > Available from local server and remote clients, in the web console.
After that we can connect from any application: Eclipse, JDeveloper, PL/SQL Developer, SQLDeveloper,… In the following screenshot I show how to connect from eclipse even it is our favorite IDE, and with a single screenshot we can see the needed configuration for the connection:

We have the purpose to define some architectures for web application development. To do this we ar going to base in a extremely easy example, which help us to see how to develop with the choosen technologies and how to integrate them.
For a develeoper is e隆very important to see somthing runs ever it is very easy. After he can marchal the own application complexity.
Read the rest of this entry »
This post comes from the last, which treats my generic definition for a Web Applications Development Architecture.
Taking basis in Oracle documentation, investing on internet, and searching the most realistic situation for an enterprise environment, I purpose the following architecture WebLogic based:

The figure shows the generic architecture against Oracle’s one:
- JSF: MVC on presentation layer, wanting to avoid javascript and crossbrowsing.
- JAX-WS: the standard to make Web Services
- Jasper: tool to make reports in many formats (PDF,XSL,DOC,..) and from many data sources (SQL, XML, XLS,….)
- Spring: creating service layer, and using Dependecy Injection in the other layers.
- EclipseLink: JPA implementation.
- Weblogic: JEEreference server for Oracle (at the moment).
- Java 6: advantages of 6 version of Java language.
- Eclipse OEPE: Eclipse Oracle distro, with its best tools for this IDE.
After long time without posts, and huge not very regular, I have wash up the blog, and mainly to my profesional objectives.
In the following posts I will try to define a enterprise web applications architecture development (big data volume, mixed developers, big servers, grid,…) and an enterpreur architecture (low cost, agile development and fast, escalable,…).
Read the rest of this entry »