ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-455) iBatis - Additional space gets added in the SQL Server table fields while the data gets added.
Date Thu, 06 Sep 2007 16:40:31 GMT

    [ https://issues.apache.org/jira/browse/IBATIS-455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12525456

Brandon Goodin commented on IBATIS-455:

It is best for you to post questions like this to the user list. Once it is confirmed as a
bug you should enter it here. I would encourage you to try this with straight jdbc. It may
be an issue with your JDBC driver. Additionally, it would be good for you to enabling logging
and provide the logging output that occurs during this operation. I can say that iBATIS does
nothing unusual. It uses PreparedStatement to set values underneath just like straight JDBC

> iBatis - Additional space gets added in the SQL Server table fields while the data gets
> ----------------------------------------------------------------------------------------------
>                 Key: IBATIS-455
>                 URL: https://issues.apache.org/jira/browse/IBATIS-455
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects Versions: 2.3.0
>         Environment: Windows XP, SQL SERVER 2000.
>            Reporter: Vyas
> I have a field defined in the SQL SERVER table (SHPG_CAT) as below.
> And the data is inserted to this field using the following Insert Query defined in iBatis
Query Map,
> <insert id="insertShippingCategory" parameterClass="com.bestbuy.rise.sdi.dataobject.ShippingDO">
>   VALUES (#bsnsHierID#, #shpgCatDesc#,
>   #shpgMthdTypCode#,#recCreateTS#,#recCreateUserID#,#recUpdateTS#,#recUpdUserID#)
> </insert>
> Issue: During Runtime, if Ienter a value in the description like - TEST, it gets added
to this database field as TEST + (251 spaces)
> I made sure that from the when the parameter is passed to the Query Map from Java, its
trimmed. But still trailing spaces comes in the field. Please let me know if this is a bug
or I'm doing something wrong.
> As of now, I have added RTRIM(#shpgCatDesc#) in the query to trim the space. Is this
the only solution?

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message