Welcome to blog of Ramesh Baral

JavaScript Stock Charts and other Charts

2012-01-17T01:32:00.000-08:00

It's a set of JavaScript/HTML5 charts for most of your needs. Our package includes serial (column, bar, line, area, step line, smoothed line, candlestick and ohlc graphs), pie/donut, radar/polar and xy/scatter/bubble charts.

For details,please have a look at: http://www.amcharts.com/

Oracle Coherence: Providing Extreme Performance, Predictable Scalability, and Continuous Availability for Mission-Critical Java Applications

2012-01-16T01:29:00.000-08:00

Organizations can gain significant advantage by managing and exploiting their

information systems more effectively than their competitors. But with today’s tight

budget constraints and technology limitations, many miss the opportunity—

sometimes with disastrous results. This white paper addresses how you can gain a

measurable competitive edge without compromise—today.

For further details have a look at the valuable doc:

http://www.docstoc.com/Docs/DownloadFile.ashx?docId=110978612

Using Struts2.0 and Spring 3.0 together

2012-01-16T00:49:00.000-08:00

This article illustrates how can we use the combination of Struts2.0 and Spring3.0. The combination might be required when you need the strength of Spring like dependency injection and jdbc support to be used with in the Struts 2.0 application.

Now lets start with the core files required:

The core file is the deployment descriptor which should be something like this:

******************************************************web.xml*******************************
<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_9" 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">
    <display-name>Struts Blank</display-name>
    <filter>
        <filter-name>struts2</filter-name>
        <filter-class>org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter</filter-class>
        
    </filter>
    <filter-mapping>
        <filter-name>struts2</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
<listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>

<context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>/WEB-INF/applicationContext*.xml,classpath*:applicationContext-*.xml</param-value>
</context-param>
    <welcome-file-list>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>index.html</welcome-file>
    </welcome-file-list>
</web-app>
******************************************************
For dependency injection,applicationcontext.xml is defined as mentioned below:
***************************************************applicationcontext.xml******************************
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="showDashBoard" class="com.d2.oam.report.impl.util.ShowDashBoard"/>
    <bean id="reportDAO" class="com.d2.oam.report.impl.dao.ReportDAO">
    <property name="dataSource" ref="dataSource" />
    </bean>

    <bean id="reportController" class="com.d2.oam.report.impl.controller.ReportController">
    <property name="reportDAO" ref="reportDAO"/>
    </bean>
    <bean id="reportService" class="com.d2.oam.report.impl.service.ReportService">
        <property name="reportController" ref="reportController"/>
    </bean>
    <bean id="generateReports" class="com.d2.oam.report.impl.service.ReportService">
        <property name="reportController" ref="reportController"/>
    </bean>
<bean name="reportCreator" class="org.springframework.scheduling.quartz.JobDetailBean">
        <property name="jobClass" value="com.d2.oam.report.impl.util.SchedularJob" />
        <property name="jobDataAsMap">
            <map>
                <entry key="reportService">
                    <ref bean="reportService" />
                </entry>
            </map>
        </property>
    </bean>
    
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
        destroy-method="close" autowire="default">
        <property name="driverClassName" value="${jdbc.driverClassName}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <property name="initialSize" value="${jdbc.initialSize}" />
        <property name="maxActive" value="${jdbc.maxActive}" />
        <property name="maxIdle" value="${jdbc.maxIdle}" />
        <property name="minIdle" value="${jdbc.minIdle}" />
        <property name="timeBetweenEvictionRunsMillis" value="${jdbc.timeBetweenEvictionRunsMillis}" />
        <property name="minEvictableIdleTimeMillis" value="${jdbc.minEvictableIdleTimeMillis}" />
        <property name="maxWait" value="${jdbc.maxWait}" />
    </bean>
<bean id="propertyConfigurer"
        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="locations">
            <list>
                <value>classpath:/com/d2/oam/report/resource/jdbc.properties</value>
                <value>classpath:/com/d2/oam/report/resource/cronjob.properties</value>
            </list>
        </property>
    </bean>

<bean id="cronTrigger" class="com.d2.oam.report.impl.util.CronTriggerUtil">
<property name="jobDetail" ref="reportCreator"/>
   <property name="cronSec" value="${cron.sec}"/>
   <property name="cronMin" value="${cron.min}"/>
   <property name="cronHour" value="${cron.hour}"/>
   <property name="cronDayOfMonth" value="${cron.dayofmonth}"/>
   <property name="cronMonth" value="${cron.month}"/>
   <property name="cronDayOfWeek" value="${cron.dayofweek}"/>
   <property name="cronExpression" value="${cron.expression}"/>
</bean>
<bean class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
<property name="triggers">
    <list>
      <ref bean="cronTrigger"/>
      </list>
</property>
</bean>
</beans>
*******************************************************************
jdbc.properties--to provide configuration related to database connectivity
***************************jdbc.properties***************************************
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc\:oracle\:thin\:@(DESCRIPTION\=(ADDRESS_LIST\=(LOAD_BALANCE\=ON)(ADDRESS\=(PROTOCOL\=TCP)(HOST\=$hostName)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=orcl)))
jdbc.username=dbusername
jdbc.password=dbuserpassword
jdbc.initialSize=10
jdbc.maxActive=60
jdbc.maxIdle=10
jdbc.minIdle=2
jdbc.timeBetweenEvictionRunsMillis=300000
jdbc.minEvictableIdleTimeMillis=600000
jdbc.maxWait=300000

**********************************************************************************
cronjob.properties--to provide configuration for scheduling events
******************************cronjob.properties****************************************************
cron.sec= 0
cron.min= 0
cron.hour= 0
cron.dayofmonth= *
cron.month= *
cron.dayofweek= ?
cron.year= *
cron.expression=10,30,50 * * * * ?
*****************************************************************************************************
The following file is for message bundle
*******************************************package.properties*****************************************************
message.welcome=Welcome to ...Application
message.appstatus= Application is up and running ...
requiredstring = ${getText(fieldName)} is required.
password = Password
username = User Name
message.Missing= This feature is under construction. Please try again in the next interation.
*****************************************************************************************************
The following file is one of the core file of struts2 framework.It defines the details of the actions.
********************************struts.xml**********************************
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
    
    <constant name="struts.objectFactory" value="org.apache.struts2.spring.StrutsSpringObjectFactory" />
    <constant name="struts.custom.i18n.resources" value="com/d2/oam/report/resource/package" />
    <constant name="struts.action.extension" value="action"/>
    <package name="default" extends="struts-default">
        <default-action-ref name="pmdashboard" />
        <global-results>
            <result name="error">/error.jsp</result>
        </global-results>
        <global-exception-mappings>
            <exception-mapping exception="java.lang.Exception" result="error"/>
        </global-exception-mappings>
        <action name="pmdashboard">
            <result>/pages/DashBoard.jsp</result>
        </action>
      </package>
    <include file="actions.xml"/>
    
</struts>
**********************************************************************************
**********************************struts.properties****************************
struts.objectFactory = spring
struts.devMode = true
struts.enable.DynamicMethodInvocation = false
*****************************************************************************
***************************************
    index.jsp- a file that is loaded in first and redirects to desirrd action
*********************index.jsp******************
<% response.sendRedirect("pmdashboard.action"); %>
************************************************

The pmdashboard.action entry in this is looked for in the struts.xml(and any such xmls specified in struts.xml file itself).Here, it resembles something like this from struts.xml:
<package name="default" extends="struts-default">
        <default-action-ref name="pmdashboard" />
        <global-results>
            <result name="error">/error.jsp</result>
        </global-results>
        <global-exception-mappings>
            <exception-mapping exception="java.lang.Exception" result="error"/>
        </global-exception-mappings>
        <action name="pmdashboard">
            <result>/pages/DashBoard.jsp</result>
        </action>
</package>

So the redirection is made into Dashboard.jsp page.
This page can be any simple jsp page,from where you can provide link to particular actions. The link can be something like this:
<li>
        <s:url id="url" action="generateReports">
        <s:a href="%{url}">Generate All Report</s:a>
    </li>
    where<s></s> is the struts core tag.
    Now see the generateReports action in struts.xml(and actions.xml) file.

    We see in actions.xml the entry
    <action name="generateReports" class="reportService" method="generateAllReports">
            <result name="success" type="redirect">/pages/Graphs.jsp</result>
        </action>

        Digging out gradually we get the control goes to the reportService bean, which is ReportService.java(as specified in applicationContext.xml).
        The method generateallReports(..) of ReportServices.java is invoked, which simply has the following:

        public String generateAllReports(){
        return reportController.generateAllReports();
        }

        The retrun typ string indicates that we are returning control from here and determine the result page accordingly.(If success is returned then the redirection is made to the page /pages/Graphs.jsp).

The ReportController.java is simply a java class that extends ActionSupport(from Struts 2.0). By extending this class, we get access to the method with signature as shown below:

public String execute() throws Exception{
        return "";
    }

    This is the default method to be called, but the method to be invoked can be changed on our own need basis. I have invoked the method generateAllReports(but via ReportService.java). The generateAllReports method in ReportController.java has following format:
    public String generateAllReports(){
        //your logic
        return SUCCESS;//or any other string
    }

The jars required for Struts can be found in http://struts.apache.org/
and the jar named struts2-spring-plugin-2.2.3.1.jar is required for the combination to work.

So the above example shows how to use Struts2.0 and Spring3.0 uniting their strengths to make a robust system.

Reading the spreadsheet in Google Docs

2011-12-29T03:42:00.001-08:00

import java.io.IOException;
import java.net.MalformedURLException;
import java.net.URL;
import java.util.List;

import com.google.gdata.client.docs.DocsService;
import com.google.gdata.client.spreadsheet.SpreadsheetService;
import com.google.gdata.data.Link;
import com.google.gdata.data.docs.DocumentListEntry;
import com.google.gdata.data.docs.DocumentListFeed;
import com.google.gdata.data.spreadsheet.CellEntry;
import com.google.gdata.data.spreadsheet.CellFeed;
import com.google.gdata.data.spreadsheet.SpreadsheetEntry;
import com.google.gdata.data.spreadsheet.SpreadsheetFeed;
import com.google.gdata.data.spreadsheet.WorksheetEntry;
import com.google.gdata.util.AuthenticationException;
import com.google.gdata.util.ServiceException;

public class ReadSpreadSheet {

public static void main(String args[]){
SpreadsheetService client=new SpreadsheetService("yourCo-yourAppName-v1");
String username="...@gmail.com";
String password="***";
client.setAuthSubToken("token");
try {
client.setUserCredentials(username, password);
} catch (AuthenticationException e) {
e.printStackTrace();
}
System.out.println("***authenticated");
SpreadsheetFeed spreadSheetFeed=null;
try {
URL docsURI = new URL("https://spreadsheets.google.com/feeds/spreadsheets/private/full");//("https://docs.google.com/feeds/default/private/full");
spreadSheetFeed=client.getFeed(docsURI, SpreadsheetFeed.class);
System.out.println("***no of spreadsheets:"+spreadSheetFeed.getEntries().size());
for(SpreadsheetEntry spreadSheetEntry:spreadSheetFeed.getEntries()){
if(spreadSheetEntry.getTitle().getPlainText().equalsIgnoreCase("testspreadsheet")){
System.out.println("***spreadsheetname:"+spreadSheetEntry.getTitle().getPlainText());
List worksheets = spreadSheetEntry.getWorksheets();
for(WorksheetEntry workSheetEntry:worksheets){//for each sheet
System.out.println(workSheetEntry.getRowCount());
/*********cell based query**********/
URL cellFeedUrl = workSheetEntry.getCellFeedUrl();
CellFeed feed = client.getFeed(cellFeedUrl, CellFeed.class);
for (CellEntry cell : feed.getEntries()) {
//System.out.println(workSheetEntry.getTitle().getPlainText());
String shortId = cell.getId().substring(cell.getId().lastIndexOf('/') + 1);
System.out.println("shortid-value pair:"+shortId + "/ row:"+cell.getCell().getRow()+",col:"+cell.getCell().getCol()+"..value:" + cell.getCell().getValue());
}
/*********cell based query**********/
}
}
}
}catch (MalformedURLException e) {
e.printStackTrace();
}catch (IOException e) {
e.printStackTrace();
}catch (ServiceException e) {
e.printStackTrace();
}
System.out.println("***completed");
}
}

Java Read/Write CSV File

2011-12-06T21:27:00.000-08:00

This time a simple script to read CSV file and print its output.

The csv file has following fields and values:
___________________________
id name address
___________________________
1 ram kamalpokhari
2 hari kalanki
3 mahesh sundhara
4 gopal koteshwor

The java file is :

import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.util.StringTokenizer;

public class ReadCSV {

public static void main(String args[]) throws IOException{
File file = new File("D:\\csvsample.csv");
String[][] numbers=new String[5][4];
BufferedReader bufRdr = new BufferedReader(new FileReader(file));
String line = null;
int row = 0;
int col = 0;

//read each line of text file
while((line = bufRdr.readLine()) != null)
{
StringTokenizer st = new StringTokenizer(line,",");
while (st.hasMoreTokens())
{
//get next token and store it in the array
String token=st.nextToken();
if(token!=null){
numbers[row][col] =token;
col++;
}

}
col=0;
row++;
}
//close the file
bufRdr.close();
for(int i=0;i<5;i++){ for(int j=0;j<3;j++) System.out.println("***element "+numbers[i][j]); } } }

The input csv file should be something like this:

Similarly this script writes the output to CSV file:

public class WriteToCSV {

public static void main(String[] args) throws IOException {
FileWriter fw = new FileWriter("D:\\WriteTest.csv");
PrintWriter pw = new PrintWriter(fw);
//Write to file for the first row
pw.print("First Row first Entry");
pw.print(",");
pw.print("First Row Second Entry");
pw.print(",");
pw.println("First Row Third Entry");//note the new line print statement

//Write to file for the second row
pw.print("Second Row first Entry");
pw.print(",");
pw.print("Second Row second Entry");
pw.print(",");
pw.print("Second Row third Entry");

//Flush the output to the file
pw.flush();

//Close the Print Writer
pw.close();

//Close the File Writer
fw.close();
}
}

the outuput to the csv looks something like this:

Thanks.

Rewriting SendRedirect to deal with SSL (or https) offloading

2011-05-30T23:35:00.000-07:00

Rewriting SendRedirect to deal with SSL (or https) offloading
Keywords
CSS
SSL offloader
sendRedirect problem
https becomes http
servlet filter
HttpServletResponseWrapper

Problem

When "sendRedirect" is used, some times the relative url is being translated into an absolute url using wrong scheme (http vs https). This articles explores the problem and a possible solution using servlet filters.
History

The call "sendRedirect" on an "HttpServletRequest" has had a history of being iffy and very dependent on the servlet container. About 4 to 5 years ago I have seen an issue where an incoming https when redirected using "sendredirect" will become an "http". The possible variations on a sendredirect forced me to abstract out the sendredirect into a pluggable interface with three implementations.

ClientsideRedirect
SendRedirect
ServersideRedirect

ClientsideRedirect

In this strategy the target url and the parameters are sent to the browser in a response. The response includes a javasript that will take the url and redirects the browser using document.location. It also removes the current url from the browser history so that the back button will work.
SendRedirect

Some times I call this a "defaultredirect" essentially preserving the "sendredirect" functionality where the browser is told to redirect using a redirect header.
ServersideRedirect

This strategy uses a "forward" of the servlet api there by including the response as part of the original url. Although this assures the fastest response time, has the draw back of repeating a "state" change on the server if a user were to refresh the page.
Why does "https" become "http" on a sendredirect?

Although a browser may be thinking that it is talking with its target server, there may be a number of servers enroute to the target servers doing such things as load balancing, encrypting, decrypting, etc. Usually this is not a problem. But there is case in which something called an "ssl offloader" is introduced into the pipeline of servers. These guys decode the "https" data and send the decoded data as "http" to the target server. At this point the target server thinks that the data is coming on an "http". Any sendredirect issued inside the server, especially relative urls, will be tagged with the protocol and the web server address. In this case the protocol will become "http".

Some web servers seem to deal with well, by recognizing that there is an offloader in the pipeline. This is typically done in association with the offloader where the offloader could be introducing an http header indicating that ssl offloading took place for a certain request.

Here is a symptom of this problem

first url from the browser

https://host:port/webapp/dir/page1.jsp

url by the time it reached the server

http://host:port/webapp/dir/page1.jsp

servelet redirects it to using sendredirect

/webapp/dir/page2.jsp

server sends a redirect to the browser by translating this to an absolute url

http://host:port/webapp/dir/page2.jsp

Notice how the "https" has become "http" in translating the relative url to an absolute url. This is because the webserver wrongly concluded that the incoming protocol is http.
How to fix the problem using webserver

if you are lucky and have enough time before production you can pursue with the vendor to see if they have fix for this in their web server.
Writing a sendredirect filter

Thanks to the servelet filtering architecture, it is surprisingly simple to fix it using a servelet filter. A servlet filter allows you to intercept all urls into a servlet container and alter the response related properties. The following code shows how easy it is to change the behavior of "sendredirect" for the whole web application while keeping its fundamental behavior intact.
Writing a basic filter

public class AbsoluteSendRedirectFilter implements Filter
{
public void init(FilterConfig filterConfig)
throws ServletException
{
}

public void destroy()
{
}

public void doFilter(ServletRequest request
, ServletResponse response
, FilterChain chain)
throws IOException, ServletException
{
//continue the request
chain.doFilter(request,response);
}
}

Registering a filter

AbsoluteSendRedirectFilter

filter for transferring relative to absolute urls

AbsoluteSendRedirectFilter

parm1

parm1value

description

AbsoluteSendRedirectFilter

Overriding the sendredirect

class SendRedirectOverloadedResponse extends HttpServletResponseWrapper
{
private HttpServletRequest m_request;
private String prefix = null;
public SendRedirectOverloadedResponse(HttpServletRequest inRequest
, HttpServletResponse response)
{
super(response);
m_request = inRequest;
prefix = getPrefix(inRequest);
}

/**
*This is the method which you
*want to edit for customizing your
*requirement.For instance we replaced
*the url pattern http://..........with https://..
*/
public void sendRedirect(String location) throws IOException
{
Log.trace("Going originally to:" + location);
String finalurl = null;

if (isUrlAbsolute(location))
{
Log.trace("This url is absolute. No scheme changes will be attempted");
finalurl = location;
}
else
{
finalurl = fixForScheme(prefix + location);
Log.trace("Going to absolute url:" + finalurl);
}
super.sendRedirect(finalurl);
}

public boolean isUrlAbsolute(String url)
{
String lowercaseurl = url.toLowerCase();
if (lowercaseurl.startsWith("http") == true)
{
return true;
}
else
{
return false;
}
}
public String fixForScheme(String url)
{
//alter the url here if you were to change the scheme
return url;
}

public String getPrefix(HttpServletRequest request)
{
StringBuffer str = request.getRequestURL();
String url = str.toString();
String uri = request.getRequestURI();
Log.trace("requesturl:" + url);
Log.trace("uri:" + uri);
int offset = url.indexOf(uri);
String prefix = url.substring(0,offset);
Log.trace("prefix:" + prefix);
return prefix;
}
}

Putting it all together

public class AbsoluteSendRedirectFilter implements Filter
{
public void init(FilterConfig filterConfig)
throws ServletException
{
}

public void destroy()
{
}

public void doFilter(ServletRequest request
, ServletResponse response
, FilterChain chain)
throws IOException, ServletException
{
//continue the request
chain.doFilter(request
,new SendRedirectOverloadedResponse(request,response));
}
}

