SPRINGMVC Hibernate add multiple data sources (Sshe/sypro add multiple data sources as an example)

Source: Internet
Author: User
Tags save file
SPRINGMVC Hibernate add multiple data sources

(Example of adding multiple data sources to class Sshe/sypro)

Note: Applies to projects with SPRINGMVC + Hibernate. Other frameworks can only be used for reference.

Configure Spring Create a new spring data source configuration file, such as Spring-hibernate-aite.xml

How to create a new file without saying it.


The contents of the new spring data Source configuration file:

The content is able to copy the original Spring-hibernate.xml completely and then make the corresponding changes.

A.datasource the corresponding changes

<!--  Configure the Name property of the data source ①bean, it turns out that DataSource is now Datasourceaite --><bean name= "Datasourceaite" class= " Com.alibaba.druid.pool.DruidDataSource "init-method=" Init "destroy-method=" close "><property name=" url "value = "${jdbc_url_aite}"/><property name= "username" value= "${jdbc_username_aite}"/><property name= " Password "value=" ${jdbc_password_aite} "/><!--initialize connection size--><property name=" initialsize "value=" 0 "/> <!--connection pool maximum number of connections--><property name= "maxactive" value= "/><!--connection Pool Max spare--><property name=" Maxidle "value="/><!--connection Pool min spare--><property name= "Minidle" value= "0"/><!--get connection max wait time-->< Property Name= "Maxwait" value= "60000"/><property name= "Validationquery" value= "${validationquery}"/>< Property Name= "Testonborrow" value= "false"/><property name= "Testonreturn" value= "false"/><property name = "Testwhileidle" value= "true"/><!--configuration interval How often does a check detect the spare connection that needs to be closed, in milliseconds--&GT;&LT;PROperty name= "Timebetweenevictionrunsmillis" value= "60000"/><!--Configure the minimum time for a connection to survive in the pool. Units are milliseconds--><property name= "Minevictableidletimemillis" value= "25200000"/><!--open removeabandoned Function-- <property name= "removeabandoned" value= "true"/><!--1800 seconds, i.e. 30 minutes--><property name= " Removeabandonedtimeout "value=" 1800 "/><!--off abanded connection output error log--><property name=" logabandoned "value=" True "/><!--monitoring database--><!--<property name=" Filters "value=" stat "/>--><property name=" Filters " Value= "Mergestat"/></bean>
b.sessionfactory the corresponding changes
<!--Configure Hibernate session factory. ①bean id attribute, the original ID is sessionfactory now changed to Sessionfactoryaite;②datasource ref, the original is datasource now changed to the top with a new Data source name Datasourceaite--><bean id= "Sessionfactoryaite" class= " Org.springframework.orm.hibernate4.LocalSessionFactoryBean "><property name=" DataSource "ref=" Datasourceaite "/><property name=" hibernateproperties "><props><prop key=" Hibernate.hbm2ddl.auto ">none</prop><prop key=" Hibernate.dialect ">${hibernate.dialect}</prop><prop key=" Hibernate.show_sql ">${hibernate.show_sql}</prop><prop key=" Hibernate.format_sql ">${ hibernate.format_sql}</prop></props></property><!--to actively scan the Hibernate class file configured by annotation mode-->< Property Name= "Packagestoscan" ><list><value>sy.*.model</value></list></property ></bean>

