Trouble running example from Hibernate Made Easy, p. 156

[Matthew Busse]

Hello Ranchers,

I'm working my way through the Hibernate Made Easy book, and it's been great so far, but I'm stuck on the example on p.156.

When I try to run the User class, I get this error: "java.sql.SQLException: Data too long for column 'verified' at row 1"

Here's my code, I checked it several times to make sure I didn't miss anything:

package com.examscam.model;

import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;
import javax.persistence.Transient;

import org.hibernate.Session;


@Entity
public class User {
	
	private Long id;
	private String password;
	private String loginName;
	private String encryptedPassword;
	private String emailAddress;
	private Boolean verified;
	private java.util.Date lastAccessTime;
	private java.util.Calendar registrationDate;
	
	@Transient
	public String getEncryptedPassword() {
		return encryptedPassword;
	}
	public void setEncryptedPassword(String encryptedPassword) {
		this.encryptedPassword = encryptedPassword;
	}
	@Id
	@GeneratedValue
	@Column (name="id")
	public Long getId() {
		return id;
	}
	public void setId(Long id) {
		this.id = id;
	}
	
	@Column (name="login_name")
	public String getLoginName() {
		return loginName;
	}
	public void setLoginName(String loginName) {
		this.loginName = loginName;
	}
	
	@Column (name="password", nullable=false)
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	
	public String getEmailAddress() {
		return emailAddress;
	}
	public void setEmailAddress(String emailAddress) {
		this.emailAddress = emailAddress;
	}
	
	@Basic
	public Boolean isVerified() {
		return verified;
	}
	public void setVerified(Boolean verified) {
		this.verified = verified;
	}
	
	@Temporal(TemporalType.TIMESTAMP)
	public java.util.Date getLastAccessTime() {
		return lastAccessTime;
	}
	public void setLastAccessTime(java.util.Date lastAccessTime) {
		this.lastAccessTime = lastAccessTime;
	}
	
	@Temporal(TemporalType.DATE)
	public java.util.Calendar getRegistrationDate() {
		return registrationDate;
	}
	public void setRegistrationDate(java.util.Calendar registrationDate) {
		this.registrationDate = registrationDate;
	}
	
	public static void main(String args[]) {
		Session session = HibernateUtil.beginTransaction();
		
		System.out.println("creating user");
		
		User user = new User();
		user.setPassword("abc123");
		user.setLoginName("mj");
		user.setEncryptedPassword("zab012");
		user.setEmailAddress("[e-mail]");
		user.setLastAccessTime(new java.util.Date());
		user.setRegistrationDate(new java.util.GregorianCalendar());
		user.setVerified(Boolean.FALSE);
		
		session.save(user);
		System.out.println("user saved");
		
		HibernateUtil.commitTransaction();
		System.out.println("transaction successful!!!");
	}
}

I don't understand by Boolean.FALSE is too big to fit in verified column.

Thanks!
Matt

[Oliver Chua]

Hi,

In your log4j.properties, add this

	<logger name="org.hibernate.SQL" additivity="false">
		<level value="DEBUG" />
		<appender-ref ref="Console" />
	</logger>

so you can see the sql statements

I've tried recreating the problem but it worked fine for me.
Below are the log entries when creating the table and inserting a record

CREATE TABLE "Individual_Simple_Entity1"
(
"ID" NUMBER(19,0) NOT NULL ENABLE,
"BOOLEANFIELD" NUMBER(1,0) NOT NULL ENABLE,
PRIMARY KEY ("ID") ENABLE
)

insert into Individual_Simple_Entity1 (booleanField, id) values (?, ?)
binding 'true' to parameter: 1
binding '1' to parameter: 2

in the db, the value of booleanField becomes 1

[Liu Xing]

Oliver Chua wrote:Hi,

In your log4j.properties, add this

	<logger name="org.hibernate.SQL" additivity="false">
		<level value="DEBUG" />
		<appender-ref ref="Console" />
	</logger>

so you can see the sql statements

I've tried recreating the problem but it worked fine for me.
Below are the log entries when creating the table and inserting a record

CREATE TABLE "Individual_Simple_Entity1"
(
"ID" NUMBER(19,0) NOT NULL ENABLE,
"BOOLEANFIELD" NUMBER(1,0) NOT NULL ENABLE,
PRIMARY KEY ("ID") ENABLE
)

insert into Individual_Simple_Entity1 (booleanField, id) values (?, ?)
binding 'true' to parameter: 1
binding '1' to parameter: 2

in the db, the value of booleanField becomes 1

Thank you very much.
You are quite right.