References

1. Java Server Side api ver 1.6

2. Look up just servlet package classes

3. Java Programming NOtes

4. http://www.satyakomatineni.com/akc/servlet/DisplayServlet?url=DisplayNoteMPURL&reportId=1711&ownerUserId=satya

Customizing RollingAppenders of Log4j

2011-03-28T03:34:00.000-07:00

Apache's Log4j is a versatile event logging system.I admire the flexibility of Log4j.
Once a situation came where I need to append the datestamp to the filename and also limit the filesize to some customizable value.
The first could be obtained by using DailyRollingFileAppender(which however is blamed as prone to lose some logs--why? see apache docs for log4j) and the second could be obtained by using RollingFileAppender.
My requirements could be met by two ways:
a)if I could control the filenames to be used in RollingFileAppender
b)or rollover the files when a certain size is reached, when I use DailyRollingFileAppender

I thought of trying to extend RollingFileAppender and attempted to introduce a twist in my class.
The main methods for the RollingFileAppender that are required for me to override were subAppend(..) and rollOver(..).
After trying a bit I got the following class working for me:

import java.io.BufferedWriter;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.Writer;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

import org.apache.log4j.FileAppender;
import org.apache.log4j.Layout;
import org.apache.log4j.RollingFileAppender;
import org.apache.log4j.helpers.CountingQuietWriter;
import org.apache.log4j.helpers.LogLog;
import org.apache.log4j.helpers.OptionConverter;
import org.apache.log4j.spi.LoggingEvent;

/**
*
* File:CustomRollingFileAppender.java
* @author: Ramesh Raj Baral
* @since: Mar 25, 2011
* @version:1.0
*/
public class CustomRollingFileAppender extends RollingFileAppender{

/**
The default maximum file size is 10KB.
*/
protected String value = "10*1024";
protected long maximumFileSize=10*1024;
protected long currentFileSize;
protected String fileName="";
/**
The date pattern. By default, the pattern is set to
"'.'yyyy-MM-dd" meaning daily rollover.
*/
private String datePattern = "'.'yyyy-MM-dd";
String newFileName="";

/**
* The default constructor simply calls its {@link FileAppender#FileAppender
* parents constructor}.
*/
public CustomRollingFileAppender() {
super();
}

/**
* Instantiate a RollingFileAppender and open the file designated by
* filename. The opened filename will become the ouput
* destination for this appender.
*
*

* If the append parameter is true, the file will be appended
* to. Otherwise, the file desginated by filename will be
* truncated before being opened.
*/
public CustomRollingFileAppender(Layout layout, String filename, boolean append)
throws IOException {
super(layout, filename, append);
}

/**
* Instantiate a FileAppender and open the file designated by
* filename. The opened filename will become the output
* destination for this appender.
*
*

* The file will be appended to.
*/
public CustomRollingFileAppender(Layout layout, String filename)
throws IOException {
super(layout, filename);
}

/**
* Description:
*

this method sets the filename with date pattern

rather than LogFileName.1,LogFileName.2 and so on

use date pattern 'yyyy-MM-dd' to be appended

* @author Ramesh Raj Baral
* @since March 25 2011
*/
public void rollOver() {
File target;
File file;
if (maxBackupIndex > 0) {
// Delete the oldest file, to keep Windows happy.
file = new File(getNewFileName() + '.' + maxBackupIndex);
if (file.exists())
file.delete();
for (int i = maxBackupIndex - 1; i >= 1; i--) {
file = new File(getNewFileName() + "." + i);
/**
* if file exist then increase its index after dot(.)
* .i.e. if log.5 exist then rename it as log.6
* and create log.5 as a new file and so on
*/
if (file.exists()) {
target = new File(getNewFileName() + '.' + (i + 1));
LogLog.debug("Renaming file " + file + " to " + target);
file.renameTo(target);
}
}
/**
* Rename fileName to fileName.1
* fileName.1 is the second latest file in the list
*/
target = new File(getNewFileName() + "." + 1);
this.closeFile();
file = new File(fileName);
file.renameTo(target);
}

try {
// This will also close the file. This is OK since multiple
// close operations are safe.
this.setFile(getNewFileName(), false, bufferedIO, bufferSize);
} catch (IOException e) {
LogLog.error("setFile(" + fileName + ", false) call failed.", e);
}
}

public synchronized void setFile(String fileName, boolean append,
boolean bufferedIO, int bufferSize) throws IOException {
LogLog.debug("setFile called: "+fileName+", "+append);
// It does not make sense to have immediate flush and bufferedIO.
if(bufferedIO) {
setImmediateFlush(false);
}
reset();
Writer fw = createWriter(new FileOutputStream(fileName, append));
if(bufferedIO) {
fw = new BufferedWriter(fw, bufferSize);
}
this.setQWForFiles(fw);
this.fileName = fileName;
this.fileAppend = append;
this.bufferedIO = bufferedIO;
this.bufferSize = bufferSize;
writeHeader();
LogLog.debug("setFile ended");
//this.fileName=fileName;
if (append) {
File f = new File(fileName);
((CountingQuietWriter) qw).setCount(f.length());
currentFileSize=f.length();
System.out.println("^^^^^^^^^^^^append true "+currentFileSize);
}
else{
//System.out.println("^^^^^^^^^^^^append false "+currentFileSize);
}
}

/**
* This method differentiates CustomRollingFileAppender from its super
* class.
*
*/
protected void subAppend(LoggingEvent event) {
this.qw.write(this.layout.format(event));
if(layout.ignoresThrowable()) {
String[] s = event.getThrowableStrRep();
if (s != null) {
int len = s.length;
for(int i = 0; i < len; i++) { this.qw.write(s[i]); this.qw.write(Layout.LINE_SEP); } } } this.qw.flush(); if ((fileName != null) && currentFileSize >= this.getMaximumFileSize()){
System.out.println("^^^^^^^^^^^^^^^^rolling over");
this.rollOver();
}
else{
if(fileName==null)
System.out.println("^^^^^^^^^^^^filename null");
}
}

public String getDatePattern() {
return datePattern;
}
public void setDatePattern(String datePattern) {
this.datePattern = datePattern;
}

public String getNewFileName(){
String datePatternString="";
DateFormat format=new SimpleDateFormat("yyyy-MM-dd");
Date today=new Date();
datePatternString=format.format(today);
return (fileName+datePatternString);
}

public void setMaxFileSize(String value) {
//System.out.println("*********setting maxFileSize as:"+value+"....and:"+OptionConverter.toFileSize(value, maxFileSize + 1));
super.setMaximumFileSize(OptionConverter.toFileSize(value, maxFileSize + 1));
this.setMaximumFileSize(OptionConverter.toFileSize(value, maxFileSize + 1));
super.setMaxFileSize(value);
this.setMaximumFileSize(OptionConverter.toFileSize(value, maxFileSize + 1));
}

public long getMaximumFileSize() {
return maximumFileSize;
}

public void setMaximumFileSize(long maximumFileSize) {
this.maximumFileSize = maximumFileSize;
}

public long getCurrentFileSize() {
return currentFileSize;
}

public void setCurrentFileSize(long currentFileSize) {
this.currentFileSize = currentFileSize;
}
}

*********************************
the log4j.properties file I used for this was:

# Set root logger level to DEBUG and its only appender to Appender1.
log4j.rootLogger=Appender1,Appender2

# Appender1 is set to be a ConsoleAppender.
log4j.appender.Appender1=org.apache.log4j.ConsoleAppender
#log4j.appender.Appender2=org.apache.log4j.DailyRollingFileAppender
log4j.appender.Appender2=${packagename}.CustomRollingFileAppender
log4j.appender.Appender2.MaxFileSize=5KB
log4j.appender.Appender2.MaxBackupIndex=100
#log4j.appender.Appender2.DatePattern='.'yyyy-MM-dd

log4j.appender.Appender2.File=../Log/General/GeneralLog.log

# Appender2 uses PatternLayout.
log4j.appender.Appender2.layout=org.apache.log4j.PatternLayout
log4j.appender.Appender2.layout.ConversionPattern=%d{HH:mm:ss}[%-5p]%c %x[%-5p] - %m%n
**************************************************

I got it working.
The filenames were GeneralLog.log,GeneralLog.log2011-03-28.i where i=1 to 100.
The filesize was limited to 6KB (5KB +1)--a small value was used for testing purpose,can be customized as per requirement.

Writing own working class is quite interesting:)))

Thanks

Calendar

2011-01-18T21:55:00.001-08:00

Nepali Calendar

Custom Table Filters in Rich Faces

2010-12-06T04:28:00.001-08:00

In this article I shall show an example of how to use custom(user defined) filter on rich:dataTable elements:

Lets trace from the view itself:

In the first row of a dataTable we can have a row entries with the text field that will take the user input string that act as the filter string expression.

<rich:column >
<f:facet name="header">
<h:inputText
value="#{reviewReportController.filter.expForAppraisee}"
id="appraisee" onkeypress="updateAppraisee(event);"/>

</f:facet>
<h:outputText value="#{reviewData.appraisee}" />
</rich:column>

Now we need to define the updateAppraisee(evt) named javascript method as shown below:
      function updateAppraisee(e){
               //Unless the user presses the enter key donot process the action
      if (e.keyCode != 13) {return false}
else{
showProcessingPanel();
fireAjaxForAppraisee($('myForm:reviewReportTable:appraisee').value);
                                       //fire Ajax Event on the inputtext field defined in the above part
return true;

}
      }

Now we need to define the method fireAjaxForAppraisee within the <a4j:Form..> as shown below:
            <a4j:form>
<a4j:jsFunction name="fireAjaxForAppraisee"
action="#{reviewReportController.filterAppraisee}"
oncomplete="hideProcessingPanel();">
<a4j:actionparam name="param1"
assignTo="#{reviewReportController.filter.expForAppraisee}" />
</a4j:jsFunction>

</a4j:form>
Here:
action:defines which method to be called on the backing bean;
assignTo:defines which input field to be considered for the string input
showProcessingPanel,hideProcessingPanel-js methods used to show/hide the processing panels
param1:the parameter to be sent --here event itself; to the js method

Now lets see what is the actual logic inside the backing bean.
The main method triggered inside the backing bean is as shown below:

public boolean filterAppraisee() {
List reviewFilteredList=this.filterStringExp(getRateAndDateFilteredList());
return true;
    }

public List filterStringExp(List iterationList) {
//filter on the basis of review
reviewReportListForDisplay=new ArrayList();
if (this.filter.getExpForReview().trim().length()>0) {
for(int i=0;i<iterationList.size();i++){
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
if(!reviewReportDTO.getReview().toLowerCase().matches(".*"+this.filter.getExpForReview().toLowerCase()+".*")) {
reviewReportDTO.setFilteredOut(true);
}
}
        }
//filter on the basis of designation
if (this.filter.getExpForDesignation().trim().length()>0) {
for(int i=0;i<iterationList.size();i++){
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
if(!reviewReportDTO.getDesignation().toLowerCase().matches(".*"+this.filter.getExpForDesignation().toLowerCase()+".*")) {
reviewReportDTO.setFilteredOut(true);
}
}
        }
//filter on the basis of subdepartment
if (this.filter.getExpForSubDepartment().trim().length()>0) {
for(int i=0;i<iterationList.size();i++){
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
if(!reviewReportDTO.getSubdepartment().toLowerCase().matches(".*"+this.filter.getExpForSubDepartment().toLowerCase()+".*")) {
reviewReportDTO.setFilteredOut(true);
}
}
        }

//filter on the basis of department
if (this.filter.getExpForDepartment().trim().length()>0) {
for(int i=0;i<iterationList.size();i++){
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
if(!reviewReportDTO.getDepartment().toLowerCase().matches(".*"+this.filter.getExpForDepartment().toLowerCase()+".*")) {
reviewReportDTO.setFilteredOut(true);
}
}
        }

//filter on the basis of appriasee
if (this.filter.getExpForAppraisee().trim().length()>0) {
for(int i=0;i<iterationList.size();i++){
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
if(!reviewReportDTO.getAppraisee().toLowerCase().matches(".*"+this.filter.getExpForAppraisee().toLowerCase()+".*")) {
reviewReportDTO.setFilteredOut(true);
}
}
        }
//filter on the basis of appriasee
if (this.filter.getExpForAppraiser().trim().length()>0) {
for(int i=0;i<iterationList.size();i++){
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
if(!reviewReportDTO.getAppraiser().toLowerCase().matches(".*"+this.filter.getExpForAppraiser().toLowerCase()+".*")) {
reviewReportDTO.setFilteredOut(true);
}
}
        }
for(int i=0;i<iterationList.size();i++){
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
if(!reviewReportDTO.isFilteredOut()){
reviewReportListForDisplay.add(reviewReportDTO);
}
}
return reviewReportListForDisplay;
    }

Lets examine the reviewReportDTO bean.

package ......

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Transient;

import com.d2.hrm.common.api.core.DTO;

/**
*
* FileName:ReviewReportDTO.java
* Version:1.0
* @author:Ramesh Raj Baral
* @since:Nov 3, 2010
*
*/
/**
* Description:
* <li>this class resembles the report instance for review only</li>
*/
@Entity
@Table(name="...._review_report")

public class ReviewReportDTO implements DTO {

private Long id;
private String appraiser;
private String appraisee;
private String department;
private String subdepartment;
private double rating;
private String review;
private Date reviewdate;
private String appraiserEmail;
private String appraiseeEmail;
private String designation;
private boolean filteredOut=false;

@Id
@GeneratedValue(strategy=GenerationType.SEQUENCE,generator="reviewSeq")
@SequenceGenerator(name="reviewSeq",sequenceName="sq_d2hrm_review_report",allocationSize=1)
@Column(name = "id")
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}

@Column(name = "appraiser")
public String getAppraiser() {
return appraiser;
}
public void setAppraiser(String appraiser) {
this.appraiser = appraiser;
}
@Column(name = "appraisee")
public String getAppraisee() {
return appraisee;
}
public void setAppraisee(String appraisee) {
this.appraisee = appraisee;
}
@Column(name = "department")
public String getDepartment() {
return department;
}
public void setDepartment(String department) {
this.department = department;
}
@Column(name = "subdepartment")
public String getSubdepartment() {
return subdepartment;
}
public void setSubdepartment(String subdepartment) {
this.subdepartment = subdepartment;
}

@Column(name = "rating")
public double getRating() {
return rating;
}
public void setRating(double rating) {
this.rating = rating;
}

@Column(name = "reviewdate")
public Date getReviewdate() {
return reviewdate;
}
public void setReviewdate(Date reviewdate) {
this.reviewdate = reviewdate;
}

@Column(name = "designation")
public String getDesignation() {
return designation;
}
public void setDesignation(String designation) {
this.designation = designation;
}
@Column(name = "review")
public String getReview() {
return review;
}
public void setReview(String review) {
this.review = review;
}

@Column(name = "appraiser_email")
public String getAppraiserEmail() {
return appraiserEmail;
}
public void setAppraiserEmail(String appraiserEmail) {
this.appraiserEmail = appraiserEmail;
}

@Column(name = "appraisee_email")
public String getAppraiseeEmail() {
return appraiseeEmail;
}
public void setAppraiseeEmail(String appraiseeEmail) {
this.appraiseeEmail = appraiseeEmail;
}

@Override
public String toString() {
/**
* headerName:id
*****************headerName:appraisee
*****************headerName:appraiseeemail
*****************headerName:appraiser
*****************headerName:appraiseremail
*****************headerName:design
*****************headerName:dept
*****************headerName:subdept
*****************headerName:rating
*****************headerName:review
*****************headerName:reviewdate
*/
String a="id="+getId()+",appraisee="+getAppraisee()+",appraiseeemail="+getAppraiseeEmail()+",appraiser="+getAppraiser()+",appraiseremail="+getAppraiserEmail()+",design="+getDesignation()+",dept="+getDepartment()+",subdept="+getSubdepartment()+",rating="+getRating()+",review="+getReview()+",reviewdate="+getReviewdate().toString().split(" ")[0];
return a;

}

@Transient
public boolean isFilteredOut() {
return filteredOut;
}
public void setFilteredOut(boolean filteredOut) {
this.filteredOut = filteredOut;
}

}

The ultimate returning object of the filter method is the list that is assigned to the dataTable on our view.Based on this list the contents of the dataTable on view is dynamically changed.
I used this approach to filter numbers (including the symbol expressions:<,<=,>,>=,=,-) and the date with the fore mentioned expressions.

Now in advance lets examine the numberfiltering method:
In Controller we have a similar method for filtering numeric expression:
public boolean filterRate(){
List rateFilteredList=this.filterRateExp(reviewReportList);
return true;
}

public List filterRateExp(List iterationList) {
for(int i=0;i<iterationList.size();i++){
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
reviewReportDTO.setFilteredOut(false);
}
if (this.filter.getExpForRating().length()==0) {
this.setReviewReportListForDisplay(iterationList);
            return reviewReportListForDisplay;
        }
        else{
        List filterElements=ServiceUtil.getFilterNumberExpression(this.filter.getExpForRating());
        reviewReportListForDisplay = new ArrayList();
        if(filterElements!=null && filterElements.size()>0){
        FilterElementDTO filterSymbol=(FilterElementDTO)filterElements.get(0);
    FilterElementDTO filterFirstValue=(FilterElementDTO)filterElements.get(1);
    if(filterElements.size()==2)//has <,<=,>,>=,= and a number
        {
        for(int i=0;i<iterationList.size();i++){
        ReviewReportDTO reviewReport=(ReviewReportDTO)iterationList.get(i);
        if(filterSymbol.getElement().equals("<")){
        if(reviewReport.getRating()< Float.parseFloat(filterFirstValue.getElement())){
        //System.out.println("************inside if of case 1:"+reviewReportListForDisplay.size()+"...contains:"+reviewReport.getReviewdate()+".."+reviewReport.getRating()+".."+reviewReportListForDisplay.contains(reviewReport));
        if(!reviewReportListForDisplay.contains(reviewReport)){
        reviewReportListForDisplay.add(reviewReport);
        }

        }
        else{
        //System.out.println("************inside else of case 1:"+reviewReportListForDisplay.size()+".....contains:"+reviewReport.getReviewdate()+".."+reviewReport.getRating()+"...."+reviewReportListForDisplay.contains(reviewReport));
if(reviewReportListForDisplay.size()>0 && reviewReportListForDisplay.contains(reviewReport)){
reviewReportListForDisplay.remove(reviewReport);
}

}
        }
        else if(filterSymbol.getElement().equals(">")){
        if(reviewReport.getRating()> Float.parseFloat(filterFirstValue.getElement())){
        if(!reviewReportListForDisplay.contains(reviewReport))
reviewReportListForDisplay.add(reviewReport);
        }
        else{
if(reviewReportListForDisplay.size()>0)
reviewReportListForDisplay.remove(reviewReport);
}
        }
        else if(filterSymbol.getElement().equals("<=")){
        if(reviewReport.getRating()<= Float.parseFloat(filterFirstValue.getElement())){
        if(!reviewReportListForDisplay.contains(reviewReport))
reviewReportListForDisplay.add(reviewReport);
        }
        else{
if(reviewReportListForDisplay.size()>0)
reviewReportListForDisplay.remove(reviewReport);
}
        }
        else if(filterSymbol.getElement().equals(">=")){
        if(reviewReport.getRating()>= Float.parseFloat(filterFirstValue.getElement())){
        if(!reviewReportListForDisplay.contains(reviewReport))
reviewReportListForDisplay.add(reviewReport);
        }
        else{
if(reviewReportListForDisplay.size()>0)
reviewReportListForDisplay.remove(reviewReport);
}
        }
        else if(filterSymbol.getElement().equals("=")){
        if(reviewReport.getRating()== Float.parseFloat(filterFirstValue.getElement())){
        if(!reviewReportListForDisplay.contains(reviewReport))
reviewReportListForDisplay.add(reviewReport);
        }
        else{
if(reviewReportListForDisplay.size()>0)
reviewReportListForDisplay.remove(reviewReport);
}
        }
        else{
        System.out.println("********diff symbol encountered:"+filterSymbol.getElement()+"...");
        }
        }
        }
        else if(filterElements.size()==3){
        /**
        * has a range of number a-b
        */
        FilterElementDTO filterSecondValue=(FilterElementDTO)filterElements.get(2);
        if(filterSymbol.getElement().equals("-")){
        for(int i=0;i<iterationList.size();i++){
            ReviewReportDTO reviewReport=(ReviewReportDTO)iterationList.get(i);
            //System.out.println("*****range comparision:"+Float.parseFloat(reviewReport.getRating())+".."+Float.parseFloat(filterFirstValue.getElement())+".."+Float.parseFloat(filterSecondValue.getElement()));
            if(reviewReport.getRating()>= Float.parseFloat(filterFirstValue.getElement()) &&(reviewReport.getRating())<= Float.parseFloat(filterSecondValue.getElement())){
        reviewReportListForDisplay.add(reviewReport);
        }else{
if(reviewReportListForDisplay.size()>0)
reviewReportListForDisplay.remove(reviewReport);
}
        }

        }
        //System.out.println("valid search returning true");
        this.setReviewReportListForDisplay(reviewReportListForDisplay);
        }
        }
        else{
        /**
        * search for the string pattern
        */
        reviewReportListForDisplay=new ArrayList();
for(int i=0;i<iterationList.size();i++){
    ReviewReportDTO reviewReportDTO=(ReviewReportDTO)iterationList.get(i);
    //System.out.println("*****range comparision:"+Float.parseFloat(reviewReport.getRating())+".."+Float.parseFloat(filterFirstValue.getElement())+".."+Float.parseFloat(filterSecondValue.getElement()));
    String rating=""+reviewReportDTO.getRating();
    if(rating.startsWith(this.filter.getExpForRating())){
reviewReportListForDisplay.add(reviewReportDTO);
}else{
if(reviewReportListForDisplay.size()>0)
reviewReportListForDisplay.remove(reviewReportDTO);
}
}
        //System.out.println("invalid serch expression returning false");

        }
        }
        return reviewReportListForDisplay;
    }

