Starting with Spring DAO layer – Stored procedures/functions

Configuring Spring JDBC DAO- Create a Java/or Dynamic Web project in eclipse. Copy all the spring jar files from /dist/modules into your project’s lib folder and add these jar files to java build path. Copy all the jar files (except commons-attributes-compiler.jar) from /lib/jakarta-commons into your project’s lib folder and add these jar files to java [...]

Starting with GWT (Google Web ToolKit)

Eclipse provides a standard plugin for GWT. 1). Download the GWT plugin following the instructions on http://code.google.com/eclipse/docs/install-eclipse-3.4.html 2). Create a new Web Application Project. The Project gets configured ready for GWT development and it comes with a sample GreetingService service. 3). Clean build the Project and right click on the project and select Run As [...]

SQL Server Tips

1). Get a list of values as a comma-seperated list SELECT DISTINCT STUFF( ( SELECT ‘,’ + RTRIM(fieldName) FROM table1 where id = ‘id’ FOR XML PATH(”)),1 ,1, ”) FROM table1 where id = ‘id’ 2). Get just the time from datetime field .e.g. 12:11 AM select (CASE SUBSTRING(CONVERT(varchar(24), getDate(), 121), 12, 12) when ’00:00:00.000′ [...]

Starting With Hibernate

Tools : Eclipse, SQL Server 1). Create a Dynamic Web project in Eclipse. 2). Copy the following jar files into project’s lib folder and project’s class path. antlr-2.7.6.jar asm.jar asm-attrs.jar cglib-2.1.3.jar commons-collections-2.1.1.jar commons-logging-1.1.jar dom4j-1.6.1.jar hibernate3.jar javassist.jar jta-1.1.jar sqljdbc.jar (FOR MS SQL Server) 3). Create the Hibernate configuration file hibernate.cfg.xml as follows – 4). For example [...]