Exception setting property value with CGLIB

[Pranav Pal]

I have an User table in my MySQL database. I changed one column of that table from STATUS(varchar) to ISACTIVE(boolean).

Now when I call any getter method of the User bean, which corresponds to the User table, I get following exception:

exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.bean.Expert.setIsActive

What can be the reason for this?

I have appropriately chaned the user.hbm.xml file and User.java bean class

Thanks in advance

[Mark Spritzler]

Please post your mapping and bean code, using the CODE button below, so that the code keeps its indentations.

I am sure it is probably one simple change.

so if your field is called isactive, and if you called your attribute isActive, then wouldn't that then make your method isIsActive?

Mark

[Pranav Pal]

I have changed attribute name to "active" and getter/setter methods are now isActive() and setActive()

Still I am geting exception:
org.hibernate.PropertyAccessException:exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.bean.User.setActive

Code for user.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
 
    <class name="com.bean.User" table="User">
<id name="userId" column="USERID" >
   <generator class="assigned"/>
</id>
 
<property name="password">
           <column name="PASSWORD" />
</property>
<property name="email">
   <column name="EMAIL"/>
</property>
<property name="active">
   <column name="ISACTIVE" />
</property>
  
<property name="screenName">
   <column name="SCREENNAME" />
</property>
  
<property name="image">
   <column name="IMAGE" />
</property>
 
<property name="isPaidUser">
   <column name="ISPAIDUSER" />
</property>
   </class>
    
</hibernate-mapping>

Code for User.java (Bean)

package com.bean;
 
import java.util.*;
 
import org.hibernate.*;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;
 

 
public class User {


private String userId;
private String password;
private String email;
private boolean active;
private String image;
private String screenName;
private Boolean isPaidUser;


public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
 

public boolean isActive() {
return active;
}
public void setActive(boolean active) {
this.active = active;
}
public String getImage() {
return image;
}
public void setImage(String image) {
this.image = image;
}
public String getScreenName() {
return screenName;
}
public void setScreenName(String screenName) {
this.screenName = screenName;
}
public Boolean getIsPaidUser() {
return isPaidUser;
}
public void setIsPaidUser(Boolean isPaidUser) {
this.isPaidUser = isPaidUser;
}

}
 

[Jaikiran Pai]

Originally posted by Pranav Pal:
I changed one column of that table from STATUS(varchar) to ISACTIVE(boolean).

I don't know, how you have changed the column definition. But have you also ensured that when you changed the column from varchar to boolean, you even cleared off this column contents (might be dumb question, if the database already takes care of clearing the contents of the column when you change its schema definition )

[Pranav Pal]

Originally posted by Jaikiran Pai:


I don't know, how you have changed the column definition. But have you also ensured that when you changed the column from varchar to boolean, you even cleared off this column contents (might be dumb question, if the database already takes care of clearing the contents of the column when you change its schema definition )

I didn't need to change the contents as the values for STATUS was NULL in all the tuples.

[Mark Spritzler]

Please also post your hibernate.cfg.xml file

I see you also have another boolean field

public Boolean getIsPaidUser() {
    return isPaidUser;
}
 
public void setIsPaidUser(Boolean isPaidUser) {
    this.isPaidUser = isPaidUser;
}

Totally un-related, but why were the database field names have the "is" in front of the name, why not just PAID_USER?

Mark

[Pranav Pal]

I have found that the reason why I was getting exception was that I had mapped a primitive property (active - boolean) to a nullable column (ISACTIVE). Since primitives cannot be null, one cannot map it to a nullable ccolumn. I was not getting the same excpetion for isPaidUser because the type declared for isPaidUser was Boolean (Wrapper class) and not boolean (primitive).

Thank you Mark and Jaikiran for your help

[Prashant Langade]

Hi

I am also facing the same issue.

Here is the code snippet

The main java class.

package com.deere.hibernate;

import java.math.BigDecimal;
import java.util.ArrayList;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

import com.deere.domain.Customers;
import com.deere.domain.ProductAlive;
import com.deere.domain.ProductAliveKey;
import com.deere.domain.ProductFamily;