Here ServiceUtil.getFilterNumberExpression(this.filter.getExpForRating()); is a utility method used to validate the input string to accept the input that satisfies the given regular expression.The method goes here:

/**
   *
   * Description:
   * <li>given the filter string,it identifies the symbols encountered,their types,position</li>
   * <li>and returns the list of valid FilterElementDTO</li>
   * getFilterNumberExpression
   * ServiceUtil
   * @param exp
   * @returns <li>list of FilterElementDTO if satisfies the condition else returns the empty list</li>
   * List
   * @author:Ramesh Raj Baral
   * @since:Nov 18, 2010
   *
   */
public static List getFilterNumberExpression(String exp){
List filterElementList = new ArrayList();
String value = "";
int symbolIndex = -1;
String[] validSymbols = { "<=", ">=", "=", "<", ">" };
String patternForRange = "(\\d{1,2})(.\\d{0,2})(-{1})(\\d{1,2})(.\\d{0,2})";// for
// now
// 1.0-15.0
// works
String patternString = "";
Pattern p;
Matcher m;
Matcher m1;
FilterElementDTO filterElement = new FilterElementDTO();
for (int i = 0; i < validSymbols.length; i++) {
/**
* pattern for elements of validSymbols array
*/
patternString = "(" + validSymbols[i] + ")(\\d{1,2})(.\\d{0,1})";
p = Pattern.compile(patternString);
m = p.matcher(exp);
m1=p.matcher(exp+".");
//System.out.println("************comparing:" + exp + "..with pattern:" + validSymbols[i] + ".....matches:" + m.matches());
if (m.matches() ||m1.matches()) {
symbolIndex = i;
value = exp.substring(validSymbols[i].length(), exp.length());
// add symbol
filterElement = new FilterElementDTO();
filterElement.setElement(exp.substring(0, validSymbols[i]
.length()));
filterElement.setElementType("string");
filterElement.setValid(true);
filterElement.setPosition(0);
filterElementList.add(filterElement);
// add number
filterElement = new FilterElementDTO();
filterElement.setElement(value);
filterElement.setElementType("int");
filterElement.setValid(true);
filterElement.setPosition(0);
filterElementList.add(filterElement);
break;
}
}
// if no match found then search for range pattern
if (symbolIndex < 0) {
p = Pattern.compile(patternForRange);
m=p.matcher(exp);
String periodAppendedExp=exp;
//if search expression has a range symbol(-) then append the period operator to it
if(exp.indexOf("-")>-1){
int rangeSymbol=exp.indexOf("-");
String firstNumber=exp.substring(0,rangeSymbol);
if(firstNumber.indexOf(".")<-0)
firstNumber+=".0";
String secondNumber=exp.substring(rangeSymbol,exp.length());
if(secondNumber.indexOf(".")<-0)
secondNumber+=".0";
periodAppendedExp=firstNumber+secondNumber;
//System.out.println("******************comparing for range:"+exp+"..firstnumber:"+firstNumber+"...second:"+secondNumber);
}
m1=p.matcher(periodAppendedExp);
if (m.matches() ||m1.matches()) {
// matched for range pattern,should have three elements in the
// form n.k-m.l
filterElementList = new ArrayList();
String[] values = exp.split("-");
// add the symbol
filterElement = new FilterElementDTO();
filterElement.setElement("-");
filterElement.setElementType("string");
filterElement.setValid(true);
filterElement.setPosition(0);
filterElementList.add(filterElement);
// add first number
filterElement = new FilterElementDTO();
filterElement.setElement(values[0]);
filterElement.setElementType("int");
filterElement.setValid(true);
filterElement.setPosition(0);
filterElementList.add(filterElement);
// add the second number
filterElement = new FilterElementDTO();
filterElement.setElement(values[1]);
filterElement.setElementType("int");
filterElement.setValid(true);
filterElement.setPosition(0);
filterElementList.add(filterElement);
}
}

return filterElementList;
}

The filterElement is simply a pojo with following structure:

package .....

import java.util.ArrayList;
import java.util.List;

/**
*
* FileName:FilterElementDTO.java
* Version:1.0
* @author:Ramesh Raj Baral
* @since:Nov 18, 2010
* Description:
* <li>represents filter expression used in reporting module</li>
* <li>expression can be combination of symbols and values(number or date)</li>
*
*/
public class FilterElementDTO implements DTO {

private String element;
private String elementType;
private int position;
private boolean valid;

public String getElement() {
return element;
}
public void setElement(String element) {
this.element = element;
}
public String getElementType() {
return elementType;
}
public void setElementType(String elementType) {
this.elementType = elementType;
}
public int getPosition() {
return position;
}
public void setPosition(int position) {
this.position = position;
}

public boolean isValid() {
return valid;
}
public void setValid(boolean valid) {
this.valid = valid;
}

}

Thanks,
Ramesh.

DynamicJasper to Generate Dynamic Reports

2010-12-06T04:06:00.001-08:00

This article will explain on how to use DynamicJasper in your project to generate the dynamic reports on demand.

The Jars required are:
DynamicJasper-3.1.5.jar( or any other latest one)
DynamicJasper-3.1.5-tests(or any other latest one)--this is optional

1)In Controller:
public String generateReport(){
/**
* get the list of departments,subdepartments,designations,
* date range to be used while populating report
*/
//System.out.println("report from date:"+this.getFilter().getFromDate()+"..todate:"+this.getFilter().getToDate());
this.setFilter((ReviewFilterDTO)this.initialize(this.getFilter()));
this.setReviewReportList(this.service.generateReport(this.getFilter()));
return "";
}

//initialize method
@Override
public DTO initialize(DTO dto) {
/**
* Description:
* <li>this method has been overrided to initialze the review filters</li>
* @author rbaral
* @since Nov 24 2010
*/
this.getFilter().getSelectedDepartments().clear();
this.getFilter().getSelectedSubDepartments().clear();
this.getFilter().getSelectedDesignations().clear();
this.getFilter().getSelectedHeaders().clear();
//add selected departments
for(int i=0;i<allDepartment.size();i++){
DepartmentDTO department=(DepartmentDTO)allDepartment.get(i);
if(allDeptChecked){
this.getFilter().getSelectedDepartments().put(department.getDepartmentID(),department);
}
else{
if(department.isDeptChecked()){
this.getFilter().getSelectedDepartments().put(department.getDepartmentID(),department);
}

}
}

//add selected subdepartments
if(subDepartments!=null)
for(int i=0;i<subDepartments.size();i++){
SubDepartmentDTO subDepartment=(SubDepartmentDTO)subDepartments.get(i);
if(allSubDeptChecked)
this.getFilter().getSelectedSubDepartments().put(subDepartment.getSubDepartmentID(), subDepartment);
else
{
if(subDepartment.isSubDeptChecked())
this.getFilter().getSelectedSubDepartments().put(subDepartment.getSubDepartmentID(), subDepartment);
}
}

//add selected designation
if(allDesignation!=null)
for(int i=0;i<allDesignation.size();i++){
DesignationDTO designation=(DesignationDTO)allDesignation.get(i);
if(allDesgChecked){
this.getFilter().getSelectedDesignations().put(designation.getId(), designation);
}
else{
if(designation.isDesgChecked())
this.getFilter().getSelectedDesignations().put(designation.getId(), designation);
}
}
//add selected headers
if(this.checkAllHeaders){
//System.out.println("*****************all headers set");
this.getFilter().setAllHeadersSelected(true);
this.getFilter().getSelectedHeaders().add("appraiser");
this.getFilter().getSelectedHeaders().add("appraisee");
this.getFilter().getSelectedHeaders().add("dept");
this.getFilter().getSelectedHeaders().add("subdept");
this.getFilter().getSelectedHeaders().add("design");
this.getFilter().getSelectedHeaders().add("review");
this.getFilter().getSelectedHeaders().add("reviewdate");
this.getFilter().getSelectedHeaders().add("rating");
}else{
this.getFilter().setAllHeadersSelected(false);
/**
* <li>the elements to be added to the list</li>
* <li>are the one that are defined in the respective DTO</li>
*/
if(this.checkAppraiserHeader)
this.getFilter().getSelectedHeaders().add("appraiser");
if(this.checkAppraiseeHeader)
this.getFilter().getSelectedHeaders().add("appraisee");
if(this.checkDeptHeader)
this.getFilter().getSelectedHeaders().add("dept");
if(this.checkSubDeptHeader)
this.getFilter().getSelectedHeaders().add("subdept");
if(this.checkDesiHeader)
this.getFilter().getSelectedHeaders().add("design");
if(this.checkReviewHeader)
this.getFilter().getSelectedHeaders().add("review");
if(this.checkReviewDateHeader)
this.getFilter().getSelectedHeaders().add("reviewdate");
if(this.checkRatingHeader)
this.getFilter().getSelectedHeaders().add("rating");
}
//System.out.println("*********************after init total headers:"+this.getFilter().getSelectedHeaders().size());
return this.getFilter();
}

//Filter Class
package com......

import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
*
* FileName:ReviewFilterDTO.java
* Version:1.0
* @author:Ramesh Raj Baral
* @since:Nov 17, 2010
* Description:
* <li>This class is used for implementing filter expressions</li>
* <li>for the ReviewReport page</li>
*/
public class ReviewFilterDTO implements DTO {

private String expForAppraisee="";
private String expForAppraiser="";
private String expForReview="";
private String expForDepartment="";
private String expForSubDepartment="";
private String expForRating="";
private String expForReviewDate="";
private String expForDesignation="";
private Date fromDate;
private Date toDate;

/**
* added to track the respective selected values
*/
Map selectedDepartments=new HashMap();
Map selectedSubDepartments=new HashMap();
Map selectedDesignations=new HashMap();
/**
* added to tracke the respective selected headers
*/
List selectedHeaders=new ArrayList();
private boolean allHeadersSelected=true;

public String getExpForAppraisee() {
return expForAppraisee.trim();
}
public void setExpForAppraisee(String expForAppraisee) {
this.expForAppraisee = expForAppraisee;
}
public String getExpForAppraiser() {
return expForAppraiser.trim();
}
public void setExpForAppraiser(String expForAppraiser) {
//System.out.println("**************************setting expForappraiser:"+expForAppraiser);
this.expForAppraiser = expForAppraiser;
}
public String getExpForReview() {
return expForReview.trim();
}
public void setExpForReview(String expForReview) {
this.expForReview = expForReview;
}
public String getExpForDepartment() {
return expForDepartment.trim();
}
public void setExpForDepartment(String expForDepartment) {
this.expForDepartment = expForDepartment;
}
public String getExpForSubDepartment() {
return expForSubDepartment.trim();
}
public void setExpForSubDepartment(String expForSubDepartment) {
this.expForSubDepartment = expForSubDepartment;
}
public String getExpForRating() {
return expForRating.trim();
}
public void setExpForRating(String expForRating) {
//System.out.println("**************************setting expForRating:"+expForRating);
this.expForRating = expForRating;
}
public String getExpForReviewDate() {
return expForReviewDate.trim();
}
public void setExpForReviewDate(String expForReviewDate) {
this.expForReviewDate = expForReviewDate;
}
public String getExpForDesignation() {
return expForDesignation.trim();
}
public void setExpForDesignation(String expForDesignation) {
this.expForDesignation = expForDesignation;
}
public Map getSelectedDepartments() {
return selectedDepartments;
}
public Map getSelectedSubDepartments() {
return selectedSubDepartments;
}
public Map getSelectedDesignations() {
return selectedDesignations;
}
public Date getFromDate() {
return fromDate;
}
public void setFromDate(Date fromDate) {
this.fromDate = fromDate;
}
public Date getToDate() {
return toDate;
}
public void setToDate(Date toDate) {
this.toDate = toDate;
}
public boolean isAllHeadersSelected() {
return allHeadersSelected;
}
public void setAllHeadersSelected(boolean allHeadersSelected) {
this.allHeadersSelected = allHeadersSelected;
}
public List getSelectedHeaders() {
return selectedHeaders;
}

}

//service level methods:
2) In Service:
@Override
public List generateReport(DTO filterCriteria) {
return this.dao.getModels(filterCriteria);

}

3)In DAO:

@Override
public List<DTO> getModels(DTO searchCriteria) {
/**
* <li>has been overridden to get the review reports which satisfy the</li>
* <li>filter criteria provided as parameter</li>
* <li>filter criteria includes selected departments,subdepartments,designations</li>
* TODO
* handle user filter expressions also
*/
ReviewFilterDTO filterDTO=(ReviewFilterDTO)searchCriteria;

List reviewReportList=new ArrayList();
HibernateTemplate ht = getHibernateTemplate();
Session sess = getSession();
Map selDeptMap=filterDTO.getSelectedDepartments();
Map selSubDeptMap=filterDTO.getSelectedSubDepartments();
Map selDesignationMap=filterDTO.getSelectedDesignations();
int i=0;
String[] deptObjects=null;
if(selDeptMap!=null && selDeptMap.size()>0){
deptObjects=new String[selDeptMap.size()];
Iterator iter=selDeptMap.keySet().iterator();
while(iter.hasNext()){
DepartmentDTO department=(DepartmentDTO)selDeptMap.get(iter.next());
deptObjects[i]=department.getDepartmentName();
i++;
}
}
//user expression for department
String[] subDeptObjects=null;
if(selSubDeptMap!=null && selSubDeptMap.size()>0){
i=0;
subDeptObjects=new String[selSubDeptMap.size()];
Iterator iter=selSubDeptMap.keySet().iterator();
while(iter.hasNext()){
SubDepartmentDTO subDepartment=(SubDepartmentDTO)selSubDeptMap.get(iter.next());
subDeptObjects[i]=subDepartment.getSubDepartmentName();
i++;
}
}

String[] designObjects=null;
if(selDesignationMap!=null && selDesignationMap.size()>0){
i=0;
designObjects=new String[selDesignationMap.size()];
Iterator iter=selDesignationMap.keySet().iterator();
while(iter.hasNext()){
DesignationDTO designation=(DesignationDTO)selDesignationMap.get(iter.next());
designObjects[i]=designation.getDesignationName();
i++;
}
}

Criteria crit = sess.createCriteria(ReviewReportDTO.class);
    Criterion deptCriteria = Restrictions.in("department",deptObjects);
    Criterion deptCriteriaFromExp=Restrictions.like("department", filterDTO.getExpForDepartment(), MatchMode.ANYWHERE);
    Criterion subdeptCriteria = Restrictions.in("subdepartment",subDeptObjects);
    Criterion subdeptCriteriaFromExp=Restrictions.like("department", filterDTO.getExpForDepartment(), MatchMode.ANYWHERE);
    Criterion designCriteria = Restrictions.in("designation",designObjects);
    Criterion designCriteriaFromExp=Restrictions.like("department", filterDTO.getExpForDepartment(), MatchMode.ANYWHERE);
    Criterion dateRangeCriteria=Restrictions.between("reviewdate", filterDTO.getFromDate(), filterDTO.getToDate());
    Criterion fromDateCriteria=Restrictions.ge("reviewdate", filterDTO.getFromDate());
    Criterion toDateCriteria=Restrictions.le("reviewdate", filterDTO.getToDate());

    Conjunction conjunction = Restrictions.conjunction();

    if(filterDTO.getFromDate()!=null && filterDTO.getToDate()!=null){
    conjunction.add(dateRangeCriteria);
    }
    else if(filterDTO.getFromDate()!=null){
    conjunction.add(fromDateCriteria);
    }
    else if(filterDTO.getToDate()!=null){
    conjunction.add(toDateCriteria);
    }
    if(deptObjects!=null)
    conjunction.add(deptCriteria);
    if(subDeptObjects!=null)
    conjunction.add(subdeptCriteria);
    if(designObjects!=null)
    conjunction.add(designCriteria);
    if(filterDTO.getFromDate()!=null||filterDTO.getToDate()!=null)
    crit.add(conjunction);
    if(deptObjects!=null || subDeptObjects!=null || designObjects!=null)
    crit.add(conjunction);
reviewReportList = crit.list();
    return reviewReportList;
}

//Specific Reports: PDF and xls
A)PDF Report
    In controller:
