Ingres CAFÉ

Mailing List

Interested in Ingres CAFÉ? Join the: Mailing list

Project Information

Ingres CAFÉ is a web-application development stack, involving the following applications.

• Eclipse IDE

• Ingres Database

• Apache Tomcat

• Hibernate Libraries

• JSF Libraries

Currently Ingres CAFÉ is available only for Windows platform. (we're busy doing the Linux version and will post it soon)

CAFE_win32_v0.5.0.exe

MD5 = "830385c192f087c766e2dcc32d0219cf"

cksum = "2388017066 251847234 CAFE_win32_v0.5.0.exe"

Installation

Requirements

• Java Runtime Environment 6

Installer

After downloading the Ingres CAFÉ installer program, double click the installer program. The installer will create its directory in C:\Program Files\Ingres\ and copy its files. The setup will also launch the Ingres database installer. Select express mode and on the next wizard page choose Custom option and select the following components:

• Ingres Database Server Tools

• Ingres Networking

• Ingres Querying and Reporting Tools

This will install all the components of Ingres CAFÉ and create shortcut of Eclipse the Desktop.

Developing

Launch Eclipse by double clicking the shortcut on desktop and choose a workspace. Next go to File-> New-> Project. From the project categories choose Ingres Rapid App. This gives user to choose between:

• Ingres Demo Web Application Development

• Ingres Web Application Development

Ingres Demo Web Application

"Ingres Demo Web Application Development" option allows the user to create a demo application. Demo project is a pre-configured web-application project designed to run on top of demoDb schema present in Ingres database.

Getting the Demo Application and Using it

This is very simple two click step.

• Click Next on the project wizard after choosing "Ingres Demo Web Application Development". This will present Next wizard page informing user that a new project by the name Airline will be created in the selected workspace, and if another project by the name Airline is present, then it will be overwritten.

• Click finish to create the project.

Now the user should have Airline project in the Eclipse workbench window.

Running the project

• Right click on the Airline project and select Run as-> Run on Server.

• This will open Run on Sever Wizard with Apache Tomcat v5.5 already selected. Just click on Next.

• Next page shows the projects to run on this server. Since Airline is an already configured project, click next to run it.

This will open the the Airline application in a browser inside Eclipse

Ingres Web Application Development

"Ingres Web Application Development" allows the developer to create a web project with pre-configured JSF, Hibernate and Ingres DB communication libraries.

Creating a new Web project

• Click Next on the project wizard after choosing "Ingres Web Application Development". On the next wizard page enter the project name and from configuration select JavaServer Faces v1.1 Project and click Next.

• On the next wizard age modify the Java facet to use 5.0 or 6.0 and click Next.

• The next wizard page asks for Root Context, Content Directory and Java Source Directory. Modify the defaults if needed, otherwise click Next.

• Next Wizard page asks for JSF Libraries, select the radio button for JSF Implementation. The Component Libraries list will already have Ingres Project common libraries. Select them and click on the "> " button to Deploy them. Then click on Finish button to complete the project creation.