Netbeans 6.8 with Tomcat 6.0.20 - Requires JDK 6 Update 20

Netbeans 6.8 + Tomcat 6.0.20

Tested worked with JDK 6 Update 20

JDK 6 Update 19, JDK 6 Update 21 failed to work

Error:
In any jsp file, Netbeans will highligh error for the following lines

<%@ page contentType="text/html" session="true" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>

*Courtesy of Andy Lim*

给宠物狗的鞋子 ： 一双/两双？

周五，吃了晚饭和同事到新开的宠物店闲逛。一边赞叹琳琅满目的宠物食/用品，同事指了指包装精美的四只宠物狗鞋子。

下意识的，我回应说“不错哦，有两双可以替换”。。。。

“两双？”，同事楞了楞说道。

我说“对啊，四只不就两双吗？”。。。。

“狗有四只脚。。。。”

哈哈，惯性思维。总想着人就一双两只鞋呗，所以见到四只鞋子就理所当然的以为是两双，还“替换”呢！

其实日常工作中，常有因为惯性思维而闹笑话的事，很多时候当事人并不知晓犯了什么错误，就像我一样，愣是得意着。

注：请不要咬文嚼字计较四只，该说是一套/一双/两双？重点在于“替换” 与 “惯性思维”

Jasper Report + Oracle CURSOR_SHARING='FORCE'

Notice that if i set the Oracle Initialization Parameter

CURSOR_SHARING = 'FORCE' or
CURSOR_SHARING = 'SIMILAR'

the Jasper Report (iReport) with UNION query does not work. It shall give the following error:

java sql sqlexception : no more data read from socket

To solve this, I have to tell the optimiser to switch off the cursor sharing feature for this query by inserting the phrase /*+ CURSOR_SHARING_EXACT */ into the query.

E.g.
SELECT /*+ CURSOR_SHARING_EXACT */ field 1 FROM TABLE 1
UNION
SELECT field 2 FROM TABLE 2

References:
1. Extract from http://www.psoug.org/reference/hints.html

Oracle can replace literals in SQL statements with bind variables, when it is safe to do so. This replacement is controlled with the CURSOR_SHARING initialization parameter. The CURSOR_SHARING_EXACT hint instructs the optimizer to switch this behavior off. In other words, Oracle executes the SQL statement without any attempt to replace literals with bind variables.

2. CURSOR_SHARING :
http://www.oracle.com/technology/oramag/oracle/06-jan/o16asktom.html

jQuery/Plugin : Problem with Add/Remove row for Tablesorter Plugin

