Oracle XE: Installation and starting with the Data Base
Jun 25, 10 by Juan Lebrijo about Oracle, Database, blog
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/:
oraclexe_admin.thumbnail.png 9.11 KB
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:
create_db_user.thumbnail.png 10.9 KB
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:
eclipse_db_connection.thumbnail.png 13 KB
Example Application: Courses Certificates
Jun 23, 10 by Juan Lebrijo about requirements, arquitechture, blog
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. Title: Courses Certificates Definition: Application which will certificate the finished course by a person in our academy, school.lebrijo.com. Requirements:
  • Through a form the user be able to ask for the certificates by a NIF (Spanish Fiscal Identify number).
  • Through a Web Service , third applications be able to check how many courses a person has finished with a NIF.
  • It will generate this list of courses in PDF and XLS formats (Reports).
  • Security: ensure the data access with a user/password credential
  • Every request must be registered in a table called REGISTRY, to know when and whom we certificated what.
Aplicación ejemplo: Certificación de cursos
Jun 23, 10 by Juan Lebrijo about requirements, arquitechture, blog
Nos hemos propuesto definir varias arquitecturas para el desarrollo de aplicaciones web. Para ello nos vamos a apoyar en un ejemplo extremadamente fácil que nos ayudará a ver como se desarrolla con las tecnologías elegidas y como se integran estas. Para un desarrollador es muy importante ver algo funcionando aunque sea muy sencillo, para luego armar la complejidad de tu propia aplicación. Título: Certifica Cursos Definición: Aplicación que certificara los cursos realizados por un individuo en nuestra academia, school.lebrijo.com. Requisitos:
  • Mediante formulario un usuario será capaz de consultar los certificados para un NIF (Número de Identificación Fiscal Español) dado.
  • Mediante un Web Service, aplicaciones de terceros van a ser capaces de comprobar cuantos cursos ha realizado un alumno con un NIF dado.
  • Generar esa lista de cursos para un NIF dado en formatos PDF y XLS (reports).
  • Seguridad: asegurar el acceso a esos datos mediante usuario y contraseña.
  • Toda consulta debe quedar registrada en una tabla REGISTRO, para conocer cuando y a quien le hemos certificado qué.