Wednesday, March 3, 2010

rowNum()

rowNum() function always give the no of records fetched from the table but not the a row number in the table

Example :
select * from table where rowNum() =10;
above query will not return any thing

Tuesday, March 2, 2010

setting STRICT_QUOTE_ESCAPING in catilina.sh file

JAVA_OPTS="$JAVA_OPTS -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Dorg.apache.jasper.compiler.Parser.STRICT_QUOTE_ESCAPING=false"