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.

how to accept the ResultSet of EJB?

6 posts in EJB Client Last posting was on 2004-04-12 09:32:23.0Z
qhc_cn Posted on 2004-04-09 09:09:44.0Z
Sender: 66b1.40765a25.1804289383@sybase.com
From: qhc_cn@sohu.com
Newsgroups: sybase.public.powerbuilder.ejbclient
Subject: how to accept the ResultSet of EJB?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <40765a48.66b2.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Apr 2004 01:09:44 -0800
X-Trace: forums-1-dub 1081498184 10.22.241.41 (9 Apr 2004 01:09:44 -0800)
X-Original-Trace: 9 Apr 2004 01:09:44 -0800, 10.22.241.41
Lines: 3
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:268
Article PK: 424451

EJB return TabularResults.ResultSet,
PB Client Proxy Data type is java_ResultSet,
How to use java_ResultSet in PB?


Jim O'Neil [Sybase] Posted on 2004-04-09 15:37:40.0Z
From: joneil@sybase.com (Jim O'Neil [Sybase])
Newsgroups: sybase.public.powerbuilder.ejbclient
Subject: Re: how to accept the ResultSet of EJB?
Organization: Sybase Technical Support
Reply-To: joneil_REMOVETHISPART@sybase.com
Message-ID: <4076b43f.3297121@forums.sybase.com>
References: <40765a48.66b2.846930886@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: joneilpc.sybase.com
X-Original-NNTP-Posting-Host: joneilpc.sybase.com
Date: 9 Apr 2004 07:37:40 -0800
X-Trace: forums-1-dub 1081521460 10.18.63.187 (9 Apr 2004 07:37:40 -0800)
X-Original-Trace: 9 Apr 2004 07:37:40 -0800, joneilpc.sybase.com
Lines: 27
X-Authenticated-User: TeamPS
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:269
Article PK: 424450

You are going to need PB 9.0.1 at a minimum because
TabularResults.ResultSet has public class variables which are not
supported in PB9.0 GA.

What application server are you using? TabularResults is generally
associated with EAServer, in which case I would recommend using native
connectivity methods (the PowerBuilder connection object) because a
TabularResults.ResultSet is automatically marshalled into the
PowerBuilder ResultSet datatype by the PBVM.

Since the TabularResults package was open sourced though you could use
it with other app servers in which case the EJB Proxy mechanism is
appropriate. You will however have to traverse the fields of the
ResultSet proxy manually to do what you want on the PB client end -
e.g., populate a datastore. There is no 'magic' as there is when you
use the PowerBuilder connection object.

On 9 Apr 2004 01:09:44 -0800, qhc_cn@sohu.com wrote:

>EJB return TabularResults.ResultSet,
>PB Client Proxy Data type is java_ResultSet,
>How to use java_ResultSet in PB?

Jim O'Neil
Principal Technical Support Engineer
Sybase, Inc.
Concord, MA


qhc_cn Posted on 2004-04-12 01:30:46.0Z
Sender: 3c3f.4079e2cd.1804289383@sybase.com
From: qhc_cn@sohu.com
Newsgroups: sybase.public.powerbuilder.ejbclient
Subject: Re: how to accept the ResultSet of EJB?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <4079e333.3c41.846930886@sybase.com>
References: <40765a48.66b2.846930886@sybase.com><4076b43f.3297121@forums.sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 11 Apr 2004 17:30:44 -0800, 10.22.241.42
Lines: 33
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Apr 2004 17:30:44 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Apr 2004 17:30:46 -0800
X-Trace: forums-1-dub 1081729846 10.22.108.75 (11 Apr 2004 17:30:46 -0800)
X-Original-Trace: 11 Apr 2004 17:30:46 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:270
Article PK: 424452

Thanks for your replay!
I use the EAServer5.0 and PB9.01.
Can you give me a code examples?
Thanks.

> You are going to need PB 9.0.1 at a minimum because
> TabularResults.ResultSet has public class variables which
> are not supported in PB9.0 GA.
>
> What application server are you using? TabularResults is
> generally associated with EAServer, in which case I would
> recommend using native connectivity methods (the
> PowerBuilder connection object) because a
> TabularResults.ResultSet is automatically marshalled into
> the PowerBuilder ResultSet datatype by the PBVM.
>
> Since the TabularResults package was open sourced though
> you could use it with other app servers in which case the
> EJB Proxy mechanism is appropriate. You will however have
> to traverse the fields of the ResultSet proxy manually to
> do what you want on the PB client end - e.g., populate a
> datastore. There is no 'magic' as there is when you use
> the PowerBuilder connection object.
>
> On 9 Apr 2004 01:09:44 -0800, qhc_cn@sohu.com wrote:
>
> >EJB return TabularResults.ResultSet,
> >PB Client Proxy Data type is java_ResultSet,
> >How to use java_ResultSet in PB?
>
> Jim O'Neil
> Principal Technical Support Engineer
> Sybase, Inc.
> Concord, MA


Jim O'Neil [Sybase] Posted on 2004-04-12 01:40:22.0Z
From: joneil@sybase.com (Jim O'Neil [Sybase])
Newsgroups: sybase.public.powerbuilder.ejbclient
Subject: Re: how to accept the ResultSet of EJB?
Organization: Sybase Technical Support
Reply-To: joneil_REMOVETHISPART@sybase.com
Message-ID: <4079e524.1875727@forums.sybase.com>
References: <40765a48.66b2.846930886@sybase.com><4076b43f.3297121@forums.sybase.com> <4079e333.3c41.846930886@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
X-Original-NNTP-Posting-Host: vpn-concord-088.sybase.com
X-Original-Trace: 11 Apr 2004 17:40:20 -0800, vpn-concord-088.sybase.com
Lines: 47
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Apr 2004 17:40:21 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Apr 2004 17:40:22 -0800
X-Trace: forums-1-dub 1081730422 10.22.108.75 (11 Apr 2004 17:40:22 -0800)
X-Original-Trace: 11 Apr 2004 17:40:22 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:271
Article PK: 424453

If using EAServer, don't worry about the EJB Client method. If your
Java/EJB method returns TabularResults::ResultSet then when you create
EAServer proxies (not EJB proxies), PowerBuilder will automatically
use the PowerBuilder ResultSet type. Check out documentation on the
CreateFrom and GenerateResultSet methods to convert a ResultSet to a
datastore and vice versa.

On 11 Apr 2004 17:30:46 -0800, qhc_cn@sohu.com wrote:

>Thanks for your replay!
>I use the EAServer5.0 and PB9.01.
>Can you give me a code examples?
>Thanks.
>> You are going to need PB 9.0.1 at a minimum because
>> TabularResults.ResultSet has public class variables which
>> are not supported in PB9.0 GA.
>>
>> What application server are you using? TabularResults is
>> generally associated with EAServer, in which case I would
>> recommend using native connectivity methods (the
>> PowerBuilder connection object) because a
>> TabularResults.ResultSet is automatically marshalled into
>> the PowerBuilder ResultSet datatype by the PBVM.
>>
>> Since the TabularResults package was open sourced though
>> you could use it with other app servers in which case the
>> EJB Proxy mechanism is appropriate. You will however have
>> to traverse the fields of the ResultSet proxy manually to
>> do what you want on the PB client end - e.g., populate a
>> datastore. There is no 'magic' as there is when you use
>> the PowerBuilder connection object.
>>
>> On 9 Apr 2004 01:09:44 -0800, qhc_cn@sohu.com wrote:
>>
>> >EJB return TabularResults.ResultSet,
>> >PB Client Proxy Data type is java_ResultSet,
>> >How to use java_ResultSet in PB?
>>
>> Jim O'Neil
>> Principal Technical Support Engineer
>> Sybase, Inc.
>> Concord, MA

Jim O'Neil
Principal Technical Support Engineer
Sybase, Inc.
Concord, MA


qhc_cn Posted on 2004-04-12 07:12:36.0Z
Sender: 3d41.407a32cb.1804289383@sybase.com
From: qhc_cn@sohu.com
Newsgroups: sybase.public.powerbuilder.ejbclient
Subject: Re: how to accept the ResultSet of EJB?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <407a3352.3d45.846930886@sybase.com>
References: <40765a48.66b2.846930886@sybase.com><4076b43f.3297121@forums.sybase.com> <4079e333.3c41.846930886@sybase.com><4079e524.1875727@forums.sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 11 Apr 2004 23:12:34 -0800, 10.22.241.42
Lines: 72
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 11 Apr 2004 23:12:35 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 11 Apr 2004 23:12:36 -0800
X-Trace: forums-1-dub 1081750356 10.22.108.75 (11 Apr 2004 23:12:36 -0800)
X-Original-Trace: 11 Apr 2004 23:12:36 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:272
Article PK: 424454

In this example,Lookup return value is 50,Why?

//Invoking an EJB component method
//Connection myconnect
hello vhello
hellohome vhellohome
long vret,ll_result
string verror,vreturn
blob vb

ll_result = myconnect.Lookup(vhellohome,"hello/Hello",
"hello.HelloHome")

messagebox('',string(ll_result))//ll_result=50,why?
if ll_result<>0 then return
TRY
vhello = vhellohome.Create()
CATCH (ctscomponents_createexception ce)
MessageBox("Create exception", ce.getmessage())
END TRY

vreturn=vhello.gethello()

> If using EAServer, don't worry about the EJB Client
> method. If your Java/EJB method returns
> TabularResults::ResultSet then when you create EAServer
> proxies (not EJB proxies), PowerBuilder will automatically
> use the PowerBuilder ResultSet type. Check out
> documentation on the CreateFrom and GenerateResultSet
> methods to convert a ResultSet to a datastore and vice
> versa.
>
> On 11 Apr 2004 17:30:46 -0800, qhc_cn@sohu.com wrote:
>
> >Thanks for your replay!
> >I use the EAServer5.0 and PB9.01.
> >Can you give me a code examples?
> >Thanks.
> >> You are going to need PB 9.0.1 at a minimum because
> >> TabularResults.ResultSet has public class variables
> which >> are not supported in PB9.0 GA.
> >>
> >> What application server are you using? TabularResults
> is >> generally associated with EAServer, in which case I
> would >> recommend using native connectivity methods (the
> >> PowerBuilder connection object) because a
> >> TabularResults.ResultSet is automatically marshalled
> into >> the PowerBuilder ResultSet datatype by the PBVM.
> >>
> >> Since the TabularResults package was open sourced
> though >> you could use it with other app servers in which
> case the >> EJB Proxy mechanism is appropriate. You will
> however have >> to traverse the fields of the ResultSet
> proxy manually to >> do what you want on the PB client end
> - e.g., populate a >> datastore. There is no 'magic' as
> there is when you use >> the PowerBuilder connection
> object. >>
> >> On 9 Apr 2004 01:09:44 -0800, qhc_cn@sohu.com wrote:
> >>
> >> >EJB return TabularResults.ResultSet,
> >> >PB Client Proxy Data type is java_ResultSet,
> >> >How to use java_ResultSet in PB?
> >>
> >> Jim O'Neil
> >> Principal Technical Support Engineer
> >> Sybase, Inc.
> >> Concord, MA
>
> Jim O'Neil
> Principal Technical Support Engineer
> Sybase, Inc.
> Concord, MA


qhc_cn Posted on 2004-04-12 09:32:23.0Z
Sender: 3db3.407a5325.1804289383@sybase.com
From: qhc_cn@sohu.com
Newsgroups: sybase.public.powerbuilder.ejbclient
Subject: Re: how to accept the ResultSet of EJB?
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <407a5413.3db8.846930886@sybase.com>
References: <40765a48.66b2.846930886@sybase.com><4076b43f.3297121@forums.sybase.com> <4079e333.3c41.846930886@sybase.com><4079e524.1875727@forums.sybase.com><407a3352.3d45.846930886@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 12 Apr 2004 01:32:19 -0800, 10.22.241.42
Lines: 74
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 12 Apr 2004 01:32:22 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 12 Apr 2004 01:32:23 -0800
X-Trace: forums-1-dub 1081758743 10.22.108.75 (12 Apr 2004 01:32:23 -0800)
X-Original-Trace: 12 Apr 2004 01:32:23 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:273
Article PK: 424455

I already ravel out the problem.Thanks!

> In this example,Lookup return value is 50,Why?
>
> //Invoking an EJB component method
> //Connection myconnect
> hello vhello
> hellohome vhellohome
> long vret,ll_result
> string verror,vreturn
> blob vb
>
> ll_result = myconnect.Lookup(vhellohome,"hello/Hello",
> "hello.HelloHome")
>
> messagebox('',string(ll_result))//ll_result=50,why?
> if ll_result<>0 then return
> TRY
> vhello = vhellohome.Create()
> CATCH (ctscomponents_createexception ce)
> MessageBox("Create exception", ce.getmessage())
> END TRY
>
> vreturn=vhello.gethello()
>
> > If using EAServer, don't worry about the EJB Client
> > method. If your Java/EJB method returns
> > TabularResults::ResultSet then when you create EAServer
> > proxies (not EJB proxies), PowerBuilder will
> > automatically use the PowerBuilder ResultSet type.
> > Check out documentation on the CreateFrom and
> > GenerateResultSet methods to convert a ResultSet to a
> > datastore and vice versa.
> >
> > On 11 Apr 2004 17:30:46 -0800, qhc_cn@sohu.com wrote:
> >
> > >Thanks for your replay!
> > >I use the EAServer5.0 and PB9.01.
> > >Can you give me a code examples?
> > >Thanks.
> > >> You are going to need PB 9.0.1 at a minimum because
> > >> TabularResults.ResultSet has public class variables
> > which >> are not supported in PB9.0 GA.
> > >>
> > >> What application server are you using?
> > TabularResults is >> generally associated with EAServer,
> > in which case I would >> recommend using native
> > connectivity methods (the >> PowerBuilder connection
> > object) because a >> TabularResults.ResultSet is
> > automatically marshalled into >> the PowerBuilder
> > ResultSet datatype by the PBVM. >>
> > >> Since the TabularResults package was open sourced
> > though >> you could use it with other app servers in
> > which case the >> EJB Proxy mechanism is appropriate.
> > You will however have >> to traverse the fields of the
> > ResultSet proxy manually to >> do what you want on the
> > PB client end - e.g., populate a >> datastore. There is
> > no 'magic' as there is when you use >> the PowerBuilder
> > connection object. >>
> > >> On 9 Apr 2004 01:09:44 -0800, qhc_cn@sohu.com wrote:
> > >>
> > >> >EJB return TabularResults.ResultSet,
> > >> >PB Client Proxy Data type is java_ResultSet,
> > >> >How to use java_ResultSet in PB?
> > >>
> > >> Jim O'Neil
> > >> Principal Technical Support Engineer
> > >> Sybase, Inc.
> > >> Concord, MA
> >
> > Jim O'Neil
> > Principal Technical Support Engineer
> > Sybase, Inc.
> > Concord, MA