runtime/org.argeo.slc.server/src/main/resources/org/argeo/slc/server/spring/db.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <beans xmlns="http://www.springframework.org/schema/beans"
   3         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop"
   4         xmlns:tx="http://www.springframework.org/schema/tx"
   5         xsi:schemaLocation="
   6        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
   7        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd
   8        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd"
   9         default-lazy-init="true">
  10
  11         <import
  12                 resource="classpath:/org/argeo/slc/hibernate/spring/applicationContext.xml" />
  13
  14         <!-- Use session factories -->
  15         <bean id="sessionFactory" parent="${sessionFactoryParentBean}" />
  16
  17         <!--  JNDI data source  -->
  18         <bean id="slcDefault.jndiTemplate" class="org.springframework.jndi.JndiTemplate">
  19         </bean>
  20
  21         <bean id="slcDefaut.dataSourceJndi" class="org.springframework.jndi.JndiObjectFactoryBean">
  22                 <property name="jndiTemplate" ref="slcDefault.jndiTemplate" />
  23                 <property name="jndiName" value="java:comp/env/jdbc/mainDs" />
  24         </bean>
  25
  26         <!-- DB types -->
  27         <bean id="slcServerDefault.sessionFactory.HSQL" parent="slcTemplates.sessionFactory.hibernateBasic">
  28                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  29                 <property name="hibernateProperties">
  30                         <value><![CDATA[
  31                                 hibernate.dialect=org.hibernate.dialect.HSQLDialect
  32                                 hibernate.hbm2ddl.auto=update
  33                                 hibernate.connection.autocommit=false
  34                         ]]></value>
  35                 </property>
  36         </bean>
  37
  38         <bean id="slcServerDefault.sessionFactory.HSQLTest" parent="slcTemplates.sessionFactory.hibernateBasic">
  39                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  40                 <property name="hibernateProperties">
  41                         <value><![CDATA[
  42                                 hibernate.dialect=org.hibernate.dialect.HSQLDialect
  43                                 hibernate.hbm2ddl.auto=create
  44                                 hibernate.generate_statistics=true
  45                                 hibernate.connection.autocommit=false
  46                         ]]></value>
  47                 </property>
  48         </bean>
  49
  50         <bean id="slcServerDefault.sessionFactory.MySQL" parent="slcTemplates.sessionFactory.hibernateBasic">
  51                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  52                 <property name="hibernateProperties">
  53                         <value><![CDATA[
  54                                 hibernate.dialect=org.hibernate.dialect.MySQLDialect
  55                                 hibernate.hbm2ddl.auto=update
  56                                 hibernate.connection.autocommit=false
  57                         ]]></value>
  58                 </property>
  59         </bean>
  60
  61         <bean id="slcServerDefault.sessionFactory.MySQL5" parent="slcTemplates.sessionFactory.hibernateBasic">
  62                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  63                 <property name="hibernateProperties">
  64                         <value><![CDATA[
  65                 hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
  66                 hibernate.hbm2ddl.auto=update
  67                 hibernate.connection.autocommit=false
  68             ]]></value>
  69                 </property>
  70         </bean>
  71
  72         <bean id="slcServerDefault.sessionFactory.Sybase" parent="slcTemplates.sessionFactory.hibernateBasic">
  73                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  74                 <property name="hibernateProperties">
  75                         <value><![CDATA[
  76                 hibernate.dialect=org.hibernate.dialect.SybaseDialect
  77                 hibernate.hbm2ddl.auto=update
  78                 hibernate.connection.autocommit=false
  79             ]]></value>
  80                 </property>
  81         </bean>
  82
  83         <!-- DAOs -->
  84         <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
  85                 <property name="sessionFactory" ref="sessionFactory" />
  86                 <property name="allowCreate" value="false" />
  87         </bean>
  88
  89         <bean id="testResultDao" parent="slcTemplates.dao.testResultDao">
  90                 <property name="hibernateTemplate" ref="hibernateTemplate" />
  91         </bean>
  92
  93         <bean id="testResultCollectionDao" parent="slcTemplates.dao.testResultCollectionDao">
  94                 <property name="hibernateTemplate" ref="hibernateTemplate" />
  95         </bean>
  96
  97         <bean id="testRunDescriptorDao" parent="slcTemplates.dao.testRunDescriptorDao">
  98                 <property name="hibernateTemplate" ref="hibernateTemplate" />
  99         </bean>
 100
 101         <bean id="slcExecutionDao" parent="slcTemplates.dao.slcExecutionDao">
 102                 <property name="hibernateTemplate" ref="hibernateTemplate" />
 103         </bean>
 104
 105         <bean id="slcAgentDescriptorDao" parent="slcTemplates.dao.slcAgentDescriptorDao">
 106                 <property name="hibernateTemplate" ref="hibernateTemplate" />
 107         </bean>
 108
 109         <!-- Hibernate instrumentation -->
 110         <bean id="osivInterceptor"
 111                 class="org.springframework.orm.hibernate3.support.OpenSessionInViewInterceptor">
 112                 <property name="sessionFactory" ref="sessionFactory" />
 113         </bean>
 114
 115         <!-- Transaction -->
 116         <bean id="transactionManager"
 117                 class="org.springframework.orm.hibernate3.HibernateTransactionManager"
 118                 lazy-init="false">
 119                 <property name="sessionFactory" ref="sessionFactory" />
 120         </bean>
 121
 122 </beans>