c. Corresponding changes to the things manager
<!--<span style= "White-space:pre" ></span> Configure transaction manager <span style= "White-space:pre" ></span> ①bean's Name property, originally TransactionManager now changed to Transactionmanageraite<span style= "White-space:pre" ></span> ②sessionfactory ref, the original is sessionfactory now changed to the top with a new name Sessionfactoryaite<span style= "White-space:pre" ></ Span>--><span style= "White-space:pre" ></span><bean name= "Transactionmanageraite" class= " Org.springframework.orm.hibernate4.HibernateTransactionManager "><span style=" White-space:pre "></ Span><property name= "Sessionfactory" ref= "Sessionfactoryaite" ></property><span style= " White-space:pre "></span></bean>
D. Corresponding changes to the object interception rules
<!--interceptors to configure things ① with the newly created things manager above to manage the rules of things, the original ID is transactionadvice now changed to Transactionadviceaite② change ID. The original ID is transactionadvice now changed to Transactionadviceaite--><tx:advice id= "Transactionadviceaite" Transaction-manager= "Transactionmanageraite" ><tx:attributes><tx:method name= "add*" propagation= " REQUIRED "/><tx:method name=" append* "propagation=" REQUIRED "/><tx:method name=" save* "propagation=" REQUIRED "/><tx:method name=" update* "propagation=" REQUIRED "/><tx:method name=" modify* "propagation=" REQUIRED "/><tx:method name=" edit* "propagation=" REQUIRED "/><tx:method name=" del* "propagation=" REQUIRED "/><tx:method name=" delete* "propagation=" REQUIRED "/><tx:method name=" remove* "propagation=" REQUIRED "/><tx:method name=" Repair "propagation=" REQUIRED "/><tx:method name=" Delandrepair "propagation = "REQUIRED"/><tx:method name= "get*" propagation= "REQUIRED" read-only= "true"/><tx:method name= "find*" propagation= "REQUIRED" Read-only= "true"/><tx:method name= "load*" propagation= "REQUIRED" read-only= "true"/><tx:method name= " search* "propagation=" REQUIRED "read-only=" true "/><tx:method name=" datagrid* "propagation=" REQUIRED " Read-only= "true"/><tx:method name= "*" propagation= "REQUIRED" read-only= "true"/></tx:attributes> </tx:advice>

e.spring The corresponding changes to the facets configuration
<!--Add new rules to spring's Aop① change Advice-ref, Transactionadvice first changed to the top new name Transactionadviceaite--><aop:config ><aop:pointcut id= "transactionpointcut" expression= "Execution (* sy.*.service). *impl.* (..)) " /><aop:advisor pointcut-ref= "Transactionpointcut" advice-ref= "Transactionadviceaite"/></aop:config >

Save File

Here, the configuration of spring is basically finished.

change web. XML

To make the new data source configuration file Spring-hibernate-aite.xml Effective, you will need to add classpath in the Web. xml

<context-param><param-name>contextConfigLocation</param-name><!--Add Classpath: Spring-hibernate-aite.xml--><param-value>classpath:spring.xml,classpath:spring-hibernate.xml, Classpath:spring-hibernate-aite.xml</param-value></context-param>

Save File

This time. Be able to start the execution of the project to see if the error, in doing the next action

New DAO uses a new data source

There are several DAO that have several data sources

New Daoi

It is possible to copy the original Sy.dao.BaseDaoI.java directly into the same package folder and rename it to Sy.dao.AiteBaseDaoI.java

New Daoimpl

It is possible to copy the original Sy.dao.impl.BaseDaoImpl.java directly into the same package folder. Rename to Sy.dao.AiteBaseDaoImpl.java

Then make some minor adjustments:

/**repository originally was Basedao here changed into aitebasedao**/@Repository ("Aitebasedao") public class aitebasedaoimpl<t> Implements aitebasedaoi<t> {private static final Logger Logger=logger.getlogger (aitebasedaoimpl.class);/** Sessionfactory name is sessionfactory now changed into Sessionfactoryaite**/private sessionfactory sessionfactoryaite;public Sessionfactory Getsessionfactoryaite () {return sessionfactoryaite;} @Autowiredpublic void Setaitesessionfactory (Sessionfactory sessionfactoryaite) {this.sessionfactoryaite = Sessionfactoryaite;} Private Session getcurrentsession () {return this.sessionFactoryAite.getCurrentSession ();}

There's no change anywhere else.

After the DAO layer has been written. Ability to start the execution of the next project, see if there is an exception, and then proceed to the next step

Call of service layer
@Service ("Taskservice") public class Taskserviceimpl implements TASKSERVICEI {/** here with the new data source DAO is good. The others are consistent with the original **/private aitebasedaoi<ttask> tdao;public aitebasedaoi<ttask> Gettdao () {return tdao;} @Autowiredpublic void Settdao (aitebasedaoi<ttask> tdao) {This.tdao = Tdao;}


Here, from the configuration to the use of the finished, and then to complete your application it



SPRINGMVC Hibernate add multiple data sources (Sshe/sypro add multiple data sources as an example)

Large-Scale Price Reduction
  • 59% Max. and 23% Avg.
  • Price Reduction for Core Products
  • Price Reduction in Multiple Regions
undefined. /
Connect with us on Discord
  • Secure, anonymous group chat without disturbance
  • Stay updated on campaigns, new products, and more
  • Support for all your questions
undefined. /
Free Tier
  • Start free from ECS to Big Data
  • Get Started in 3 Simple Steps
  • Try ECS t5 1C1G
undefined. /

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.