Vinay Srini

Over time, I have tried many combinations to keep jdbc connections from tomcat's connection pool fresh. I frequently got stale connections until after many tweaks, I found the winning combination.

    <Resource name="jdbc/myresource" scope="Shareable"
        type="javax.sql.DataSource"
        url="jdbc:mysql://localhost:3306/db"
        driverClassName="com.mysql.jdbc.Driver"
        username="myuser"
        password="xxxxx"
        maxIdle="3"
        maxActive="10"
        removeAbandoned="true"
        removeAbandonedTimeout="60"
        testOnBorrow="true"
        validationQuery="select count(*) from sometablename"
        logAbandoned="true"
      />

Type "Bug 1234" in bugzilla comment text and when viewing bug details, it is automagically linked to the bug. If the bug is closed, there is a strike through!

It is not limited to just "Bug #". The feature extends to attachments, comments, urls etc. More details in the link to bugzilla documentation.

http://www.bugzilla.org/docs/tip/html/hintsandtips.html

A very handy feature some bugzilla users may not know about!

There are some folders on your mail which keep accumulating junk, and the only messages that matter are the latest ones.
You can set "Message Retention Policy" in thunderbird for each folder.

http://kb.mozillazine.org/Message_aging

Steps:
1. Right click on the desired folder - click on "Properties"
2. Click on "Retention Policy" tab
3. Set your desired preferences

Sample screenshot: