jconnect 2.1/2.2 
Author Message
 jconnect 2.1/2.2

Hi,

My java program exec the following

cstmt = conn.prepareCall("{call test_proc(?)}");
resultset_yes = cstmt.execute();

In jconnect2.1 -> the above returns true for boolean (resultset_yes)
In jconnect2.2 ->                   false  

I checked the stored proc (test_proc)

============================================================================
create proc sq_default_price_list_get_pr

as

/* template */
/* append a wildcard to price list */

begin

end
else
begin

end

select distinct     s.price_list,s.quote_form,s.tc_form,s.fob,s.credit_terms,s.precision_sd,s.protected,p.locale_name
from   cascadedb..pm_price_list p, cascadedb..sd_quote_pricelist_defaults s    

and    s.price_list = p.price_list
go
=============================================================================

Note: there are two select statements in that stored proc.

Just don't know why it returns false on Jconnect 2.2.
( it cannot take two select statements?)

thanks.

Paul.



Sun, 09 Apr 2000 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Migrating from WebDB 2.1 to 2.2

2. Migrating from Oracle WebDB 2.1 to 2.2

3. jConnect 2.2 connect problem from java cartridge in was

4. Questions on JConnect 2.2

5. JDBC Support in NetBeans Developer 2.1 and DeveloperX2 2.1

6. SQL-Programmer 2.2 Available!

7. Announcing SQL-Programmer 2.2

8. Trouble Checker 2.2 released

9. Trouble Checker 2.2 released

10. SQL-Programmer 2.2 Available / FREE Upgrade!

11. Hallmore Group announces Analysis Center Library (ACL) 2.2

12. AppsMart 2.2


 
Powered by phpBB® Forum Software