Skip to main content

Posts

Showing posts from March, 2013

So confusing Oracle left join

Starting with Oracle9i, the confusing outer join syntax using the ‘(+)’ notation has been superseded by ISO 99 outer join syntax.  As we know, there are three types of outer joins, left, right, and full outer join.  The purpose of an outer join is to include non-matching rows, and the outer join returns these missing columns as NULL values.  Let’s review the syntax differences between these variations in join syntax: Left outer join:  Oracle8i select    last_name,    department_name
from    employees e,    departments d
where    e.department_id = d.department_id(+); Left outer join:  Oracle9i select    last_name,    department_name
from    employees e left outer join    departments d on    e.department_id = d.department_id;

iBatis and Log4j

log4j.rootLogger=DEBUG, A2  # SqlMap logging configuration...  log4j.logger.com.ibatis=DEBUG  log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG  log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG  log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG  log4j.logger.java.sql.Connection=DEBUG  log4j.logger.java.sql.Statement=DEBUG  log4j.logger.java.sql.PreparedStatement=DEBUG  log4j.logger.java.sql.ResultSet=DEBUG  # Console output...  log4j.appender.stdout=org.apache.log4j.ConsoleAppender  log4j.appender.stdout.layout=org.apache.log4j.PatternLayout  log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n  log4j.appender.A2=org.apache.log4j.FileAppender  log4j.appender.A2.File=C:/dcsi/twacs.log  # Truncate 'twacs'if it aleady exists.  log4j.appender.A2.Append=true# Appender A2 uses the

javascript code segments

In the gap of two sprints, I have sometime  to review the basic knowledge. Here we go.

#1 Image
<img name="news" src="xxx">
js: document.images.news.src = xxxx;
you can also do this way,
newsOff = new Image();
newsOff.src = "xxx";




#2 Eval()
The  eval() method handles nicely if you want to dynamically create JavaScript code.
e.g. eval(“document.images.news.src = xxxx;”


Examples of using Quartz

Here are some full examples: ExpressionMeaning0 0 12 * * ?Fire at 12pm (noon) every day0 15 10 ? * *Fire at 10:15am every day0 15 10 * * ?Fire at 10:15am every day0 15 10 * * ? *Fire at 10:15am every day0 15 10 * * ? 2005Fire at 10:15am every day during the year 20050 * 14 * * ?Fire every minute starting at 2pm and ending at 2:59pm, every day0 0/5 14 * * ?Fire every 5 minutes starting at 2pm and ending at 2:55pm, every day0 0/5 14,18 * * ?Fire every 5 minutes starting at 2pm and ending at 2:55pm, AND fire every 5 minutes starting at 6pm and ending at 6:55pm, every day0 0-5 14 * * ?Fire every minute starting at 2pm and ending at 2:05pm, every day0 10,44 14 ? 3 WEDFire at 2:10pm and at 2:44pm every Wednesday in the month of March.0