public String generatePDFReport(){
this.setFilter((ReviewFilterDTO)this.initialize(this.getFilter()));
this.service.generatePdfReportFromView(this.getFilter().getSelectedHeaders(),reviewReportListForDisplay);
return "";
}
Corresponding method on Service:
@Override
public boolean generatePdfReportFromView(List headers, List reportElements) {
JasperPrint jasperPrint=this.buildReport(headers, reportElements);
this.reportGenerator.displayPdfReport(jasperPrint);
return true;
}
//the buildReport(...,...) method has:
@Override
public JasperPrint buildReport(List headers, List data) {
String title="";
String subTitle="";
JasperPrint jp=null;
try {
DynamicReportBuilder drb = new DynamicReportBuilder();
//a default font available to windows and unix machine was used
Font font = new Font(9, "SansSerif", false);
Font headerFont = new Font(10, "SansSerif", true,false,true);
Style titleStyle = new StyleBuilder(false).setFont(font).setVerticalAlign(VerticalAlign.JUSTIFIED).setStretchWithOverflow(true).build();
Style headerStyle = new StyleBuilder(false).setFont(headerFont).setHorizontalAlign(HorizontalAlign.JUSTIFY)
.setVerticalAlign(VerticalAlign.JUSTIFIED).build();
drb
.setTitle(title)
.setSubtitle(subTitle)
.setDetailHeight(15)
.setMargins(30, 20, 15, 15)
.setColumnsPerPage(1).setReportName("Employee Review Report")
.setSubtitleStyle(titleStyle).setTitleStyle(titleStyle)
.setDefaultStyles(titleStyle, titleStyle, headerStyle,titleStyle)
.setHeaderHeight(15)
.setReportName("Appraisal Review Report")
.addAutoText(AutoText.AUTOTEXT_PAGE_X_OF_Y,Position.POSITION_TYPE_FIX_RELATIVE_TO_BOTTOM.getValue(),HorizontalBandAlignment.CENTER.getAlignment())
.addAutoText("Appraisal Copyright@2010",Position.POSITION_TYPE_FIX_RELATIVE_TO_TOP.getValue(),HorizontalBandAlignment.CENTER.getAlignment())
.setPrintBackgroundOnOddRows(true);

/**
* Column definitions. We use a new ColumnBuilder instance for each
* column, the ColumnBuilder.getNew() method returns a new instance
* of the builder. the property of <code>dto</code> should all be
* casted into string or their proper data type should be used
* instead before populating report
*/
String headerName;
AbstractColumn[] columns = new AbstractColumn[headers.size()];
System.out
.println("********************total entries sent to report:"+ data.size());
List data1 = new ArrayList(data.size());
for (int j = 0; j < headers.size(); j++) {
headerName = headers.get(j).toString();
//System.out.println("*****************headerName:" + headerName);
columns[j] = ColumnBuilder.getNew().setColumnProperty(
headerName, String.class.getName())
.setColumnType(ColumnBuilder.COLUMN_TYPE_DEFAULT)
.setTitle(headerName.toUpperCase()).setWidth(85)
.build();
columns[j].setStyle(titleStyle);
drb.addColumn(columns[j]);
}
int fieldsIndex=0;
String mapKey="";
String mapValue="";
String []userString=null;
for(int i=0;i<data.size();i++){
Map<String, String> map1 = new HashMap<String, String>();
ReviewReportDTO reviewReportDTO=(ReviewReportDTO)data.get(i);
//System.out.println("**************reportdto string:"+reviewReportDTO.toString());
userString=reviewReportDTO.toString().split(",");
do{
mapKey=userString[fieldsIndex].toString().split("=")[0];
mapValue="";
if(userString[fieldsIndex].split("=").length>1){
mapValue=userString[fieldsIndex].split("=")[1]==null?"":userString[fieldsIndex].split("=")[1];
}
/**
* if the selected header element and the element in the DTO string are common then only add it to the map
*/
if(headers.contains(mapKey)){
//System.out.println("***************adding object:"+mapKey+"...=..."+ mapValue+"..in headerindex:"+headerIndex);
map1.put(mapKey,mapValue);
}
fieldsIndex++;
}while(fieldsIndex<userString.length);
data1.add(map1);
fieldsIndex = 0;
}
drb.setUseFullPageWidth(true);
DynamicReport dr = drb.build();
JRDataSource ds = new JRBeanCollectionDataSource(data1, true);
//String jrxmlString = DynamicJasperHelper.generateJRXML(dr,new ClassicLayoutManager(), new HashMap(), "");
//System.out.println("****************generated jrxml is:\n"+jrxmlString);
jp = DynamicJasperHelper.generateJasperPrint(dr,
new ListLayoutManager(), ds);
} catch (JRException e) {
e.printStackTrace();
} catch (ColumnBuilderException e) {
e.printStackTrace();
} catch (Exception ex) {
System.out.println("Exception occured while building report:"
+ ex.getMessage());
ex.printStackTrace();
}
return jp;
}

//the displayPdfReport method:
public void displayPdfReport(JasperPrint jasperPrint){
try{
byte[]data=JasperExportManager.exportReportToPdf(jasperPrint);
FacesContext context = FacesContext.getCurrentInstance();
HttpServletResponse response = (HttpServletResponse) FacesContext
.getCurrentInstance().getExternalContext().getResponse();
response.setHeader("Content-disposition","attachment; filename= EmployeeList.pdf");
response.setContentLength(data.length);
response.setContentType("application/pdf");
try {

response.getOutputStream().write(data);
response.getOutputStream().flush();
response.getOutputStream().close();
context.responseComplete();
}catch(Exception ex){
System.out.println("*************inner exception");
}
}
catch(JRException ex){
System.out.println("***************exception inside basereportgenerator:"+ex.getMessage());
ex.printStackTrace();
}
}

Similarly for Excel Report we can use the method: displayExcelReport as shown below:
public void displayExcelReport(JasperPrint jasperPrint){
Font font = new Font(12, "SansSerif", true);
Style titleStyle = new StyleBuilder(false).setFont(font).build();
JRXlsExporter exporter = new JRXlsExporter();
try {
byte[] data = JasperExportManager.exportReportToPdf(jasperPrint);
FacesContext context = FacesContext.getCurrentInstance();
HttpServletResponse response = (HttpServletResponse) FacesContext
.getCurrentInstance().getExternalContext().getResponse();

ServletContext servletContext = (ServletContext) FacesContext.getCurrentInstance().getExternalContext().getContext();
response = (HttpServletResponse)context.getExternalContext().getResponse();

String contentType = "application/vnd.ms-excel";
response.addHeader("Content-disposition", "attachment; filename=EmployeeList.xls");
response.setContentType(contentType);
byte[] bytes = null;
ByteArrayOutputStream xlsReport = new ByteArrayOutputStream();
OutputStream output = response.getOutputStream();
JRXlsExporter exporter1 = new JRXlsExporter();
ServletOutputStream servletOutputStream =response.getOutputStream();
exporter1.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
exporter1.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.FALSE);
exporter1.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
exporter1.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, xlsReport);
exporter1.setParameter(JRXlsExporterParameter.SHEET_NAMES, new String[]{"Employees", "Review"});
exporter1.setParameter(JRXlsExporterParameter.IGNORE_PAGE_MARGINS,Boolean.TRUE);
exporter1.setParameter(JRXlsExporterParameter.OFFSET_X, 0);
exporter1.setParameter(JRXlsExporterParameter.IS_IGNORE_CELL_BORDER, Boolean.FALSE);
exporter1.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
exporter1.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, false);
exporter1.exportReport();
bytes = xlsReport.toByteArray();
context.responseComplete();
output.write(xlsReport.toByteArray());
ServletOutputStream outputStream1 = response.getOutputStream();
outputStream1.write(bytes);
context.renderResponse();
servletOutputStream.flush();
servletOutputStream.close();

} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

Here,
List data parameter is of type ArrayList and has the list of the objects to be displayed on the page.

Thanks,
Ramesh.

saveOrUpdate(Object) Hibernate: a different object with the same identifier value was already associated with the session:

2010-12-06T03:30:00.000-08:00

this common problem in hibernate transaction can be solved by defining a new session ojbect for each transaction and commit or rollback the transaction in the DataAccess Object level.

Following code snippet in DAO level was used to solve the problem:

Transaction tx=null;
Session sess = SessionFactoryUtils.getNewSession(getSessionFactory());
try {
tx = sess.beginTransaction();
sess.saveOrUpdate(updatedModel);
tx.commit();
}
catch (JDBCException e) {
return false;
}
catch(Exception ex){
System.out.println("****************************exception sent"+ex.getMessage());
}
finally {
sess.close();
}

Thanks,
Ramesh.

Rich Faces CalendarDataModel

2010-12-06T03:16:00.000-08:00

Often we might want to control the calendar object of our view from the server side.
For instance I needed the user to be prevented from selecting the date before today. This was achieved using the CalendarDataModel.

Simply use the following steps:
1)In your view with element add the following property:

dataModel="#{calendarDataModel}" mode="ajax"

--here dataModel property indicates the model to be used. The mode defines whether to operate on client mode or on ajax mode. To use datamodel we need to have ajax mode to be used.

2)Now register the bean named calendarDataModel in your applicationContext.xml(for spring application) or in faces-config.xml in JSF based application or wherever appropriate(depending on the requirement)

3)Now Define the classes CalendarDataModelImpl and CalendarDataModelItemImpl as shown below:

Class CalendarDataModelImpl.java

package .......

import java.util.Calendar;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import javax.faces.event.ValueChangeEvent;

import org.richfaces.model.CalendarDataModel;
import org.richfaces.model.CalendarDataModelItem;

/**
*
* FileName:CalendarDataModelImpl.java
* Version:1.0
* @author:Ramesh Raj Baral
* @since:Dec 6, 2010
*
*/
public class CalendarDataModelImpl implements CalendarDataModel {

private CalendarDataModelItem[] items;
private String currentShortDescription;
private Date currentDate, beginDate, endDate;
private boolean currentDisabled;

public CalendarDataModelItem[] getData(Date[] dateArray) {
if (dateArray == null) {
return null;
}
items = new CalendarDataModelItem[dateArray.length];
for (int i = 0; i < dateArray.length; i++) { items[i] = createDataModelItem(dateArray[i]); } return items; } /** * * Description: *

has been used to prevent user to select the date before today

* createDataModelItem
* CalendarDataModelImpl
* @param date
* @return
* CalendarDataModelItem
* @author:Ramesh Raj Baral
* @since:Dec 6, 2010
*
*/
protected CalendarDataModelItem createDataModelItem(Date date) {
CalendarDataModelItemImpl item = new CalendarDataModelItemImpl();
Map data = new HashMap();
Calendar c = Calendar.getInstance();
c.setTime(date);
item.setDay(c.get(Calendar.DAY_OF_MONTH));
/**
* if this date is before today then set it as disabled
*/
Calendar today=Calendar.getInstance();
today.setTime(new Date());
int thisMonth=today.get(Calendar.MONTH);
int thisYear=today.get(Calendar.YEAR);
int thisDay=today.get(Calendar.DAY_OF_MONTH);
int selectedMonth=c.get(Calendar.MONTH);
int selectedYear=c.get(Calendar.YEAR);
int selectedDay=c.get(Calendar.DAY_OF_MONTH);
if(thisYear>selectedYear){
item.setEnabled(false);
//item.setStyleClass("rich-bottom-cell rich-calendar-cell-size rich-calendar-cell rich-calendar-holly rich-right-cell rich-calendar-boundary-dates");
}
else if(thisMonth>selectedMonth){
item.setEnabled(false);
}
else if(thisDay>selectedDay){
item.setEnabled(false);
}
else{
item.setEnabled(true);

}
item.setData(data);
return item;
}

public Object getToolTip(Date date) {
return "Date Previous to today is not allowed";
}

/**
* @return items
*/
public CalendarDataModelItem[] getItems() {
return items;
}

/**
* @param setter for items
*/
public void setItems(CalendarDataModelItem[] items) {
this.items = items;
}

/**
* @param valueChangeEvent handling
*/
public void valueChanged(ValueChangeEvent event) {
setCurrentDate((Date)event.getNewValue());
Calendar calendar = Calendar.getInstance();
calendar.setTime(getCurrentDate());
}

/**
* Storing changes action
*/
public void storeDayDetails() {
Calendar calendar = Calendar.getInstance();
calendar.setTime(getCurrentDate());
((HashMap)items[calendar.get(Calendar.DAY_OF_MONTH)-1].getData()).put("shortDescription", getCurrentShortDescription());
}

/**
* @return currentDisabled
*/
public boolean isCurrentDisabled() {
return currentDisabled;
}

/**
* @param currentDisabled
*/
public void setCurrentDisabled(boolean currentDisabled) {
this.currentDisabled = currentDisabled;
}

/**
* @return currentShortDescription
*/
public String getCurrentShortDescription() {
return currentShortDescription;
}

/**
* @param currentShortDescription
*/
public void setCurrentShortDescription(String currentShortDescription) {
this.currentShortDescription = currentShortDescription;
}

/**
* @return currentDate
*/
public Date getCurrentDate() {
return currentDate;
}

/**
* @param currentDate
*/
public void setCurrentDate(Date currentDate) {
this.currentDate = currentDate;
}

public Date getBeginDate() {
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.DAY_OF_YEAR, -365);
return calendar.getTime();
}

public Date getEndDate() {
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.DAY_OF_YEAR, 365);
return calendar.getTime();
}

}

When the calendar item is loaded on the view the main method that will be triggered is:

public CalendarDataModelItem[] getData(Date[] dateArray) {
........
}

So we can customize our bean as per our requirement.

Class CalendarDataModelItemImpl.java

package .........

import org.richfaces.model.CalendarDataModelItem;

/**
*
* FileName:CalendarDataModelItemImpl.java
* Version:1.0
* @author:Ramesh Raj Baral
* @since:Dec 6, 2010
*
*/
public class CalendarDataModelItemImpl implements CalendarDataModelItem{

private Object data;
private int day;
private String styleClass;
private Object toolTip;
private boolean isEnabled;

@Override
public Object getData() {
return data;
}

@Override
public int getDay() {
return day;
}

@Override
public String getStyleClass() {
// TODO Auto-generated method stub
return null;
}

@Override
public Object getToolTip() {
// TODO Auto-generated method stub
return null;
}

@Override
public boolean hasToolTip() {
return false;
}

@Override
public boolean isEnabled() {
return isEnabled;
}

public void setData(Object data) {
this.data = data;
}

public void setDay(int day) {
this.day = day;
}

public void setStyleClass(String styleClass) {
this.styleClass = styleClass;
}

public void setToolTip(Object toolTip) {
this.toolTip = toolTip;
}

public void setEnabled(boolean isEnabled) {
this.isEnabled = isEnabled;
}

}

This class will access each and every element (item) of the date element. So we can change the corresponding attributes of the element if required.

Thanks a lot for the urls:
http://community.jboss.org/message/29742
RichFaces LiveDemo

PS:This code has been successfully implemented for my requirement.

Thanks,
Ramesh.

Automatic startup and shutdown of oracle on unix machines

2010-11-13T22:16:00.000-08:00

how to automate start and shutdown of Oracle database with the start up and shutdown of Operating system is described here:

1) Open the oratab file as root user in any text editor:
# vi /etc/oratab
Database entries in the oratab file are displayed in the following format:

SID:ORACLE_HOME:{Y|N}

In this example, Y or N specifies whether you want the scripts to start up or shut down the database. For each database for which you want to automate shutdown and startup, first find the instance identifier (SID) for that database, which is identified by the SID in the first field. Then, change the last field for each to Y

2)Then create a file dbora inside /etc/int.d with the following content

#! /bin/sh -x
#
# Change the value of ORACLE_HOME to specify the correct Oracle home
# directory for your installation.

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
#
# Change the value of ORACLE to the login name of the
# oracle owner at your site.
#
ORACLE=oracle

PATH=${PATH}:$ORACLE_HOME/bin
HOST='hostname'
PLATFORM='Linux'
export ORACLE_HOME PATH
#
if [ ! "$2" = "ORA_DB" ] ; then
if [ "$PLATFORM" = "HP-UX" ] ; then
remsh $HOST -l $ORACLE -n "$0 $1 ORA_DB"
exit
else
rsh $HOST -l $ORACLE $0 $1 ORA_DB
exit
fi
fi
#
case $1 in
'start')
if [ "$PLATFORM" = "Linux" ] ; then
touch /var/lock/subsys/dbora
fi
$ORACLE_HOME/bin/dbstart $ORACLE_HOME &
;;
$ORACLE_HOME/bin/lsnrctl start LISTENER;;

'stop')
$ORACLE_HOME/bin/dbshut $ORACLE_HOME &
;;
$ORACLE_HOME/bin/lsnrctl start LISTENER;;
*)
echo "usage: $0 {start|stop}"
exit
;;
esac
#
exit

**Note:ORACLE_HOME: points to the oracle directory where it has the runnable script for oracle

3)Change the group of the dbora file to the OSDBA group (typically dba), and set the permissions to 750:
# chgrp dba dbora
# chmod 750 dbora

4)Create symbolic links to the dbora script in the appropriate run-level script directories as follows
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/K01dbora
# ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora

Try restarting your server and after the server has successfully restarted check the connectivity to oracle. It should work fine.

Thank you.

Thanks for:
http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/strt_stp.htm#CFAHAHGA

OCA Basics-Part 1

2010-10-14T03:41:00.000-07:00

Remove Oracle

First of all we will remove the existing oracle in our machine.For this we will run the following commands listed with their purposes:

Issue following commands by oracle user:
echo $ORACLE_BASE can be done to be sure for the value of $ORACLE_BASE.
# rm -rf $ORACLE_BASE/* #<--- Removes Entire Oracle Software Directoryfollowing commands can be removed by oracle/root user
# rm -f /etc/oraInst.loc #<--- Removes Install Loc# rm -f /etc/oratab #<--- Removes OraTab used by dbstart and dbshut scripts# rm -f /usr/local/bin/dbhome #<--- Removes Database Home Identifier Script# rm -f /usr/local/bin/oraenv #<--- Removes Env Script used by Bourne, Bash, or Korn shell# rm -f /usr/local/bin/coraenv #<--- Removes Env Script used by C shell-->

Install Oracle
Now we will install the oracle application in our machine.
--------------------------------------------------------

Steps to Install Oracle 10g Release 2 (10.2.0.1) on Red Hat Linux:

Download the 64-bit installation file 10201_database_linux_x86_64.cpio and place it in specific drive (/u01/d2dba)

Unpack the contents of the file:
cpio -idmv < 10201_database_linux_x86_64.cpio Kernel parameter Setup

Add the following lines to the /etc/sysctl.conf file:

kernel.shmall = 4101757

kernel.shmmax = 16800796672

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default=262144

net.core.rmem_max=262144

net.core.wmem_default=262144

net.core.wmem_max=262144

Run the following command to change the current kernel parameters:

? /sbin/sysctl p

Add the following lines to the /etc/security/limits.conf file:

* soft nproc 2047

* hard nproc 16384

* soft nofile 2048

* hard nofile 65536

Add the following line to the /etc/pam.d/login file, if it does not already exist:

session required /lib/security/pam_limits.so

Install the following packages, if necessary:

? # From RedHat AS3 Disk 2

? cd /mnt/cdrom/RedHat/RPMS

? rpm -Uvh setarch-1.3-1.i386.rpm

? rpm -Uvh sysstat-4.0.7-4.EL3.3.i386.rpm

?

? # From RedHat AS3 Disk 3

? cd /mnt/cdrom/RedHat/RPMS

? rpm -Uvh openmotif21-2.1.30-8.i386.rpm

? rpm -Uvh ORBit-0.5.17-10.4.i386.rpm

? rpm -Uvh libpng10-1.0.13-15.i386.rpm

? rpm -Uvh gnome-libs-1.4.1.2.90-34.1.i386.rpm

? rpm -Uvh compat-glibc-7.x-2.2.4.32.6.i386.rpm \

? compat-gcc-7.3-2.96.128.i386.rpm \

? compat-gcc-c++-7.3-2.96.128.i386.rpm \

? compat-libstdc++-7.3-2.96.128.i386.rpm \

