You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Clinton Begin (JIRA)" <ib...@incubator.apache.org> on 2005/09/18 20:57:57 UTC
[jira] Closed: (IBATIS-78) JDBC driver properties does not work when using DBCP
[ http://issues.apache.org/jira/browse/IBATIS-78?page=all ]
Clinton Begin closed IBATIS-78:
-------------------------------
> JDBC driver properties does not work when using DBCP
> ----------------------------------------------------
>
> Key: IBATIS-78
> URL: http://issues.apache.org/jira/browse/IBATIS-78
> Project: iBatis for Java
> Type: Bug
> Components: SQL Maps
> Versions: 2.0.9
> Environment: Windows, Tomcat 5.0, Oracle 9i
> Reporter: Sukhyung Lee
> Assignee: Brandon Goodin
> Fix For: 2.1.0
>
> I am using iBatis Sqlamp with Oracle and have Oracle type compare problem.
> Oracle CHAR type compare problem is :
> 1) User table has user_id = '111'
> 2) user_id column type is CHAR(7)
> 3) When I set user_id = "111" and the select statement could NOT find the row.
> 4) When I set user_id = "111 " and the select statement could find the row.
> The java source code is here.
> String user_id = "111"; // Search fail
> //String user_id = "111 "; // Search successful
> try
> {
> User user = new User();
> user.setUser_id(user_id);
> user = (User) sqlMap.queryForObject("getUser", user);
> if (user == null)
> {
> System.out.print("Can not find User . user_id=" + user_id);
> }
> else
> {
> System.out.println("User Information:");
> System.out.println("user_id=" + user.getUser_id());
> System.out.println("user_name=" + user.getUser_name());
> }
> }
> I set Driver.fixedString to true to solve Oracle CHAR type compare problem like below. (Actually to solve this problem I need Custom Type Handler also)
> <transactionManager type="JDBC">
> <dataSource type="SIMPLE">
> <property value="${driver}" name="JDBC.Driver"/>
> <property value="${url}" name="JDBC.ConnectionURL"/>
> <property value="${username}" name="JDBC.Username"/>
> <property value="${password}" name="JDBC.Password"/>
> <property value="128" name="Pool.MaximumActiveConnections"/>
> <property value="128" name="Pool.MaximumIdleConnections"/>
> <property value="1000" name="Pool.MaximumWait"/>
> <!-- To resolve Oracle CHAR Type compare problem, need fixedString=true-->
> <property value="true" name="Driver.fixedString"/>
> </dataSource>
> </transactionManager>
> It worked fine and I and trying to use DBCP instead of SimpleDataSource and
> modified transactionMangager definition like below.
> <transactionManager type="JDBC">
> <dataSource type="DBCP">
> <property value="${driver}" name="JDBC.Driver"/>
> <property value="${url}" name="JDBC.ConnectionURL"/>
> <property value="${username}" name="JDBC.Username"/>
> <property value="${password}" name="JDBC.Password"/>
> <property value="15" name="Pool.MaximumActiveConnections"/>
> <property value="1" name="Pool.MaximumIdleConnections"/>
> <property value="5000" name="Pool.MaximumWait"/>
> <!-- To resolve Oracle CHAR Type compare problem, need fixedString=true-->
> <property value="true" name="Driver.fixedString"/>
> <!-- DBCP Property -->
> <property value="select count(*) from dual" name="Pool.ValidationQuery"/>
> <property value="true" name="Pool.LogAbandoned"/>
> <property value="false" name="Pool.RemoveAbandoned"/>
> <property value="50000" name="Pool.RemoveAbandonedTimeout"/>
> </dataSource>
> </transactionManager>
> With above transactionManager definition, fixedString JDBC connection property does not set to true and CHAR type compare problem occured again.
> Could you please help me to solve this problem?
> Regards,
> Sukhyung Lee
> Inzent Co., Ltd
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira