Eclipse Memory Enhancements

Default Eclipse settings are optimal for machines running on 1 GB/low memory. So if you have a machine with high memory, you can use below settings to optimize performance. Add the following settings in eclipse.ini(residing in your eclipse home directory) file and start/restart the eclipse.

-Xmn128m
-Xms1024m
-Xmx1024m
-Xss2m
-XX:PermSize=128m
-XX:MaxPermSize=128m
-XX:+UseParallelGC

Thanks.

SQL Restriction In Hibernate Criteria Query

Here is an example to add a SQL Restriction in hibernate Criteria query.
Let's consider we have

• A Student.java entity
• A stored procedure in place which returns total marks obtained by a student in each subject.

public Class Student {
    private Integer id;
    private String name;
    .
    .
    //getters & setters methods
}

Assuming get_marks() stored procedure will result records in following format.

id	Maths	Enlish	Science
1	78	75	23
2	74	70	97

I want to list down the Students who has got more than 90 in Maths. Here goes the Hibernate Criteria query.

Criteria c = session.createCriteria(Student.class)
		.addSqlrestriction(" {alias}.id in (SELECT id FROM get_marks() WHERE maths_total > ? ) ", new Double(90.0), Hibernate.Double);

In above statement {alias}.id will refer to the id column of Student table. The above addSqlrestriction example shows the SQL restriction statement with only one parameter.
What if you have to pass multiple arguments?
In such cases you need to pass array of Objects & array of Type as second & third parameter to the addSqlrestriction(String, Object[], Type[]). And in SQL String have ? where ever argument is required, as shown in above example.

I hope this helps.
Thanks.

GTalk - Show Current Music Track - Bug: Workaround Fix

Hi All,

I have Windows XP, Google Talk 1.0.0.104 and Winamp 5.6.

GTalk is crashing whenever I'm setting my status message to "Show Current Music Track" (Winamp Playing). Here is a simple fix for this issue.

1. Open notepad
2. Click on File --> Save
3. Save file it under Winamp installation directory [ "C:\Program Files\Winamp" - in my case] with file name as "winamp.m3u".

Restart Winamp & GTalk.

This is it !!! :)