? compat-libstdc++-devel-7.3-2.96.128.i386.rpm

RPMs can be chzecked by :

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n'
binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel
make pdksh sysstat xscreensaver libaio libaio-devel

Create the new groups and users:

groupadd oinstall

groupadd dba

groupadd oper

useradd -g oinstall -G dba -s /bin/ksh oracle

passwd oracle

chown oracle:oinstall /home/oracle -R

yum install libXp

Create the directories in which the Oracle software will be installed:

mkdir -p /u01/app/oracle/product/j2ee_10_1_2

chown -R oracle.oinstall /u01

Login as root and issue the following command:

xhost +

/*

[oracle@host database]$ export DISPLAY=192.168.112.36:0.0

[oracle@host database]$ xhost +

xhost: unable to open display "192.168.112.36:0.0"

[oracle@host database]$ export DISPLAY=192.168.112.36:2.0 (if :2)

[oracle@host database]$ xhost +

access control disabled, clients can connect from any host

*/

Edit .bash_profile as:

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

#PATH=$PATH:/usr/sbin:$PATH; export PATH

#PATH=$ORACLE_HOME/bin:$PATH; export PATH

#ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

#ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME

#PATH=$ORACLE_HOME/bin:$PATH; export PATH

#LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

export ORACLE_SID=orcl

PATH=$PATH:$HOME/bin

ORACLE_BASE=/u01/app/oracle

export ORACLE_BASE

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

unset USERNAME

#export PATH

#unset USERNAME

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable:

DISPLAY=:0.0; export DISPLAY

Start the Oracle Universal Installer (OUI) by issuing the following command in the Disk1 directory:

./runInstaller

Steps to upgrade Oracle 10.2.0.X to 10.2.0.4:

Download the oracle patch of 64-bit and uncompress it:

unzip p6810189_10204_Linux-x86-64.zip

Stop all the current oracle services issuing following commands:

o emctl stop dbconsole

o $ isqlplusctl stop

o $ lsnrctl stop

Shutdown the oracle instance:

o Shutdown immediate

Now to enable X applications, run the following command on the machine that you want to use to display Oracle Universal Installer:

o $ xhost +

Go to the directory of Disk1 to locate runInstaller and issue following command to execute it:

o ./runInstaller

Follow the windows installation procedure of installation (OUI)

Run $ORACLE_HOME/root.sh as root after completion

? Supply the bin parameter when prompted

On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer

Start the listener

Enter the following command from the command prompt:

dbua

Follow the database Upgrade Assistance Windows instruction for upgrade to version 10.2.0.4.

run $ORACLE_HOME/install/changePerm.sh

System Parameters to be configured
alter system set filesystemio_options="asynch" scope=spfile;
alter system set db_file_multiblock_read_count=128 scope=spfile;
alter system set sga_max_size=19G scope=spfile;
alter system set sga_target=19G scope=spfile;
alter system set pga_aggregate_target=10G scope=spfile;
alter system set "_gby_hash_aggregation_enabled"=false;
--------------------------------------------------------

प्रकाश बराल द्वारा स्वरबद्द आधुनिक गीत

2010-07-15T10:19:00.000-07:00

तिमी नडराउनु म मरेको हेर्दा ,
आसुँ नबगाउनु मलाई कात्रोले बेर्दा
जीवन हाम्रो खरानी हुनलाई
बुझिदेउ तिमीले हुँदैन रुनलाई

मैले भनेका यि कुरालाई ,
उपहार ठानिदेउ पोते र चुरालाई
सिन्दुर तिमीलाई छु मैले दिएको
पर्दैन लगाउन सेतो बस्त्र कोराले सिएको

साथमा सगै बस्न पाएनौ
दैवले हामीलाई ठगेको छ
तिमी देखी छुट्ट्याइ मलाई कतै अन्तै
विरानो ठाउमा लगेको छ

छन साना कोपिला तिम्रा साथमा
सुम्पेको छु अब तिम्रै हातमा
यिनकै मुहारमा मलाई हेरन
यिनिहरुकै साथमा सुबाश फेरन

तिमी नडराउनु म मरेको हेर्दा ,
आसुँ नबगाउनु मलाई कात्रोले बेर्दा
जीवन हाम्रो खरानी हुनलाई
बुझिदेउ तिमीले हुँदैन रुनलाई

Playing with Java and SVN

2010-06-30T23:29:00.000-07:00

Playing with Java and SVN:

package svn;

import java.io.File;

import org.tigris.subversion.javahl.ClientException;

import org.tmatesoft.svn.core.SVNCommitInfo;

import org.tmatesoft.svn.core.SVNDepth;

import org.tmatesoft.svn.core.SVNException;

import org.tmatesoft.svn.core.SVNURL;

import org.tmatesoft.svn.core.internal.io.dav.DAVRepositoryFactory;

import org.tmatesoft.svn.core.internal.io.fs.FSRepositoryFactory;

import org.tmatesoft.svn.core.internal.io.svn.SVNRepositoryFactoryImpl;

import org.tmatesoft.svn.core.internal.wc.DefaultSVNOptions;

import org.tmatesoft.svn.core.wc.SVNClientManager;

import org.tmatesoft.svn.core.wc.SVNRevision;

import org.tmatesoft.svn.core.wc.SVNUpdateClient;

public class WorkingCopy {

/**
*jar files required:svnkit.jar,svnkit-cli.jar,svnkit-jhl.jar
*tested o.k with jdk 1.5
*
*
*
*/

private static SVNClientManager ourClientManager;

/**

*

* @param url

* @param commitMessage

* @return

* @throws SVNException

* creates a new directory immediately in a repository:

*/

private static SVNCommitInfo makeDirectory( SVNURL url , String commitMessage ) throws SVNException {

return ourClientManager.getCommitClient( ).doMkDir( new SVNURL[] { url } , commitMessage );

}

private static void setUpFactory(){

/*

* For using over http:// and https://

*/

DAVRepositoryFactory.setup();

/*

* For using over svn:// and svn+xxx://

*/

SVNRepositoryFactoryImpl.setup();

/*

* For using over file:///

*/

//FSRepositoryFactory.setup();

}

/**

*

* @param localPath

* @param dstURL

* @param commitMessage

* @param isRecursive

* @return

* @throws SVNException

* imports a local directory to a repository:

*/

private static SVNCommitInfo importDirectory( File localPath , SVNURL dstURL , String commitMessage , boolean isRecursive ) throws SVNException {

return ourClientManager.getCommitClient( ).doImport( localPath , dstURL , commitMessage , isRecursive );

}

/**

*

* @param wcPath

* @param keepLocks

* @param commitMessage

* @return

* @throws SVNException

* recursively commits Working Copy modifications to a repository

*/

private static SVNCommitInfo commit( File wcPath , boolean keepLocks , String commitMessage ) throws SVNException {

return ourClientManager.getCommitClient().doCommit( new File[] { wcPath } , keepLocks , commitMessage , false , true );

}

/**

*

* @param url

* @param revision

* @param destPath

* @param isRecursive

* @return

* @throws SVNException

* checks out a Working Copy given a repository url

*/

private static long checkout( SVNURL url , SVNRevision revision , File destPath , boolean isRecursive ) throws SVNException {

SVNUpdateClient updateClient = ourClientManager.getUpdateClient( );

/*

* sets externals not to be ignored during the checkout

*/

updateClient.setIgnoreExternals( false );

/*

* returns the number of the revision at which the working copy is

*/

//return updateClient.doCheckout( url , destPath , revision , revision , isRecursive );

return updateClient.doCheckout(url, destPath, revision, revision, SVNDepth.INFINITY, true);

}

/**

*

* @param wcPath

* @param updateToRevision

* @param isRecursive

* @return

* @throws SVNException

* updates a Working Copy to a particular revision

*/

private static long update( File wcPath , SVNRevision updateToRevision , boolean isRecursive ) throws SVNException {

SVNUpdateClient updateClient = ourClientManager.getUpdateClient( );

/*

* sets externals not to be ignored during the update

*/

updateClient.setIgnoreExternals( false );

/*

* returns the number of the revision wcPath was updated to

*/

return updateClient.doUpdate( wcPath , updateToRevision , isRecursive );

}

/**

*

* @param wcPath

* @param url

* @param updateToRevision

* @param isRecursive

* @return

* @throws SVNException

* switches a Working Copy to another url

*/

private static long switchToURL( File wcPath , SVNURL url , SVNRevision updateToRevision , boolean isRecursive ) throws SVNException {

SVNUpdateClient updateClient = ourClientManager.getUpdateClient( );

/*

* sets externals not to be ignored during the switch

*/

updateClient.setIgnoreExternals( false );

/*

* returns the number of the revision wcPath was updated to

*/

return updateClient.doSwitch( wcPath , url , updateToRevision , isRecursive );

}

/**

*

* @param wcPath

* @throws SVNException

* recursively adds an existing local item under version control (schedules for addition)

*/

private static void addEntry( File wcPath ) throws SVNException {

ourClientManager.getWCClient( ).doAdd( wcPath , false , false , false , true );

}

/**

*

* @param wcPath

* @param isStealLock

* @param lockComment

* @throws SVNException

* locks a versioned item

*/

private static void lock( File wcPath , boolean isStealLock , String lockComment ) throws SVNException {

ourClientManager.getWCClient( ).doLock( new File[] { wcPath } , isStealLock , lockComment );

}

/**

*

* @param wcPath

* @param force

* @throws SVNException

* deletes a versioned item from version control (schedules for deletion)

*/

private static void delete( File wcPath , boolean force ) throws SVNException {

ourClientManager.getWCClient( ).doDelete( wcPath , force , false );

}

/**

*

* @param srcURL

* @param dstURL

* @param isMove

* @param commitMessage

* @return

* @throws SVNException

* copies or moves one location to another one within the same repository

*/

/* private static SVNCommitInfo copy( SVNURL srcURL , SVNURL dstURL , boolean isMove , String commitMessage ) throws SVNException {

return ourClientManager.getCopyClient().doCopy( srcURL , SVNRevision.HEAD , dstURL , isMove , commitMessage );

}*/

public static void main( String args[]){

String svnURL="https://rproject.svn.sourceforge.net/svnroot/rproject";

File filePath=new File("/home/D2HS/rbaral/Documents/rproject/firstfile1.java");

DefaultSVNOptions myOptions=new DefaultSVNOptions();

String username="username";

String pwd="password";

SVNRevision revision=SVNRevision.HEAD;

String destPath="destination";

File destFile=new File(destPath);

boolean isRecursive=true;

ourClientManager=SVNClientManager.newInstance(myOptions, username, pwd);

try {

setUpFactory();

//addEntry(filePath);

//commit(filePath, true, "test commit message");

SVNURL url=SVNURL.parseURIDecoded(svnURL);

System.out.println("files checking out ");

checkout(url, revision, destFile, isRecursive);

File updateFile=new File("filepath to be updated");

//update(updateFile, SVNRevision.HEAD, true);

System.out.println("file checked out from remote svn");

} catch (SVNException e) {

System.out.println("SVNException while checking out :"+e.getMessage());

e.printStackTrace();

}

}

}

thanks to the site:svnkit
osdir.com

Thanks,
Ramesh

Java Mysql BLOB reading/writing

2010-06-08T11:49:00.000-07:00

The following tested code reads a file using fileinputstream stores in blob format in mysql table. It then reads the blob object and writes to some location in the form of a file. Due to limitation of blob this might not support for huge files.If you need to process with large files be on safe side to use LONGBLOB data type.
/**
*
*mysql table creation
*create table stb(id integer,doc blob) engine=innodb;
*
*/

package com.test;

