runtime/org.argeo.slc.server/src/main/resources/org/argeo/slc/server/spring/db-osgi.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         <!--
  15                 Use session factories <bean id="sessionFactory"
  16                 parent="${sessionFactoryParentBean}" />
  17         -->
  18         <bean id="sessionFactory" parent="slcTemplates.sessionFactory.hibernateBasic">
  19                 <property name="dataSource" ref="slcDefault.dataSource.inMemoryTestHSQL" />
  20                 <property name="hibernateProperties">
  21                         <value><![CDATA[
  22                                 hibernate.dialect=org.hibernate.dialect.HSQLDialect
  23                                 hibernate.hbm2ddl.auto=create
  24                                 hibernate.generate_statistics=true
  25                                 hibernate.connection.autocommit=false
  26                         ]]></value>
  27                 </property>
  28         </bean>
  29
  30
  31         <!--  JNDI data source  -->
  32         <bean id="slcDefault.jndiTemplate" class="org.springframework.jndi.JndiTemplate">
  33         </bean>
  34
  35         <bean id="slcDefaut.dataSourceJndi" class="org.springframework.jndi.JndiObjectFactoryBean">
  36                 <property name="jndiTemplate" ref="slcDefault.jndiTemplate" />
  37                 <property name="jndiName" value="java:comp/env/jdbc/mainDs" />
  38         </bean>
  39
  40         <!-- DB types -->
  41         <bean id="slcServerDefault.sessionFactory.HSQL" parent="slcTemplates.sessionFactory.hibernateBasic">
  42                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  43                 <property name="hibernateProperties">
  44                         <value><![CDATA[
  45                                 hibernate.dialect=org.hibernate.dialect.HSQLDialect
  46                                 hibernate.hbm2ddl.auto=update
  47                                 hibernate.connection.autocommit=false
  48                         ]]></value>
  49                 </property>
  50         </bean>
  51
  52         <bean id="slcServerDefault.sessionFactory.HSQLTest" parent="slcTemplates.sessionFactory.hibernateBasic">
  53                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  54                 <property name="hibernateProperties">
  55                         <value><![CDATA[
  56                                 hibernate.dialect=org.hibernate.dialect.HSQLDialect
  57                                 hibernate.hbm2ddl.auto=create
  58                                 hibernate.generate_statistics=true
  59                                 hibernate.connection.autocommit=false
  60                         ]]></value>
  61                 </property>
  62         </bean>
  63
  64         <bean id="slcServerDefault.sessionFactory.MySQL" parent="slcTemplates.sessionFactory.hibernateBasic">
  65                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  66                 <property name="hibernateProperties">
  67                         <value><![CDATA[
  68                                 hibernate.dialect=org.hibernate.dialect.MySQLDialect
  69                                 hibernate.hbm2ddl.auto=update
  70                                 hibernate.connection.autocommit=false
  71                         ]]></value>
  72                 </property>
  73         </bean>
  74
  75         <bean id="slcServerDefault.sessionFactory.MySQL5" parent="slcTemplates.sessionFactory.hibernateBasic">
  76                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  77                 <property name="hibernateProperties">
  78                         <value><![CDATA[
  79                 hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
  80                 hibernate.hbm2ddl.auto=update
  81                 hibernate.connection.autocommit=false
  82             ]]></value>
  83                 </property>
  84         </bean>
  85
  86         <bean id="slcServerDefault.sessionFactory.Sybase" parent="slcTemplates.sessionFactory.hibernateBasic">
  87                 <property name="dataSource" ref="slcDefaut.dataSourceJndi" />
  88                 <property name="hibernateProperties">
  89                         <value><![CDATA[
  90                 hibernate.dialect=org.hibernate.dialect.SybaseDialect
  91                 hibernate.hbm2ddl.auto=update
  92                 hibernate.connection.autocommit=false
  93             ]]></value>
  94                 </property>
  95         </bean>
  96
  97         <!-- DAOs -->
  98         <bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate">
  99                 <property name="sessionFactory" ref="sessionFactory" />
 100                 <property name="allowCreate" value="false" />
 101         </bean>
 102
 103         <bean id="testResultDao" parent="slcTemplates.dao.testResultDao">
 104                 <property name="hibernateTemplate" ref="hibernateTemplate" />
 105         </bean>
 106
 107         <bean id="testResultCollectionDao" parent="slcTemplates.dao.testResultCollectionDao">
 108                 <property name="hibernateTemplate" ref="hibernateTemplate" />
 109         </bean>
 110
 111         <bean id="testRunDescriptorDao" parent="slcTemplates.dao.testRunDescriptorDao">
 112                 <property name="hibernateTemplate" ref="hibernateTemplate" />
 113         </bean>
 114
 115         <bean id="slcExecutionDao" parent="slcTemplates.dao.slcExecutionDao">
 116                 <property name="hibernateTemplate" ref="hibernateTemplate" />
 117         </bean>
 118
 119         <bean id="slcAgentDescriptorDao" parent="slcTemplates.dao.slcAgentDescriptorDao">
 120                 <property name="hibernateTemplate" ref="hibernateTemplate" />
 121         </bean>
 122
 123         <!-- Hibernate instrumentation -->
 124         <bean id="osivInterceptor"
 125                 class="org.springframework.orm.hibernate3.support.OpenSessionInViewInterceptor">
 126                 <property name="sessionFactory" ref="sessionFactory" />
 127         </bean>
 128
 129         <!-- Transaction -->
 130         <bean id="transactionManager"
 131                 class="org.springframework.orm.hibernate3.HibernateTransactionManager"
 132                 lazy-init="false">
 133                 <property name="sessionFactory" ref="sessionFactory" />
 134         </bean>
 135
 136 </beans>