Hi

I'am having a table which does have one primary key and remaining columns are not null.

When I'm trying execute find with select query on that table its also trying to call update and
throwing SQL exception with "Assignment of a NULL value to a NOT NULL column".

Why is it trying to call update ? And whats the solution to this problem ?

Thanks in advance.

Regards
Malay.

Malay,

Could you please post your mapping, java code, version of hibernate and database used? Can't help you without basic info.

Hi gpani

Please find here the details

<!-- Mapping for Table DTEST -->
<class name="com.test.hibernate.QueryTableDummy" table="DTEST">
<id name="dummyId" column="DTS_ID" type="int" unsaved-value="1">
<generator class="assigned" />
</id>

<property name="dummyName" type="string" column="DTS_NM" />
<property name="dummyEffDate" type="java.sql.Timestamp" column="DTS_EFF_DT" />
<property name="dummyTestId" type="string" column="DTS_TST_ID" />
<property name="dummyNameOpId" type="string" column="DTS_OPER_ID" />
<property name="dummyTs" type="java.sql.Timestamp" column="DTS_INS_TS" />
<property name="dummyEndDate" type="java.sql.Timestamp" column="DTS_END_DT" />
</class>

-- Script for table DTEST

create table DTEST
(
DTS_ID integer not null primary key,
DTS_NM varchar(60) not null,
DTS_EFF_DT date not null,
DTS_TST_ID varchar(8) not null,
DTS_OPER_ID varchar(8) not null,
DTS_INS_TS timestamp not null,
DTS_END_DT date not null
);

-- Mapping class

package com.test.hibernate;

import java.io.Serializable;
import java.sql.Timestamp;

/**
* @author guest
*
* To change this generated comment edit the template variable "typecomment":
* Window>Preferences>Java>Templates.
* To enable and disable the creation of type comments go to
* Window>Preferences>Java>Code Generation.
*/
public class QueryTableDummy implements Serializable {

private int dummyId;
private String dummyName;
private Timestamp dummyEffDate;
private String dummyTestId;
private String dummyNameOpId;
private Timestamp dummyTs;
private Timestamp dummyEndDate;

public QueryTableDummy()
{
}

/**
* Returns the dummyEffDate.
* @return Timestamp
*/
public Timestamp getDummyEffDate() {
return dummyEffDate;
}

/**
* Returns the dummyEndDate.
* @return Timestamp
*/
public Timestamp getDummyEndDate() {
return dummyEndDate;
}

/**
* Returns the dummyId.
* @return int
*/
public int getDummyId() {
return dummyId;
}

/**
* Returns the dummyName.
* @return String
*/
public String getDummyName() {
return dummyName;
}

/**
* Returns the dummyNameOpId.
* @return String
*/
public String getDummyNameOpId() {
return dummyNameOpId;
}

/**
* Returns the dummyTestId.
* @return String
*/
public String getDummyTestId() {
return dummyTestId;
}

/**
* Returns the dummyTs.
* @return Timestamp
*/
public Timestamp getDummyTs() {
return dummyTs;
}

/**
* Sets the dummyEffDate.
* @param dummyEffDate The dummyEffDate to set
*/
public void setDummyEffDate(Timestamp dummyEffDate) {
this.dummyEffDate = dummyEffDate;
}

/**
* Sets the dummyEndDate.
* @param dummyEndDate The dummyEndDate to set
*/
public void setDummyEndDate(Timestamp dummyEndDate) {
this.dummyEndDate = dummyEndDate;
}

/**
* Sets the dummyId.
* @param dummyId The dummyId to set
*/
public void setDummyId(int dummyId) {
this.dummyId = dummyId;
}

/**
* Sets the dummyName.
* @param dummyName The dummyName to set
*/
public void setDummyName(String dummyName) {
this.dummyName = dummyName;
}

/**
* Sets the dummyNameOpId.
* @param dummyNameOpId The dummyNameOpId to set
*/
public void setDummyNameOpId(String dummyNameOpId) {
this.dummyNameOpId = dummyNameOpId;
}

/**
* Sets the dummyTestId.
* @param dummyTestId The dummyTestId to set
*/
public void setDummyTestId(String dummyTestId) {
this.dummyTestId = dummyTestId;
}

/**
* Sets the dummyTs.
* @param dummyTs The dummyTs to set
*/
public void setDummyTs(Timestamp dummyTs) {
this.dummyTs = dummyTs;
}

}
-------

And from my other class I'm calling the query something like the following

select dummy from dummy in class QueryTableDummy where dummyId = 10

Malay,

The mapping and Bean look fine. Could you provide a sample of the code where you are doing a search? That is probably where you need to check if something is being updated.

Hi

Basically I'm using Hibernate from Spring Framework.

Here is following the code :


package com.test.hibernate;

import java.util.List;

import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;

/**
* @author guest
*
* To change this generated comment edit the template variable "typecomment":
* Window>Preferences>Java>Templates.
* To enable and disable the creation of type comments go to
* Window>Preferences>Java>Code Generation.
*/

public class QueryTableDummyHibernateTest
extends HibernateDaoSupport{

public List getDummyData()
throws DataAccessException {

List lst =
getHibernateTemplate().find(
"select dummy from dummy in class QueryTableDummy where dummyId = 10 ");


System.out.println("Test data from Db -> "+lst);

return lst;
}
}

Do you use the ThreadLocal way of getting hibernate sessions in your getHibernateTemplate() method?

Could you please explain the same in detail what do you mean by ThreadLocal way?. Why hibernate is calling update while selecting?

1. I find it very difficult to believe that Hibernate would be doing an update when all you are doing in your code is a select. If this were really an issue, no one would be using Hibernate.

2. If you look through the Hibernate documentation regarding Session usage you will see code where you use sessions in conjunction with a ThreadLocal.


Please do some more research.