Skip to main content

One to One Mapping in Grails GORM


********************Main class where we need column of other class***********************************
class ObjectMapping {

//int sourceMapId
String oldSourceCd
String oldPrintedSourceCd
int minUpo =1 //DEFAULT 1,
String newPrintedSourceCd
Date mapStartDate
Date mapEndDate
String clientId 
Date createdDate // DEFAULT SYSDATE,
String createdBy
Date modifiedDate
String modifiedBy

//added after requirement
BigDecimal oldCampaignId
BigDecimal newCampaignId
String newSourceCd

Client client
//static belongsTo= [Client]
//static mappedBy = [client: "client_id"]

static mapping = {

table "cf_source_cd_mapping"
id column: "source_map_id", generator:'sequence', params:[sequence:'SOURCE_MAP_ID_SEQ']
sort id: "desc"
version false
oldPrintedSourceCd column: 'old_printed_source_cd'
newPrintedSourceCd column: 'new_printed_source_cd'
oldSourceCd column: 'old_source_cd'
minUpo column: 'min_upo'
client column:["CLIENT_ID"]

}


static constraints = {

oldSourceCd (nullable: false, blank: false)
oldPrintedSourceCd (nullable: false, blank: false)
newPrintedSourceCd (nullable: false, blank: false)
minUpo(min:1,nullable: false, blank: false)
mapStartDate (nullable: false, blank: false)
mapEndDate (nullable: false, blank: false)
createdBy (nullable: false, blank: false)
modifiedBy (nullable :true, blank: true)
modifiedDate (nullable :true, blank: true)

}}

****child class where we have details which i need to fetch d based on a column present in main class and here column is id****************************************************


package com.org

import javax.persistence.FetchType;
import javax.persistence.OneToOne;
import javax.persistence.PrimaryKeyJoinColumn;

class Client {


//static hasMany =[objectMappings:ObjectMapping]
//static mappedBy = [objectMapping: "client_id"]

String clientName

static mapping = {

table "cf_client"
id column: "client_id", type:"long"
clientName coloumn: 'client_name'
version false

}



static constraints = {
}
}
********************************************************access in gsp like this***********************************************************************************

<g:each in="${objectMappingInstanceList}" status="i" var="objectMappingInstance">
<tr class="${(i % 2) == 0 ? 'even' : 'odd'}">

<td>
         <g:each in="${objectMappingInstance.client}" var="client"> 
                 ${client.clientName}
           </g:each>
</td> 

<td>${objectMappingInstance.oldCampaignId}</td>


Comments

Popular posts from this blog

Conversion from Clob To String in java and Vice versa

/***reading Clob data from oracle table and setting to Pojo**/
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

import oracle.sql.CLOB;

import com.poc.one.pojo.StagedMessage;

public class MessageDao {
private static String url = "jdbc:oracle:thin:@172.22.22.198:1521:ORACLE";
private static String username = "ABC123";
private static String password = "ABC123";


public  List readClobToBO() throws Exception {

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection(url, username, password);
PreparedStatement stmt = conn
.prepareStatement("SELECT ID, STORE_ID, MESSAGE_DATA FROM STAGED_MESSAGE ");
ResultSet resultSet = stmt.executeQuery();
List msgList= new ArrayList();

while (resultSet.next()) {

StagedMessage message = new StagedMessage();

message.setId(resultSet.getInt(1));
message.setStoreId(r…

Portable Java 8/ JDK8 setup without admin rights

Some time we got machine to work where we don't have access rights to install anything or if you do not want to install. You can get latest jdk running by this trick. Just follow step step & do comment if you like it.

Step by Step details to get running java from .exe setup without any admin rights. Get portable 7 zip from portableapps.comdownload java 8 from oracle  http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.htmlopen 7 zip & extract jdk-8u102-windows-x64.exeyou will see below folders                .data                .pdata                .rdata                .reloc                .rsrc                .text                CERTIFICATE

          5.Go inside E:\jdk-8u102-windows-x64\.rsrc\1033\JAVA_CAB10you will find 111 file.

         6.extract it it some folder where you can find tools.zip again extract that to some folder say Java & copy it to very first folder of setup along with .data,.rsrc etc.
         7.Go to folder where you have co…

GOF Design pattern with Java & Real World Examples

What are design patterns? 

So basically these are just collection of best practices to solve recurring problem by different kind of class arrangement. These arrangement could be based on creation of object or structural basis or on basis of required behavior.




Creational Design Pattern
Prototype Designpattern we will like to use this designpattern whenever creation of initial object & setting required default values is costly. So we just create 1 object & later on whenever more objects required we can provide initial object by just cloning of given object.Java Example is java.lang.Object#clone()
Builder DesignPattern When we jave object structure are complex and complicated we would go for this. we will be separating object creation from internal representation. With help of some simple interface we would create complicated Object.
Singleton When we need one instance per JVM. Example : Java Run time environment Java.lang.System.  java.lang.StringBuilder, Spring Beans are singleton …