Happy Vesak Day 2554 BE / 2010

Namo Tassa Bhagavato Arahato Sammasambuddhassa

Vesākha
Pali; Sanskrit : Vaisakha / Vaiśākha वैशाख
International: Vesak
Indonesia       : Waisak

Vesak day is celebrated by Buddhist from all over the world to commemorate 3 event in Buddha’s life :

the birth of Prince Siddharta

the enlightenment (nibbana) of Gautama Buddha

the passing away (maha-parinibbana) of Buddha

Today, as Buddha’s teaching spread from India it was assimilated into many foreign cultures, and consequently Vesākha is celebrated in many different ways all over the world. Here the flag of Buddhist

The teaching of the Buddha is open to all to see and judge for themselves. The universality of the teachings of the Buddha has led one of the world’s greatest scientists, Albert Einstein to declare that ‘if there is any religion that could cope with modern scientific needs, it would be Buddhism.

The religion of the future will be a cosmic religion. It should transcend personal God and avoid dogma and theology. Covering both the natural and the spiritual, it should be based on a religious sense arising from the experience of all things natural and spiritual as a meaningful unity. Buddhism answers this description. If there is any religion that could cope with modern scientific needs it would be Buddhism. (Albert Einstein)

sabbe satta bhavantu sukhitatta
sabbe satta avera hontu (may all beings be free from enmity and danger)
saddhu…saddhu…saddhu…_/|\_

arti dalam Bahasa Indonesia:
sabbe satta bhavantu sukhitatta=semoga semua makhluk hidup berbahagia
sabbe satta avera hontu =semoga semua makhluk terbebas dari permusuhan dan bahaya

Elemen taglib in web.xml

