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>
"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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
