I'm running into a problem where it appears that a column that I intend to map as a String is being read in as a Byte. Apologies in advance if I've provided too much information below, let me know the right amount and I'll adjust in the future. M
Hibernate version: 2.1.6

Mapping documents:


Code between sessionFactory.openSession() and session.close():


Full stack trace of any exception that occurs:


Name and version of the database you are using:
mysqld-nt.exe Ver 4.0.20a-nt-log for NT on i32
mysql-connector-java-3.1.14

The generated SQL (show_sql=true):




Debug level Hibernate log excerpt:

debug

DB Info:



A sample query:

mysql> select * from securityindex securityin0_ where securityin0_.SecurityID="001204106" and securityin0_.SecurityTypeid=1 and securityin0_.IndexType
ID=6;
+------------+----------------+-------------+--------------------+--------+---------------------+---------+-----------+
| SecurityID | SecurityTypeid | IndexTypeID | CompanyName | Ticker | StartDate | EndDate | CompanyID |
+------------+----------------+-------------+--------------------+--------+---------------------+---------+-----------+
| 001204106 | 1 | 6 | FOO Resources Inc. | FOO | 2004-02-25 10:31:00 | NULL | 316 |
+------------+----------------+-------------+--------------------+--------+---------------------+---------+-----------+
1 row in set (0.02 sec)

Java Class & PK:


import java.io.Serializable;
import java.util.Date;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
/**
* @hibernate.class
* table="securityindex"
*
*/
public class SecurityIndex extends ValueObjectImpl implements Serializable, com.iss.va.vo.SecurityIndex {

/** identifier field */
private com.iss.va.vo.impl.SecurityIndexPK comp_id;

/** persistent field */
private String companyName;

/** nullable persistent field */
private String ticker;

/** persistent field */
private Date startDate;

/** nullable persistent field */
private Date endDate;

/** nullable persistent field */
private com.iss.va.vo.impl.SecurityTypeCode securitytypecode;

/** nullable persistent field */
private com.iss.va.vo.impl.Security security;

/** persistent field */
private com.iss.va.vo.impl.Company company;

/** full constructor */
public SecurityIndex(com.iss.va.vo.impl.SecurityIndexPK comp_id, String companyName, String ticker, Date startDate, Date endDate, com.iss.va.vo.impl.SecurityTypeCode securitytypecode, com.iss.va.vo.impl.Security security, com.iss.va.vo.impl.Company company) {
this.comp_id = comp_id;
this.companyName = companyName;
this.ticker = ticker;
this.startDate = startDate;
this.endDate = endDate;
this.securitytypecode = securitytypecode;
this.security = security;
this.company = company;
}

/** default constructor */
public SecurityIndex() {
}

/** minimal constructor */
public SecurityIndex(com.iss.va.vo.impl.SecurityIndexPK comp_id, String companyName, Date startDate, com.iss.va.vo.impl.Company company) {
this.comp_id = comp_id;
this.companyName = companyName;
this.startDate = startDate;
this.company = company;
}

/**
* @hibernate.id
* generator-class="assigned"
*
*/
public com.iss.va.vo.impl.SecurityIndexPK getComp_id() {
return this.comp_id;
}

public void setComp_id(com.iss.va.vo.impl.SecurityIndexPK comp_id) {
this.comp_id = comp_id;
}
public com.iss.va.vo.SecurityIndexPK getPK() {
return (com.iss.va.vo.SecurityIndexPK)getComp_id();
}
public void setPK(com.iss.va.vo.SecurityIndexPK pk) {
setComp_id((com.iss.va.vo.impl.SecurityIndexPK)pk);
}

/**
* @hibernate.property
* column="CompanyName"
* length="60"
* not-null="true"
*
*/
public String getCompanyName() {
return this.companyName;
}

public void setCompanyName(String companyName) {
this.companyName = companyName;
}

/**
* @hibernate.property
* column="Ticker"
* length="20"
*
*/
public String getTicker() {
return this.ticker;
}

public void setTicker(String ticker) {
this.ticker = ticker;
}

/**
* @hibernate.property
* column="StartDate"
* length="19"
* not-null="true"
*
*/
public Date getStartDate() {
return this.startDate;
}

public void setStartDate(Date startDate) {
this.startDate = startDate;
}

/**
* @hibernate.property
* column="EndDate"
* length="19"
*
*/
public Date getEndDate() {
return this.endDate;
}

public void setEndDate(Date endDate) {
this.endDate = endDate;
}

/**
* @hibernate.many-to-one
* update="false"
* insert="false"
* outer-join="false"
*
* @hibernate.column
* name="SecurityTypeid"
*
*/
public com.iss.va.vo.impl.SecurityTypeCode getSecuritytypecode() {
return this.securitytypecode;
}

public void setSecuritytypecode(com.iss.va.vo.impl.SecurityTypeCode securitytypecode) {
this.securitytypecode = securitytypecode;
}

/**
* @hibernate.many-to-one
* update="false"
* insert="false"
* outer-join="false"
*
* @hibernate.column
* name="SecurityTypeid"
*
* @hibernate.column
* name="SecurityID"
*
*/
public com.iss.va.vo.impl.Security getSecurity() {
return this.security;
}

public void setSecurity(com.iss.va.vo.impl.Security security) {
this.security = security;
}

/**
* @hibernate.many-to-one
* not-null="true"
* outer-join="false"
* @hibernate.column name="CompanyID"
*
*/
public com.iss.va.vo.impl.Company getCompany() {
return this.company;
}

public void setCompany(com.iss.va.vo.impl.Company company) {
this.company = company;
}

public boolean equals(Object other) {
if ( !(other instanceof SecurityIndex) ) return false;
SecurityIndex castOther = (SecurityIndex) other;
return new EqualsBuilder()
.append(this.getComp_id(), castOther.getComp_id())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getComp_id())
.toHashCode();
}

}