When I validate web.xml, I got this error message :
XML validation started.
Checking file:/C:/temp/konoho/web/WEB-INF/web.xml…
cvc-complex-type.2.4.a: Invalid content was found starting with element ‘taglib’. One of ‘{“http://java.sun.com/xml/ns/javaee”:description, “http://java.sun.com/xml/ns/javaee”:display-name, “…..’ is expected. [685]
XML validation finished.

My previous web.xml

<web-app>
…
<taglib>
<taglib-uri>http://jakarta.apache.org/struts/tags-bean</taglib-uri&gt;
<taglib-location>/WEB-INF/tld/struts-bean.tld</taglib-location>
</taglib>

<taglib>
<taglib-uri>http://jakarta.apache.org/struts/tags-html</taglib-uri&gt;
<taglib-location>/WEB-INF/tld/struts-html.tld</taglib-location>
</taglib>
…
</web-app>

To fix this, add tag <jsp-config> , because <taglib>is not a direct sub-element of the tag <web-app>.

<web-app>
…
<jsp-config>
<taglib>
<taglib-uri>http://jakarta.apache.org/struts/tags-bean</taglib-uri&gt;
<taglib-location>/WEB-INF/tld/struts-bean.tld</taglib-location>
</taglib>

<taglib>
<taglib-uri>http://jakarta.apache.org/struts/tags-html</taglib-uri&gt;
<taglib-location>/WEB-INF/tld/struts-html.tld</taglib-location>
</taglib>
</jsp-config>
…
</web-app>

Indexing Tomcat Log File Format By Date

I want to change tomcat log file from this format “catalina.2010-05-17.log” to “2010-05-17.catalina.log”. With “date” as prefix, i can index the log file. But because prefix if remarked then the log file will add “juli.” as prefix, so i left prefix = .
To do that, here the steps,
1. Edit “logging.properties” file on [TOMCAT_HOME]/conf
2. Change some text like this

.
.
.
1catalina.org.apache.juli.FileHandler.prefix = .
1catalina.org.apache.juli.FileHandler.suffix = .catalina
.
.
.
2localhost.org.apache.juli.FileHandler.prefix = .
2localhost.org.apache.juli.FileHandler.suffix = .localhost
.
.
.
3manager.org.apache.juli.FileHandler.prefix = .
3manager.org.apache.juli.FileHandler.suffix = manager
.
.
.
4host-manager.org.apache.juli.FileHandler.prefix = .
4host-manager.org.apache.juli.FileHandler.suffix = .host-manager

Integrate Tomcat with Apache

I use Apache2.2 and apache-tomcat-6.0.26, so here these steps:

1. download mod_jk, you can find the latest version here
2. edit Apache httpd.conf, add :

# Load mod_jk
#mod_jk-1.2.30-httpd-2.2.3.so
LoadModule jk_module D:/oss/Apache2.2/modules/mod_jk.so

# Configure mod_jk
#
#JkWorkersFile D:/oss/apache-tomcat-6.0.26/conf/jk/workers.properties
#JkLogFile logs/mod_jk.log
#JkLogLevel info

JkLogStampFormat “[%a %b %d %H:%M:%S %Y] “
JkMount /*.jsp ajp13

#To be added at the end of your httpd.conf
#For using Tomcat auto-configure
Include D:/oss/apache-tomcat-6.0.26/conf/auto/mod_jk.conf

3. create file “workers.properties” to [TOMCAT_HOME]/conf

worker.list=ajp13w,wlb,jkstatus

#
# Defining a worker named ajp13w and of type ajp13
# Note that the name and the type do not have to match.
#
worker.ajp13w.type=ajp13
worker.ajp13w.host=localhost
worker.ajp13w.port=8009

#
# Defining a load balancer
#

worker.wlb.type=lb
worker.wlb.balance_workers=ajp13w

#
# Define status worker
#

worker.jkstatus.type=status

note:
- replace [TOMCAT_HOME] & [JAVA_HOME] to your local path

- for Apache 2, you don’t need AddModule mod_jk.c

- other related tips, click integrate tomcat with apache

Error On JPivot – Slice and Dice with two hierarchies – Using XML/A

After I had fix example on Mondrian – JPivot pivot table by XMLA, I try to fix JPivot example. On my localhost, http://localhost:8123/jpivot/, I had try all examples :
JPivot Demonstration
Using the Mondrian OLAP engine

* Slice and Dice with two hierarchies
* …and with four hierachies
* Dynamic parameters with Mondrian
* Arrows in Cells
* Colors in Cells
* Test data
* Dynamic parameters with test data
Everything is OK, but when I clicked Using XML/A example – Slice and Dice with two hierarchies, i got this error

Error on Mondrian – JPivot pivot table by XMLA

I have installed Mondrian 3.1.6.13364 with environments :
- Apache Tomcat 6.0.26 on port 8123 (D:\oss\apache-tomcat-6.0.26)
- Java version 1.6.0_17 (C:\Program Files\Java\jdk1.6.0_17)
- Access Database with ODBC MondrianFoodMart (D:\pentaho\mondrian\demo\access\MondrianFoodMart.mdb)

I run on http://localhost:8123/mondrian/, i see :
Mondrian examples:

* JPivot pivot table
* JPivot pivot table by XMLA
* JPivot with 4 hierarchies
* JPivot with role ‘California Manager’ set
* JPivot with arrows
* JPivot with colors
* Various queries formatted using the Mondrian tag-library
* Basic interface for ad hoc queries
* XML for Analysis tester

Other links:

* Mondrian home page
* Mondrian project page
* JPivot home page
* JPivot project page

Every Mondrian examples link is OK, except JPivot pivot table by XMLA

I’ve search and found a lot of discussion about this issue, but the most help are the following link :
1. http://lists.pentaho.org/pipermail/mondrian/2009-January/001550.html

rem for JDK 1.6 – force the use of Axis for SOAP not the internal JDK web services implementation
set JAVA_OPTS=%JAVA_OPTS%
-Djavax.xml.soap.MessageFactory=org.apache.axis.soap.MessageFactoryImpl
-Djavax.xml.soap.SOAPConnectionFactory=org.apache.axis.soap.SOAPConnectionFactoryImpl
-Djavax.xml.soap.SOAPFactory=org.apache.axis.soap.SOAPFactoryImpl

rem for JDK 1.6 – use xalan, not JDK 1.6 internal Xalan implementation
set JAVA_OPTS=%JAVA_OPTS%
-Djavax.xml.transform.TransformerFactory=org.apache.xalan.processor.TransformerFactoryImpl

2. http://lists.pentaho.org/pipermail/mondrian/2009-January/001553.html

add the following jars into mondrian web app library :
- axis-1.4.jar
- commons-discovery-0.4.jar
- jaxrpc-api-1.1.jar
- wsdl4j-1.6.2.jar

Below the error when i click JPivot pivot table by XMLA

Change Default HTTP Port 8080 in Oracle Express Edition

1. login as sysdba user, use sqlplus
   C:\Users\wi>sqlplus wi/wi@xe as sysdba
2. SQL > exec dbms_xdb.sethttpport(’8181′);
   PL/SQL procedure successfully completed.

Different between download Binary and Source Code

I wonder what different between download Binary and Source, so after searching, here some diffs:

• Source code is the set of instructions the programmer writes; it’s not in executable form until it’s compiled/linked into a binary or until it’s parsed by an interpreter. (There’s another possibility called “bytecode” which is a preparsed form that speeds up interpretation.)
• Source code
  Advantages
  When you compile your source packages they are tailored much more to the system, and thus will give better performance, as it is more optimized for your system. It is also generaly smaller and doesn’t take up as much room on the hrd drive or your bandwidth.
  Disadvantages
  They can take a long time to compile all of the program. Also the dependancy issues can be slightly mor difficult to desipher.
• Binary
  Advantages
  They are usually quick and easy to install, and some can resolve dependacy issues for you.
  Disadvantages
  They are big files, and take up more space. They are usually enabled with all the options on the install, and thus the file isn’t as well tailored for your system, andit will run slower (this is one of the reasons why source based distro’s like gentoo are so fast).

ORA-01122: database file 1 failed verification check

When database startup, it send this message to the console,

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1:
‘D:\ORACLE\PRODUCT\10.2.0\ORADATA\ITCAPPS2\SYSTEM01.DBF’
ORA-01207: file is more recent than control file – old control file

To fix this, try

1. alter database backup controlfile to trace;
2. startup nomount;
3. recover database using backup controlfile;
4. alter database open;

Hope this will work ^_^

OLTP – OLAP

OLTP (Online Transaction Processing) – row oriented

OLAP (Online Analytical Processing) – column oriented

good design

To check if OLAP is installed and correctly configured, use this statement:
select comp_name, version, status, modified from dba_registry where comp_name like ‘%OLAP%’;

COMP_NAME VERSION STATUS MODIFIED

OLAP Analytic Workspace 10.2.0.1.0 VALID 29-OCT-2005 01:37:54
Oracle OLAP API 10.2.0.1.0 VALID 29-OCT-2005 01:37:54
OLAP Catalog 10.2.0.1.0 VALID 29-OCT-2005 01:37:56

ORA-30371: column cannot define a level in more than one dimension

Cause

A column was used in the definition of a level after it had already been used to define a level in a different dimension.

Action

Reorganize dimension levels and hierarchies into a single dimension such that no column is used to define levels in different dimensions. There is no limit on the number of levels or hierarchies you can place in a dimension. A column can be used to define any number of levels provided all such levels are in the same dimension and provided no two levels contain identical sets of columns.