Thursday, August 9, 2007

Oracle Performance Issue

Using function in the query will get the performance issue (increase the loading time)

lets take a table has got more than 1000 records

example:
SELECT * FROM EMP WHERE UPPER(NAME) = UPPER('ram') takes 15secs

whereas
SELECT * FROM EMP WHERE NAME = 'ram' takes less than a sec

request scope attributes

request scope attributes for include and forward.
While doing include or forward by default following attributes will get populated. Below are them respectively.

javax.servlet.include.request_uri
javax.servlet.include.servlet_path
javax.servlet.include.context_path
javax.servlet.include.path_info
javax.servlet.include.query_string

javax.servlet.forward.request_uri
javax.servlet.forward.servlet_path
javax.servlet.forward.path_info
javax.servlet.forward.query_string

To access the attributes
Servlet / JSP: request.getAttribute("javax.servlet.include.request_uri")

EL: requestScope['javax.servlet.include.request_uri'] or ${requestScope.javax.servlet.include.request_uri}

CHMOD

A combination of:
  • u user (file owner)
  • g group
  • o others
  • a all (same as ugo)

And combination of:
  • r read
  • w write
  • x execute

with the Permissions:
  • = assigned
  • + added
  • - subtracted

one of the following to copy permissions:
  • u user
  • g group
  • o other
or, to set user id:
  • s
example: chmod a+rw temp/

to have read/write access to everyone to the temp folder

Lotus Notes - Javamail gotcha

Any javamail generated message body (text/html) content doesn't allowed to have form fields. If you want to have a form field then you must follow either of two things.
1. use <input type='image' width='0' height='0' src=''/>
2. change your email message to edit mode

Java EE 5 Architect

Sun recently conducted the survey to release the Java Architect certification on Java EE 5 platform. Tentativly scheduled in September 2007. Here is the snapshot of sections covered.

1. Application Design Concepts and Principles
2. Common Architecture
3. Integration and Messaging
4. Business Tier Technologies
5. Web Tier Technologies
6. Applicability of Java EE Technology
7. Patterns
8. Security