Spring Hibernate JPA不支持云铸造

Question

我正在做一个使用spring hibernate & jpa的项目，并将其部署在cloud foundry上。我的问题是，当我调用Dao将我的实体持久化到mysql数据库时，什么也没有发生。没有抛出错误，我已经尝试在try catch块中包装持久化，但什么都没有。

我将persistance.xml中的show sql属性设置为true。当我使用其他Dao方法来查询数据库时，我可以看到运行的SQL。但是，当我尝试持久化时，没有SQL被写入控制台。

来自查询的示例控制台反馈

Hibernate: select animal0_.animal_id as animal1_1_, animal0_.about as about1_, animal0_.animaltype as animaltype1_, animal0_.breed as breed1_, animal0_.date_in as date5_1_, animal0_.date_out as date6_1_, animal0_.image_1 as image7_1_, animal0_.image_1_content_type as image8_1_, animal0_.image_1_file_name as image9_1_, animal0_.image_1_file_size as image10_1_, animal0_.image_2 as image11_1_, animal0_.image_2_content_type as image12_1_, animal0_.image_2_file_name as image13_1_, animal0_.image_2_file_size as image14_1_, animal0_.image_3 as image15_1_, animal0_.image_3_content_type as image16_1_, animal0_.image_3_file_name as image17_1_, animal0_.image_3_file_size as image18_1_, animal0_.name as name1_, animal0_.status as status1_ from animals animal0_
INFO : com.lasthope.web.animals.service.AnimalsServiceImpl - Found 0 animals in care.

来自持久化的示例控制台反馈：

INFO : com.lasthope.web.animals.service.AnimalsServiceImpl - Saving Gerry to database.
INFO : com.lasthope.web.animals.dao.AnimalsDaoImpl - DAO, saving animal Gerry ID: null

任何反馈都将非常感谢！

root-context.xml：

<cloud:data-source id="dataSource" />

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
 <property name="dataSource" ref="dataSource" />
</bean>

<bean class="org.springframework.orm.jpa.JpaTransactionManager" id="transactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>

<tx:annotation-driven mode="aspectj" transaction-manager="transactionManager"/>

<bean class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" id="entityManagerFactory">
    <property name="dataSource" ref="dataSource"/>
</bean> 

服务：

@Service("animalsService")
public class AnimalsServiceImpl implements AnimalsService {

@Autowired
private AnimalsDao animalsDao;


    @Override
@Transactional
public void saveAnimal(Animal animal) {

    logger.info("Saving "+animal.getName()+ " to database.");

    animalsDao.saveAnimal(animal);


}

DAO：

@Repository("animalsDao")
public class AnimalsDaoImpl implements AnimalsDao {

private static final Logger logger = LoggerFactory.getLogger(AnimalsDaoImpl.class);

   private EntityManager entityManager;

    public EntityManager getEntityManager() {
        return entityManager;
    }

    @PersistenceContext
    public void setEntityManager(EntityManager entityManager) {
        this.entityManager = entityManager;
    }

@Override
public void saveAnimal(Animal animal) {

    logger.info("DAO, saving animal " +animal.getName() +" ID: " +animal.getAnimalId());    

    getEntityManager().persist(animal);         

}

persistance.xml

<persistence-unit name="persistenceUnit" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
        <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
        <property name="hibernate.hbm2ddl.auto" value="update"/>
        <property name="hibernate.ejb.naming_strategy" value="org.hibernate.cfg.ImprovedNamingStrategy"/>
        <property name="hibernate.show_sql" value="true"/> 
    </properties>
</persistence-unit>

​

动物类：

@Entity
@Table(name="animals")
public class Animal implements Serializable  {

@Id
@Column(name = "ANIMAL_ID")
@GeneratedValue(strategy = GenerationType.AUTO)
private Integer animalId;

@Column(name = "ANIMALTYPE")
private String animalType;

@Column(name = "BREED")
private String breed;

@Column(name = "NAME")
private String name;

@Column(name = "IMAGE_1")
@Lob
private Blob image1;

@Column(name = "IMAGE_1_CONTENT_TYPE")
private String image1ContentType;

@Column(name = "IMAGE_1_FILE_NAME")
private String image1FileName;

@Column(name = "IMAGE_1_FILE_SIZE")
private String image1FileSize;

@Column(name = "IMAGE_2")
@Lob
private Blob image2;

@Column(name = "IMAGE_2_CONTENT_TYPE")
private String image2ContentType;

@Column(name = "IMAGE_2_FILE_NAME")
private String image2FileName;

@Column(name = "IMAGE_2_FILE_SIZE")
private String image2FileSize;

@Column(name = "IMAGE_3")
@Lob
private Blob image3;

@Column(name = "IMAGE_3_CONTENT_TYPE")
private String image3ContentType;

@Column(name = "IMAGE_3_FILE_NAME")
private String image3FileName;

@Column(name = "IMAGE_3_FILE_SIZE")
private String image3FileSize;  

@Column(name = "ABOUT")
private String about;

@Column(name = "DATE_IN")
private Date dateIn;

@Column(name = "DATE_OUT")
private Date dateOut;

@Column(name = "STATUS")
private String status;

Answer 1

让它工作了！终于来了！

以下是我必须做的更改的摘要。

在Animal类(实体对象)中，我将id字段从Integer改为long。(我怀疑这与修复有任何关系！)并删除了可序列化的实现。

在根上下文中，我将tx从

<tx:annotation-driven mode="aspectj" transaction-manager="transactionManager"/>

至

<tx:annotation-driven/>

我加了一句

<context:component-scan base-package="com.lasthope.web"/>

然后在我的servlet上下文中，我添加了

<context:component-scan base-package="com.lasthope.web.controllers" />

看起来像是compenet扫描之间的冲突。

当我指向一个我永远不会知道的Oracle数据库时，它为什么会工作。

Answer 2

尝试将GeneratedValue策略设置为identity，确保将ANIMAL_ID列指定为自动编号。

@Id
@Column(name = "ANIMAL_ID")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer animalId;

此外，如果您使用的是新版本的mySql (v5.x+)，则应在persistence.xml文件中将方言指定为：

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect" />

持久化时尝试创建事务：

public void saveAnimal(Animal animal) {

    logger.info("DAO, saving animal " +animal.getName() +" ID: " +animal.getAnimalId());    

    EntityManager em = getEntityManager();
    em.getTransaction().begin();
    em.persist(animal);
    em.getTransaction().commit();         

}