public class ProductMaintain {
	public static void main(String args[]){
		SessionFactory sessionFactory=null;
		Session session=null;
		Transaction tx=null;
		try {
			sessionFactory = new org.hibernate.cfg.Configuration().configure().buildSessionFactory();
			session=sessionFactory.openSession();
			tx = session.beginTransaction();
			
			ProductFamily family = new ProductFamily();
			family.setProductFamilyId("TESTPRODFAMID");
			family.setAnnualUsageHrs(new BigDecimal("10"));
			family.setMachinesPerCatalogCnt(new Short("1"));
			family.setProductFamilyDsc("TESTPRODFAMDESC");
			
			ProductAliveKey key = new ProductAliveKey();
			key.setProductFamilyId("TESTPRODFAMID");
			key.setPartsCatalogNum(new Character('A'));
			key.setAliveYr(new Short("1"));
			
			ProductAlive alive = new ProductAlive();
			alive.setKey(key);
			alive.setAlivePct(10);
			
			ArrayList<ProductAlive> arr = new ArrayList<ProductAlive>();
			arr.add(alive);

			family.setProductAliveList(arr);
			
			
			session.save(family);
			tx.commit();
			
			System.out.println("Insert successfully");

		} catch (Exception e) {
				e.printStackTrace();
		}finally{
			//session.flush();
			session.close();
		}
	}
}

The ProductFamily pojo mapped to PRODUCT_FAMILY table

package com.deere.domain;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.ArrayList;

public class ProductFamily implements Serializable{
	
	String productFamilyId;
	String productFamilyDsc;
	BigDecimal annualUsageHrs;
	Short machinesPerCatalogCnt;
	
	ArrayList<ProductAlive> productAliveList;

	public String getProductFamilyId() {
		return productFamilyId;
	}

	public void setProductFamilyId(String productFamilyId) {
		this.productFamilyId = productFamilyId;
	}

	public String getProductFamilyDsc() {
		return productFamilyDsc;
	}

	public void setProductFamilyDsc(String productFamilyDsc) {
		this.productFamilyDsc = productFamilyDsc;
	}

	

	public BigDecimal getAnnualUsageHrs() {
		return annualUsageHrs;
	}

	public void setAnnualUsageHrs(BigDecimal annualUsageHrs) {
		this.annualUsageHrs = annualUsageHrs;
	}

	

	public Short getMachinesPerCatalogCnt() {
		return machinesPerCatalogCnt;
	}

	public void setMachinesPerCatalogCnt(Short machinesPerCatalogCnt) {
		this.machinesPerCatalogCnt = machinesPerCatalogCnt;
	}

	public ArrayList<ProductAlive> getProductAliveList() {
		return productAliveList;
	}

	public void setProductAliveList(ArrayList<ProductAlive> productAliveList) {
		this.productAliveList = productAliveList;
	}
	
	
	

}

The ProductAlive pojo mapped to PRODUCTS_ALIVE table

PRODUCT_FAMILY has one to many relationship with PRODUCTS_ALIVE table

package com.deere.domain;

import java.io.Serializable;

public class ProductAlive implements Serializable{
	
	private ProductAliveKey key;
	Integer alivePct;
	
	public ProductAliveKey getKey() {
		return key;
	}
	public void setKey(ProductAliveKey key) {
		this.key = key;
	}
	public Integer getAlivePct() {
		return alivePct;
	}
	public void setAlivePct(Integer alivePct) {
		this.alivePct = alivePct;
	}	
}

PROUDCTS_ALIVE has three primary keys(Composite primary keys).
The corresponding separate pojo ProductAliveKey representing it.

package com.deere.domain;

import java.io.Serializable;

public class ProductAliveKey  implements Serializable{
	
	String productFamilyId;
	Character partsCatalogNum;
	Short aliveYr;
	
	
	
	
	public Short getAliveYr() {
		return aliveYr;
	}
	public void setAliveYr(Short aliveYr) {
		this.aliveYr = aliveYr;
	}
	public String getProductFamilyId() {
		return productFamilyId;
	}
	public void setProductFamilyId(String productFamilyId) {
		this.productFamilyId = productFamilyId;
	}
	public Character getPartsCatalogNum() {
		return partsCatalogNum;
	}
	public void setPartsCatalogNum(Character partsCatalogNum) {
		this.partsCatalogNum = partsCatalogNum;
	}
	
	

	
	

}

HBM files

ProductFamily.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="com.deere.domain.ProductFamily" table="PRODUCT_FAMILY">
		<id name="productFamilyId" type="string" column ="PRODUCT_FAMILY_ID">
			<generator class="assigned"/>
		</id>
		
		<property name="productFamilyDsc" type="string" column="PRODUCT_FAMILY_DSC"/>
		<property name="annualUsageHrs" type="big_decimal" column="ANNUAL_USAGE_HRS_TM"/>
		<property name="machinesPerCatalogCnt" type="short" column="MACHINES_PER_CATALOG_CNT"/>
		
		<!-- <list name="productAliveList" cascade="all">            
			<list-index column="PRODUCT_FAMILY_ID"/>
			<key column="PRODUCT_FAMILY_ID"/>
			<one-to-many class="com.deere.domain.ProductAlive"/>
		</list>-->
		
		<bag name="productAliveList">
                 <key column="key"/>
                 <one-to-many class="com.deere.domain.ProductAlive"/>
          </bag>
		
		
	</class>
	
