http://puretech.paawak.com My musings on software Thu, 25 Nov 2010 20:52:25 +0000 http://backend.userland.com/rss092 en Let us consider the relation between Semester and Subjects. A Semester has a collection of Subjects. Each Subject, in turn, has a reference to the Semester. This is illustrated as below: public class Semester { private Long semesterId; private String semesterName; private Set ... http://puretech.paawak.com/2010/11/26/example-hibernate-one-to-many-bidirectional-relation/ Oracle TimeStamp with TimeZone: A Critical Analysis For storing the TimeZone information in TimeStamp, Oracle (10g) has two options: TIMESTAMP WITH TIME ZONE data type:  As the name indicates, this stores the TimeZone data along with the TimeStamp. The TimeZone can be either stored in the UTC format (eaxmple: +05:30) or the ... http://puretech.paawak.com/2010/11/02/how-to-handle-oracle-timestamp-with-timezone-from-java/ Why need custom data type? I have a java.util.Calendar object which I want to persist in the db, along with the TimeZone. Suppose I am working with a db which does not have support for storing TimeZone. How do I proceed? One of the easiest solutions would be to store the ... http://puretech.paawak.com/2010/10/31/using-custom-data-type-in-hibernate/ I have the following SQL Script: CREATE SEQUENCE MY_SEQ START WITH 1 INCREMENT BY 1; CREATE TABLE SEQ_DEMO ( ID INTEGER PRIMARY KEY NOT NULL, NAME VARCHAR2(20) NOT NULL ) ; The Hibernate entity for this ... http://puretech.paawak.com/2010/10/31/id-generation-in-hibernate-with-sequence/ I will list here the common how to-s for the new Annotation based Spring MVC. Please note that I am using Spring version 3.0.0.RELEASE. This is a bit, only a small bit, different from the version 2.5.x. So, if you are using 2.5.x, you have to tweak things a bit ... http://puretech.paawak.com/2010/09/05/annotation-based-spring-mvc-how-tos/ Eclipse WTP has this nice feature where it allows you to deploy, run and debug Web Applications from the IDE. You start by going to the Server View, adding the target server (like Apache Tomcat in our case) and then adding the Web Project to the server. This is how ... http://puretech.paawak.com/2010/08/28/how-to-convert-a-maven-project-to-eclipse-web-project/ Maven is the build tool of choice for many people due to the simplicity and flexibility of use. The real strength of Maven is vetted when handling real complex projetcs consisting of tens of modules, each requiring elaborate build requirements. I had faced an uphill task of Mavenising one of our ... http://puretech.paawak.com/2010/08/22/creating-an-ear-with-maven/ Kopete is one of the most versatile and cool Instant Messenger for Linux. Its lot better and more secure and feature rich than Pidgin. GTalk is based on the open source XMPP Protocol, Jabber compatible. While entering the new account details, select Jabber: Enter your full email id. Go to the connection tab. ... http://puretech.paawak.com/2010/08/21/how-to-configure-gtalk-on-kopete/ MySQL is installed on Fedora and most Linuxes by default. Its just about some tweaking before you can use it. I am detailing some of the rather useful commands. To Install MySQL and start it mysql_install_db mysqld_safe & Make MySQL case insensitive This is useful when the DB Script is also expected to run on ... http://puretech.paawak.com/2010/08/21/tweaking-mysql-on-fedora/ PPTP is an wonderful utility to enable VPN on a Linux box. Its secure and compatible with Windows network. I first heard about PPTP from (this wonderful guy called) Nikolaj. I have learnt how to set it up from him. I am detailing the steps here: 1> Install PPTP yum install pptp 2> vi ... http://puretech.paawak.com/2010/08/21/how-to-enable-vpn-on-linux-by-pptp/