import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class StreamtoBinary {

/**
* @param args
*/
public static void main(String[] args) {
System.out.println("reading inputstream");
Statement stmt = null;
Connection con = null;
try {
File file = new File(
"srcfilepath");
FileInputStream iStream = new FileInputStream(file);

Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/test";
con = DriverManager.getConnection(url, "root", "");
stmt = con.createStatement();
String sql = "insert into stb values(?,?)";
PreparedStatement pstmt = con.prepareStatement(sql);
pstmt.setInt(1, 1);
pstmt.setBinaryStream(2, iStream, (int) file.length());
// pstmt.executeUpdate();
// con.commit();
System.out.println("written to table:" + (int) file.length());
// now read the blob object and write to a file
sql = "SELECT id, doc FROM stb";
PreparedStatement stmt1 = con.prepareStatement(sql);
ResultSet resultSet = stmt1.executeQuery();
int i = 0;
while (resultSet.next()) {
String id = resultSet.getString(1);
File doc = new File(
"destfilepath");

FileOutputStream fos = new FileOutputStream(doc);
Blob b = resultSet.getBlob(2);
BufferedOutputStream os;

os = new BufferedOutputStream(new FileOutputStream(doc));
os.write(b.getBytes(1, (int) b.length()), 0, (int) b.length());
os.flush();
os.close();
System.out.println("writing record:" + id);
System.out.println("written to file:" + doc.length());
// }
fos.close();
i++;
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
stmt.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
}

}

Thanks,
Ramesh.

java mail sending mail and reading mail from external server

2010-06-03T01:47:00.000-07:00

The following code will assist in sending emails from a given host using smtp.
It also has methods for reading emails from external mail servers.
This is a tested code and simply copy paste of the code will run without further configuration.

package test;

import java.io.IOException;
import java.io.InputStream;
import java.io.UnsupportedEncodingException;
import java.util.Properties;

import javax.mail.Folder;
import javax.mail.Message;
import javax.mail.MessageRemovedException;
import javax.mail.MessagingException;
import javax.mail.Session;
import javax.mail.Store;
import javax.mail.Transport;
import javax.mail.event.FolderEvent;
import javax.mail.event.FolderListener;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeMessage;

import com.sun.mail.pop3.POP3Folder;

public class TestMail {

/**
* Description:
* TestMail
* @param args
* void
* Author:Ramesh Raj Baral
* @throws MessagingException
* @throws MessagingException
* @throws IOException
* @since Jun 2, 2010
*/
private static String host="hostName";

public static void main(String[] args) throws MessagingException, IOException {
// TODO Auto-generated method stub
sendEmail();
readEmail();
//readGmail();
}

/**
this method reads the emails from the inbox folder only of any pop server
*/

public static void readEmail() throws MessagingException, IOException{
Properties props = new Properties();
props.put("mail.smtp.host", host);
props.put("mail.transport.protocol", "smtp");
String password="password";
Session session = Session.getDefaultInstance(props, null);
Store store = session.getStore("pop3s");//pop3
store.connect(host,"userName", password);
Folder folder = store.getFolder("inbox");//only inbox is supported by pop3
folder.open(Folder.READ_WRITE);
System.out.println("no of msg:"+folder.getUnreadMessageCount());
Message[] message = folder.getMessages();
// Display message in the descending order of received date.
for (int i = message.length-1; i >0; i--) {
try{
System.out.println("------------ Message " + (i + 1) + " ------------");
System.out.println("SentDate : " + message[i].getSentDate());
System.out.println("From : " + message[i].getFrom()[0]);
System.out.println("Subject : " + message[i].getSubject());
//System.out.print("Message : ");
//this part checks the unique id (UID) of the message which can be useful to decide //if the message is new or old
if (folder instanceof POP3Folder) {
POP3Folder pf =
(POP3Folder)folder;
String uid = pf.getUID(message[i]);
if (uid != null)
System.out.println("UID is:"+uid);
}
InputStream stream = message[i].getInputStream();
System.out.println("*************************************");
while (stream.available() != 0) {
//print the content of mail
System.out.print((char) stream.read());
}
System.out.println("**************************************");
}catch(MessageRemovedException mex){
System.out.println("message removed exception ");
}
}
}

/**
this method sends email
*/
public static void sendEmail() throws MessagingException, UnsupportedEncodingException{
Properties props = new Properties();
props.put("mail.smtp.host", host);
props.put("mail.transport.protocol", "smtp");
InternetAddress[] bccFilteredList = new InternetAddress[1];
bccFilteredList[0]=new InternetAddress("emailadderess@domain.com".toString(),"any name");
InternetAddress[] toFilteredList = new InternetAddress[1];
toFilteredList[0]=new InternetAddress("emailadderess@domain.com".toString(),"");
Session session = Session.getDefaultInstance(props, null);
//session.setDebug(true);//if uncommented displays all the debug info
Message msg = new MimeMessage(session);

msg.setFrom(new InternetAddress("fromemail@domain.com","username"));
msg.setRecipients(Message.RecipientType.TO, toFilteredList);
msg.setRecipients(Message.RecipientType.BCC,bccFilteredList);
msg.setSubject("Test msg!");
msg.setHeader("Content-Type", "text/html");
String body="Another Test msg";
msg.setText(body);
Transport.send(msg);
System.out.println("mail sent");
}

/**
this method reads the mails from gmail server of a given account

*/
public static void readGmail() throws MessagingException, IOException{
String host = "pop.gmail.com";
String user = "emailaddress@gmail.com";
String password = "password";
// Get system properties
Properties properties = System.getProperties();
// Get the default Session object.
Session session = Session.getDefaultInstance(properties, null);
// Get a Store object that implements the specified protocol.
Store store = session.getStore("pop3s");
//Connect to the current host using the specified username and password.
store.connect(host, user, password);
//Create a Folder object corresponding to the given name.
Folder folder = store.getFolder("inbox");
// Open the Folder.
folder.open(Folder.READ_ONLY);
System.out.println("new emails:"+folder.getNewMessageCount());;
Message[] message = folder.getMessages();

// Display message.
for (int i = message.length-1; i >0; i--) {
try{
System.out.println("------------ Message " + (i + 1) + " ------------");
System.out.println("SentDate : " + message[i].getSentDate());
System.out.println("From : " + message[i].getFrom()[0]);
System.out.println("Subject : " + message[i].getSubject());
//System.out.print("Message : ");

InputStream stream = message[i].getInputStream();
//uncomment the following loop if you want to print the mail body
/* while (stream.available() != 0) {
//System.out.print((char) stream.read());
}*/
}catch(MessageRemovedException mex){
System.out.println("message removed exception ");
}
}

folder.close(true);
store.close();

}
}

Cheers,
Ramesh Baral.

Affair

2010-05-31T09:07:00.000-07:00

AFFAIR

It was the November 25th 2005, Sudarshan was in the college. There was cold outside. A slight rain was acting to make the temperature below the threshold value. It was a leisure period, as the teacher was absent due to some work.
The teacher has given a lab works to the students so that, they won’t be wasting their time in unnecessary activities. However the Bachelor level students found it difficult to concern on the teacher’s path, some of them were playing table tennis, some were busy in scoring three points in Basket Ball and some were sitting in class and singing their cool favorite song. Some sincere students were busy in their lab work. This time Sudarshan was trying to prove himself as a sincere student and was doing his lab work. He was searching the Internet for the work. By chance he was not getting the right tutorials and was scratching his head. In the mean time, he checked out his mail. There was a new mail in his inbox. It was an invitation by his school mate to join a web site. He hadn’t tried these sorts of sites till today. However he could not tolerate to neglect the request of his friend and so he filled the form. It was his bad luck that he didn’t have any of his photographs. He had formatted his USB drive just a few moments ago. So, he selected the nice photo of his best actor, though other data certainly corresponded to him. Finally, he was welcomed with a congratulations message, that he was registered to the site. He clicked the friend’s link of the friend (Sohan) who sent him the request to join the group. He added some of them to his friends group. Finally, he found the right tutorial for the lab work and prepared the lab report. It was the time for the next lecture, the bell said like that.
The next Lecture was from Mr. Peterson, who always tried to keep a strict discipline in the class. Students were not allowed to come late than two minutes. If they come late then their attendance was not taken and certainly this will also be considered while calculating the internal grades. All of the students came in right time. The teacher took the class and left as usual in the right time. The students were eager to leave home after this last lecture for today.
It was the tomorrow morning; Mr. Peterson gave the students lab work and left for his work. This day most of the students were busy preparing their lab report. Some of the guys started playing outdoor games and asked their friends to do the work for them too. Sudarshan took no time in completing the lab work as it was very easy. Then he browsed the site that he registered yesterday. There he found a new message for him. There were two messages, one from his classmate inviting him to join the get together tomorrow evening. The second one was from completely unknown lady. Though he had added her to his friends list just yesterday, he really did not know about her except the data mentioned in the site. She had given her email address and asked him to mail. She had also admired his profile and asked if he would like to be her good friend. He was feeling very difficult. It was the youth mind and he revisited the lady’s profile. He was very excited to get the email address of such a beautiful girl. He did not considered what other information was about.
It did not take so much time to send mail to the girl. He added some other friends to his group and increased the friends in his group. The time passed in its rate.
“Because I Love You….” , the hotel’s stereo was saying. Many boys were already present in the joined table. Sohan was laughing with other guys. Sudarshan was welcomed by Sohan and introduced to some new friends. It was a great meet. Sudarshan enjoyed a lot. In the mean time he asked about the lady, whether Sohan added her to his group by knowing or not. Sohan just ignored and said that he also added her from another friend’s group and really did not know her. Sudarshan told the incident happened today. Sohan laughed and yelled,” Girls are crazy to see your profile and might have given you their email id. That’s not the great thing at all. But I don’t have any email id of such girls. Bad Luck! Only boys”.
Sudarshan thought a lot why she was giving her email id to him and not to Sohan. He was proud to be special to girls for some time. He thought whether some special friendship can be established between them. He did not expected much more than that from a girl till now. In the mean time the stereo was playing cool sentimental song, “Timro mero sambandhako artha khojna kar laagyo..”, one of the best song of Sudarshan. He compared his situation with the feeling of the music for some time.
“Come on guys its already time to close the hotel for today, best time next day….”, Sohan said. In a short time, the group was dismissed. Sudarshan left to home alone. .Bad luck, no bus for him today. It was nearly fifteen minutes walk to his house. In the mean time he was thinking of the party and the girl. “Why she gave me the email id and what might be her expectance? Being a lady? Ha, let’s leave it. There can be various good relations between male and female other than what young guys think. Yes, she can be a good friend for me like Sohan is…..”.
“Is this your time to return home?”, Father shouted him. Mother said calmly, “you should return home early, son. Its not good to stay outside longer in evening, right?” He looked at his father’s face. It seemed that all of his blood is in his face. He murmured,” See his eyes, oh my god an ordinary person would have fainted, how could I tolerate. Only, because he is my father.” What makes the man so different from the women? How much my mother and father differ in his habits, even more than the land and the sky. Why the god gave him so hard heart?
My anger instantly increased. Sudarshan was listening to music and doing the home works. His father called him for dinner. Again he murmured, ”What makes him change his habit so instantly? Just now how he was treating me, but now he is to express his love voice”. He called him to join the dinner once again.” His temper might increase in no time, so its not good to make him .” The father, mother and son took a lovely meal. The father was adding food to his son’s plate. Sudarshan was amazed. Finally, he concluded that he was not his enemy at all. They are his god and love, shout and scold whatever is just for his good. “Parents are always good to their child. It is impossible to return the love that parents give to their child”
Tomorrow morning the inbox was filled with the reply the girls send. Her actual name was Sudha and she mentioned that she was happy to have a friend like him. Sudarshan was eager to send the reply. After sending, he felt whether he has missed the thing that he wanted to include in the mail. The bell ranged to indicate that the break was over. Mr. Sharma was completing his course today and thanked the students for their co-operation during the semester. He wished a good luck for their exam. There was no more than fifteen days for the exam. By tomorrow almost the entire subject teacher will be thanking the students.
In this way the semester ended and the students are to prepare for their University exam. Sudarshan was busy preparing at home. Some moment he spent with his friends in discussion for the exam. The exam started on 12th December and lasted for seventeen days. Sudarshan did his best. In the gap days he would be searching in the internet and discussing with friends for the doubts. There were already ten mails from Sudha and Sudarshan up to now. Now they are frank to express their feelings and at least a mail per day was the rate.
The exam was completed and the college will be starting only by 5th January. What to do in the mean time? Just roaming here and there in day time, visiting the internet at night, chatting with friends was the only routine of Sudarshan. He did not miss a single opportunity to help his parents in their work. It was a New Year time approaching the world. People were celebrating in their own way. Though it was not the actual festival of Nepalese, they are habituated to do so. Sudha sent a nice e card, Sudarshan too did so.
Look at the age of the two creature. Both in their early twenties and what might be in their heart and mind? Now they have started to chat in the mobile. At least a call from each other is a normal rate.
It was the time to go for studies once again. The new books and new teachers are actually inspiring the students to have some interest in their studies. The class was in silent mode. The mobile bell rang silently in his pocket. Nobody recognized it. He silenty looked at the number, it was Sudha’ s call. Mr. Paudel was teaching and everybody was looking to the white board in his beautiful handwriting. There was no option to cancel the call, though there was a great regret. No more than a minute had expired and the call came again. It was break and why not to talk. He responded and slowly went to the alone. A ten minute gossip was not sufficient but the friends were shouting to join for the lunch.
It was February 10th and still cold. He was inside the blanket and chatting with Sudha. “Very memorable chat every time”, he thought so. Suddenly the light went off and the city was in a dark. All people had already dreamt and the two creatures were sharing their feelings. He was also obliged to close the conversation as the UPS produced some warnings. Tomorrow morning, again there was a new mail and no way other than to response the mail for him. Till now no body was able to have a single sign about the affair. Today the February 13th night, some people in the city were enjoying the upcoming Valentines Day. Look at the two strange creatures. Don’t they have other work? Only chatting? Very strange! ha?
Today it was a strange conversation that took place in their life.
Sudarshan-“How are you celebrating tomorrow’s Valentines Day? Don’t u have any Valentine? ”

Sudha-“How to say? He is in my dream.”

Sudarshan-“Come on bring him to your reality and take the advantage of this great day. Tell him the words you want. Don’t wonder. It’s not to wait a long. You have to finalize. Utilize your time fully.”

Sudha-“Me 2, thinking so.”

Disturbance again! Suddenly the light went off and his UPS was warning that he has few minutes to proper shut down the machine.

Sudarshan-“ Me 2 go. Load shedding! Good night”

Sudha-“I should tell it finally no?”

Sudarshan-“Yes do it ok? now me 2 leave.”

Sudha-“It’s to you. Will you be my Valentine? I love u Sudarshan and want to spend my life with you”

Amazed! What to say. Trembling fingers are missing the typing rate…….
Sudarshan-“ whaaatttt?”

Sudha-“Yup man I really love you though I haven’t seen you, I respect ur feelings man. I will be compromising anything for you”

Last, long signal from the UPS. Finally all black.
Unable to sleep the whole night. Thinking about the three words presented to him.
“How she decided such a great thing? We haven’t any dates at all and even...”
Hey Sudarshan come on its time for the tea. Don’t you have college today? Its already six and sleeping till now? The college bus wont be waiting for you today and I wont be giving you any bus charges. You lazy bone……
“Mom….I…I ..I will be ready in few minutes…”
All friends were waiting for him. There was no much to study today. The sports week has started and almost everyone participating in it. Sudarshan will be having his football match tomorrow. “Guys I will be for the practice in few minutes, you guys go on...” shouting these words he was to open the inbox. There was a long mail from Sudha with a love e card. Even after three days he could not reply at all and not have a single call and chat. The cell is switched off.
Finally, he turned the cell on and there was an immediate call and it was she. Again, the same three words. Call was ended from the receiver. Again same number and same words, but some questions for this time.
“If my words hurt you I am sorry. But I am in deep love with you.”
“How could you say like that, we haven’t seen each another and our parents haven’t talked to each other? I have still a lot to study and you only doing your PCL course.”
“These all don’t matter, if we are true and there is no deceived. We can continue our study and convince our parents. I didn’t ask you to marry me just now. Its only the propose, we can direct it to long journey or…Its totally up to we two..”
“I love my parents and can’t go against them. They love me very much. They are my god, heaven and everything for me. I can’t compromise them for you. You listen; I can’t sacrifice my parents at any cost. Please excuse me, we are a good friend and can be so for ever. You are a girl, please think of your parents what might they be thinking?”
“I don’t have my parents. They are dead when I was ten in a plane crash………..sh sh sh..” A painful scream from the other end was heard. The call terminated suddenly.

A long try from this side was unsuccessful as the cell was switched off. No training for the match and the mail server was ready to send the consolation words for Sudha. For consolation only there was an inclusion of the words”. I also love you, but as a friend….”
“Oh! I will call her better” searches the pocket for the cell but unable. He has forgotten to bring the cell today. He was wondering the whole day,” what she might be feeling? Better I did not have answered instantly in that manner? But……..” He could not concentrate on the training and was hurried to leave for home.
“There was a call for you on the cell. I was surprised that you have forgotten to take it today. Finally there was a message for you, a girl..Sudha has a message on your cell...” Mother explained.
The message was already entered in the inbox, so mother had read it and nothing private. He worried a lot and was afraid what his father will be thinking of. Also his tempered face and large eyes. He could not imagine. “Its better to tell everything truly before it gets out of way.”, thinking this he straightly went to his mother and collected great courage and finally told all the story. “I even rejected the proposal but she is not to leave me and wanted to meet me tomorrow. You tell me what I shall do. It’s all adventitious.” Regretting, he was with his face down. In the mean time it was the entry of the great person- father! Both were silent. Father looked them seriously and with his tempered face and large eyes again looked to both of them.
“I heard everything of your conversation. I am sorry about this. It’s not your fault nor is the girl doing any fault. This is the age that made you so. So you should be very careful and convince the girl. Look, you should be very formal and don’t hurt the girl. As she had called you, go and tell her that this is not the time to do so and for now you are good friends and let the future decide the thing. Don’t hurt her at all else you will be losing a good friend”.
He was surprised after listening this. There was no sleep for the whole night. He could not memorize what sorts of incident happened in the match and nothing at all. The only thing he was remembering is that he has a difficult date at 5 today. He was on the road side seeking the girl face of his concern. As she had already mentioned she will be in yellow kurta salwar( a Pakistani dress), he didn’t find any difficulty in identifying her. She was waiting on the other corner and polling the watch in her thin and whitish wrist. He had already mailed her that the photo he posted was not of his own, but the girl did not concerned this at all and was all the way at her.
He was amazed that the girl who had proposed him was such a beautiful creature of the world. He kept looking her for some moment in the mean time there were phone calls, but still unaware about it. Later a truck blew strong horn and shouted at him as he was in the middle of the road. He stroked his head slightly and call returned to her to confirm that the girl was Sudha. It was not confusion and she responded, he mentioned that he is on the opposite corner in the white shirt and black pant posing towards her with a cell in a hand. It took no time to truncate the call and she was keenly looking to him from the opposite corner. It was the feelings that make them blind that both were unaware that they were crossing the road. There was no more than some meters distance between them. Suddenly a truck was there to hit Sudha. Sudarshan was frightened. Sudha was lying on the road with blood covered her face and trembling her hand towards Sudarshan. She could hardly say, ”Sudarshan the god was so rude that we could not meet in this life. No matter, the only thing that I want to hear from you is the three words. Please let me leave the world happily. Wont you? I swear we will meet in next life and for whole life.” Tears exploded the beautiful face and finally mixed to the blood. The red tears were flooding the heart of Sudarshan.
He could hardly say and do anything. The truck finally came with back gear and was to stroke Sudha again. But the public was to protect her. Soon there was the siren of the ambulance and Sudha was to be admitted in the emergency operation theater. Sudha was asking for the same reply. Sudarshan could not tolerate at all. He cut his hand with the broken glass of the window and put the latch of blood on the forehead of Sudha. Sudha slightly laughed and again her tears made the way to become red. The doctors started the operation. Sudarshan was waiting outside in the hope that Sudha would be alright. But the chance was against them, doctors asked for an excuse like in the serials. Sudarshan went to see the corps of Sudha and was continually looking. Finally he felt down on Sudha’s dead body. The doctors admitted him on the next theater. Sudarshan’s parents also visited the hospital. Their eyes were being flooded with tears.
The doctor came from the operation theater with no feelings in their face. He said seriously that Sudarshan is unconscious till now and the treatment is going on. Minutes, hours and days passed but no progress. The doctors were hesitating to explain that Sudarshan has lost his memory and could hardly remember any things from his past life. The parents were screaming in pain.
See the god, how can he change the life of a person from the beautiful garden to the arid desert.
Now its one year passed since Sudarshan has been in amnesia. Sudarshan has a new mimic life. He could not remember his parents, his friends and none of all. The doctor referred his parents to take him to another country for further treatment, and hoped that he might be able to live a new happy life. Today these three creatures are leaving for the treatment. Sudarshan’s friends, neighbors, teachers all wished him a better treatment, though he did not recognize them.
Don’t you think we should wish him a better treatment?

ORACLE 10G:Get a column in a single comma separated string

2010-04-21T23:27:00.000-07:00

The following code I found was quite helpfule to me.This gives you a single column values in comma separated form.
SELECT
LTRIM( REPLACE(
REPLACE(
XMLAGG(XMLELEMENT("x", clientid) ORDER BY clientid),
'',
','
),
''
),','
) as allclients

FROM (SELECT DISTINCT clientid
FROM clients)

In above query there is a table called clients where clientid is a field.
When above query is executed the result will be as shown below:

clients
1,2,3,4,5,.....

where the client with ids 1-5 are present in the clients table.
This worked perfectly in oracle 10g. I haven't checked in other.

Health Environmentalists Group

2010-03-23T21:00:00.001-07:00

Health Environmentalists

Visit this group

simply transfer contents of a text file to excel sheet.

2010-02-25T05:30:00.000-08:00

This code reads the input text file.It scans each line at a time and separates the words by comma.Each token is placed in a single cell in the excel file. Some times these sorts of silly codes are also useful.
The thing to be noted is that if there is duplicate record in consecutive lines it prevents the duplicates too.
Ex:
test,abcd,efgh,ttt in line1 and
test,abcd,ijkl,sss in line2 then
the entry test abcd is inserted in the first row first column,efgh,ttt,sss in the next columns in the same row.
Similarly other records are proceeded.
I encountered such requirement during my work and thought if someone might require it and posted here.

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.biff.RowsExceededException;
public class Test {
public Test() {
}
private static String[] months=new String[]{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"};
public static void main(String[] args) throws ParseException, GeneralSecurityException, FileNotFoundException, RowsExceededException, Exception {
    Test test1 = new Test();


    StringBuilder contents = new StringBuilder();

    try {
        String[] tempArray=new String[5];
        String lastUser="";
        //use buffering, reading one line at a time
        //FileReader always assumes default encoding is OK!
        BufferedReader input = new BufferedReader(new FileReader("abcd.txt"));
        try {
          String line = null; //not declared within while loop
          /*
          * readLine is a bit quirky :
          * it returns the content of a line MINUS the newline.
          * it returns null only for the END of the stream.
          * it returns an empty String if two newlines appear in a row.
          */
          int lastIndex=0;
          int secondLastIndex=0;
          int i=0;
          int rowNum=0;
          int colNum=0;
          WritableWorkbook w = Workbook.createWorkbook(new BufferedOutputStream(new FileOutputStream("report.xls")));
          WritableSheet s = w.createSheet("Demo", 0);
          while (( line = input.readLine()) != null){
            tempArray=line.split(",");
            if(tempArray.length>1){
            lastIndex=tempArray.length-1;
            secondLastIndex=lastIndex-1;
            if(i<1){
                lastUser=tempArray[0]+" "+tempArray[1];
            }
            if(lastUser.equalsIgnoreCase(tempArray[0]+" "+tempArray[1])){
                if(i<1){//this is the first attempt
                    //System.out.println("first case");
                    contents.append(lastUser);
                    s.addCell(new Label(rowNum,colNum, lastUser));
                    //contents.append(System.getProperty("line.separator"));
                    rowNum++;
                    s.addCell(new Label(rowNum,colNum, tempArray[secondLastIndex]));
                    contents.append(","+tempArray[secondLastIndex]+",");
                    //contents.append(System.getProperty("line.separator"));
                    rowNum++;
                    s.addCell(new Label(rowNum,colNum, tempArray[lastIndex]));
                    contents.append(tempArray[lastIndex]);

                }
                else{
                    String lastSkillEntered=s.getCell(rowNum, colNum).getContents().toString();
                    System.out.println("inside 1:"+rowNum+colNum+lastSkillEntered+","+tempArray[lastIndex]);
                    s.addCell(new Label(rowNum,colNum,lastSkillEntered+","+tempArray[lastIndex]));
                    contents.append(":"+tempArray[lastIndex]);


                }

            }
            else{
                colNum++;
                rowNum=0;
                System.out.println("new entry:"+rowNum+colNum);
                s.addCell(new Label(rowNum,colNum, tempArray[0]+" "+tempArray[1]));
                contents.append(System.getProperty("line.separator"));
                contents.append(tempArray[0]+" "+tempArray[1]);
                //contents.append(System.getProperty("line.separator"));
                rowNum++;
                s.addCell(new Label(rowNum,colNum,tempArray[secondLastIndex]));
                contents.append(","+tempArray[secondLastIndex]+",");
                //contents.append(System.getProperty("line.separator"));
                rowNum++;
                s.addCell(new Label(rowNum,colNum,tempArray[lastIndex]));
                contents.append(tempArray[lastIndex]);

            }

            }
            lastUser=tempArray[0]+" "+tempArray[1];
            i++;
          }
          System.out.println("contents read:\n"+contents.toString());
          w.write();
          w.close();
          System.out.println("done");
      }

        catch (IOException ex){
        ex.printStackTrace();
      }
      catch(Exception ex){
        System.out.println("Exception:"+ex.getMessage());
      }
    finally {
        input.close();
      }
}
    finally {
       // input.close();
      }
}

All the functionality is provided by the jar file jxl.jar.So you need to download this jar file and place in the class path/build path accordingly.
Almost all the things are clear and no more explanation is required.

Saankhu to Nagarkot hike on Feb-7 2010

2010-02-19T04:00:00.000-08:00

http://s790.photobucket.com/albums/yy187/rameshraj/Sankhu%20hike/?start=0

Nepali Parser

2010-02-03T05:37:00.000-08:00

I thought it wont be fair to keep the research and findings of my and mine friends limited to some sectors of hard disk. So I think of publishing objectives that we achieved during researching on Nepali Parser two years back.

This work wont be performed and the result that we have achieved wont be at this level without affable support from Madan Puraskar Pustakalaya.(An organization) They provided us the requirement and the rules that needed to incorporate in the technical part of the project.

Another expertise came from Mr. G. Prasanna David- former Lecturer of Gandaki College of Engineering and Science. (He holds great expertise in Linux System Administration,Networking, Natural Language Processing and many more..).

Mr.Chandra Kanta Adhikari (Teacher of Gandaki Boarding School, Nepali Department) provided his expertise, suggestions and guidelines for us. His expertise in Nepali Language was really appreciable.

We did this work as the major project to fulfill requirement of our B.E final semester.

As the project cannot be done in single, there are my friends Mr. Shakeel Shrestha, Ms. Muna khadka in our team. We all had equal contribution from our side to reach our goal.

The term 'Parser' itself clarifies the meaning but on the level of research and implementation, we needed to break down into two components-Chunker and Parse Tree Generator. While the Chunker part is the core essential part but the importance of Tree Generator is inevitable as it plays the vital role in user view of the result prepared by the Chunker.I will first elaborate the Chunker part.

Chunking is the part of the Natural Language Processing in which the relationship between the words or phrases present in a sentence is determined and is grouped together. The Chunker in this context takes some tagged input sentence and then performs chunking or so called as finding the relation between words or between phrases and represents them in parenthesized notation. The system operates on the basis of certain rules. The input sentence should be given in Unicode value of the word following a slash and then the tag of the word in capital English letters. Two consecutive words can have only a single spacing between them. It then finds the phrases from the input words according to those rules. In simple, the generated phrases are called as chunks.

The Chunker in this context is domain specific and chunks the simple sentences like those we can find in simple school books for primary level. Complex sentences are not considered as the context of this project. To have a broad domain coverage well analyzed and complete set of rules need to be provided.

Such a system is useful for many other systems like Machine Translator, Grammar Checking, information retrieval etc. Below is the block diagram of the whole system.

MultiActionFormController in Spring

2010-01-27T05:25:00.000-08:00

I last felt the requirement of a Controller that could process the form submitted as well as the view page be able to trigger multiple events triggered to the same controller.
It was simply a burden to have both feature in a single controller. But after searching and some re-searching(ha..ha) I came out for the solution I required.
To have a controller that can process the form as well as has multiple methods that will be triggered as my requirement.

For this I made a class called SimpleMultiActionFormController as shown below:

import java.io.File;
import java.io.IOException;
import java.lang.reflect.Method;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.log4j.Logger;
import org.springframework.validation.BindException;
import org.springframework.web.bind.ServletRequestDataBinder;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.SimpleFormController;
import org.springframework.web.servlet.mvc.multiaction.MethodNameResolver;
import org.springframework.web.servlet.mvc.multiaction.NoSuchRequestHandlingMethodException;

import com....api.service.ProductionManager;
import com...impl.dto.ProductionManagerDTO;
import com......impl.dto.UserEventLogDTO;
import com....impl.service.ProductionManagerImpl;

/**
* <desc>This method will be responsible to act as combination of
* SimpleFormController and MultiActionController</desc>
* @author Ramesh Raj Baral
* @since:Jan 21, 2010
* File:SimpleMultiActionFormController.java
* @Version:1.0
*/

public class SimpleMultiActionFormController extends SimpleFormController {

    private MethodNameResolver methodNameResolver = new SubmitParameterPropertiesMethodNameResolver();
    private ProductionManager productionManager;
    private String fileUploadPath;
    private Logger log=Logger.getLogger(this.getClass());

    public final void setMethodNameResolver(MethodNameResolver methodNameResolver) {
        this.methodNameResolver = methodNameResolver;
    }

    public final MethodNameResolver getMethodNameResolver() {
        return this.methodNameResolver;
    }
    protected Object formBackingObject(HttpServletRequest request) throws ServletException {
            return productionManager;
        }

    public ProductionManager getProductionManager() {
        return productionManager;
    }

    public void setProductionManager(ProductionManager productionManager) {
        this.productionManager = productionManager;
    }

    public String getFileUploadPath() {
        return fileUploadPath;
    }

    public void setFileUploadPath(String fileUploadPath) {
        this.fileUploadPath = fileUploadPath;
    }

    protected ModelAndView processFormSubmission(HttpServletRequest request,
            HttpServletResponse response, Object command, BindException errors)
            throws Exception {
        ProductionManagerDTO pdto=(ProductionManagerDTO)((ProductionManagerImpl)command).getModel();
        log.info("binded filename from parent:"+pdto.getFileName()+"...");
        ServletRequestDataBinder binder = createBinder(request, command);
        binder.bind(request);


        if (errors.hasErrors() || isFormChangeRequest(request)) {
            if (logger.isDebugEnabled()) {
                logger.info("Data binding errors: " + errors.getErrorCount());
            }
            logger.info("error is:"+errors.getFieldValue(request.getAttribute("file0").toString()));
            logger.info("error is:"+errors.getNestedPath());

            return showForm(request, response, errors);
        }
        else {
            String methodName = this.methodNameResolver.getHandlerMethodName(request);

            Method m = (Method) this.getClass().getMethod(methodName,
                    new Class[] {HttpServletRequest.class,HttpServletResponse.class,
                                Object.class,BindException.class});
            if (m == null) {
                throw new NoSuchRequestHandlingMethodException(methodName, getClass());
            }


            List params = new ArrayList(4);
            params.add(request);
            params.add(response);
            params.add(command);
            params.add(errors);

            return (ModelAndView) m.invoke(this, params.toArray(new Object[params.size()]));
            //return null;
        }

    }

    public ModelAndView deleteFiles(HttpServletRequest request,HttpServletResponse response, Object command, BindException errors) throws Exception {
        logger.info("inside deleteFiles method...........");
        ProductionManagerDTO pdto=(ProductionManagerDTO)((ProductionManagerImpl)command).getModel();
        System.out.println("binded filename:"+pdto.getFileName()+"...");
        String file = request.getParameter("file");
        String fileName = request.getParameter("fileName");
        String fileID=request.getParameter("fileID");
        String tempDestPath=new File(new File(".").getCanonicalPath()).toString()+System.getProperty("file.separator")+this.fileUploadPath+System.getProperty("file.separator")+fileName;
        File uFile = new File(tempDestPath);
        System.out.println("filepath is:"+tempDestPath);
        System.out.println("File exist:"+uFile.exists()+"..readable:"+uFile.isFile());

        return this.showForm(request, errors, getFormView());
    }

    public ModelAndView finalSubmit(HttpServletRequest request,HttpServletResponse response, Object command, BindException errors) throws Exception {
        Map model = new HashMap();
        model.put("item", "");
        logger.info("inside finalSubmit method");
        logger.info("inside deleteFiles method...........");
        ProductionManagerDTO pdto=(ProductionManagerDTO)((ProductionManagerImpl)command).getModel();
        System.out.println("binded filename:"+pdto.getFileName()+"...");
        String file = request.getParameter("file");
        String fileName = request.getParameter("fileName");
        String fileID=request.getParameter("fileID");
        String tempDestPath=new File(new File(".").getCanonicalPath()).toString()+System.getProperty("file.separator")+this.fileUploadPath+System.getProperty("file.separator")+fileName;
        File uFile = new File(tempDestPath);
        System.out.println("filepath is:"+tempDestPath);
        System.out.println("File exist:"+uFile.exists()+"..readable:"+uFile.isFile());
        return new ModelAndView(getSuccessView(), model);
    }

This has the properties as normal and their getter and setters. The point to be noted is the method processFormSubmission(...). this method will return the name of the corresponding method whose name is posted in request scope.
The child class of this class can have multiple methods. The method names are resolved using the methodResolver.

Now register your customized resolver in your dispatcher servlet as shown below in mine case:

<bean id="submitActionParamResolver" class="com....impl.web.controller.SubmitParameterPropertiesMethodNameResolver">
       <property name="mappings">
          <props>
            <prop key="_finish">finalSubmit</prop>
            <prop key="_deleteFiles">deleteFiles</prop>
            <prop key="_addFileElement">addElement</prop>
            <prop key="_removeFileElement">removeElement</prop>
         </props>
       </property>
       <property name="defaultMethodName"><value>finalSubmit</value></property>
</bean>

There are four methods registered namely finalSubmit,deleteFiles,addElement,removeElement. The SubmitParameterPropertiesMethodNameResolver is shown below:

import java.util.Iterator;
import java.util.Properties;

import javax.servlet.http.HttpServletRequest;

import org.apache.log4j.Logger;
import org.springframework.web.servlet.mvc.multiaction.MethodNameResolver;
import org.springframework.web.servlet.mvc.multiaction.NoSuchRequestHandlingMethodException;
import org.springframework.web.util.WebUtils;
/**
* <desc>This class resolves the method name from the request parameter
* and provide its mapped value defined in dispatcher servlet</desc>
* @author Ramesh Raj Baral
* @since:Jan 21, 2010
* File:SubmitParameterPropertiesMethodNameResolver.java
* @Version:1.0
*/
public class SubmitParameterPropertiesMethodNameResolver implements
MethodNameResolver {

private String defaultMethodName;

private Properties mappings;
private Logger logger=Logger.getLogger(this.getClass());

/**
* Set URL to method name mappings from a Properties object.
* @param mappings properties with URL as key and method name as value
*/
public void setMappings(Properties mappings) {
this.mappings = mappings;
}

/**
* @param defaultMethodName The defaultMethodName to set.
*/
public void setDefaultMethodName(String defaultMethodName) {
    //logger.info("setting defaultMethod:"+defaultMethodName);
this.defaultMethodName = defaultMethodName;
}

public void afterPropertiesSet() {
if (this.mappings == null || this.mappings.isEmpty()) {
    throw new IllegalArgumentException("'mappings' property is required");
}
}

public String getHandlerMethodName(HttpServletRequest request)
    throws NoSuchRequestHandlingMethodException {

for (Iterator it = this.mappings.keySet().iterator(); it.hasNext();) {
    String submitParamter = (String) it.next();
    //logger.info("getHandlerMethodName:"+submitParamter);
    if (WebUtils.hasSubmitParameter(request, submitParamter)) {
        return (String) this.mappings.get(submitParamter);
    }
}
//logger.info("returning defaultMethodName");
return defaultMethodName;
}
}

Now your Controller will be as shown below:

package com.d2.vhippm.impl.web.controller;

import java.io.File;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.util.StringUtils;
import org.springframework.validation.BindException;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;

/**
* This is responsible for the actions
* <li>fileview</li>
* <li>fieldelete</li>
* <li>comment related actions</li>
* @author Ramesh Raj Baral
* @since:Jan 22, 2010
* File:CommentsController.java
* @Version:1.0
*/
public class CommentsController extends SimpleMultiActionFormController {

    /** Logger for this class and subclasses */
    protected final Log logger = LogFactory.getLog(getClass());
    private ProductionManager productionManager;
    private List<DTO> prodManagerFilesList;
    private ProductionManagerFilesDTO prodManagerFile;
    private UserEventLogDTO userEventDTO;
    private List<DTO> userEventLogsList;
    private String fileUploadPath;


    protected Object formBackingObject(HttpServletRequest request) throws ServletException {
        return productionManager;
    }

    public ProductionManager getProductionManager() {
        return productionManager;
    }

    public void setProductionManager(ProductionManager productionManager) {
        this.productionManager = productionManager;
    }

    public ModelAndView deleteFiles(HttpServletRequest request,HttpServletResponse response, Object command, BindException errors) throws Exception {
        logger.info("inside deleteFiles method");
        ProductionManagerDTO pdto=(ProductionManagerDTO)((ProductionManagerImpl)command).getModel();
        ProductionManagerFilesDTO selectedFileDTO=(ProductionManagerFilesDTO)pdto.getSelectedFileDTO();
        String fileLocation = selectedFileDTO.getFileLocation();
        String fileName = selectedFileDTO.getFileName();
        String fileID=selectedFileDTO.getFileID();
        String tempDestPath=new File(new File(".").getCanonicalPath()).toString()+System.getProperty("file.separator")+this.fileUploadPath+System.getProperty("file.separator")+fileName;
        File uFile = new File(tempDestPath);
        System.out.println("filepath is:"+tempDestPath);
        System.out.println("File exist:"+uFile.exists()+"..readable:"+uFile.isFile());
        if(uFile.delete()){
            userEventDTO=new UserEventLogDTO();
            userEventDTO.setLogDesc("File_Deleted:"+tempDestPath);
            userEventDTO.setUserID("19345");
            userEventDTO.setUserName("system");
            userEventDTO.setLogType("File_Deleted");
            userEventDTO.setClientGroupID(1);
            userEventDTO.setClientID("1");
            this.productionManager.logEvents(userEventDTO);
            this.productionManager.updateModel(selectedFileDTO);
        }

        return this.showForm(request, errors, getFormView());
    }

    public ModelAndView finalSubmit(HttpServletRequest request,HttpServletResponse response, Object command, BindException errors) throws Exception {
        logger.info("inside finalSubmit method");
        ProductionManagerDTO pdto=(ProductionManagerDTO)((ProductionManagerImpl)command).getModel();
        pdto.getNewCommentsDTO().setFileUploadPath(fileUploadPath);
        MultipartHttpServletRequest multiRequest = (MultipartHttpServletRequest) request;
        final Map files = multiRequest.getFileMap();
        System.out.println(fileUploadPath);
        if (files == null) {
              logger.info("no file was sent");
        }
        else{
            String tempDestPath;
            Iterator fileIterator=files.values().iterator();
            MultipartFile file;
            prodManagerFilesList=new ArrayList<DTO>();
            userEventLogsList=new ArrayList<DTO>();
            while(fileIterator.hasNext()) {
                tempDestPath=new File(new File(".").getCanonicalPath()).toString()+System.getProperty("file.separator")+this.fileUploadPath+System.getProperty("file.separator");
                System.out.println("uploading to:"+tempDestPath);
                file =(MultipartFile)fileIterator.next();
                tempDestPath+=file.getOriginalFilename();
                prodManagerFile=new ProductionManagerFilesDTO();
                prodManagerFile.setFile(file);
                prodManagerFile.setIsDeleted('N');
                prodManagerFile.setFileName(file.getOriginalFilename());
                prodManagerFile.setFileSize(file.getSize());
                prodManagerFile.setFileType(file.getContentType());
                prodManagerFile.setUploadedBy("currentUser");
                prodManagerFile.setUploadedOn(new Date());
                prodManagerFile.setType(file.getContentType());
                if(StringUtils.hasLength(file.getOriginalFilename()) && file.getSize()>0){
                    prodManagerFilesList.add(prodManagerFile);
                }
                //file.transferTo(new File(tempDestPath));
                //make an entry if the transfer succeeds
            }
            pdto.getNewCommentsDTO().setFileDTOList(prodManagerFilesList);
        }
        if(StringUtils.hasLength(StringUtils.trimAllWhitespace(pdto.getNewCommentsDTO().getCommentMessage())))
            this.productionManager.updateModel(pdto);
        ((ProductionManagerDTO)this.productionManager.getModel()).getNewCommentsDTO().setCommentMessage("");
        List fileDTOList=new ArrayList();
        fileDTOList.add(new ProductionManagerFilesDTO());
        ((ProductionManagerDTO)this.productionManager.getModel()).getNewCommentsDTO().setFileDTOList(fileDTOList);
        return this.showForm(request, errors, getSuccessView());
    }
    /* (non-Javadoc)
    * @see org.springframework.web.servlet.mvc.SimpleFormController#referenceData(javax.servlet.http.HttpServletRequest)
    */
    protected Map referenceData(HttpServletRequest request) throws Exception {
        logger.info("inside referencedata");
        return super.referenceData(request);
    }
    public ModelAndView addElement(HttpServletRequest request,HttpServletResponse response, Object command, BindException errors) throws Exception {
        logger.info("adding new file element");
        this.productionManager.addElement(((ProductionManagerDTO)this.productionManager.getModel()).getNewCommentsDTO().getFileDTOList());
        return this.showForm(request, errors, getFormView());

    }

    public ModelAndView removeElement(HttpServletRequest request,HttpServletResponse response, Object command, BindException errors) throws Exception {
        logger.info("removing file element");
        return this.showForm(request, errors, getFormView());
        /**
        if(((ProductionManagerDTO)this.productionManager).getNewCommentsDTO().getFileDTOList().size()>1)
        return this.productionManager.removeElement(((ProductionManagerDTO)this.productionManager).getNewCommentsDTO().getFileDTOList(), 1);
        else
            return ((ProductionManagerDTO)this.productionManager).getNewCommentsDTO().getFileDTOList();
            */
    }


    public String getFileUploadPath() {
        return fileUploadPath;
    }

    public void setFileUploadPath(String fileUploadPath) {
        this.fileUploadPath = fileUploadPath;
    }
}

As you can see this controller has different methods. Register this controller in your dispatcher servlet as well:
<bean id="commentsController" class="com.....impl.web.controller.CommentsController">
    <property name="methodNameResolver"><ref bean="submitActionParamResolver"/></property>
    <property name="sessionForm"><value>true</value></property>
    <property name="commandName" value="productionManager"/>
    <property name="formView" value="commentPost"/>
    <property name="successView" value="PMCycles"/>
    <property name="productionManager" ref="productionManager"/>
    <property name="fileUploadPath" value=".../Clients"/>
</bean>

Now your jsp page will be something like:

<%@ include file="/VHIPPM/jsp/include.jsp"%>
<%@ taglib uri="http://www.springframework.org/tags/form" prefix="form"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %>

<html>
<head>
<script type="text/javascript">
function setFileParameters(fileLocation,fileID,fileName,buttonName){
                   document.getElementById("fileID").value=fileID;
                   document.getElementById("fileName").value=fileName;
                   document.getElementById("fileLocation").value=fileLocation;
                   document.fileViewForm.fileName.value=fileName;
                   document.fileViewForm.fileID.value=fileID;
                   document.fileViewForm.fileLocation.value=fileLocation;

                   document.fileViewForm._deleteFiles.click();
                   document.fileViewForm.submit();
                   alert("setting fileParam"+fileLocation+".."+fileID+".."+fileName+".."+ buttonName);
                   //return true;
                }
<script>
</head>
<body>
<form:form method="post" name="fileViewForm"
    commandName="productionManager" action="addComment.htm" enctype="multipart/form-data" >
<table border="1" width="100%">
<tr>
<td rowspan="2">Client Name</td>
<td rowspan="2">App Name</td>
<td rowspan="2">Start Date</td>
<td rowspan="1" colspan="3" align="center">Phase</td>
<td rowspan="2">Target Date</td>
<td rowspan="2">Revenue Month</td>
<td rowspan="2">Priority</td>
</tr>
<tr>
<td>Phase</td>
<td>Status</td>
<td>Next Phase</td>
</tr>
<tr>
<td>test</td>
<td>test</td>
<td>test</td>
<td>current phase</td>
<td>

</td>
<td>test</td>
<td></td>
<td>Click to upload</td>
<td>

</td>
</tr>
</table>
    <table border="1" background="green" width="100%">
        <tr>
            <th>Comments/Message</th>
        </tr>
        <tr>
            <td colspan="3"><form:textarea path="model.newCommentsDTO.commentMessage" />
            </td>
        </tr>
        <tr>
            <td>
            <c:forEach var="fileDTO" items="${productionManager.model.newCommentsDTO.fileDTOList}">
                <input id="file" type="file" name="${fileDTO.file}" size="30"/>
            </c:forEach>
            <input type="submit" value="More" name="_addFileElement"/>
            </td>
        </tr>
        <tr>
            <td><input type="submit" name="_finish" value="Submit" /></td>
        </tr>

        <tr>
            <td>S.No</td>
            <td>Comments/Message</td>
            <td>Posted By</td>
            <td>Posted On</td>
        </tr>
        <c:set var="count" value="0"/>
        <c:forEach var="prodManagerDTO" items="${productionManager.models}">
            <c:forEach var="comments" items="${prodManagerDTO.commentsDTOList}"
                varStatus="status">
                <c:set var="count" value="${count +1}" />
            </c:forEach>
            <c:forEach var="comments" items="${prodManagerDTO.commentsDTOList}"
                varStatus="status" begin="1">
                <tr>
                    <td><c:out value="${status.count}" /></td>
                    <td><b><c:out value="${comments.commentMessage}" /></b> <br />
                    <table border="0">
                        <c:forEach var="files" items="${comments.fileDTOList}">
                            <tr>
                                <c:choose>
                                    <c:when test="${empty files.deletedDesc }">
                                        <c:if test="${!empty files.fileName}">
                                        <td><a
                                            href="../download.htm?file=<c:out value='${files.fileLocation}'/>&fileName=<c:out value='${files.fileName}'/>" /><c:out
                                            value="${files.fileName}" /></a></td>
                                        <td><a href="../deleteFiles.htm"
                                            onclick="setFileParameters('<c:out value="${files.fileLocation}"/>','<c:out value="${files.fileID}"/>','<c:out value="${files.fileName}"/>','deleteFile');">Delete
                                        Me!</a></td>
                                        </c:if>
                                    </c:when>
                                    <c:otherwise>
                                        <td><c:out value="${files.deletedDesc}"></c:out></td>
                                    </c:otherwise>
                                </c:choose>
                            </tr>
                        </c:forEach>
                    </table>
                    </td>
                    <td><c:out value="${comments.postedBy}" /></td>
                    <td><c:out value="${comments.postedOn}" /></td>
                </tr>
            </c:forEach>
        </c:forEach>
    </table>
    <form:input id="fileName" path="model.selectedFileDTO.fileName" cssStyle="display:none"/></td>
    <form:input id="fileID" path="model.selectedFileDTO.fileID" cssStyle="display:none"/></td>
    <form:input id="fileLocation" path="model.selectedFileDTO.fileLocation" cssStyle="display:none" /></td>
    <div id="delFileButtonDiv" style="display: none"><input
        type="submit" name="_deleteFiles" value="Delete File!" /><c:out
        value="${files.fileName}" /></div>
</form:form>
</body>
</html>

As you can see the statements in the jsp page highlighted in red color are responsible fro triggering the submit action. These submit action will trigger the corresponding methods in the CommentsController.java class.
For example if you click the submit button with name '_finish' then from the dispatcher servlet the method name will be resolved as 'finalSubmit'.

See the entry <prop key="_finish">finalSubmit</prop>.
The finalSubmit method will get the control from the jsp. Now as the controller is of type SimpleFormController, you have the access of the form elements as well and as the name of buttons are mapped to different methods of controller via the methodNameResolver and the dispatcher servlet different methods will be triggered accordingly.

Thanks for the posts at: http://forum.springsource.org/showthread.php?t=11702

Thanks.

How to download the files using Spring!

2010-01-15T03:32:00.000-08:00

Like the upload process, the download process needs some tricky way to handle the operation effectively. As I have come through the problem and wasted some time, you can have a look and save your time......

After populating the list of files in the jsp(view) part, you can have an anchor link either on their name or any other properties.
I have used in their names.
Simply use this link in their names in your jsp page:

<td><a href="../download.htm?file=<c:out value='${files.fileLocation}'/>&fileName=<c:out value='${files.fileName}'/>"/><c:out value="${files.fileName}"/></a></td>

Now make your entry for the download.htm in the dispatcher servlet:

<bean id="downloadFileController" class="com.d2.vhippm.impl.web.controller.DownloadFilesController">
<property name="filePath" value="VHIPPMFiles/Clients"/>
</bean>

Finally here goes the controller:

//you can modify this as you desire
//this controller allows the user to download the file whose link was clcked by the user

import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.PrintWriter;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.springframework.util.FileCopyUtils;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.Controller;

/**
*
* @author Ramesh Raj Baral
* @since:Jan 15, 2010
* File:DownloadFilesController.java
* @Version:1.0
*/

public class DownloadFilesController implements Controller {
private String filePath;

   public ModelAndView handleRequest(HttpServletRequest request,
           HttpServletResponse response) throws Exception {
       ServletContext servletContext = request.getSession()
       .getServletContext();

       String file = request.getParameter("file");
       String fileName = request.getParameter("fileName");
       String tempDestPath=new File(new File(".").getCanonicalPath()).toString()+System.getProperty("file.separator")+this.filePath+System.getProperty("file.separator")+fileName;
       File uFile = new File(tempDestPath);
       System.out.println("filepath:"+tempDestPath);
       System.out.println("File exist:"+uFile.exists()+"..readable:"+uFile.isFile());
       try{
           uFile=new File(tempDestPath);
       }
       catch(Exception ex){
           System.out.println("exception getting file:"+ex.getMessage());
       }
       int fSize = (int) uFile.length();
       if (fSize > 0) {

       BufferedInputStream in = new BufferedInputStream(
       new FileInputStream(uFile));
       String mimetype = servletContext.getMimeType(file);

       response.setBufferSize(fSize);
       response.setContentType(mimetype);
       response.setHeader("Content-Disposition", "attachment; filename=\""
       + fileName + "\"");
       response.setContentLength(fSize);
       //added later
       /**response.setHeader("Cache-Control", "no-cache");
       response.setHeader("Pragma", "no-cache");
       response.setDateHeader("Expires", 0);
       */
       //finish added later
       FileCopyUtils.copy(in, response.getOutputStream());
       in.close();
       response.getOutputStream().flush();
       response.getOutputStream().close();
       } else {
       response.setContentType("text/html");
       PrintWriter printwriter = response.getWriter();
       printwriter.println("<html>");
       printwriter.println("<br><br><br><h2>Could not get file name:<br>" + file + "</h2>");
       printwriter.println("<br><br><br><center><h3><a href='javascript: history.go(-1)'>Back</a></h3></center>");
       printwriter.println("<br><br><br>© webAccess");
       printwriter.println("</html>");
       printwriter.flush();
       printwriter.close();
       }

       return null;
       }

   public String getFilePath() {
       return filePath;
   }

   public void setFilePath(String filePath) {
       this.filePath = filePath;
   }

}

Safe exception handling is customizable as you wish.

Thanks a lot for the posts at: http://forum.springsource.org/showthread.php?t=14128

Thank you.

Multiple File Uploads in Spring MVC applications

2010-01-11T22:43:00.000-08:00

It has been really a hassle implementing the multiple file upload feature in spring application.
Either you need to allow a single file upload or some specified number rather than the number of file uploads as desired by the user.
Here is a fully implemented and tested approach that allows the user to upload the number of files desired.

First we need to have a fileupload.jsp page with the contents as follows:
<html>
    <head>
        <title>Upload a file please</title>
        <script SRC="../js/prototype.js"></script>
        <script type="text/javascript">
         var items=1;
         function AddItem() {
          var div=document.getElementById("items");
          var button=document.getElementById("add");
          items++;
          newitem="<br><br>File:"+ items;
          newitem+="<input type=\"file\" name=\"file";// + items;
          newitem+="\" size=\"30\">";
          newnode=document.createElement("span");
          newnode.innerHTML=newitem;
          div.insertBefore(newnode,button);
         }
        </script>
    </head>
    <body>
        <h1>Please upload a file</h1>
        <form method="post" enctype="multipart/form-data">
            <div ID="items">
            File:1
            <input id="uploadFile" type="file" name="file1" size="30"/>
            <input type="button" value="More" name="more" onclick="AddItem();"/>
            </div>
            <input type="submit" value="Done!"/>
        </form>
    </body>
</html>

this is javascript to add the desired number of file input elements:

Further more....

To allow the user add and delete the required number of <file... elements in the page, the following javascript will work:

    <script type="text/javascript">
             var items=1;
             function AddItem() {
              var div=document.getElementById("items");
              var button=document.getElementById("add");
              items++;
              newitem="<br><br>File:"+ items;
            newitem+="<p><input type=\"file\" name=\"file\"";// + items;
              newitem+="\"id=file"+items;
              newitem+="\" size=\"30\">";
              newitem+="<p><input type=\"button\" id=\"delButton"+items;
              newitem+="\" value=\"Delete\" name=\"button"+items;
              newitem+="\" onclick=deletethisRow("+items+")>";
                       newnode=document.createElement("div");
              newnode.setAttribute("id","child"+items);
              newnode.innerHTML=newitem;
            div.insertBefore(newnode,button);
            }
            function deletethisRow(obj){
                var fileElement=document.getElementById("file"+obj);
                var buttonElement=document.getElementById("delButton"+obj);
                var childDivName="child"+obj;
                if (buttonElement) {
                      var child = document.getElementById(childDivName);
                      var parent = document.getElementById("items");
                      parent.removeChild(child);
                 }


                }


    In addition, this dynamically generates the <file element and the delete button along with it. Click on the delete button if you no more want it. Click more button if you need to have more files upload.

in your dispatcher servlet add the following entries:

<bean id="multipartResolver" class="com.d2hawkeye.util.MultiCommonsMultipartResolver"/>

<bean id="fileUploadController" class="com.....web.controller.FileUploadFormController">
    <property name="commandName" value="fileManager"/>
    <property name="formView" value="fileuploadform"/>
    <property name="successView" value="SuccessPage"/>
    <property name="fileManager" ref="fileManager"/>
    <property name="fileUploadPath" value="uplaodedFiles"/>
</bean>

The successPage is simply a jsp page(successPage.jsp) with success msg.
The fileuploadform is the jsp page with name fileuploadform.jsp which is listed above.

The fileManager is reference to the Service class that manipulates the uploaded file.

The fileupload controller is listed below:

import java.io.File;
import java.io.IOException;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.util.Map;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.util.StringUtils;
import org.springframework.validation.BindException;
import org.springframework.web.bind.ServletRequestDataBinder;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.multipart.support.ByteArrayMultipartFileEditor;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.SimpleFormController;

import com....api.service.FileManager;

/**
*
* @author Ramesh Raj Baral
* @since:Jan 11, 2010
* @Version:1.0
*/
public class FileUploadFormController extends SimpleFormController {

    /** Logger for this class and subclasses */
    protected final Log logger = LogFactory.getLog(getClass());
    private FileManager fileManager;
    private String fileUploadPath;//path on server where file is to be uploaded

    protected Object formBackingObject(HttpServletRequest request) throws ServletException {
        return productionManager;
    }

    public FileManager getFileManager() {
        return fileManager;
    }

    public void setFileManager(FileManager fileManager) {
        this.fileManager = fileManager;
    }

    public String getFileUploadPath() {
        return fileUploadPath;
    }

    public void setFileUploadPath(String filePath) {
        this.fileUploadPath = filePath;
    }
    protected ModelAndView onSubmit(
            HttpServletRequest request,
            HttpServletResponse response,
            Object command,
            BindException errors) throws ServletException, IOException,Exception {
            System.out.println("adding uploaded files"+command.getClass());
            logger.info("Adding the uploaded files");
            MultipartHttpServletRequest multiRequest = (MultipartHttpServletRequest) request;
            final Map files = multiRequest.getFileMap();
            logger.info("no of files:"+files.size());
            System.out.println(fileUploadPath);
            if (files == null) {
                  logger.info("no file was sent");
            }
            else{
                String tempDestPath;
                Iterator fileIterator=files.values().iterator();
                MultipartFile file;
                while(fileIterator.hasNext()) {
                    tempDestPath=new File(new File(".").getCanonicalPath()).toString()+System.getProperty("file.separator")+this.fileUploadPath+System.getProperty("file.separator");
                    System.out.println("uploading to:"+tempDestPath);
                    file =(MultipartFile)fileIterator.next();
                    tempDestPath+=file.getOriginalFilename();
                    logger.info("file name:"+file.getOriginalFilename());

                    if(StringUtils.hasLength(file.getOriginalFilename()) && file.getSize()>0){
                        filesList.add(file);
                    }
                    file.transferTo(new File(tempDestPath));
                    //make an entry if the transfer succeeds
                }




            }
            return super.onSubmit(request, response, command, errors);
//simply display the success page
        }


}

This is simply the controller that is responsible for handling the uploaded files.

The class MultiCommonsMultipartResolver is listed below:

import java.io.UnsupportedEncodingException;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
/**
* inspired from
* http://dhruba.name/2008/12/27/implementing-single-and-multiple-file-multipart-uploads-using-spring-25/
* modified by:
* @author Ramesh Raj Baral
* @since Jan 11 2010
*/
import javax.servlet.ServletContext;

import org.apache.commons.fileupload.FileItem;
import org.springframework.util.StringUtils;
import org.springframework.web.multipart.MultipartException;
import org.springframework.web.multipart.commons.CommonsMultipartFile;
import org.springframework.web.multipart.commons.CommonsMultipartResolver;
public class MultiCommonsMultipartResolver extends CommonsMultipartResolver {

    public MultiCommonsMultipartResolver() {
        }

        public MultiCommonsMultipartResolver(ServletContext servletContext) {
            super(servletContext);
        }

        @Override
        @SuppressWarnings("unchecked")
        protected MultipartParsingResult parseFileItems(List fileItems, String encoding) {
            Map multipartFiles = new HashMap();
            Map multipartParameters = new HashMap();

            // Extract multipart files and multipart parameters.
            for (Iterator it = fileItems.iterator(); it.hasNext();) {
                FileItem fileItem = (FileItem) it.next();
                if (fileItem.isFormField()) {
                    String value = null;
                    if (encoding != null) {
                        try {
                            value = fileItem.getString(encoding);
                        } catch (UnsupportedEncodingException ex) {
                            if (logger.isWarnEnabled()) {
                                logger.warn("Could not decode multipart item '" + fileItem.getFieldName()
                                        + "' with encoding '" + encoding + "': using platform default");
                            }
                            value = fileItem.getString();
                        }
                    } else {
                        value = fileItem.getString();
                    }
                    String[] curParam = (String[]) multipartParameters.get(fileItem.getFieldName());
                    if (curParam == null) {
                        // simple form field
                        multipartParameters.put(fileItem.getFieldName(), new String[] { value });
                    } else {
                        // array of simple form fields
                        String[] newParam = StringUtils.addStringToArray(curParam, value);
                        multipartParameters.put(fileItem.getFieldName(), newParam);
                    }
                } else {
                    // multipart file field
                    CommonsMultipartFile file = new CommonsMultipartFile(fileItem);
                    logger.info("filename:"+file.getOriginalFilename());
                    /**
                     * if the filename is blank-donot add it to the map
                     * @author Ramesh Raj Baral
                     * @since Jan 11 2010,5:24 pm
                     *
                     */
                    if(StringUtils.hasLength(file.getOriginalFilename())){
                    if (multipartFiles.put(fileItem.getName(), file) != null) {
                        throw new MultipartException("Multiple files for field name [" + file.getName()
                                + "] found - not supported by MultipartResolver");
                    }
                    }
                    else{
                        logger.info("empty or invalid filename submitted:"+file.getOriginalFilename());
                    }
                    if (logger.isDebugEnabled()) {
                        logger.debug("Found multipart file [" + file.getName() + "] of size " + file.getSize()
                                + " bytes with original filename [" + file.getOriginalFilename() + "], stored "
                                + file.getStorageDescription());
                    }
                }
            }
            return new MultipartParsingResult(multipartFiles, multipartParameters);
        }

    }

The purpose of this class is to override the functionality of conventional MultipartResolver from commons-fileupload so that you can do multiple uploads.If however the client insists on using the same form input name such as ‘files[]‘ or ‘files’ and then populating that name with multiple files then a small hack is necessary as follows. As noted above Spring 2.5 throws an exception if it detects the same form input name of type file more than once. CommonsFileUploadSupport – the class which throws that exception is not final and the method which throws that exception is protected so using the wonders of inheritance and subclassing one can simply fix/modify the logic a little bit as follows. The change I’ve made is literally one word representing one method invocation which enables us to have multiple files incoming under the same form input name.

Further queries can be resolved from a helpful link here:
http://dhruba.name/2008/12/27/implementing-single-and-multiple-file-multipart-uploads-using-spring-25/

Thank you,
Ramesh.

GM foods!

2009-11-04T21:59:00.000-08:00

Genetically Modified Foods:

1)Genetically modified (GM) foods are foods derived from genetically modified organisms. Genetically modified organisms have had specific changes introduced into their DNA by genetic engineering, unlike similar food organisms which have been modified from their wild ancestors through selective breeding (plant breeding and animal breeding) or mutation breeding.

2)GM foods were first put on the market in the early 1990s. Typically, genetically modified foods are transgenic plant products: soybean, corn, canola, and cotton seed oil, but animal products have been developed. For example, in 2006 a pig engineered to produce omega-3 fatty acids through the expression of a roundworm gene was controversially produced. Researchers have also developed a genetically-modified breed of pigs that are able to absorb plant phosphorus more efficiently, and as a consequence the phosphorus content of their manure is reduced by as much as 60%.

3)Critics have objected to GM foods on several grounds, including perceived safety issues, ecological concerns, and economic concerns raised by the fact that these organisms are subject to intellectual property law.

4)Genetic engineering begins with the identification and isolation of a gene which expresses a desirable trait, with the aid of restriction enzymes. Then a recipient plant or animal is selected, and the gene is inserted and incorporated into its genome through a vector such as agrobacterium, through a gene gun shooting an elemental particle covered in plasmid DNA, electroporation, or a virus

5)Crop yields

