Search about sql type

Connecting to the NetRegistry MySQL Server
When your database is initially created, you will be issued with a username and password to access your database. NetRegistry gives you full control over your database however, it is MySQL that imposes some limits upon users and allows them to perform only certain functions).

To login through the MySQL client, you will need to use a connection string (which is available from the Technical Support Staff at NetRegistry) similar to the following:

mysql <database> -h caelum.netregistry.com.au -u <username> -p <password>

If you are using other MySQL enabled database management software to login, you will only require the hostname (caelum.netregistry.com.au) and your username and password.

Main Features of MySQL
Below are some of the important characteristics of MySQL and what it supports as listed at http://www.mysql.com/doc/F/e/Features.html:

• Fully multi-threaded using kernel threads. That means it can easily use multiple CPUs if available.

Introduction
MySQL is a popular database with more than 4 million users. It is one of the fastest relational databases in the market. Many companies are using it to support their websites, data warehouses, and business applications. MySQL was developed by a Swedish company named MySQL AB. The product is distributed under GNU General Public License (GPL). It can support multiple users concurrently on the network. Students can connect to a MySQL database server standalone on their own computer or from the network. You can download it free from http://dev.mysql.com/downloads/mysql/4.1.html. MySQL runs on Windows, Linux and Solaris. This tutorial demonstrates using MySQL from the Windows operating system.

Starting and Stopping MySQL Server
If your database server is not started, you can start it by typing “net start mysql” from the MySQL bin directory as shown in Figure 1.1. You can stop it by typing the command net stop mysql.

The SQL Map File(s)
Now that we have a DataSource configured and our central configuration file is ready to go, we will need to provide the actual SQL Map file which contains our SQL code and the mappings for parameter objects and result objects (input and output respectively). Continuing with our example above, let’s build an SQL Map file for the Person class and the PERSON table. We’ll start with the general structure of an SQL document, and a simple select statement:

The above example shows the simplest form of SQL Map. It uses a feature of the SQL Maps framework hat automatically maps the columns of a ResultSet to JavaBeans properties (or Map keys etc.) based on name matching. The #value# token is an input parameter. More specifically, the use of “value” implies that we are using a simple primitive wrapper type (e.g. Integer; but we’re not limited to this).

Chapter 1. Installing a Rocks Cluster

1.1. Getting Started
The advantage of using Rocks to build and maintain your cluster is simple. Building clusters is straightforward, but managing its software can be complex. This complexity becomes most unmanagable during cluster installation and expansion. Rocks provides mechanisms to control the complexity of the cluster installation and expansion process.

This chapter describes the steps to build your cluster and install its software.

1.1.1. Supported Hardware
Since Rocks is built on top of RedHat Linux releases, Rocks supports all the hardware components that RedHat supports, but only supports the x86, x86_64 and IA-64 architectures.

Processors :

• x86 (ia32, AMD Athlon, etc.)
• x86_64 (AMD Opteron and EM64T)
• IA-64 (Itanium)

Networks :

• Ethernet (All flavors that RedHat supports, including Intel Gigabit Ethernet)
• Myrinet (provided by Myricom)
• Infiniband (provided by Voltaire)

1    I NTRODUCTION
1.1    P URPOSE AND S TRUCTURE OF THIS D OCUMENT
This document is intended to get people started with R-GMA. It is one of a set, with each member customised for a different programming language.

After this introduction there are sections explaining what should be done to ensure that R-GMA is correctly installed, how to publish information via a “Primary Producer”, how to get information back via a “Consumer”, how to set-up a “Secondary Producer” and how to use the command line and web based tools.

The APIs (in C, C++, Java and Python) are all described in detail in the documentation linked from http: //hepunx.rl.ac.uk/egee/jra1-uk/r-gma/ . In addition the documentation is all distributed with the software and may be found as $RGMA_HOME/share/doc/<module>/manual.pdf, where “module” identifies the document. Look at the directory $RGMA_HOME/share/doc to see the naming scheme.

Prerequisites

• fair knowledge of Java (or at least object oriented programming concepts in another language)
• knowledge of HTML
• basics of web applications (preferably J2EE)
• Fair knowledge of SQL (SELECT, stored procedures, triggers)
• knowledge of source control (e.g. Subversion) is a plus

Minimum Laptop Requirements

• dual core processor
• 2Gb RAM
• Linux/Windows OS (MacOS is strongly advised against)
• installed latest community edition of Openbravo ERP (if not, a virtual appliance will be provided on the course) – Postgres database should be used since all materials and solutions are based on it.

01 – Welcome and Introduction
This first session will welcome you to the course and give you an overview and the schedule of the following weeks topics.