You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@xalan.apache.org by Phil Friedman <pf...@terralink.com> on 2004/07/02 23:01:26 UTC

SQL Extension exec stored proc breaks between 2.5.1 and 2.6.0

My logs that show the SQL being run are attached. 2_5_1 works, 2_6_0 fails w/ java.sql.SQLException: Error in Query. They should be otherwise identical inputs, style sheets, database, jvm, et cetera. Only the .jars in the -Xbootclasspath/p: are different versions from the binary distributions. 2_6_0 always seems to fail on the first SQL w/ an exec stored procedure.

Any Ideas?

-- 
Regards, Phil Friedman - Terralink Software - 1-207-772-6500 x101

Here is the .xsl snippet:

  <xsl:variable name="SQL">
    declare @InstKy int
    declare @MConKy int
    declare @Result int
    select @InstKy= <xsl:value-of select="$InstKy"/>
    select @MConKy= <xsl:value-of select="$MConKy"/>
    execute @Result= ICntrTyOpn <xsl:value-of select="$IConKy"/>
                              , @InstKy output
                              , @MConKy output
                              , <xsl:value-of select="$IxOrKy"/>
                              , <xsl:value-of select="$ILv"/>
    select @InstKy, @MConKy, @Result
  </xsl:variable>
  <xsl:variable name="Qy" select="sql:query($DbCon, $SQL)"/>
  <xsl:if test="$msg-sql or not( $Qy)">
    <xsl:message terminate="no">
      <xsl:value-of select="$SQL"/>= <xsl:value-of select="$Qy/sql/row-set/row[1]/col[1]"/>, <xsl:value-of select="$Qy/sql/row-set/row[1]/col[2]"/>, <xsl:value-of select="$Qy/sql/row-set/row[1]/col[3]"/>
    </xsl:message>
  </xsl:if>
  <xsl:if test="not( $Qy)" >
    <xsl:apply-templates select="sql:getError($DbCon)/ext-error"/>
  </xsl:if>



Re: SQL Extension exec stored proc breaks between 2.5.1 and 2.6.0

Posted by John Gentilin <ge...@eyecatching.com>.
Phil,

I spent an hour or so looking in to the problem, but it is unclear to me
what the root problem. Back in the 2.5 days, there was a big change to add
in support directly for Callable statements, inline variables, and multiple
result sets but from the snippet of your code it seems that you exercise the
pquery interface with not parameters. This results in a very simple stmt.execute()
statement. i.e. No fuss, no muss with inserting parameters into the query.

Since I don't have you database environment, I will need your assistance to look
into the problem.

First the areas of code we will be working with will be in
SQLDocument line 415
SQLQueryParser line 121, 146, & 213

Items that I need to debug the code.

Sybase has a way (I have not done this in ages) to set flags (through DBCC statements ??)
that will cause the SQL queries executed through the DB to be written to the log file. 
I would need to see what the DB thinks it is executing to see where there may be an error.

Execute the command line example that you have in the email in a debugging environment
and place break points on the lines declared above and to trap SQLExceptions caught &
uncaught so that we can review where the problem is occurring. 

Now that I look at you code again, if the execute statement does not return any result sets,
this error will be thrown..

Regards
John G


Phil Friedman wrote:

