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.

datawindow

3 posts in EJB Client Last posting was on 2004-07-22 15:17:00.0Z
EJB Posted on 2004-07-06 14:33:20.0Z
From: "EJB" <lukasz@pwrs.pl>
Newsgroups: sybase.public.powerbuilder.ejbclient
Subject: datawindow
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
NNTP-Posting-Host: honza-m.gda.computerland.pl
X-Original-NNTP-Posting-Host: honza-m.gda.computerland.pl
Message-ID: <40eab830@forums-1-dub>
Date: 6 Jul 2004 07:33:20 -0700
X-Trace: forums-1-dub 1089124400 195.116.44.3 (6 Jul 2004 07:33:20 -0700)
X-Original-Trace: 6 Jul 2004 07:33:20 -0700, honza-m.gda.computerland.pl
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:318
Article PK: 424496

My question is quite simple because I'm starting with ejb - what is the best
way (mean fast) to fill datawindow with data from ejb session bean.
Should my component method return resultset, collection, xml or mayby
something else that provides me with data? Is any difference in choosing
method if query
returns 500 rows or 40000 rows?

lukas


bede Posted on 2004-07-07 07:46:18.0Z
From: "bede" <bedenosp@m.sofico.be>
Newsgroups: sybase.public.powerbuilder.ejbclient
References: <40eab830@forums-1-dub>
Subject: Re: datawindow
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
X-Original-NNTP-Posting-Host: uu194-7-38-226.unknown.uunet.be
Message-ID: <40ebab04@forums-2-dub>
X-Original-Trace: 7 Jul 2004 00:49:24 -0700, uu194-7-38-226.unknown.uunet.be
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 7 Jul 2004 00:41:00 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 7 Jul 2004 00:46:18 -0700
X-Trace: forums-1-dub 1089186378 10.22.108.75 (7 Jul 2004 00:46:18 -0700)
X-Original-Trace: 7 Jul 2004 00:46:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:319
Article PK: 424498

another thing to consider is bandwidth! XML wouldn't score very high there..

we started some years ago with CORBA and got java classes in as structures
that mapped to the dw-definition.
a "setData" was possible using the datawindow-dot notation, something like:

dw.object.data = theStructure

now we've stopped using CORBA, using the pb2ejb and for now we're still
using those same EJBs serverside, returning the same java data-classes as
before.
We decided use generated mapper objects to fill the datawindows.
Results are quite allright, although we never have to deal with 40000 rows.

hth,

Ben

"EJB" <lukasz@pwrs.pl> wrote in message news:40eab830@forums-1-dub...
> My question is quite simple because I'm starting with ejb - what is the
best
> way (mean fast) to fill datawindow with data from ejb session bean.
> Should my component method return resultset, collection, xml or mayby
> something else that provides me with data? Is any difference in choosing
> method if query
> returns 500 rows or 40000 rows?
>
> lukas
>
>
>


Gokhan Demir Posted on 2004-07-22 15:17:00.0Z
From: "Gokhan Demir" <gokhan.demir@igonline.biz>
Newsgroups: sybase.public.powerbuilder.ejbclient
References: <40eab830@forums-1-dub>
Subject: Re: datawindow
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: adsluser-1165.adsl.ttnet.net.tr
Message-ID: <40ffdb61@forums-2-dub>
X-Original-Trace: 22 Jul 2004 08:21:05 -0700, adsluser-1165.adsl.ttnet.net.tr
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Jul 2004 08:10:15 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Jul 2004 08:17:00 -0700
X-Trace: forums-1-dub 1090509420 10.22.108.75 (22 Jul 2004 08:17:00 -0700)
X-Original-Trace: 22 Jul 2004 08:17:00 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.ejbclient:320
Article PK: 424499

Hi,

There are two efficient ways I believe:

1. Use the Sybase TDS protocol and TabularResults package (which is a Sybase
thing, but, open source and therefore portable). You can convert
java.sql.ResultSet to serializable TabularResults.ResultSet and return it
from the server methods. At the client side, you can use
datastore.CreateFrom( TabularResults.ResultSet ) and share this datawindow's
data with your real datawindow (the one with the display logic and the same
buffer).

2. Send dw importable strings from the server and use importString() on the
client side. (very fast). There is one problem with this approach which is
related to the server and client locale differences, decimal points etc. If
the decimal point will be "." at both sides, then there is no problem.

The inefficient way is importing into a datawindow from a java
ValueObjectList via InsertRow() and setItem( ... ) loop. You have to get rid
of this method if your query returns big result sets. (more than 20, and the
difference is getting observable).

Regards,
Gokhan

"EJB" <lukasz@pwrs.pl> wrote in message news:40eab830@forums-1-dub...
> My question is quite simple because I'm starting with ejb - what is the
best
> way (mean fast) to fill datawindow with data from ejb session bean.
> Should my component method return resultset, collection, xml or mayby
> something else that provides me with data? Is any difference in choosing
> method if query
> returns 500 rows or 40000 rows?
>
> lukas
>
>
>