I am using ibatis and oracle 10. The jdbc driver is
oracle.jdbc.driver.OracleDriver. When I retrieve data from table, I found a
space ' ' is appended. Let's say  column ACTIVE_IND CHAR(1), the data
retrieved is 'A '. is it weird? Does anybody have idea?

Thanks a lot,

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC
"-//SPRING//DTD 
BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd";>

<beans>
        <!--  Data source bean -->
        <bean id="disDataSource"
class="com.xxx.xxx.service.util.ExtendedBasicDataSource"
destroy-method="close">
          <property name="driverClassName"
value="oracle.jdbc.driver.OracleDriver"/>
          <property name="url" value="jdbc:oracle:thin:@169.31.1.62:1521:yyyy"/>
          <property name="username" value="xxxx"/>
          <property name="password" value="xxxx"/>
          <property name="connectionProperties">
              <props>
                <prop key="fixedString">true</prop>
              </props>
          </property>
        </bean>
        <bean id="prodDataSource" 
class="org.apache.commons.dbcp.BasicDataSource"
destroy-method="close">
                <!--
                INSERT CONFIG PROPERTIES FOR PRODUCTION DATABASE (Oracle, SQL 
Server,
MySQL, and etc.)
                -->
        </bean>
        <!--  Web SqlMap setup for iBATIS Database Layer -->
  <bean id="sqlMapClient" 
          class="org.springframework.orm.ibatis.SqlMapClientFactoryBean"> 
       <property name="configLocation">
         <value>/WEB-INF/sqlMapConfig.xml</value>
       </property>   
  </bean>
  <bean name="DataBaseAccess" class="com.xxx.xxx.common.IbatisDao"
singleton="false"> 
       <property name="dataSource"><ref bean="xxxDataSource"/></property>
       <property name="sqlMapClient"><ref local="sqlMapClient"/></property>
       <property name="txTemplate"><ref local="txTemplate"/></property> 
  </bean>
  
  <bean id="txManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="disDataSource"/>
  </bean>
  
  <bean id="txTemplate"
class="org.springframework.transaction.support.TransactionTemplate">
        <property name="transactionManager" ref="txManager"/>
  </bean>
  
</beans>


-- 
View this message in context: 
http://www.nabble.com/about-a-space-at-the-end-tf4851669.html#a13881815
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Reply via email to