mySQL使用配置文档.docxVIP

mySQL使用配置方案修改datasource.xml修改相应驱动、url、用户名和密码。示例代码如下： module:service id=dataSourceService beanId=dataSource targetName=javax.sql.DataSource/ bean id=dataSource name=dataSource class=mons.dbcp.BasicDataSource destroy-method=close property name=driverClassName value=com.mysql.jdbc.Driver/ property name=url value=jdbc:mysql://localhost:3306/sampledb/ property name=username value=root/ property name=password value=root/ property name=maxActive value=100/ property name=maxIdle value=30/ property name=maxWait value=5000/ property name=defaultAutoCommit value=true/ property name=removeAbandoned value=true/ property name=removeAbandonedTimeout value=60/ property name=logAbandoned value=true/ /bean 新建持久层扩展模块新建com.sgcc.uap.core.persistence.config的扩展模块，在扩展模块新增config目录，在该目录下增加perties、persistence.xml如下图：修改perties文件方言为对应的MySQL方言。内容如下：# mysql sessionFactory.hibernateProperties[hibernate.dialect] = org.hibernate.dialect.MySQLDialectsessionFactory.hibernateProperties[hibernate.show_sql] = truesessionFactory.hibernateProperties[hibernate.jdbc.fetch_size] = 50sessionFactory.hibernateProperties[hibernate.jdbc.batch_size] = 100sessionFactory.hibernateProperties[hibernate.cache.use_query_cache] = false修改persistence.xml文件,内容如下：?xml version=1.0 encoding=UTF-8?beans xmlns=/schema/beansxmlns:xsi=/2001/XMLSchema-instancexsi:schemaLocation=/schema/beans /schema/beans/spring-beans.xsdbean id=configBeanclass=org.springframework.beans.factory.config.PropertyOverrideConfigurerproperty name=location value=/config/perties //beanbean id=sessionFactory class=com.sgcc.uap.kernel.hibernate.ModuleSessionFactoryBeanautowire=byNameproperty name=lobHandlerref local= defaultLobHandler //propertyproperty name=hibernatePropertiespropsprop key=hibernate.dialectorg.hibernate.dialect.MySQLDialect/propprop key=hibernate.show_sqltrue/propprop key=hibernate.jdbc.fetch_size50/propprop key=hibernate.jdbc.batch_size100/prop/props/propertyproperty name=dataSourceref bean=proxyDataSource //property/beanbean id=txProxy