配置hsql测试jpa

参考http://thought-bytes.blogspot.com/2007/04/hello-world-with-standalone-java.html

1. 建文件夹， 存放hsql.jar ,再建个server.properties, 里面写上
   server.database.0 file:./think
   server.dbname.0 think
2. 启动hsql

   java -cp D:\hsqldb\lib\hsqldb.jar org.hsqldb.Server

3. 启动hsql manager(可选）
   java -cp D:\hsqldb\lib\hsqldb.jar org.hsqldb.util.DatabaseManager
4. 加到项目classpath hsqldb.jar
   hibernate3.jar
   hibernate-entitymanager.jar
5. 建立persistence.xml
   

       <persistence xmlns="http://java.sun.com/xml/ns/persistence"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence" version="1.0">
   
       <persistence-unit name="think" transaction-type="RESOURCE_LOCAL">
       <properties>
       <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/>
       <property name="hibernate.hbm2ddl.auto" value="update"/>
       <property name="hibernate.connection.driver_class" value="org.hsqldb.jdbcDriver"/>
       <property name="hibernate.connection.username" value="sa"/>
       <property name="hibernate.connection.password" value=""/>
       <property name="hibernate.connection.url" value="jdbc:hsqldb:hsql://localhost/think"/>
       </properties>
       </persistence-unit>
       </persistence>
   
   

    
6. 如果要测seam, 单元测试的话，直接setField(bean, "em", em)就好了
7. 如果只在内存中用hsql, 建persistenc.xml时， jdbcurl写成 这样就不用起server了
   

   jdbc:hsqldb:mem:databasename