Every now and then when I review code, I see developers write code that does not conform to the basis OO design principles and this eventually make it difficult to understand, maintain, extend blah blah..... Basically its just keeps on adding a layer of un-necessary complexity that you have to deal with. So what do you do? I guess you end-up refactoring the code( Did I said, I love refactoring?

The path to the temp directory in Java can be retreived via the sytem property as mentioned below:

System.getProperty("java.io.tmpdir");

Here is a simple snippet to find out the calling Java Class.

Class.forName(new Throwable().getStackTrace()[2].getClassName()));

Yes, you can view triggers using the INFORMATION_SCHEMA.TRIGGERS table. The following sql list all the triggers in a given schema.

select

SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER)

from dba_sequences

where SEQUENCE_OWNER='schema owner'

order by length(LAST_NUMBER) desc

The following sql list the name of all the routines in a given database.

SELECT ROUTINE_NAME

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE="PROCEDURE" AND ROUTINE_SCHEMA="dbname";

The table types have changed from ISAM to MYISAM from Mysql version 4.x to 5.x.

In order to convert a table from ISAM to MyISAM, simply issue a statement like

ALTER TABLE tblname ENGINE=MYISAM.

Data can be dumped into the database using the following command. mysql -p -h DBSERVER dbname < dbname.sql

Converting images from gif to jpg for web or other reason can be done easily using the ImageIO package. The following snippet convert all the gif images in directory rootDir to jpg images.Compile this class and execute using java command line. This utility class is also available as part of the Livrona Tools Project.The following is the code for the Image Converter.

By default rails does not clear out stale sessions from the session store. Depending on the configuration session can be stored in the local file system or the database.