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.

Unsolicited disconnects by Open Server Gateway

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-04-20 20:02:38.0Z
Michael Shengaout Posted on 1997-04-20 01:43:49.0Z
Message-ID: <335974D5.53B5@mindspring.com>
Date: Sat, 19 Apr 1997 21:43:49 -0400
From: Michael Shengaout <mshenga@mindspring.com>
Reply-To: mshenga@mindspring.com
Organization: Reusable Software Components, LLC.
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
Subject: Unsolicited disconnects by Open Server Gateway
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 66
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:962
Article PK: 252714

Hi,

I am doing an evaluation of the databases for our Internet-based
commercial package. Currently I run the setup with Java 1.1.1, Open
Server gateway 5.5 build 1073 and SQLAnyware server 5.5 build 1073 on
WIndows NT 3.51. I am not using http daemon. When I open connection, I
try to run several queries. After I run the 1st query, Open Server
Gateway disconnects me. I am also getting some error messages about some
stored procedures (???). This is the log output:


Apr 19 20:29:23 1997: Sybase SQL Anywhere Open Server Gateway Version
5.5.00 Build #1073
Apr 19 20:29:23 1997: Copyright by Sybase, Inc., and its subsidiaries,
1988, 1996.
Apr 19 20:29:23 1997: All rights reserved. Sybase is a trademark of
Sybase, Inc.

Apr 19 20:29:23 1997: Sybase Open Server Component:
Apr 19 20:29:23 1997: libsrv/10.0.3/P/PC Intel/Windows NT 3.1/1/OPT/Aug
1 1995 23:42:55
Apr 19 20:29:23 1997: Log Filename: Supply.wos

Apr 19 20:29:23 1997: Open Server Gateway Started
.......................................................
Apr 19 20:32:25 1997: SRV_CONNECT handler active
Apr 19 20:32:26 1997: Attempting to connect -- User: misha
Apr 19 20:32:31 1997: Connected user: misha
Apr 19 20:32:33 1997: SRV_RPC handler active
Apr 19 20:32:33 1997: SQL Anywhere Error Code: -265
Description: procedure 'sp_mda' not found
Apr 19 20:32:33 1997: SRV_RPC handler active
Apr 19 20:32:34 1997: SQL Anywhere Error Code: -265
Description: procedure 'sp_mda' not found
Apr 19 20:32:34 1997: SRV_LANGUAGE handler active
Apr 19 20:32:34 1997: SQL statement received: SELECT produce_id,
produce_desc FROM
produce
Apr 19 20:32:35 1997: OS error handler active
Apr 19 20:32:35 1997: Error Code #16145, Severity 10 CS error : Server
process '5' has invalid
I/O in 'srv_senddone()'

Apr 19 20:32:35 1997: SRV_DISCONNECT handler active
Apr 19 20:32:35 1997: Disconnecting user: misha

Chuck Kann wrote:
>
> Can someone help me? I am trying to run IsqlApp. If I do an incorrect
> query (ie, spell the name of the database wrong, ie uathors instead of
> authors) the program gives me the correct error, so I am sure I have
> connected to the database. However, any query which gives a result
> (ie. select * from authors) gives me an error:
>
> java.lang.UnknownError: com/sybase/jdbc/SybResultSet
> com.sybase.jdbc.SybStatement.nextResult....
>
> Can anyone tell me why this is happening?
>
> Chuck Kann
> ckann@seas.gwu.edu

Could anybody tell me what I have to do in order not to be disconnected
after running the query once?

Thanks

Misha


Michael Shengaout Posted on 1997-04-20 20:02:38.0Z
Message-ID: <335A765E.4B8E@mindspring.com>
Date: Sun, 20 Apr 1997 16:02:38 -0400
From: Michael Shengaout <mshenga@mindspring.com>
Reply-To: mshenga@mindspring.com
Organization: Reusable Software Components, LLC.
X-Mailer: Mozilla 3.01 (WinNT; I)
MIME-Version: 1.0
Subject: More: Unsolicited disconnects by Open Server Gateway
References: <335974D5.53B5@mindspring.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 6
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:960
Article PK: 252712

I forgot to mention that I have run sql_anywhere.sql to install
stored procedures for the Metadata and that I log in as a user with
DBA privilages, so supposedly everything should be visible...

Misha