Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Problem when executing stored procedures

2 posts in JConnect version 3.0 Last posting was on 1999-11-23 13:44:36.0Z
Jesper Brolin Posted on 1999-11-23 08:32:10.0Z
Message-ID: <383A5109.DDF171AD@student.hk-r.se>
Date: Tue, 23 Nov 1999 09:32:10 +0100
From: Jesper Brolin <mda98jbr@student.hk-r.se>
X-Mailer: Mozilla 4.6 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Problem when executing stored procedures
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jconnect30
Lines: 9
NNTP-Posting-Host: merlin.rby.hk-r.se 194.47.140.142
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:232
Article PK: 256607

Help!

We have big problem when executing stored procedures.

We can only insert a value already defined in the DataBase.
Otherwise the execution don't stop. The value IS stored in DB but the
close() method don't close the connection.

We use.
JDK 1.2
Sybase shareware version 4.0.

Please help!
Caroline


Lance Andersen Posted on 1999-11-23 13:44:36.0Z
Message-ID: <383A9A44.BCBCA9F6@sybase.com>
Date: Tue, 23 Nov 1999 08:44:36 -0500
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 4.7 [en] (X11; I; SunOS 5.7 sun4u)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Problem when executing stored procedures
References: <383A5109.DDF171AD@student.hk-r.se>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jconnect30
Lines: 29
NNTP-Posting-Host: 157.133.125.15
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.jconnect30:231
Article PK: 254574


Jesper Brolin wrote:
>
> Help!
>
> We have big problem when executing stored procedures.
>
> We can only insert a value already defined in the DataBase.
> Otherwise the execution don't stop. The value IS stored in DB but the
> close() method don't close the connection.
>
> We use.
> JDK 1.2
> Sybase shareware version 4.0.
>
> Please help!
> Caroline

I suspect this is a coding error but without any info, it is impossible
to assist. Please review the samples Execute.java, MyCallable.java

for how to properly process sprocs.

If you still have a problem, please post a complete but compact
sample which also creates the tables and sprocs needed

Lance
--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Product Support Engineering Phone:(781) 564-6336
77 South Bedford Street Fax: (781) 564-7001
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================