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