Online Informations

r-onlineinformation.blogspot.com   Setting up Eclipse and Tomcat Page Setting up Eclipse and Tomcat NOTE: Please do not download any softwares right now. All softwares are already copied into your desktop. To create Servlet projects, you need to use a version of Eclipse with J2EE support built in. The default version of Eclipse which you get with Ubuntu does NOT include J2EE support, so you have to download a version of Eclipse with J2EE support. You can get it from the Eclipse download site: http://www.eclipse.org/downloads/    ( choose according to your hardware configuration and OS) Version: We are using Eclipse Juno (4.2) Enterprise Edition in the workshop.  We suggest you also use this version, although an older version should also work fine if you are already familiar with it and using it currently. After downloading, extract the compressed archive on your local file system. Then eclipse can be started by double-clicking on the ecli...

r-onlineinformation.blogspot.com   Using Eclipse: an Introduction STARTING ECLIPSE Start eclipse by directly Biologydouble clicking the file "eclipse" inside the extracted folder (Eg. /home/ /Desktop/software/eclipse. This could be different and depends on where you have extracted the eclipse archive). Select the working directory to save your current project. The default directory will be /home/ /workspace Start A New Project Click File->New Choose "Dynamic Web Project" Provide a name for the project Choose the option "New Runtime" and a New runtime window opens Choose "Apache Tomcat v7.0" and say Next. In the "Tomcat installation directory", browse and select "/home/ /Desktop/software/apache-tomcat-7.0.2" Click Finish Click Finish Running a Hello world program in eclipse Click File-> New -> Java project -> give project name -> finish Right click on project name -> new -...

r-onlineinformation.blogspot.com   How to draw ER models ER Models can be drawn using any of several tools.   Among these Dia is a very convenient open source tool which runs on multiple platforms including Linux, Windows and MacOS. Dia has a number of "sheets" each of which includes diagram objects for different modeling tools, such as UML, ER diagrams, flowcharts, etc. The ER tool has objects for entities, relationships, attributes (using the oval notation), edges, and so on.  The properties boxes for each of these elements allows you to specify cardinality constraints, total participation, identifying relationship, etc. To create the ER notation used in the Database System Concepts 6th Ed book, we use the UML class objects instead of ER entity objects in Dia.  Open the properties of the class object and give it a name (entity set name), and add attributes.  Select Visibility  Implementation to remove the + before the attribute nam...

r-onlineinformation.blogspot.com Tips for running queries on Oracle We encourage the use of PostgreSQL for the labs, to expose students to an excellent open source database.  However, if your syllabus forces you to use Oracle (and all participants at your remote centre are also from universities where they are forced to use Oracle), you can do assignments on Oracle.  Our model solutions will often give syntax errors on Oracle due to non-support for some SQL features in Oracle.  Below are some tips on how you can rewrite the queries to work on Oracle. Oracle SQL Tips: non-standard features, and limitations The following issues are for Oracle 10, and may or may not apply to later versions of Oracle. Oracle does not support the  as  clause, except as part of the "with" statement. In all other cases, just use the same syntax without the "as" keyword, and things should work. To use a single quote in a string, use two consecutive single qu...