Spring JPA Hsqldb持久性

Question

@Entity
@NamedQuery(name="findUser4Email",
query="SELECT * " +
      "FROM User " +
      "WHERE email = :userEmail")
public class User extends AbstractNamedDomain {

private String name;
private String email;
private String password;
...

public class UserManager implements IUserManager {

    @PersistenceContext 
    private EntityManager em;

public User findUser4Email(String email) {
    return (User) em.createNamedQuery("findUser4Email").setParameter("userEmail",
            email).getSingleResult();
}

public User storeUser(User user) {
    //User u = em.merge(user);
    em.persist(user); 
    return user;
}
...

  <?xml version="1.0" encoding="UTF-8" ?>

   <beans xmlns="http://www.springframework.org/schema/beans"
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns:aop="http://www.springframework.org/schema/aop"
   xmlns:tx="http://www.springframework.org/schema/tx"
   xsi:schemaLocation="
   http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
   http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
   http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">

    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
            <property name="dataSource" ref="dataSource" />
            <property name="persistenceUnitName" value="BankingWeb" />
            <property name="jpaVendorAdapter">
                    <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
                            <property name="generateDdl" value="true" />
                            <property name="showSql" value="true" />
                            <property name="databasePlatform" value="${hibernate.dialect}" />
                    </bean>
            </property>
    </bean>

    <bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor" />

    <bean name="AccountManager" class="ssel.banking.dao.jpa.AccountManager" />

    <bean name="UserManager" class="ssel.banking.dao.jpa.UserManager" />


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

    <tx:annotation-driven transaction-manager="txManager"/>

    </beans>

这就是我的datasourcebean的样子

 <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="url" value="${jdbc.url}"/>
    <property name="driverClassName" value="${jdbc.driverClassName}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
</bean>

Answer 1

您必须定义一个数据源bean，如下所示：

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://192.0.0.1:3306/yourDB"/>
    <property name="username" value=""/>
    <property name="password" value=""/>
</bean>

（或JNDI查找）

<jee:jndi-lookup jndi-name="jdbc/datasource" id="dataSource" />

您可以按照本教程来帮助您设置一切。