Conception of Information Systems - Summer Semester 2005

Exercise Organization

1. Overview

For part 1, the exercises are of practical nature and serve to experience some of the technologies directly. They will be posed in a way that they can be solved in principle on paper, but we will offer the opportunity to gather practical experiences. Exercises are not marked.

There will be five exercises:

  • XML
  • JDBC and JSP
  • Distributed Transactions
  • JMS and Enterprise Java Beans
  • Web Services

You can use the computers in IN1/3. Questions can be posed in the newsgroup epfl.ic.cours.CIS or personally to the responsible assistants during the specified office hours. Solutions for the exercises and  introduction to the new exercises will be presented during the exercise hours.

2. Infrastructure

You will work in the room IN3, which is reserved for this course every Wednesday 16-18h. Every second week, starting from Wednesday March 17, we will have an exercise session in this room.

In the first exercise you will work with some XML basics and you will use only computers from IN1/3. However, for the exercises 2-5 you will use J2EE application servers, installed on our Linux machines. Thus, you will use SSH to log in to our computers with J2EE servers and work remotely. The addresses of the computers are: lsir-cis-pc9.epfl.ch ... lsir-cis-pc12.epfl.ch. Let us use the notation lsir-cis-pcX.epfl.ch, where X=9,10,11,12, to denote these computers.  The usernames are user01 ... user05 or, user0Y, where Y=1,...,5.

 

For the exercises 2-5 you will be working in groups of two. Each group will use username user0Y and machine lsir-cis-pcX.epfl.ch, where X and Y are different for each group. To obtain X, Y and password for your group you will have to register here. You must change the passwords after the first login. In case of problems please communicate with Martin Rubli (martin.rubli at epfl.ch).

 

Thus, the working environment for any group is completely determined by these two numbers, X and Y. So if you have for instance, X=9 and Y=1 you will use the command ssh -Y user01@lsir-cis-pc9.epfl.ch to log in (of course, 'Y' in the above command is a flag of the command, it should not be replaced with 1). When you log in you will be paced in your home directories. Of course, you can create new subdirectories in your home directory and organize them as you wish.

J2EE Servers

 

You are expected to read the documentation and get familiar with the basics of the environment  (starting and stopping the  servers, their organization, etc.). Please use /opt/j2ee0Y/docs/QuickStart.html (and the links you find in this document) to learn the basics about the server and http://java.sun.com/j2ee/1.4/docs/tutorial/doc/index.html to learn more about the J2EE architecture.

 

Please keep in mind that the port numbers on your system are different from the default ones. The following three numbers are of interest to you:

  • HTTP port -  800Y  (the default is 8080)
  • Server administration port  - 480Y  (the default is 4848)
  • Database server port - 500Y  (the default is 9092).

(Needles to say, Y is here the user number that you have.)

To deploy applications and administer the servers you can use the username admin (the same for all systems). The passwords will be distributed separately. As before, you can change them, but do not forget to mail us (the responsible assistant) the new passwords.

Database Servers

 

As you could already figure out, there is a DBMS bundled with J2EE server. The name of the product is PointBase. Please use pdf documents (console guide, developer's guide, system guide) to learn more about this database system. In particular, the SQL reference is in the developer's guide.