Several studies supported by organic growers have claimed that genetically modified varieties of plants do not produce higher crop yields than normal plants. However, independent scientific studies have not been able to substantiate such claims.

One study by Charles Benbrook, Chief Scientist of the Organic Center, found that genetically engineered Roundup Ready soybeans do not increase yields (Bendrook, 1999). The report reviewed over 8,200 university trials in 1998 and found that Roundup Ready soybeans yielded 7-10% less than similar natural varieties. In addition, the same study found that farmers used 5-10 times more herbicide (Roundup) on Roundup Ready soybeans than on conventional ones.

Merits/Demerits

Advantages:
1. Modified to make them more resistant to unfavourable conditions
2. Produce higher yields
3. Use less fertilizers
4. Use lesser water
5. Pest resistance
6. Herbicide tolerance
7. Increasing food supplies in co-relation with an increasing world population.
8. can ge yield in irrespective of the season

Disadvantages:
1. Harmful to environment
2. Harmful to humans
3. Give rise to 'super weeds'
4. 'Super weeds' dominate the fields and affect main crops
5. Genes from the genetically modified food could be transferred to the pests which can make them become resistant to the pesticides and the pesticides become useless.
6.The new genes that are put in food could be resistant to certain antibiotics; if we eat them the effectiveness of antibiotics could be reduced. New allergens could be accidentally created and known allergens could be transferred to other foods. For example, if a gene from peanuts was taken and put in a tomato, people allergic to peanuts could be allergic to that tomato.
7.Genetic pollution

Genetically modified DNA from any part of a GM plant can enter the
environment unobserved, for example, through pollen transfer to a
conventional crop, through seed dispersal or plant decomposition and
persistence in soil ecology. The toxins encoded in the DNA also kill
wildlife and contaminate soil and water, as do herbicides such as
glyphosate and glufosinate ammonium that are an essential component of
the herbicide tolerant crop system.

GM contamination lasts at least 15 years in soil

शुभ दिपआवली २०६६......

2009-10-15T21:26:00.001-07:00

शुभ दिपआवली २०६६ को शुखद उपलक्षमा सबै पाठक बर्गमा हार्दिक मंगल्मये शुभकामना व्यक्त गर्दछु ।।।।।।रमेशराज बराल