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-28 17:20:00.0Z
Michael Shengaout Posted on 1997-04-20 01:45:20.0Z
Message-ID: <33597530.1FD6@mindspring.com>
Date: Sat, 19 Apr 1997 21:45:20 -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:961
Article PK: 252713

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


David Clegg Posted on 1997-04-28 17:20:00.0Z
Message-ID: <3364DC40.79F14AA3@sybase.com>
Date: Mon, 28 Apr 1997 10:20:00 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: mshenga@mindspring.com
CC: davec@sybase.com
Subject: Re: Unsolicited disconnects by Open Server Gateway
References: <33597530.1FD6@mindspring.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 96
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:918
Article PK: 252670

Michael,
Sorry about the delay in getting back to you.
This seems to be a OSG/SQL Anywhere problem. I have not seen it in
the setup I've got, and have not heard of similar problems from
others -- but your log output certainly indicates a bug somewhere.

If you download the latest (4/23/97) jConnect driver, you can use the
new "USE_METADATA" connection property to prevent jConnect from trying
to figure out what kind of database it is connected to (the sp_mda
RPC you are seeing below). This would only be a temporary workaround
on the theory that this is what is causing your disconnects.

You may want to check out the SQLAnywhere support:

http://www.powersoft.com/service/support/sqlanywhere
or if you are a licenced SQL Anywhere user, take advantage of that
support avenue.

I will forward this posting to a SQL Anywhere support dude, but
cannot promise anything back from them - they have plenty to do
for paying customers.

Thanks for reporting the problem.

dave

>
> 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