Terrence Miao

's adventure

Posts Tagged ‘Database’

How to set up and run MySQL on Red Hat Linux 6.1 without being root/su?

May 3rd, 2013

jenkins@ci ~
11:36:57 317 $ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.1 (Santiago)
jenkins@ci ~
11:37:07 318 $ uname -a
Linux hx371 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

Download MySQL 5.1 (mysql-5.1.68-linux-x86_64-glibc23.tar.gz) from http://downloads.mysql.com/archives.php?p=mysql-5.1&v=5.1.68
Unzip tar ball into ~/mysql-binary directory
Create ~/mysql/data, ~/mysql/log, ~/mysql/run directories

Create ~/my.cnf file:

jenkins@ci ~
11:41:18 321 $ cat my.cnf
[server]
user=jenkins
basedir=/u01/apps/jenkins/mysql-binary
datadir=/u01/apps/jenkins/mysql/data
socket=/tmp/mysql.sock
port=3306

[safe_mysqld]
log_error=/u01/apps/jenkins/mysql/log/error.log
pid-file=/u01/apps/jenkins/mysql/run/mysqld.pid

Set up database:

jenkins@ci ~/mysql-binary
11:43:37 762 $ ./scripts/mysql_install_db --defaults-file=~/my.cnf --user=jenkins --basedir=/u01/apps/jenkins/mysql-binary --datadir=/u01/apps/jenkins/mysql/data --socket=/tmp/mysql.sock

Start up database:
```
jenkins@ci ~/mysql-binary
11:44:58 762 $ nohup ./bin/mysqld_safe --defaults-file=~/my.cnf &
```
» Read more: How to set up and run MySQL on Red Hat Linux 6.1 without being root/su?

No comments »

Posted in Technology

Tags: Database MySQL

JSF 2, Spring 3, Spring MVC 3, Hibernate 4, Tomcat 7 – a lightweight approach

April 22nd, 2012

“What is your favourite design pattern?” Question asked in a job interview.

WTF question is that?

“Hmmm… my favourite design pattern is Salami pattern – approaching to the finish line slice by slice.”

– From Antidisestablishmentarianism I.T.

In my previous blog - Spring 3 shacks up JSF 2, the maverick way, demonstrating how JSF 2 a component, event driven framework as the presentation layer, and Spring 3, Spring MVC 3 work in middleware. Well, technology keeps evolving. Hopefully even pigs could programe one day. This time, Hibernate 4 is added as the persistence layer. Now, we have end-to-end, a “traditional” three tiers web application. Moreover, an unit test to test business logic layer, the most important, runs outside of container.

Firstly, files and directories structure:

The backend database is Oracle’s example of Human Resources (HR) application for a fictitious company (check the reference at the end of the blog).

No comments »

Posted in Technology

Tags: Database Development Hibernate Java JSF Maven Oracle Spring Tomcat

Step by step to create a dynamic Map chart in APEX

April 11th, 2012

In last blog, I demo how to create a dynamic 3D bar chart in APEX. Now let’s have a bit fun – let’s create a map chart in APEX. It is based on the same example of Human Resources (HR) application for a fictitious company called ManyCo Corp.

I’m going to create a map page for ManyCo app, drawing a map including number of employees around world by each country.

Log on APEX, select ManyCo app, click on “Create Page” button and select “Chart”, then click on “Next”:

Choose “World and Continent Maps” in Select Map Type step, then click on “Next”:

Choose “World” in Create Map page, then click on “Next”:

No comments »

Posted in Technology

Tags: Database Development Oracle

Step by step to create a dynamic 3D bar chart in APEX

April 10th, 2012

Here I’m going to demo how to Step by step to create a dynamic 3D bar chart in APEX.

Remember Oracle has this an example of Human Resources (HR) application for a fictitious company called ManyCo Corp?

Here is ManyCo departments page. Remind you ManyCo has several offices around world:

I select IT department, in employees page, five staff belong to IT listed. This time, we are going to particular interested in “Hire Date” field:

Now I’m going to create a chart page for ManyCo app, drawing a chart including employees hired by year.

Log on APEX, select ManyCo app, click on “Create Page” button and select “Chart”, then click on “Next”:

No comments »

Posted in Technology

Tags: Database Development Oracle

Rapid application development with Oracle Application Express

April 5th, 2012

When people were growing up in 1960′s and 1970′s, labour and time saving machines are propelling engine for productivity. So that you can see top-loading washing machine had replaced the front step, than came the television with remote control, which meant you no longer had to sit through 24 hours weather channel because you couldn’t be bothered get off your bums.

Life was very good.

But, it doesn’t much the same story in IT.

When database invented and became core repository storing business information, people in company’s IT department became mad loading tons and tons relevant and irrelevant data into it without considering the best way to utilise and mine them; and after WWW invented, so web based application was getting into the mainstream for lightweight and loose-coupling enterprise IT solution, and you got dot-com bubble and new bubble now change theirs name to web 2.0 and social network …

To developers, life is getting worse and worse. Automation in IT didn’t reduce developers work hours, but make them more overworked and underpaid.

Developers have to have a board knowledge base, mastering every technology aspect from client to server, craftmaning from business logic implementation to unit test developing.

There is an example. The requirement is to develop a web-based application, to let end-users browse, view, search and report some business information stored in back-end database.

First thought you would like “OK, it’s web app we should go with JSP, Struts for front-end; with back-end database, we could go with Hibernate, and use Spring to “glue” all these components together. Oh, you want to generate some ‘sexy’ report as well, we can use Open Source graphic tools GNU, erh …, something. Sorry, I can’t remember the exact name”.

No comments »

Posted in Technology

Tags: Database Development Oracle

Step by step to install Oracle Application Express (APEX) 4.1.1

April 2nd, 2012

I’m now showing you a step by step instructions how to install Oracle Application Express (APEX) 4.1.1 on Windows 7. With help from Cygwin environment.

Download Oracle Application Express (APEX) version 4.1.1 and Listener from OTN website: http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html and http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html
Run sqlplus and log on database as user SYS:
sqlplus SYS/Welcome1@localhost:1521/OracleDB as sysdba
Create tablespace “APEX”:
DROP TABLESPACE APEX INCLUDING CONTENTS AND DATAFILES;
CREATE TABLESPACE APEX DATAFILE 'C:\APP\ORADATA\ORACLEDB\APEX01.DBF' SIZE 256M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED LOGGING ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE BLOCKSIZE 8K SEGMENT SPACE MANAGEMENT AUTO FLASHBACK ON;

Assume you are under APEX package directory, then run the APEX installation sql script:



SQL> @apexins APEX APEX01 TEMP /i/

The installation will take a while. Time for a cup of tea till you see these on the screen:

...
...Compiled 701 out of 2896 objects considered, 0 failed compilation 14:01:03

...253 packages

...245 package bodies

...447 tables

...12 functions

...19 procedures

...3 sequences

...445 triggers

...1266 indexes

...196 views

...0 libraries

...6 types

...0 type bodies

...0 operators

...0 index types

...Begin key object existence check 14:01:03

...Completed key object existence check 14:01:03

...Setting DBMS Registry 14:01:03

...Setting DBMS Registry Complete 14:01:03

...Exiting validate 14:01:03

timing for: Validate Installation

Elapsed: 00:02:10.40

timing for: Development Installation

Elapsed: 00:15:59.51

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Unpack APEX Listener to e.g. C:\app\apex directory

» Read more: Step by step to install Oracle Application Express (APEX) 4.1.1