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.

Error: Caught IOException: End of data.

8 posts in General Discussion Last posting was on 2009-03-19 07:42:49.0Z
Pieter Coene Posted on 2009-02-26 10:40:30.0Z
Sender: 5d4e.49a670d1.1804289383@sybase.com
From: Pieter Coene
Newsgroups: sybase.public.workspace.general
Subject: Error: Caught IOException: End of data.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49a6719e.5d5a.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 26 Feb 2009 02:40:30 -0800
X-Trace: forums-1-dub 1235644830 10.22.241.41 (26 Feb 2009 02:40:30 -0800)
X-Original-Trace: 26 Feb 2009 02:40:30 -0800, 10.22.241.41
Lines: 26
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:806
Article PK: 1088485

hi,

when i run a stored procedure with a select statement in
(for example to debug some information) and in that
procedure there is a raiserror, i always get an "Caught
IOException: java.io.IOException: JZ0EM: End of data.", and
my select statement and raiserror is not shown.

i created a very simple sample procedure to demonstrate
this:

create procedure lsp_sample
as
begin
select "something"

raiserror 31000 "this is an error"

return 1
end
go

Is this known?

Greetz
Pieter


Li huang [Sybase] Posted on 2009-02-27 05:10:20.0Z
Message-ID: <49A775BB.60508@sybase.com>
From: "Li huang [Sybase]" <lihuang@sybase.com>
Reply-To: lihuang@sybase.com
Organization: Sybase Software Co., Ltd
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
To: lihuang@sybase.com
Subject: Re: Error: Caught IOException: End of data.
References: <49a6719e.5d5a.1681692777@sybase.com>
In-Reply-To: <49a6719e.5d5a.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 26 Feb 2009 21:10:20 -0800
X-Trace: forums-1-dub 1235711420 10.22.241.152 (26 Feb 2009 21:10:20 -0800)
X-Original-Trace: 26 Feb 2009 21:10:20 -0800, vip152.sybase.com
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:807
Article PK: 1088486

Hi, Pieter:

We tried the below stored procedure in ASE 15.0.0 and ASE12.5.4 with WorkSpace 2.1 and can't get the problem you reported.

Could you provide the detailed reproduce steps?

Thanks.

Pieter Coene wrote:
> hi,
>
> when i run a stored procedure with a select statement in
> (for example to debug some information) and in that
> procedure there is a raiserror, i always get an "Caught
> IOException: java.io.IOException: JZ0EM: End of data.", and
> my select statement and raiserror is not shown.
>
> i created a very simple sample procedure to demonstrate
> this:
>
> create procedure lsp_sample
> as
> begin
> select "something"
>
> raiserror 31000 "this is an error"
>
> return 1
> end
> go
>
> Is this known?
>
> Greetz
> Pieter

--
Thanks and regards,

Daniel(Li) Huang [Sybase]

Sybase
Sybase Software (China) Co., Ltd
Room 1202-1203, Building One,
Zhangjiang Semiconductor Industry Park
3000 Longdong Avenue
Pudong, Shanghai 201203
Tel 8621-38657420
Email: lihuang@sybase.com


Li huang [Sybase] Posted on 2009-03-04 07:35:52.0Z
From: "Li huang [Sybase]" <lihuang@sybase.com>
Reply-To: lihuang@sybase.com
Organization: Sybase Software Co., Ltd
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: sybase.public.workspace.general
Subject: Re: Error: Caught IOException: End of data.
References: <49A775BB.60508@sybase.com> <49a7b153.7b7f.1681692777@sybase.com>
In-Reply-To: <49a7b153.7b7f.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49ae2f58$1@forums-1-dub>
Date: 3 Mar 2009 23:35:52 -0800
X-Trace: forums-1-dub 1236152152 10.22.241.152 (3 Mar 2009 23:35:52 -0800)
X-Original-Trace: 3 Mar 2009 23:35:52 -0800, vip152.sybase.com
Lines: 93
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:809
Article PK: 1088487

Hi, Pieter:

What versions are your WorkSpace and ASE server?

Did you get the same issue from isql?

Thanks.