import java.io.Serializable;
import org.apache.commons.lang.builder.EqualsBuilder;
import org.apache.commons.lang.builder.HashCodeBuilder;
import org.apache.commons.lang.builder.ToStringBuilder;

/** @author Hibernate CodeGenerator */
public class SecurityIndexPK implements Serializable, com.iss.va.vo.SecurityIndexPK {

/** identifier field */
private String securityId;

/** identifier field */
private Byte securityTypeid;

/** identifier field */
private Short indexTypeId;

/** full constructor */
public SecurityIndexPK(String securityId, Byte securityTypeid, Short indexTypeId) {
this.securityId = securityId;
this.securityTypeid = securityTypeid;
this.indexTypeId = indexTypeId;
}

/** default constructor */
public SecurityIndexPK() {
}

/**
* @hibernate.property
* column="SecurityID"
* length="14"
*
*/
public String getSecurityId() {
return this.securityId;
}

public void setSecurityId(String securityId) {
this.securityId = securityId;
}

/**
* @hibernate.property
* column="SecurityTypeid"
* length="4"
*
*/
public Byte getSecurityTypeid() {
return this.securityTypeid;
}

public void setSecurityTypeid(Byte securityTypeid) {
this.securityTypeid = securityTypeid;
}

/**
* @hibernate.property
* column="IndexTypeID"
* length="6"
*
*/
public Short getIndexTypeId() {
return this.indexTypeId;
}

public void setIndexTypeId(Short indexTypeId) {
this.indexTypeId = indexTypeId;
}

public String toString() {
return new ToStringBuilder(this)
.append("securityId", getSecurityId())
.append("securityTypeid", getSecurityTypeid())
.append("indexTypeId", getIndexTypeId())
.toString();
}

public boolean equals(Object other) {
if ( !(other instanceof SecurityIndexPK) ) return false;
SecurityIndexPK castOther = (SecurityIndexPK) other;
return new EqualsBuilder()
.append(this.getSecurityId(), castOther.getSecurityId())
.append(this.getSecurityTypeid(), castOther.getSecurityTypeid())
.append(this.getIndexTypeId(), castOther.getIndexTypeId())
.isEquals();
}

public int hashCode() {
return new HashCodeBuilder()
.append(getSecurityId())
.append(getSecurityTypeid())
.append(getIndexTypeId())
.toHashCode();
}

}

Don't cross post !

The original post in at http://forum.hibernate.org/viewtopic.php?t=934451 and is currently answered.

Hi Bertrand,

Apologies for it. I posted to Tools by mistake. If you are an admin, please feel free to delete from there as it was a mistake.

Mike