org.hibernate.exception.GenericJDBCException: could not prepare statement

public interface BaseEntity<ID extends Serializable> extends Serializable {

	/**

	 * @return

	 */

	public abstract ID getId();



	/**

	 * @param id

	 */

	public abstract void setId(ID id);

}



@Entity

@Table(name = "t_character_build")

public class CharacterBuild implements BaseEntity<Integer> {



	/**

	 * 

	 */

	private static final long serialVersionUID = -4265343379276247352L;



	private Integer id;

	

	private int charId;

	

	private String stateInfo;





	@Id

	@GeneratedValue(strategy = GenerationType.IDENTITY)

	@Override

	public Integer getId() {

		return id;

	}



	@Override

	public void setId(Integer id) {

		this.id = id;

	}



	@Column(name = "stateInfo")

	public String getStateInfo() {

		return stateInfo;

	}



	public void setStateInfo(String stateInfo) {

		this.stateInfo = stateInfo;

	}



	@Column(name = "charId")

	public int getCharId() {

		return charId;

	}



	public void setCharId(int charId) {

		this.charId = charId;

	}



}





public class HibernateDBServcieImpl implements DBService {

	private final SessionFactory sessionFactory;

	private final HibernamteTemplate transTemplate = new TranHibernateTemplate();

	private static final String DB_CHECK_SQL = "select 1";



      @Override

	public void update(final BaseEntity entity) throws DataAccessException {

		transTemplate.doCall(new HibernateCallback<Object>() { //这里报错

			@Override

			public Object doCall(Session session) {

				session.update(entity);

				return null;

			}

		});



	}



      private interface HibernamteTemplate {

		public <T> T doCall(HibernateCallback<T> callback);

	}

	

	private final class TranHibernateTemplate implements HibernamteTemplate {

		@Override

		public <T> T doCall(HibernateCallback<T> callback) {

			Session _session = null;

			Transaction _tr = null;

			T _result = null;

			try {

				_session = sessionFactory.openSession();

				_tr = _session.beginTransaction();

				_result = callback.doCall(_session);

				_tr.commit();

			} catch (Exception e) {

				if (_tr != null) {

					_tr.rollback();

				}

				throw new DataAccessException(e); // 这里捕获到异常,有时没问题,有时就报错

			} finally {

				if (_session != null) {

					_session.close();

				}

			}

			return _result;

		}

	}

}



hibernate.cfg.xml文件.

<session-factory>

               <property name="hibernate.dialect">

			org.hibernate.dialect.MySQL5InnoDBDialect

		</property>

		<property name="hibernate.connection.driver_class">

			com.mysql.jdbc.Driver

		</property>

		<property name="hibernate.transaction.factory_class">

			org.hibernate.transaction.JDBCTransactionFactory

		</property>

		<property name="hibernate.cache.provider_class">

			org.hibernate.cache.NoCacheProvider

		</property>

		<property name="hibernate.cache.use_query_cache">

			false

		</property>

		<property name="hibernate.connection.url">jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf-8&autoReconnect=true</property>

		<property name="hibernate.connection.username">root</property>

		<property name="hibernate.connection.password"></property>

		<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>

		<property name="hibernate.show_sql">false</property>

		<property name="hibernate.format_sql">false</property>

		<property name="hibernate.hbm2ddl.auto">none</property>

		<property name="hibernate.jdbc.batch_size">50</property>

		<property name="hibernate.c3p0.maxIdleTime">180</property>

		<property name="hibernate.c3p0.min_size">5</property>

		<property name="hibernate.c3p0.max_size">20</property>

		<property name="hibernate.c3p0.timeout">1000</property>

		<property name="hibernate.c3p0.max_statements">20</property>

               ........

</session-factory>