For using the jQuery tablesorter (http://tablesorter.com/docs/ ), the table will not refresh correctly if you use the additional pager plugin.

To solve this problem, you have to add in 2 customised functions/events to take care of the row adding/removal.

Add the following 2 functions to the tablesoter javascript file.

function addRow(table, newRow){

//Rebuild html table from the modified rowsCopy
$.tablesorter.clearTableBody(table);

if (table.config.rowsCopy!=undefined)
$.each(table.config.rowsCopy, function() {
$(table).find('tbody:first').append($(this));
});

//Append new row to the HTML table
$(table).find('tbody:first').append(newRow);

//Update call will rebuild tablesorter.cache from the existing HTML table
$(table).trigger("update");
//With pager plugin, this will call appender function in pager
//In turn, it will redraw the table with pagination
$(table).trigger("appendCache");
//Retain sorting if any
$(table).trigger("sorton",[table.config.sortList]);
}

function removeRow(table, rowId){
//Remove the selected row from pager.rowsCopy
var newRowsCopy = $.grep(table.config.rowsCopy, function(n, i){
return ($(n).attr('id')!=rowId);
});

table.config.rowsCopy = newRowsCopy;

//Rebuild html table from the modified rowsCopy
$.tablesorter.clearTableBody(table);

if (table.config.rowsCopy!=undefined)
$.each(table.config.rowsCopy, function() {
$(table).find('tbody:first').append($(this));
});

//Update call will rebuild tablesorter.cache from the existing HTML table
$(table).trigger("update");
//With pager plugin, this will call appender function in pager
//In turn, it will redraw the table with pagination
$(table).trigger("appendCache");
}

You can bind the functions 2 customised events as follows:

   $this.bind("addRow",function(event,newRow){
addRow(this,newRow);
});

$this.bind("removeRow",function(event,rowId){
removeRow(this,rowId);
});

Finally you can call the events from your page as follows:

  $(sortTable).trigger("removeRow",[id for the row to be removed]);

var newTr = $('<tr><td>New Row</td></tr>');
$(sortTable).trigger("addRow",[newTr]);

Deploy Netbeans 6.1 Web Application to Tomcat 5.5

Netbeans 6.1 come bundles with Tomcat 6.0. So you will encounter problem if you upload the war file directly to your production Tomcat 5.5 server.

Reason being the web.xml in you war file use version 2.5 XML declaration but Tomcat 5.5 uses version 2.4. The web.xml is located at
<catalina-home>/webapps/<your apps>/WEB_INF

Look at the first two lines of the web.xml, you shall see something like the following

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd">


Whereas in Tomcat 5.5, the two lines shall be replaced with the following

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">

After which, you have to clear the cache of compiled JSP file.
<catalina-home>\work\Catalina\<your apps>

Remove the whole folder with name "_" (underscore). This is the compiled JSP file (java class) by tomcat and is compiled only once when the jsp page is accessed/requested for the first time.

You have to stop the tomcat before removing the folder.
The folder will be rebuild automatically after you have restarted the tomcat and the jsp is being accessed.

Install OSX86 on Dell Vostro 220S

Background :
1. OSX86 : iAKTOS V7 - Leopard 10.5.7

2. Dell Vostro Slim 220s
- Chipset : Intel G45
- Audio : 82801JI (ICH10 Family) HD Audio
- Video : Intel GMA X4500HD
- LAN : Realtek RTL8111/8168B

3. Reference : http://www.insanelymac.com/forum/lofiversion/index.php/t149504.html

Installation Instructions:
1. Load iAktos V7 DVD

2. At prompt, press F8 and type in cpus=1 (Otherwise, you are not able to boot up)

3. Customised Options
a. X86 Patches -> ACPI -> X86 ACPI

b. X86 Patches -> Disabler (uncheck, it is checked by default)

c. Drivers -> VGA -> Intel -> EFI String for Intel

d. Drivers -> System -> SATA/IDE -> AHCI
(must set bios with SATA = AHCI, else you will get "waiting for root device
error during boot up later after finish the installation)

e. Drivers -> System -> IntelSpeedStep -> Choose both

f. Drivers -> System -> USB -> checked

g. Drivers -> System -> Sound -> AppleAzalia
( I choose the default Voodoo HDA driver before and ran into problem during boot up)

g. Drivers -> System -> PS/2 Mouse/Keyboard -> Apple PS/2 Driver

The rest just leave it as default.

I am able to make it work with the above installation, network proven working.

However, it tooks quite long to boot up
Going to test installing Xcode.

Project : MyERA Portal

Project : MyERA Portal
Platform : JSP / Apache Tomcat
Company : ERA Realty Network Pte Ltd



This is the first web application that I developed using JSP + Tomcat.


It is designed to serve as a one-stop portal for our property agents initially and grows to assists our staff as well todate.


This is really a 'break-through' for our company as it is the first web application launched to provide various online services to our agents and staff.






Thorough the portal, our agent can


1. Check their transactions online
2. Print their commission payment voucher
3. Check past transaction sales price
4. Check property available for sales/rental
5. Updated property news
6. Company annoucements
7. Download electronic copy of various documents/forms






There is a lot more that agent can benefit from the portal and I am consistently improving it to provide more services online.



Amid improving the portal, I found that there are some services that are also useful to our staff by acessing the same data source. Therefore, I added in some services for the staff to replace their manual workflow.



More importantly, our management can retrieve various reports online anytime anywhere now compare to last time whereby I need to prepare for them manually upon request.



In fact, I am very satisfied and proud this portal as it not only benefit our agents in terms of convenience and efficiency but also streamline our office workflow by automate it to save manpower as well.


For example, last time we need dedicated manpower to update some of the details on our company website http://www.era.com.sg/ on a regular basis. It is a very routine and tedious tasks whereby the department concern need to compile the updated information and pass it to the IT for converting to the web pages. In the end, I created a module so that the staff in charge can update the information directly without going through IT and it will be reflected online immediately. Through many of such modules, I am able to cut down uncessary manpower wastage on these routine tasks.



Well, I have more ideas to make it better but.....


Anyway, the next improvement in the pipeline is to implement SSL on the website to make it secure!