[
https://issues.apache.org/jira/browse/IBATIS-473?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jeff Butler closed IBATIS-473.
------------------------------
Resolution: Invalid
Several things...
1. Use the mailing lists for support questions
2. This is not a bug in iBATIS - it's that way databases work! This is why
it's better to use VARCHAR than CHAR in many cases.
3. The bug you reference was simply a way to forward an Oracle specific driver
property during configuration. This is not applicable in your situation
because you are using JNDI.
4. You need to configure your JNDI datasource to add the Oracle driver property
"fixedString=true". This is done in the WebSphere console - not in iBATIS.
5. For your JUNIT tests, you need to configure iBATIS differently - using
either SIMPLE or DBCP data sources and setting the property as shown in
IBATIS-78
> see IBATIS-78
> -------------
>
> Key: IBATIS-473
> URL: https://issues.apache.org/jira/browse/IBATIS-473
> Project: iBatis for Java
> Issue Type: Bug
> Components: DAO
> Affects Versions: 2.3.0
> Environment: JVM 1.5 with Spring Trasaction
> Reporter: Daniele Valentini
> Priority: Critical
>
> I've read a bug (2005) IBATIS-78 that there is a problem with JDBC Driver
> Oracle when the select staement is a follow:
> "select * from [tableName] where [fieldName]=#value#"
> where a fieldName is defined a CHAR(10) type and the parameter passed (value)
> is a java.lang.String type.
> if the parameter is : "ABCD " the record found it! and if parameter is :
> "ABC" the records not found!.
> I use a class JDBC : oracle.jdbc.pool.OracleDataSource present in the jar
> file named ojdbc14.jar (Oracle 10.2g)
> The fix present in precedent Bug say that the problem is present with a DBCP
> (BasicDataSource)
> The problem is very critical for my Project .
> How to ?????
> I've read also that the property the DataSource Driver.fixedString imposted a
> true value but the property in my class JDBC
> (oracle.jdbc.pool.OracleDataSource) not is present
> PS. i use in jndi for localized a dataSource in my Server WAS 6.1 but the
> problem is present also in Junit Test without a server .
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
