context-hibernate.xml

주석으로 설명 달아 놓았습니다. 이해가 안가시는분은 댓글 달아 주세요.

was 에 따라서 멀티 db가 조금 꼬여서 톰캣서버에서는 잘되는데 jboss에서는 되긴 되는데 조금 db연결이 꼬여서 제외 했습니다. 멀티 db 마이바티스는 잘됩니다. jpa도 톰캣서버에서는 멀티 db 잘됩니다.

java

닫기 줄바꿈

<?xml version="1.0" encoding="utf-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
‌xmlns:context="http://www.springframework.org/schema/context"
‌xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
‌xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
‌‌http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
‌
‌<!-- DB1 postgreSql 셋팅 컨테이너가 관리하는 EntityManager 생성, @PersistenceContext와 함께 사용 -->
‌​<!--
‌<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" primary="true">
​​​​-->
‌<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean" >
‌‌
‌‌<!-- postgreSql -->
‌‌<property name="dataSource" ref="egov.postgreDataSource" />
‌‌<!-- entity 어노테이션 매핑정보 스캔 --> 
‌‌<property name="packagesToScan" value="egovframework.invako.domain" /> 
‌‌​​
​​​​​​​​<!-- 
​​​​​​​​<property name="packagesToScan" value="egovframework.invako.postgre.domain" />  
​​​​​​​​<property name="packagesToScan" value="egovframework" />
​​​​​​​​​--> 
​​​​​​​​​​​​​
‌‌<!-- 구현체별 자체 기능을 표준화 -->
‌‌<property name="jpaVendorAdapter">
‌‌‌<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
‌‌‌‌<property name="showSql" value="true" />
‌‌‌‌<property name="generateDdl" value="true" />
‌‌‌</bean>
‌‌</property>
‌‌<!-- persistence.xml 설정정보와 함께 사용가능 --> 
‌​​
‌‌<property name="persistenceUnitName" value="postgresqlPersistenceUnit" />

‌‌<property name="jpaProperties">
‌‌‌<props>
‌‌‌‌<prop key="hibernate.naming.implicit-strategy">org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyJpaImpl</prop>
‌‌‌‌<prop key="hibernate.naming.physical-strategy">org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl</prop>
‌‌‌‌<prop key="hibernate.hbm2ddl.auto">none</prop>
‌‌‌‌<!-- 
‌‌‌​​​​<prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>
‌‌‌​​​​-->
‌‌‌​​​​<prop key="hibernate.dialect">egovframework.invako.querydsl.config.CustomPostgreSQLDialect</prop>
‌‌‌‌<prop key="hibernate.show_sql">true</prop>                
‌‌‌‌<prop key="hibernate.format_sql">true</prop>                
‌‌‌‌<prop key="hibernate.use_sql_comments">true</prop>         
‌‌‌‌<prop key="hibernate.jdbc.batch_size">5</prop>
‌‌‌‌<!-- 스키마설정 default:public -->
‌‌‌‌<!-- 
‌‌‌‌<prop key="hibernate.default_schema">${yourSchema}</prop>
‌‌‌‌-->
‌‌‌</props>
‌‌</property>
‌‌‌‌
‌‌​<!-- 
‌‌<property name="persistenceXmlLocation" value="classpath:META-INF/persistence.xml" />
‌‌-->
‌‌
‌</bean> 
‌​
‌<!-- DB2 tibero 컨테이너가 관리하는 EntityManager 생성, @PersistenceContext와 함께 사용 -->
‌<!-- tomcat 잘되는 jboss에는 멀티db셋팅시 영속성에 오류가 나서 제외함 -->
‌<!-- 
‌<bean id="entityManagerFactory2" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
‌‌
‌‌<property name="dataSource" ref="egov.tiberoDataSource" /> 
‌‌​
​​​​​​​​​<property name="packagesToScan" value="egovframework.invako.tibero.domain" />

‌‌<property name="jpaVendorAdapter">
‌‌‌<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
‌‌‌‌<property name="showSql" value="true" />
‌‌‌‌<property name="generateDdl" value="true" />
‌‌‌</bean>
‌‌</property>
‌​​
‌‌<property name="persistenceUnitName" value="tiberoPersistenceUnit" />
‌
‌‌<property name="jpaProperties">
‌‌‌<props>
‌‌‌‌<prop key="hibernate.naming.implicit-strategy">org.hibernate.boot.model.naming.ImplicitNamingStrategyLegacyJpaImpl</prop>
‌‌‌‌<prop key="hibernate.naming.physical-strategy">org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl</prop>

‌‌‌‌<prop key="hibernate.hbm2ddl.auto">none</prop>
‌‌‌‌<prop key="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</prop>
‌‌‌‌<prop key="hibernate.show_sql">true</prop>                
‌‌‌‌<prop key="hibernate.format_sql">true</prop>                
‌‌‌‌<prop key="hibernate.use_sql_comments">true</prop>         
‌‌‌‌<prop key="hibernate.jdbc.batch_size">5</prop>
‌‌‌</props>
‌‌</property> 
‌‌​
‌‌<property name="persistenceXmlLocation" value="classpath:META-INF/persistence.xml" />
‌‌
‌</bean>
‌-->

</beans>