- Weblogic Erroneous Handlers Error - this is caused by the jrockit version of jdk. To get the correct error message, use the Java jdk first. Source: http://ricksolutions.blogspot.hk/2009/03/fixing-erroneous-handlers-error.html
- checking tables on db2 select * from sysibm.systables where dbname='NACS01DB' and name like 'PC%'
- command for unzipping war files jar xvf xxx.war
- Extracting the Contents a JAR File
The basic command to use for extracting the contents of a JAR file is:
jar xf jar-file [archived-file(s)]
- The x option indicates that you want to extract files from the JAR archive.
- The f options indicates that the JAR file from which files are to be extracted is specified on the command line, rather than through stdin.
- The jar-file argument is the filename (or path and filename) of the JAR file from which to extract files.
- archived-file(s) is an optional argument consisting of a space-delimited list of the files to be extracted from the archive. If this argument is not present, the Jar tool will extract all the files in the archive.
- character encoding - http://www.joelonsoftware.com/articles/Unicode.html
- DB2 Timestamp to java.util.Date or java.sql.Timestamp
- DB2 format = yyyy-MM-dd HH:mm:ss.ZZZZZZ where Z = seconds since previos midnight (00000 - 86400), http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.sql.ref.doc%2Fdoc%2Fr0007107.html
- java.sql.Timestamp = yyyy-mm-dd hh:mm:ss.fffffffff where f = nanoseconds
To convert to java.util.Date, use
new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(dateStr)
To convert to java.sql.Timestamp, use
resultSet.getTimestamp([column name or column index])
http://technobuz.com/2011/04/run-commands-for-microsoft-applications/