> My logs that show the SQL being run are attached. 2_5_1 works, 2_6_0 
> fails w/ java.sql.SQLException: Error in Query. They should be otherwise 
> identical inputs, style sheets, database, jvm, et cetera. Only the .jars 
> in the -Xbootclasspath/p: are different versions from the binary 
> distributions. 2_6_0 always seems to fail on the first SQL w/ an exec 
> stored procedure.
> 
> Any Ideas?
> 
> 
> ------------------------------------------------------------------------
> 
> "C:\Program Files\Java\j2re1.4.2_04\bin\java.exe" -Xmx512m -Xbootclasspath/p:"C:\Program Files\apache\xalan-j_2_5_1\bin\xalan.jar";"C:\Program Files\apache\xalan-j_2_5_1\bin\xercesImpl.jar" -cp "C:\Program Files\Sybase\Shared8.0.2.4398\jConnect-5_5\classes\jconn2.jar" org.apache.xalan.xslt.Process  -PARAM DbDrvr com.sybase.jdbc2.jdbc.SybDriver -PARAM DbUrl jdbc:sybase:Tds:aeolus:2638?servicename=TWebDevel -PARAM DbUsr JimRussell -PARAM DbPwd Masterkey -PARAM LsIConKy 1449293988 -PARAM LsInstKy 1001 -PARAM msg-tplt X -PARAM msg-sql X -PARAM out-pc X -PARAM XplObjTyMn XOL -DIAG -INDENT 2 -xsl "C:\Shared\c2g2-00-400\Programs\_WebDb.251.bat".xsl -in "C:\Shared\c2g2-00-400\_nsTestXsl\WebDbExpCnti.xml" -out "C:\Shared\c2g2-00-400\_nsTestXsl\WebDbExpCnti.xml".out.xml 
> file:///C:/Shared/c2g2-00-400/Programs/CmnC2G.xsl; Line #175; Column #33; 
>     select connection_property( 'Number') as IConKy
>   = 94455812
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #41; Column #33; 
>         select isnull(max(CntrTyKy),-1) from CntrTy
>           where lower('1 Liter Jar')=lower(LclNm)
>       = 1021 Fri Jul 02 16:35:31 EDT 2004
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #227; Column #33; 
>     declare @InstKy int
>     declare @MConKy int
>     declare @Result int
>     select @InstKy= -1
>     select @MConKy= 94455812
>     execute @Result= ICntrTyOpn 94455812
>                               , @InstKy output
>                               , @MConKy output
>                               , 1021
>                               , 2
>     select @InstKy, @MConKy, @Result
>   = 1001, 94455812, 1
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #245; Column #33; Fri Jul 02 16:35:31 EDT 2004 ICntrTyOpn
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #280; Column #35; 
>       select  (select Mn from Glyph G where I.GlyphIx=G.GlyphIx) GlyphMn
>            , I.SABo
>            , I.LclNm
>            , trim(I.LclAbr) LclAbr
>            , I.Dsc
>            , I.Cap
>            , trim(I.CapUntAbr) CapUntAbr
>            , I.Weight
>            , trim(I.WeightUntAbr) WeightUntAbr
>            , I.InBhvrNm InBhvrNm 
>            , I.OutBhvrNm OutBhvrNm 
>            , I.AddNts
>            , I.MnftBo
>            , I.UsrModBo
>         from ICntrTy I
>         where 94455812=I.IConKy
>           and 1001=I.InstKy
>           and 1021=I.CntrTyKy
>           and 'v'=I.IRowSts
>     =Cntr,1 Liter Jar
> file:///C:/Shared/c2g2-00-400/Programs/CmnC2G.xsl; Line #118; Column #33; 
>         select isnull( min( XOT.XplObjTyIx), -10) from XplObjTy XOT where 'Cnti'=Mn /* By $XplObjTyMn */
>        = 15
> file:///C:/Shared/c2g2-00-400/Programs/CmnUsrDfn.xsl; Line #644; Column #33; 
>     declare @InstKy int
>     declare @MConKy int
>     declare @Rslt int
>     select @InstKy= -1
>     select @MConKy= -1
>     execute @Rslt= IUsrDfnOpn 94455812
>                            , @InstKy output
>                            , @MConKy output
>                            , 15
>                            , 1021
>                            , -1
>     select @InstKy, @MConKy, @Rslt
>   = -1, -1, 0
> file:///C:/Shared/c2g2-00-400/Programs/CmnUsrDfn.xsl; Line #663; Column #33; Fri Jul 02 16:35:31 EDT 2004 IUsrDfnUpd
> file:///C:/Shared/c2g2-00-400/Programs/CmnUsrDfn.xsl; Line #699; Column #33; 
>     select  Dsc as TyDsc
>          , Val
>       from IUsrDfn
>       where 94455812= IConKy
>         and -1= InstKy
>         and 15= XplObjTyIx
>         and 1021= IxOrKy
>         and -1= CIxOrKy
>         and IRowSts in ( 'a', 'i', 'u', 'v')
>       order by UsrDfnTyIx
>   =, 
> file:///C:/Shared/c2g2-00-400/Programs/CmnUsrDfn.xsl; Line #845; Column #33; 
>     declare @InstKy int
>     declare @Result int
>     exec @Result= IUsrDfnClr 94455812
>                            , -1
>                            , 15
>                            , 1021
>                            , -1
>     select @Result
>   
>       = 0
> file:///C:/Shared/c2g2-00-400/Programs/CmnUsrDfn.xsl; Line #864; Column #18; Fri Jul 02 16:35:31 EDT 2004 IUsrDfnClr
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #424; Column #33; 
>     declare @Result int
>     exec @Result= ICntrTyClr 94455812
>                            , 1001
>                            , 1021
>     select @Result
>   = 1
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #441; Column #33; ICntrTyClr Fri Jul 02 16:35:31 EDT 2004
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #100; Column #33; Fri Jul 02 16:35:31 EDT 2004 CntrTyExp
> 
> 
>  --------- Transform of C:\Shared\c2g2-00-400\_nsTestXsl\WebDbExpCnti.xml via C:\Shared\c2g2-00-400\Programs\_WebDb.251.bat.xsl took 3,716 ms
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> "C:\Program Files\Java\j2re1.4.2_04\bin\java.exe" -Xmx512m -Xbootclasspath/p:"C:\Program Files\apache\xalan-j_2_6_0\bin\xalan.jar";"C:\Program Files\apache\xalan-j_2_6_0\bin\xercesImpl.jar" -cp "C:\Program Files\Sybase\Shared8.0.2.4398\jConnect-5_5\classes\jconn2.jar" org.apache.xalan.xslt.Process  -PARAM DbDrvr com.sybase.jdbc2.jdbc.SybDriver -PARAM DbUrl jdbc:sybase:Tds:aeolus:2638?servicename=TWebDevel -PARAM DbUsr JimRussell -PARAM DbPwd Masterkey -PARAM LsIConKy 1449293988 -PARAM LsInstKy 1001 -PARAM msg-tplt X -PARAM msg-sql X -PARAM out-pc X -PARAM XplObjTyMn XOL -DIAG -INDENT 2 -xsl "C:\Shared\c2g2-00-400\Programs\_WebDb.260.bat".xsl -in "C:\Shared\c2g2-00-400\_nsTestXsl\WebDbExpCnti.xml" -out "C:\Shared\c2g2-00-400\_nsTestXsl\WebDbExpCnti.xml".out.xml 
> file:///C:/Shared/c2g2-00-400/Programs/CmnC2G.xsl; Line #175; Column #33; 
>     select connection_property( 'Number') as IConKy
>   = 2110017376
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #41; Column #33; 
>         select isnull(max(CntrTyKy),-1) from CntrTy
>           where lower('1 Liter Jar')=lower(LclNm)
>       = 1021 Fri Jul 02 16:34:52 EDT 2004
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #225; Column #61; java.sql.SQLException: Error in Query
> file:///C:/Shared/c2g2-00-400/Programs/CmnCntrTy.xsl; Line #227; Column #33; 
>     declare @InstKy int
>     declare @MConKy int
>     declare @Result int
>     select @InstKy= -1
>     select @MConKy= 2110017376
>     execute @Result= ICntrTyOpn 2110017376
>                               , @InstKy output
>                               , @MConKy output
>                               , 1021
>                               , 2
>     select @InstKy, @MConKy, @Result
>   = , , 
> file:///C:/Shared/c2g2-00-400/Programs/CmnJDBC.xsl; Line #22; Column #34; Fri Jul 02 16:34:53 EDT 2004 Error in Query cd: 0 msg: Error in Query
> 
> (Location of error unknown)XSLT Error (javax.xml.transform.TransformerException): Stylesheet directed termination
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: xalan-dev-unsubscribe@xml.apache.org
> For additional commands, e-mail: xalan-dev-help@xml.apache.org





---------------------------------------------------------------------
To unsubscribe, e-mail: xalan-dev-unsubscribe@xml.apache.org
For additional commands, e-mail: xalan-dev-help@xml.apache.org