You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by "Lin, Ming {PBG}" <mi...@pepsi.com> on 2007/11/14 14:59:30 UTC
Ibatis truncates string
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>
RE: Ibatis truncates string
Posted by "Lin, Ming {PBG}" <mi...@pepsi.com>.
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} <mi...@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} <mi...@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>
> >
> >
> >
>
Re: Ibatis truncates string
Posted by Larry Meadors <lm...@apache.org>.
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} <mi...@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} <mi...@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>
> >
> >
> >
>
RE: Ibatis truncates string
Posted by "Lin, Ming {PBG}" <mi...@pepsi.com>.
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} <mi...@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>
>
>
>
Re: Ibatis truncates string
Posted by Larry Meadors <lm...@apache.org>.
Can you post the stored procedure?
Larry
On Nov 14, 2007 6:59 AM, Lin, Ming {PBG} <mi...@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>
>
>
>