Category Archives: Tool and Debug

Excel Copy Column Value Based On Another Column Value Lookup

Problem: One Excel sheet named “Account Info” contains accountnumber and account name. The other sheet named “Order Info” contains order mapping between orderid and accountnumber. Now we need to add another column to the second sheet to show the matching … Continue reading

Posted in Excel | Tagged , , | Leave a comment

Excel Concatenate String With Cell Value

You can use the “&” operator for this purpose, see the attached screenshot.

Posted in Database, Excel, Tool and Debug | Tagged , | Leave a comment

Windows Open Command Window from File Explorer

Imagining that you want to open the Windows console when you are browsing to a deep directory hierarchy M:\liuzy163\projects\PictureManager\src\java\ca\zl\picturemanager\flow\action, and you need to perform some command line actions in this folder. You can do so easily by shift+right click the … Continue reading

Posted in Tool and Debug | Tagged , , | Leave a comment

Tomcat Server Slow Due To Blocked SeedGenerator Thread on Insufficient Random Number On Linux

Problem: An application deployed on Tomcat server (via Coldfusion11) suffers slowness problem. Sometimes opening up a https page could take 20 seconds or so. The problem was not experienced on CF9 (which doesn’t use Tomcat). And the same application runs … Continue reading

Posted in Coldfusion, Java, Linux, Tool and Debug | Tagged , , , , , , , | 2 Comments

Java Read Excel Files Using Apache POI

Apache POI is a Java library for processing Microsoft Office files. Here below are a few limited examples of its operation on Excel files(both in xls and xlsx format). Maven POM Add the following dependency into your project pom.xml file … Continue reading

Posted in Excel, Java | Tagged , , | Leave a comment

Query the In-memory HSQLDB When Integrated With Hibernate

HSQLDB in-memory database is often used with Hibernate for testing, prototyping and even in production environment. With Hibernate, you can perform powerful database operations either using the ORM based APIs, HSQL or native SQL. As a developer, sometimes you want … Continue reading

Posted in Database, Java, Programming, Tool and Debug | Tagged , , , | 1 Comment

PageSpeed Insight – Test Your Web Page Loading Speed

PageSPeed Insight is provided by Google to test your web pages loading speed and give you advice on how to make them faster. Simply copy your web page URL and paste to the page to have a try.

Posted in Best Software Practices, Tool and Debug | Tagged , , , | Leave a comment