ExtJs : Grid scrolling issue while saving or refreshing the grid

 I was able to fix this issue by simply adding the below code near refresh and save methods.

Do this before you 'refresh or save' a record:

var scrollPos = grid.getEl().down('.x-grid-view').getScroll();


//And then after the record is saved or refreshed add this line

grid.getEl().down('.x-grid-view').scrollTo('top', scrollPos.top, false);

(Solved) Reset Chrome download manager to default

Free download click catcher plugin. How to disable it in Chrome

I Installed Free download Manager sometime back and uninstalled it, but Google Chrome is still taking that extension and directing it to Free Download Manager. How to disable it.

1. Open Chrome
2. In Address Bar type chrome://plugins/
3. Disable Free Download Manager Click Catcher Plug-In for Netscape, Opera, Mozilla

Done.

How to change a Color Picture to Black and white picture using Photoshop

Open Photoshop
Open the picture from Photoshop
Goto menu Image --> Mode --> Grayscale

If you have multiple layers it will ask you to Flatten. Select flatten to merge all layers or else select Don't flatten

Done.
Save the Image and close Photoshop.

Java Spring Hibernate : How to make MySql group_concat, concat_ws work in Hibernate

I have an application where I am using spring Hibernate and my applicationContext.xml files looks like below. I want to use group_concat and concat_ws in Hibernate queries.

 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource" ref="dataSource" />
  <property name="configLocation">
   <value>classpath:hibernate.cfg.xml</value>
  </property>
  <property name="configurationClass">
   <value>org.hibernate.cfg.AnnotationConfiguration</value>
  </property>

  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">${jdbc.dialect}</prop>
    <prop key="hibernate.show_sql">true</prop>
   </props>
  </property>

 </bean>

Solution

Add a new java file somewhere in your solution. For example I am adding in the below package
com.myApp.util
Class Name : CustomDialect

package com.myApp.util;
import org.hibernate.dialect.MySQLDialect;
import org.hibernate.dialect.function.StandardSQLFunction;
import org.hibernate.type.StringType;

public CustomDialect(){
   registerFunction("group_concat", new StandardSQLFunction("group_concat", StringType.INSTANCE));
    registerFunction("concat_ws", new StandardSQLFunction("concat_ws", StringType.INSTANCE));
}

}

Update applicationConctext.xml like below

....
<props>

<prop key="hibernate.dialect">com.myApp.util.CustomDialect</prop>
<prop key="hibernate.show_sql">true</prop>
</props>

....

Lenovo Service Centers Hyderabad

Lenovo Tablets Service Center Hyderabad

6-3-679/1/201

Classic Emarald Apts

Punjagutta 

Hyderabad

Phone : 8832443314

7-1-58

Flat No 36

Divya Shakthi Apts

Opp. Lal Bungalow

Ameerpert 

Hyderabad

Phone : 8886675564