Tuesday, December 11, 2012

How to enable manager app for Tomcat with Virtual Host

Make a copy of the file
       ${tomcat-home}/webapps/host-manager/manager.xml

and copy to the folder (the same name with your virtual host folder under webapps)
       ${tomcat-home}/conf/Catalina/<your virtual host folder name>

Access via browser with the link http://<your virtual host name>/manager/html



Wednesday, June 13, 2012

Table header is not fixed with Jquery fixheadertable plugin

If you load the table result into a div like the following, where you try to fix the height with css with overflow, the header will not be fixed after scrolling

     <div id="divA21InvResult" style="height:300px;overflow:auto"></div>  



Instead you should add the option "height" when you call the fixheadertable function and pair with a simple div without any height declaration in css

       <div id="divA21InvResult"></div>  

        $('#tblA21InvPrint').fixheadertable({
                    caption     : '',
                    height      : '300',                   
                    colratio    : [30, 50, 100, 100, 50, 515, 80, 400, 400],                  
                    sortable    : true,
                    sortedColId : 1,
                    dateFormat  : 'd-M-Y',
                    resizeCol   : true, 
                    sortType    : ['string1','integer', 'date', 'string', 'string', 'string', 'float', 'string', 'string'],
                    textAlign   : ['center','right','center','center','center','left','right','left','left']
                });


Tuesday, June 12, 2012

Error Placement Issue with Jquery Validation Plugin










I encountered the above problem with jquery validation plugin where the error message spans into multiple lines, eventhough there is more than enough span after the input element.

To solve this problem, you may add in the following css

label.error{
    color:red;   
    width:auto; /*Add this line*/
}


Saturday, January 28, 2012

How to embed fonts into PDF generated by JasperReport (iReport)

Setup:
» Tomcat 7.0 + JSP
» iReport 4.1.1

Reference:
http://javaskeleton.blogspot.com/2010/12/embedding-fonts-into-pdf-generated-by.html

Steps:
1. Launch iReport, choose Tools->Options->Fonts

2. Click "Install Font" and follow the wizard to install your desired font.



*Remember to tick the option "Embed this font in the PDF document"








3. Select the newly installed font and click the button "Export as extension"




4. Save the export file as JAR file

5. Copy the JAR file to the folder within your application classpath
*I choose to put all the JAR files into $(JRE_HOME}/lib/ext

Friday, January 13, 2012

How to display/Store Chinese Character Thru Browser

The following is extracted from http://java.sun.com/developer/technicalArticles/Intl/HTTPCharset/#browser

Server: Tomcat
1. Setting the context parameter is done in the WEB-INF/web.xml file.

<context-param>
<param-name>PARAMETER_ENCODING</param-name>
<param-value>UTF-8</param-value>
</context-param>

2. Add the following code to your JSP file.
<%
    //Must put in the first section of the jsp page
    String paramEncoding = application.getInitParameter("PARAMETER_ENCODING");
    request.setCharacterEncoding(paramEncoding); 

%>
*Please note that the following lines must be inserted at the begining of the JSP page after header declaration (eg. tagLib or Page), before any other content processing.

Friday, January 6, 2012

Run JasperReport (ireport) in JSP

(1) Import the following libraries to your project
===================================================
jasperreports-3.7.2.jar
iText-2.1.7.jar
jdt-compiler-3.1.1.jar
groovy-all-1.5.5.jar
commons-logging-api-1.1.jar
commons-logging-adapters-1.1.jar
commons-logging-1.1.jar
commons-digester-1.8.jar
commons-collections-testframework-3.2.jar
commons-collections-3.2.jar
commons-beanutils-core.jar
commons-beanutils-bean-collections.jar
commons-beanutils.jar

(2) Sample JSP Code
===================================================
String dirPath = "ireports";
String realPath = this.getServletContext().getRealPath(dirPath);
String orderNo = request.getParameter("orderNo");
String jasperReport = "nameCardFront.jasper";
JasperPrint print = null;
String outputFileName = null;
Connection conn = null;

try{
InitialContext initialContext = new InitialContext();
DataSource ds = (DataSource)initialContext.lookup("java:comp/env/jdbc/DOS");
conn = ds.getConnection();

Map parameters = new HashMap();
parameters.put("orderNo", "a");
print = JasperFillManager.fillReport(realPath + "//" + jasperReport, parameters, conn);

SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd-HHmmss");
outputFileName = "file.pdf";

out.clearBuffer();
//set the content type(can be excel/word/powerpoint etc..)
response.setContentType ("application/pdf");
//set the header and also the Name by which user will be prompted to save
response.setHeader ("Content-Disposition", "attachment; filename=\"" + outputFileName);

JasperExportManager.exportReportToPdfStream(print, response.getOutputStream());

}
catch(Exception ex){
ex.printStackTrace();
out.println(ex.getMessage());
}
finally{
if (conn != null)
conn.close();
}