Pieter Coene wrote:
> Hi,
>
> i just enter "exec lsp_sample" in the sql editor and execute
> it. I don't get anything specific in the "Problems"-view,
> only the error message in the "SQL result"-view.
>
> i must say, we had this problem a long time with complex
> procedures, but now i could reproduce it with this sample
> procedure.
>
> Can i provide any other information?
>
> Greetz
> Pieter
>
>> Hi, Pieter:
>>
>
>> We tried the below stored procedure in ASE 15.0.0 and
>> ASE12.5.4 with WorkSpace 2.1 and can't get the problem you
>> reported.
>>
>> Could you provide the detailed reproduce steps?
>>
>> Thanks.
>>
>> Pieter Coene wrote:
>>> hi,
>>>
>>> when i run a stored procedure with a select statement in
>>> (for example to debug some information) and in that
>>> procedure there is a raiserror, i always get an "Caught
>>> IOException: java.io.IOException: JZ0EM: End of data.",
>>> and my select statement and raiserror is not shown.
>>>
>>> i created a very simple sample procedure to demonstrate
>>> this:
>>>
>>> create procedure lsp_sample
>>> as
>>> begin
>>> select "something"
>>>
>>> raiserror 31000 "this is an error"
>>>
>>> return 1
>>> end
>>> go
>>>
>>> Is this known?
>>>
>>> Greetz
>>> Pieter
>>
>> --
>> Thanks and regards,
>>
>> Daniel(Li) Huang [Sybase]
>>
>> Sybase
>> Sybase Software (China) Co., Ltd
>> Room 1202-1203, Building One,
>> Zhangjiang Semiconductor Industry Park
>> 3000 Longdong Avenue
>> Pudong, Shanghai 201203
>> Tel 8621-38657420
>> Email: lihuang@sybase.com

--
Thanks and regards,

Daniel(Li) Huang [Sybase]

Sybase
Sybase Software (China) Co., Ltd
Room 1202-1203, Building One,
Zhangjiang Semiconductor Industry Park
3000 Longdong Avenue
Pudong, Shanghai 201203
Tel 8621-38657420
Email: lihuang@sybase.com


Pieter Coene Posted on 2009-03-06 08:34:50.0Z
Sender: 11e1.49acd61a.1804289383@sybase.com
From: Pieter Coene
Newsgroups: sybase.public.workspace.general
Subject: Re: Error: Caught IOException: End of data.
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49b0e02a.6ff8.1681692777@sybase.com>
References: <49ae2f58$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Mar 2009 00:34:50 -0800
X-Trace: forums-1-dub 1236328490 10.22.241.41 (6 Mar 2009 00:34:50 -0800)
X-Original-Trace: 6 Mar 2009 00:34:50 -0800, 10.22.241.41
Lines: 112
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.workspace.general:811
Article PK: 1088489

Hi,

my Workspace version is 2.1.0 and my ASE server is Adaptive
Server Enterprise/15.0.2/EBF 14337/P/X64/Windows
Server/ase1502/2486/64-bit/OPT/Thu May 24 04:12:45 2007

this is the result from isql:
1> exec lsp_sample
2> go

---------
something

(1 row affected)
Msg 31000, Level 16, State 1:
Server 'TRSDB', Procedure 'lsp_sample', Line 7:
this is an error
(return status = 1)

> Hi, Pieter:
>
> What versions are your WorkSpace and ASE server?
>
> Did you get the same issue from isql?
>
> Thanks.
>
>
>
> Pieter Coene wrote:
> > Hi,
> >
> > i just enter "exec lsp_sample" in the sql editor and
> > execute it. I don't get anything specific in the
> > "Problems"-view, only the error message in the "SQL
> > result"-view.
> > i must say, we had this problem a long time with complex
> > procedures, but now i could reproduce it with this
> > sample procedure.
> >
> > Can i provide any other information?
> >
> > Greetz
> > Pieter
> >
> >> Hi, Pieter:
> >>
> >
> >> We tried the below stored procedure in ASE 15.0.0 and
> >> ASE12.5.4 with WorkSpace 2.1 and can't get the problem
> you >> reported.
> >>
> >> Could you provide the detailed reproduce steps?
> >>
> >> Thanks.
> >>
> >> Pieter Coene wrote:
> >>> hi,
> >>>
> >>> when i run a stored procedure with a select statement
> in >>> (for example to debug some information) and in that
> >>> procedure there is a raiserror, i always get an
> "Caught >>> IOException: java.io.IOException: JZ0EM: End
> of data.", >>> and my select statement and raiserror is
> not shown. >>>
> >>> i created a very simple sample procedure to
> demonstrate >>> this:
> >>>
> >>> create procedure lsp_sample
> >>> as
> >>> begin
> >>> select "something"
> >>>
> >>> raiserror 31000 "this is an error"
> >>>
> >>> return 1
> >>> end
> >>> go
> >>>
> >>> Is this known?
> >>>
> >>> Greetz
> >>> Pieter
> >>
> >> --
> >> Thanks and regards,
> >>
> >> Daniel(Li) Huang [Sybase]
> >>
> >> Sybase
> >> Sybase Software (China) Co., Ltd
> >> Room 1202-1203, Building One,
> >> Zhangjiang Semiconductor Industry Park
> >> 3000 Longdong Avenue
> >> Pudong, Shanghai 201203
> >> Tel 8621-38657420
> >> Email: lihuang@sybase.com
>
>
> --
> Thanks and regards,
>
> Daniel(Li) Huang [Sybase]
>
> Sybase
> Sybase Software (China) Co., Ltd
> Room 1202-1203, Building One,
> Zhangjiang Semiconductor Industry Park
> 3000 Longdong Avenue
> Pudong, Shanghai 201203
> Tel 8621-38657420
> Email: lihuang@sybase.com