BroadleafCommerce使用Oracle

群号：185686402，欢迎访问blog.ebuzz.cn

1.下载ORACLE的JDBC驱动，拷贝到tomcat的lib目录下，不能放到工程lib下，因为会提前加载这个LIB。

2.修改core/src/main/resources/runtime-properties/common-shared.properties文件：

blPU.hibernate.dialect=”org.hibernate.dialect.Oracle10gDialect

blSecurePU.hibernate.dialect=”org.hibernate.dialect.Oracle10gDialect

blCMSStorage.hibernate.dialect=”org.hibernate.dialect.Oracle10gDialect

加入：

blPU.hibernate.hbm2ddl.import_files_sql_extractor=org.broadleafcommerce.common.util.sql.importsql.DemoOracleSingleLineSqlCommandExtractor

3.加入（这个目前没有发现具体作用）：

blEventPU.hibernate.hbm2ddl.import_files_sql_extractor=org.broadleafcommerce.common.util.sql.importsql.DemoOracleSingleLineSqlCommandExtractor

4.修改数据连接jndi文件，在site或者admin的src/main/webapp/META-INF/context.xml中加入：

<Resource name=”jdbc/web”

auth=”Container”

type=”javax.sql.DataSource”

factory=”org.apache.tomcat.jdbc.pool.DataSourceFactory”

testWhileIdle=”true”

testOnBorrow=”true”

testOnReturn=”false”

validationQuery=”SELECT 1″

timeBetweenEvictionRunsMillis=”30000″

maxActive=”15″

maxIdle=”10″

minIdle=”5″

removeAbandonedTimeout=”60″

removeAbandoned=”false”

logAbandoned=”true”

minEvictableIdleTimeMillis=”30000″

jdbcInterceptors=”org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;

org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer”

username=”eshop”

password=”eshop”

driverClassName=”oracle.jdbc.driver.OracleDriver”

url=”jdbc:oracle:thin:@192.168.77.6:1521:orcl”/>


<Resource name=”jdbc/storage”

auth=”Container”

type=”javax.sql.DataSource”

factory=”org.apache.tomcat.jdbc.pool.DataSourceFactory”

testWhileIdle=”true”

testOnBorrow=”true”

testOnReturn=”false”

validationQuery=”SELECT 1″

timeBetweenEvictionRunsMillis=”30000″

maxActive=”15″

maxIdle=”10″

minIdle=”5″

removeAbandonedTimeout=”60″

removeAbandoned=”false”

logAbandoned=”true”

minEvictableIdleTimeMillis=”30000″

jdbcInterceptors=”org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;

org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer”

username=”eshop”

password=”eshop”

driverClassName=”oracle.jdbc.driver.OracleDriver”

url=”jdbc:oracle:thin:@192.168.77.6:1521:orcl”/>



<Resource name=”jdbc/secure”

auth=”Container”

type=”javax.sql.DataSource”

factory=”org.apache.tomcat.jdbc.pool.DataSourceFactory”

testWhileIdle=”true”

testOnBorrow=”true”

testOnReturn=”false”

validationQuery=”SELECT 1″

timeBetweenEvictionRunsMillis=”30000″

maxActive=”15″

maxIdle=”10″

minIdle=”5″

removeAbandonedTimeout=”60″

removeAbandoned=”false”

logAbandoned=”true”

minEvictableIdleTimeMillis=”30000″

jdbcInterceptors=”org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;

org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer”

username=”eshop”

password=”eshop”

driverClassName=”oracle.jdbc.driver.OracleDriver”

url=”jdbc:oracle:thin:@192.168.77.6:1521:orcl”/>

5.Maven install site或者admin，表会自动插入数据库。
6.