当前位置: 代码迷 >> Java Web开发 >> hibernate保存多张图片到oracle数据库的blob字段有关问题
  详细解决方案

hibernate保存多张图片到oracle数据库的blob字段有关问题

热度:4086   发布时间:2013-02-25 21:19:58
hibernate保存多张图片到oracle数据库的blob字段问题
如题,我的表里有3个blob字段,需求用户同时上传这3张图片到数据库,但是上传之后,发现图片位置借位,第一张和最后一张图片会互换位置,我仔细查看代码没有发现问题,经过多次测试发现当上传>=2张图片的时候会发生这种问题,测试通过针对其中某一个字段单个保存可以正常保存,但是当>=2张时会出现上面问题。
下面是hibernate配置文件
XML code
<?xml version="1.0" encoding="utf-8"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping package="com.jeecms.cms.entity.cep">    <class name="CepUserFleet" table="T_USER_FLEET">        <id name="id" type="java.lang.Integer" column="id">            <generator class="sequence"><param name="sequence">T_USER_FLEET_SEQ</param></generator>        </id>        <property name="userId" column="USER_ID" type="java.lang.Integer" not-null="true" />        <property name="loginName" column="LOGIN_NAME" type="string" not-null="true" />        <property name="userName" column="USER_NAME" type="string" not-null="true" />        <property name="cardNumber" column="CARD_NUMBER" type="string" />        <property name="cardNumberScann" column="CARD_NUMBER_SCANN" type="java.sql.Blob" />        <property name="carNum" column="CAR_NUM" type="java.math.BigDecimal" />        <property name="legalCardNum" column="LEGAL_CARD_NUM" type="string" />        <property name="legalName" column="LEGAL_NAME" type="string" />        <property name="legalCardCopy" column="LEGAL_CARD_COPY" type="java.sql.Blob" />        <property name="businessLicenseNum" column="BUSINESS_LICENSE_NUM" type="string" />        <property name="businessLicenseScann" column="BUSINESS_LICENSE_SCANN" type="java.sql.Blob" />        <property name="companyName" column="COMPANY_NAME" type="string" />        <property name="companyAddress" column="COMPANY_ADDRESS" type="string" />        <property name="companyZipCode" column="COMPANY_ZIPCODE" type="string" />        <property name="companyPhone" column="COMPANY_PHONE" type="string" />        <property name="companyFax" column="COMPANY_FAX" type="string" />        <property name="person" column="PERSON" type="string" />        <property name="phone" column="PHONE" type="string" />        <property name="email" column="EMAIL" type="string" />        <property name="mobile" column="MOBILE" type="string" />        <property name="createTime" column="CREATE_TIME" type="timestamp" length="19"/>        <property name="updateTime" column="UPDATE_TIME" type="timestamp" length="19"/>    </class></hibernate-mapping>


Entity类如下:
Java code
package com.jeecms.cms.entity.cep.base;import java.io.Serializable;import java.math.BigDecimal;import java.sql.Blob;import java.util.Date;public abstract class BaseCepUserFleet implements Serializable {    public BaseCepUserFleet() {    }    public BaseCepUserFleet(Integer id) {        this.id = id;    }    private Integer id;    private Integer userId;    private String userName;    private String loginName;    private String cardNumber;    private Blob cardNumberScann;    private BigDecimal carNum;    private String legalCardNum;    private String legalName;    private Blob legalCardCopy;    private String businessLicenseNum;    private Blob businessLicenseScann;    private String companyName;    private String companyAddress;    private String companyZipCode;    private String companyPhone;    private String companyFax;    private String person;    private String phone;    private String mobile;    private String email;    private Date createTime;    private Date updateTime;    public Integer getId() {        return id;    }    public void setId(Integer id) {        this.id = id;    }    public Integer getUserId() {        return userId;    }    public void setUserId(Integer userId) {        this.userId = userId;    }    public String getUserName() {        return userName;    }    public void setUserName(String userName) {        this.userName = userName;    }    public String getLoginName() {        return loginName;    }    public void setLoginName(String loginName) {        this.loginName = loginName;    }    public String getCardNumber() {        return cardNumber;    }    public void setCardNumber(String cardNumber) {        this.cardNumber = cardNumber;    }    public BigDecimal getCarNum() {        return carNum;    }    public void setCarNum(BigDecimal carNum) {        this.carNum = carNum;    }    public String getLegalCardNum() {        return legalCardNum;    }    public void setLegalCardNum(String legalCardNum) {        this.legalCardNum = legalCardNum;    }    public String getLegalName() {        return legalName;    }    public void setLegalName(String legalName) {        this.legalName = legalName;    }    public String getBusinessLicenseNum() {        return businessLicenseNum;    }    public void setBusinessLicenseNum(String businessLicenseNum) {        this.businessLicenseNum = businessLicenseNum;    }    public String getCompanyAddress() {        return companyAddress;    }    public void setCompanyAddress(String companyAddress) {        this.companyAddress = companyAddress;    }    public String getCompanyZipCode() {        return companyZipCode;    }    public void setCompanyZipCode(String companyZipCode) {        this.companyZipCode = companyZipCode;    }    public String getCompanyPhone() {        return companyPhone;    }    public void setCompanyPhone(String companyPhone) {        this.companyPhone = companyPhone;    }    public String getCompanyFax() {        return companyFax;    }    public void setCompanyFax(String companyFax) {        this.companyFax = companyFax;    }    public String getPerson() {        return person;    }    public void setPerson(String person) {        this.person = person;    }    public String getPhone() {        return phone;    }    public void setPhone(String phone) {        this.phone = phone;    }    public String getMobile() {        return mobile;    }    public void setMobile(String mobile) {        this.mobile = mobile;    }    public String getEmail() {        return email;    }    public void setEmail(String email) {        this.email = email;    }    public Date getCreateTime() {        return createTime;    }    public void setCreateTime(Date createTime) {        this.createTime = createTime;    }    public Date getUpdateTime() {        return updateTime;    }    public void setUpdateTime(Date updateTime) {        this.updateTime = updateTime;    }    public String getCompanyName() {        return companyName;    }    public void setCompanyName(String companyName) {        this.companyName = companyName;    }    public Blob getCardNumberScann() {        return cardNumberScann;    }    public void setCardNumberScann(Blob cardNumberScann) {        this.cardNumberScann = cardNumberScann;    }    public Blob getLegalCardCopy() {        return legalCardCopy;    }    public void setLegalCardCopy(Blob legalCardCopy) {        this.legalCardCopy = legalCardCopy;    }    public Blob getBusinessLicenseScann() {        return businessLicenseScann;    }    public void setBusinessLicenseScann(Blob businessLicenseScann) {        this.businessLicenseScann = businessLicenseScann;    }}package com.jeecms.cms.entity.cep;import java.math.BigDecimal;import java.sql.Blob;import java.util.Date;import com.jeecms.cms.entity.cep.base.BaseCepUserFleet;public class CepUserFleet extends BaseCepUserFleet {    private static final long serialVersionUID = 1L;        public CepUserFleet() {        super();    }}
  相关解决方案
本站暂不开放注册!
内测阶段只得通过邀请码进行注册!