Spring JPA中的各种数据库连接配置

spring-jpa-datasource-h2.xml

<!-- H2的混合模式 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="org.h2.Driver" />
    <!--<property name="url" value="jdbc:h2:~/databases/mydb" />-->
    <property name="url" value="jdbc:h2:file://D:\h2\mydb;AUTO_SERVER=TRUE;USER=SA;" />
</bean>


<!-- H2的内存模式 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="org.h2.Driver" />
    <property name="url" value="jdbc:h2:mem:mydb;USER=SA;" />
</bean>