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

[John Gentilin]

Phil,
Good debugging...
That is kind of what I was expecting. The API Docs say that Execute returns
false if the execute is an Update or if the Query returns does not return a
result set. Not returning a results set is different than a query that returns 
an empty result set. Can you explain what this SP is trying to do ?

I took a look at the 2.5.1 code and I see a subtile difference in how the
Query is executed. In 2.5.1 we were using executeQuery and not execute.
Can you try the following mod:
Orig Code:
     m_Statement = conn.createStatement();
     if (! m_Statement.execute(m_QueryParser.getSQLQuery()))
     {
       throw new SQLException("Error in Query");
     }
New Code:
     m_Statement = conn.createStatement();
     m_ResultSet =  m_Statement.executeQuery(m_QueryParser.getSQLQuery()))
     return;
You probably need to run the build script then substitute the new JAR file 
with the one you are using now.

Regards
John G
Phil Friedman wrote:
John,
SQLDocument.java line 407 execute returns false for this query:
   declare @InstKy int
   declare @MConKy int
   declare @Result int
   select @InstKy= -1
   select @MConKy= 1886524808
   exec @Result= ICntrTyOpn 1886524808
                          , @InstKy output
                          , @MConKy output
                          , 1021
                          , 2
   select @InstKy, @MConKy, @Result
BTW, I'm going home, be back Monday...
Regards, Phil Friedman
John Gentilin wrote:
Phil,
I think what we are looking for is fairly straight forward. We need to 
know if the
execute returns false in SQLDocument and if so why. We should be able 
to figure that
out with the query that is being executed which will be stored in 
QueryParser. If you
get stuck, let me know what the problem is. I will be in an out today 
but should be able to get back to you in short order.

-JG
Phil Friedman wrote:
Hi John,
I finally got eclipse set up and can reproduce the problem w/ 2.6.0 
source. I'll be stepping through things, but I'm a Java tyro. If you 
have a few minutes you can reach me at 1-800-343-5143 x101. Or, I'll 
keep you posted.



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]