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.

IsqlApp on AIX (JDK1.1.1)

3 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-09-29 17:04:41.0Z
Shyama P Mandal Posted on 1997-09-19 15:16:35.0Z
Message-ID: <34229753.4B0D@imf.org>
Date: Fri, 19 Sep 1997 11:16:35 -0400
From: Shyama P Mandal <smandal@imf.org>
Reply-To: smandal@imf.org
X-Mailer: Mozilla 3.0Gold (Win95; I)
MIME-Version: 1.0
Subject: IsqlApp on AIX (JDK1.1.1)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 25
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:250
Article PK: 252002

I am using JDK 1.1.1 on AIX/RS6000 and Sybase 11.0.3. Using IsqlApp I
can do query without any problem. But when I execcute stored procedure (
e.g. exec sp_who ) , it displays all the result rows and at the end it
gives the following error
Unexpected exception : java.sql.SQLException: Unexpected result type.:
Unexpecte
d result type., sqlstate = JZ0P1
java.sql.SQLException: Unexpected result type.: Unexpected result type.
at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
at com.sybase.jdbc.SybStatement.handleParam(SybStatement.java)
at com.sybase.jdbc.SybStatement.nextResult(SybStatement.java)
at
com.sybase.jdbc.SybStatement.getMoreResults(SybStatement.java)
at IsqlApp.main(IsqlApp.java)

If I use IsqlApp against the same sqlserver from Win 95, this error does
not occur. Any help is greatly appreciated.
Thanks
Shyama


Shyama P Mandal Posted on 1997-09-19 17:58:25.0Z
Message-ID: <3422BD41.4D3A@imf.org>
Date: Fri, 19 Sep 1997 13:58:25 -0400
From: Shyama P Mandal <smandal@imf.org>
Reply-To: smandal@imf.org
X-Mailer: Mozilla 3.0Gold (Win95; I)
MIME-Version: 1.0
Subject: Re: IsqlApp on AIX (JDK1.1.1)
References: <34229753.4B0D@imf.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 32
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:249
Article PK: 252001


Shyama P Mandal wrote:
>
> I am using JDK 1.1.1 on AIX/RS6000 and Sybase 11.0.3. Using IsqlApp I
> can do query without any problem. But when I execcute stored procedure (
> e.g. exec sp_who ) , it displays all the result rows and at the end it
> gives the following error
> Unexpected exception : java.sql.SQLException: Unexpected result type.:
> Unexpecte
> d result type., sqlstate = JZ0P1
> java.sql.SQLException: Unexpected result type.: Unexpected result type.
> at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
> at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
> at com.sybase.jdbc.SybStatement.handleParam(SybStatement.java)
> at com.sybase.jdbc.SybStatement.nextResult(SybStatement.java)
> at
> com.sybase.jdbc.SybStatement.getMoreResults(SybStatement.java)
> at IsqlApp.main(IsqlApp.java)
>
> If I use IsqlApp against the same sqlserver from Win 95, this error does
> not occur. Any help is greatly appreciated.
> Thanks
> Shyama

I went thru debug and found that next result is getting PARAM instead of
STATUS . Here is the line from debug session
com.sybase.jdbc.SybStatement(Thread[main,5,main]): nextResult: PARAM

Thanks again
..Shyama


David Clegg Posted on 1997-09-29 17:04:41.0Z
Message-ID: <342FDFA9.690FAA84@sybase.com>
Date: Mon, 29 Sep 1997 10:04:41 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 3.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: smandal@imf.org
Subject: Re: IsqlApp on AIX (JDK1.1.1)
References: <34229753.4B0D@imf.org> <3422BD41.4D3A@imf.org>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 51
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:221
Article PK: 251973

Any version of jConnect built after August 8, 1997 should just
raise an SQLWarning for unprocessed parameters that are returned
from queries. Run 'java Version' to see what version of jConnect
you've got and when it was built. May be time to download the latest
release.

When you execute a stored procedure via language
command (as you have below) jConnect does get extra parameters
(output stored procedure parameters or return status values), which
an application COULD retrieve it were executing the procedure
via a CallableStatement. I cannot explain why you are seeing
different behavior between AIX and Win95 -- suspect that there
may be something more going on here.

dave

> Shyama P Mandal wrote:
> >
> > I am using JDK 1.1.1 on AIX/RS6000 and Sybase 11.0.3. Using IsqlApp I
> > can do query without any problem. But when I execcute stored procedure (
> > e.g. exec sp_who ) , it displays all the result rows and at the end it
> > gives the following error
> > Unexpected exception : java.sql.SQLException: Unexpected result type.:
> > Unexpecte
> > d result type., sqlstate = JZ0P1
> > java.sql.SQLException: Unexpected result type.: Unexpected result type.
> > at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
> > at com.sybase.jdbc.ErrorMessage.raiseError(ErrorMessage.java)
> > at com.sybase.jdbc.SybStatement.handleParam(SybStatement.java)
> > at com.sybase.jdbc.SybStatement.nextResult(SybStatement.java)
> > at
> > com.sybase.jdbc.SybStatement.getMoreResults(SybStatement.java)
> > at IsqlApp.main(IsqlApp.java)
> >
> > If I use IsqlApp against the same sqlserver from Win 95, this error does
> > not occur. Any help is greatly appreciated.
> > Thanks
> > Shyama
> I went thru debug and found that next result is getting PARAM instead of
> STATUS . Here is the line from debug session
> com.sybase.jdbc.SybStatement(Thread[main,5,main]): nextResult: PARAM
>
> Thanks again
> ..Shyama