</hibernate-mapping>

ProductAlive.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="com.deere.domain.ProductAlive" table="PRODUCTS_ALIVE">
	
	<composite-id name="key">
		<key-property name="productFamilyId" type="string" column="PRODUCT_FAMILY_ID" />
		<key-property name="partsCatalogNum" type="character" column="PARTS_CATALOG_NUM" />
		<key-property name="aliveYr" type="integer" column="ALIVE_YR" />
	</composite-id>

	<property name="alivePct" type="short" column="ALIVE_PCT"/>
		
	</class>
</hibernate-mapping>

The database structure

Create Table ADRPTMT.PRODUCT_FAMILY(
PRODUCT_FAMILY_ID             VARCHAR(60)         NOT NULL PRIMARY KEY,
ANNUAL_USAGE_HRS_TM           DECIMAL(5,2)        NOT NULL,
MACHINES_PER_CATALOG_CNT      SMALLINT            NOT NULL,
PRODUCT_FAMILY_DSC            VARCHAR(255)        NOT NULL)
;

Create Table ADRPTMT.PRODUCTS_ALIVE(
PRODUCT_FAMILY_ID             VARCHAR(60)         NOT NULL,
PARTS_CATALOG_NUM             CHAR(6)             NOT NULL,
ALIVE_YR                      SMALLINT            NOT NULL,
ALIVE_PCT                     DECIMAL(5,2)        NOT NULL)
PRODUCTFK_FAMILY_ID FOREIGN KEY (PRODUCT_FAMILY_ID)
references
   ADRPTMT.PRODUCT_FAMILY (PRODUCT_FAMILY_ID)
;

I am getting following exception when i try to run main class.

org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_optimizer=false for more info) setter of com.deere.domain.ProductFamily.setProductAliveList
at org.hibernate.tuple.PojoEntityTuplizer.setPropertyValuesWithOptimizer(PojoEntityTuplizer.java:215)
at org.hibernate.tuple.PojoEntityTuplizer.setPropertyValues(PojoEntityTuplizer.java:185)
at org.hibernate.persister.entity.AbstractEntityPersister.setPropertyValues(AbstractEntityPersister.java:3232)
at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:253)
at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:114)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:559)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:547)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:543)
at com.deere.hibernate.ProductMaintain.main(ProductMaintain.java:46)
Caused by: net.sf.cglib.beans.BulkBeanException: org.hibernate.collection.PersistentBag incompatible with java.util.ArrayList
at com.deere.domain.ProductFamily$$BulkBeanByCGLIB$$29c24265.setPropertyValues(<generated>)
at org.hibernate.tuple.PojoEntityTuplizer.setPropertyValuesWithOptimizer(PojoEntityTuplizer.java:212)
... 14 more
Caused by: java.lang.ClassCastException: org.hibernate.collection.PersistentBag incompatible with java.util.ArrayList
... 16 more

[Barclay Dunn]

Pranav Pal wrote:I have found that the reason why I was getting exception was that I had mapped a primitive property (active - boolean) to a nullable column (ISACTIVE). Since primitives cannot be null, one cannot map it to a nullable ccolumn. I was not getting the same excpetion for isPaidUser because the type declared for isPaidUser was Boolean (Wrapper class) and not boolean (primitive).

This is why living in the future is so great: I can benefit from your having had this problem and posting about its solution. As a result I spent 20 minutes on a fix rather than hours trying to figure it out. Thank you!

[Ragupathirajan Venkatesan]

Hi

What changes that you have done to fix this issue as suggested by Pranav Pal in previous reply that he has fixed by making that as wrapper.

Thanks

[sankalp suryawanshi]

Pranav Pal wrote:I have found that the reason why I was getting exception was that I had mapped a primitive property (active - boolean) to a nullable column (ISACTIVE). Since primitives cannot be null, one cannot map it to a nullable ccolumn. I was not getting the same excpetion for isPaidUser because the type declared for isPaidUser was Boolean (Wrapper class) and not boolean (primitive).

Thank you Mark and Jaikiran for your help

Me found the same error and fixed using method mentioned by Pranav , Just changed int to Integer and its all fixed. Thanks Pranav

[Barclay Dunn]

Ragupathirajan Venkatesan wrote:Hi

What changes that you have done to fix this issue as suggested by Pranav Pal in previous reply that he has fixed by making that as wrapper.

Thanks

I changed this:

private int oracleBillingId;

to this:

private Integer oracleBillingId; // must be Wrapper class since the field is nullable