ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lin, Ming {PBG}" <ming....@pepsi.com>
Subject RE: Ibatis truncates string
Date Wed, 14 Nov 2007 14:44:23 GMT
Larry,

Since it requires another build to change sql map on DEV. I took your
suggestion and declared @Help_text as follows. I still see the truncated
string on DEV. But, it works fine on my laptop. Both DEV and my laptop
use ibatis-2.3.0.677.jar.

declare @Help_text varchar(5000)

Select Help_text = text_header + 
        char(13) + char(13) + 
        text_detail +
        (Case When cust_key <> "" Then "<b>If the customer has the
key:</b><br/>" + cust_key Else "" End ) 
>From #trbl_text
Where help_id= @help_id
 

Thanks!
Ming

-----Original Message-----
From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] On Behalf
Of Larry Meadors
Sent: Wednesday, November 14, 2007 9:21 AM
To: user-java@ibatis.apache.org
Subject: Re: Ibatis truncates string

I don't see where Help_text is coming from - but there is a helptext1
variable that looks like it was to hold the result (helptext1
varchar(5000)).

You might try this:

Select Helptext1 = text_header +
        char(13) + char(13) +
        text_detail +
        (Case When cust_key <> "" Then "<b>If the customer has the
key:</b><br/>" + cust_key Else "" End )
>From #trbl_text
Where help_id= @help_id

How does that value get returned?

Larry


On Nov 14, 2007 7:06 AM, Lin, Ming {PBG} <ming.lin@pepsi.com> wrote:
> Hi, Larry,
>
> Please see the stored procedure as attached.
>
> Thanks!
> Ming
>
>
> -----Original Message-----
> From: larry.meadors@gmail.com [mailto:larry.meadors@gmail.com] On
Behalf
> Of Larry Meadors
> Sent: Wednesday, November 14, 2007 9:03 AM
> To: user-java@ibatis.apache.org
> Subject: Re: Ibatis truncates string
>
> Can you post the stored procedure?
>
> Larry
>
>
> On Nov 14, 2007 6:59 AM, Lin, Ming {PBG} <ming.lin@pepsi.com> wrote:
> > Hi,
> >
> > I would highly appreciate your help as our application needs to go
> Pilot
> > very soon!
> >
> > I find Ibatis returns truncated String (Help_Text) as shows in the
> > following log. I also copied my SQL Map below.
> >
> > Thanks a lot!
> > Ming
> > =====================Ibatis Log====================
> >
> >  {call ncets_getTroubleHelpText ( ? )}
> > 2007-11-13 11:11:42,076 DEBUG [ExecuteThread: '11' for queue:
> > 'weblogic.kernel.Default']            java.sql.PreparedStatement
-
> > {pstm-103250} Parameters: [13]
> > 2007-11-13 11:11:42,076 DEBUG [ExecuteThread: '11' for queue:
> > 'weblogic.kernel.Default']            java.sql.PreparedStatement
-
> > {pstm-103250} Types: [java.lang.Integer]
> > 2007-11-13 11:11:42,096 DEBUG [ExecuteThread: '11' for queue:
> > 'weblogic.kernel.Default']                    java.sql.ResultSet
-
> > {rset-103251} ResultSet
> > 2007-11-13 11:11:42,096 DEBUG [ExecuteThread: '11' for queue:
> > 'weblogic.kernel.Default']                    java.sql.ResultSet
-
> > {rset-103251} Header: [Help_text]
> > 2007-11-13 11:11:42,096 DEBUG [ExecuteThread: '11' for queue:
> > 'weblogic.kernel.Default']                    java.sql.ResultSet
-
> > {rset-103251} Result: [<b>Fountain Postmix No Syrup</b><br/>^M^MIs
the
> > CO2 supply empty?<br/>If the gauge dial is all the way into red at 0
> (on
> > peg), you are out of CO2 .  Change the CO2 tank.<br/><br/>Are the
BIB
> or
> > tank connectors on property?<br/>Unhook and rehook the tank or ]
> >
> >
> > ==================== SQL Map===========================
> >
> >         <!-- Get Help Text for Script Button -->
> >         <parameterMap id="ncets_getTroubleHelpText-parameters"
> > class="map">
> >                 <parameter property="helpId" jdbcType="INTEGER"
> > javaType="java.lang.Integer" mode="IN"/>
> >         </parameterMap>
> >
> >         <procedure id="ncets_getTroubleHelpText"
> > parameterMap="ncets_getTroubleHelpText-parameters"
> >                 resultClass="java.lang.String"> {call
> > ncets_getTroubleHelpText ( ? )} </procedure>
> >
> >
> >
>

Mime
View raw message