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.