How does iBatis and Spring dataSource communicate?

data-source.xml from META-INF
 
<?xml version = '1.0' encoding = 'windows-1252'?>
<data-sources xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
              xsi:noNamespaceSchemaLocation="http://xmlns.oracle.com/oracleas/schema/data-sources-10_1.xsd">
 <connection-pool name="jdev-connection-pool-qol_authschema">
                <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource"
                            user="qol"
                            password="->DataBase_User_bIyBdAJbKjpFHjI5nadAIJsLYXMVmja9"
                            url="jdbc:oracle:thin:@*****"/>
    </connection-pool>
    <managed-data-source name="jdev-connection-managed-qol_authschema"
                         jndi-name="jdbc/qol_authschemaDS"
                         connection-pool-name="jdev-connection-pool-qol_authschema"/>
    <native-data-source name="jdev-connection-native-qol_authschema"
                        jndi-name="jdbc/qol_authschemaCoreDS"
                        url="jdbc:oracle:thin:@******"
                        user="qol"
                        password="->DataBase_User_8ftciduUIkFSgxCaZr-1rh-0jLvq1hen"
                        data-source-class="oracle.jdbc.pool.OracleDataSource"/>
</data-sources>
 
SqlMapConfig.xml
 
 
<?xml version="1.0" encoding="UTF-8" ?>
 
<!DOCTYPE sqlMapConfig
    PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
 
<sqlMapConfig>
 
  <properties resource="jdbc.properties"/>  
  <transactionManager type="JDBC">
    <dataSource type="SIMPLE">
      <property name="JDBC.Driver" value="${jdbc.driverClassName}"/>
      <property name="JDBC.ConnectionURL" value="${jdbc.url}"/>
      <property name="JDBC.Username" value="${jdbc.username}"/>
      <property name="JDBC.Password" value="${jdbc.password}"/>      
      <property name="JDBC.Class" value="oracle.jdbc.pool.OracleDataSource"/>
      <property name="JDBC.DefaultAutoCommit" value="false" /> 
      <property name="Pool.MaximumActiveConnections" value="10"/>
      <property name="Pool.MaximumIdleConnections" value="5"/>
      <property name="Pool.MaximumCheckoutTime" value="120000"/>
      <property name="Pool.TimeToWait" value="500"/>
    </dataSource> 
  </transactionManager> 
 
spring.xml
 
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN 2.0//EN"
		  "http://www.springframework.org/dtd/spring-beans-2.0.dtd">
<beans>
 
 <bean id="sqlMapClient"
          class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
        <property name="configLocation">
            <value>classpath:org/nexweb/qol/gcc/ibatis/config/SqlMapConfig.xml</value>
        </property>
 </bean>
<bean id="sqlMapClientTemplate"
          class="org.springframework.orm.ibatis.SqlMapClientTemplate">
        <property name="sqlMapClient">
            <ref bean="sqlMapClient"/>
        </property>
    </bean>
 
  <bean id="customerDao" class="org.nexweb.qol.gcc.ibatis.dao.sqlmaps.CustomerSqlMapDAO"> 
        <property name="sqlMapClient"> 
            <ref bean="sqlMapClient"/> 
        </property> 
    </bean>     
 
    <bean id="customerService" class="org.nexweb.qol.gcc.ibatis.services.CustomerService"> 
        <constructor-arg index="0" ref="customerDao"/> 
    </bean> 
 
CustomerSqlMapDAO 
 
public class CustomerSqlMapDAO extends SqlMapClientTemplate implements CustomerDAO 
{ 
  public Integer insertCustomer(CustomerVO customerVo) throws DataAccessException { 
        return (Integer)insert("insertCustomer", customerVo); 
    } 
 
    public Integer insertCustomerDependent(CustomerDependentVO customerDependentVo) throws DataAccessException { 
        return (Integer)insert("insertCustomerDependent", customerDependentVo); 
    } 
 
CustomerService 
 
public class CustomerService extends CommonService 
{ 
    private CustomerDAO customerDAO; 
 
    public CustomerService(CustomerDAO customerDAO) 
    { 
        super(customerDAO); 
        this.customerDAO = customerDAO; 
    }   
 
public Integer insertCustomer(CustomerVO customerVo) throws DataAccessException  { 
        return customerDAO.insertCustomer(customerVo); 
    } 
 
    public Integer insertCustomerDependent(CustomerDependentVO customerDependentVo) throws DataAccessException  { 
        return customerDAO.insertCustomerDependent(customerDependentVo); 
    } 
 
 
CustomerAction.java 
 
CustomerService customerService = SpringBeans.getCustomerService(); 
try 
{ 
                  // retrieve cust_id from QOL_CUSTOMER using qol_customer_seq.NEXTVAL 
         custId = customerService.getCustomerId();               
 
        customerService.startTransaction(); 
         // start batch process 
        customerService.startBatch(); 
 
        // insert record into QOL_CUSTOMER table (add to batch process) 
         customerService.insertCustomer(customerVo); 
 
         // retrive dependent first/last name for insertion check to QOL_DEPENDENT tabel 
         String custDepFirstName = customerPersonalForm.getDepFirstName(); 
         String custDepLastName = customerPersonalForm.getDepLastName(); 
        // insert into DEPENDENT table only if dependent first/last name enterd on the form 
         if (StringUtils.isNotBlank(custDepFirstName) || StringUtils.isNotBlank(custDepLastName)) 
         { 
           customerDependentVo.setCustId(custId); 
           // set CustomerDependentVO to CustomerVO only if dependent first/last name exist and 
           // record to DEPENDENT is going to be inserted in for this customer id 
           customerVo.setCustomerDependentVo(customerDependentVo);           
           // insert record into DEPENDENT table (add to batch process) 
           customerService.insertCustomerDependent(customerDependentVo); 
         } 
         // insert record into VEHICLE table (add to batch process) 
         customerVehicleService.insertCustomerVehicle(customerVehicleVo);       --> same issue with this insert, if i remove constraint from DEPENDENT 
         // execute batch 
         customerService.executeBatch(); 
 
         // end batch process 
        customerService.commitTransaction(); 
     } 
       catch(SQLException sqlEx) 
       {  ........... 
}  
Open in New Window Select All
                                  

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
141:
142:
143:
144:
145:
146:
147:
148:
149:
150:
151:
152: