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.

Q: EJB and datastores

9 posts in General Discussion (old) Last posting was on 2000-02-24 16:26:30.0Z
bobby Posted on 2000-02-22 15:15:04.0Z
Newsgroups: sybase.public.easerver
From: "bobby" <brosenberger@genam.com>
Subject: Q: EJB and datastores
Date: Tue, 22 Feb 2000 09:15:04 -0600
Lines: 3
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: general.american.genam.com 208.209.229.251
Message-ID: <347_YwzjrhUf$GA.274@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28197
Article PK: 160075

Can you use a datastore within an EJB (using PowerJ 3.5)? Just curious.


Dave Wolf [Sybase] Posted on 2000-02-22 15:24:25.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: EJB and datastores
Date: Tue, 22 Feb 2000 10:24:25 -0500
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: dwolf-nt.sybase.com 157.133.41.127
Message-ID: <347_JYgsqlUf$GA.151@forums.sybase.com>
References: <347_YwzjrhUf$GA.274@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28196
Article PK: 160074

Yes you could.

Dave Wolf
Internet Applications Division

bobby <brosenberger@genam.com> wrote in message
news:YwzjrhUf$GA.274@forums.sybase.com...
> Can you use a datastore within an EJB (using PowerJ 3.5)? Just curious.
>
>


bobby Posted on 2000-02-22 16:19:19.0Z
Newsgroups: sybase.public.easerver
From: "bobby" <brosenberger@genam.com>
Subject: Re: EJB and datastores
Date: Tue, 22 Feb 2000 10:19:19 -0600
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: general.american.genam.com 208.209.229.251
Message-ID: <347_HN7dlFVf$GA.202@forums.sybase.com>
References: <347_YwzjrhUf$GA.274@forums.sybase.com> <347_JYgsqlUf$GA.151@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28182
Article PK: 160062

Hey Dave,

Is there an example of how to do this somewhere?

Thanks,

Bobby R

Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
news:JYgsqlUf$GA.151@forums.sybase.com...
> Yes you could.
>
> Dave Wolf
> Internet Applications Division
>
> bobby <brosenberger@genam.com> wrote in message
> news:YwzjrhUf$GA.274@forums.sybase.com...
> > Can you use a datastore within an EJB (using PowerJ 3.5)? Just curious.
> >
> >
>
>


Dave Wolf [Sybase] Posted on 2000-02-22 16:30:15.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: EJB and datastores
Date: Tue, 22 Feb 2000 11:30:15 -0500
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: dwolf-nt.sybase.com 157.133.41.127
Message-ID: <347_5tg7cKVf$GA.202@forums.sybase.com>
References: <347_YwzjrhUf$GA.274@forums.sybase.com> <347_JYgsqlUf$GA.151@forums.sybase.com> <347_HN7dlFVf$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28180
Article PK: 160059

Nothing I have as I dont normally use a DataStore. Can you tell me where
you want to use it and for what? Its really no different for an EJB than
any of our other samples for CORBA objects.

Dave Wolf
Internet Applications Division

bobby <brosenberger@genam.com> wrote in message
news:HN7dlFVf$GA.202@forums.sybase.com...
> Hey Dave,
>
> Is there an example of how to do this somewhere?
>
> Thanks,
>
> Bobby R
>
> Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> news:JYgsqlUf$GA.151@forums.sybase.com...
> > Yes you could.
> >
> > Dave Wolf
> > Internet Applications Division
> >
> > bobby <brosenberger@genam.com> wrote in message
> > news:YwzjrhUf$GA.274@forums.sybase.com...
> > > Can you use a datastore within an EJB (using PowerJ 3.5)? Just
curious.
> > >
> > >
> >
> >
>
>


bobby Posted on 2000-02-22 17:07:58.0Z
Newsgroups: sybase.public.easerver
From: "bobby" <brosenberger@genam.com>
Subject: Re: EJB and datastores
Date: Tue, 22 Feb 2000 11:07:58 -0600
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: general.american.genam.com 208.209.229.251
Message-ID: <347_fhoGxgVf$GA.202@forums.sybase.com>
References: <347_YwzjrhUf$GA.274@forums.sybase.com> <347_JYgsqlUf$GA.151@forums.sybase.com> <347_HN7dlFVf$GA.202@forums.sybase.com> <347_5tg7cKVf$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28174
Article PK: 160056

Well I currently have a CORBA object written in PB and deployed to Jaguar.
It uses a datastore sourced by a stored procedure to check the validity of a
username/password combination. I'm going to attempt to convert this object
to an EJB. It'll be the first EJB we've done so I'm starting to fish for
info and looking for good places to find examples, etc.

I'd appreciate any help.

Thanks.

Bobby R

Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
news:5tg7cKVf$GA.202@forums.sybase.com...
> Nothing I have as I dont normally use a DataStore. Can you tell me where
> you want to use it and for what? Its really no different for an EJB than
> any of our other samples for CORBA objects.
>
> Dave Wolf
> Internet Applications Division
>
> bobby <brosenberger@genam.com> wrote in message
> news:HN7dlFVf$GA.202@forums.sybase.com...
> > Hey Dave,
> >
> > Is there an example of how to do this somewhere?
> >
> > Thanks,
> >
> > Bobby R
> >
> > Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> > news:JYgsqlUf$GA.151@forums.sybase.com...
> > > Yes you could.
> > >
> > > Dave Wolf
> > > Internet Applications Division
> > >
> > > bobby <brosenberger@genam.com> wrote in message
> > > news:YwzjrhUf$GA.274@forums.sybase.com...
> > > > Can you use a datastore within an EJB (using PowerJ 3.5)? Just
> curious.
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Evan Ireland Posted on 2000-02-23 00:51:35.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 23 Feb 2000 13:51:35 +1300
From: Evan Ireland <eireland@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: bobby <brosenberger@genam.com>
Subject: Re: EJB and datastores
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 53
NNTP-Posting-Host: 130.214.8.39
Message-ID: <347_38B32F17.A95A21B1@sybase.com>
References: <347_YwzjrhUf$GA.274@forums.sybase.com> <347_JYgsqlUf$GA.151@forums.sybase.com> <347_HN7dlFVf$GA.202@forums.sybase.com> <347_5tg7cKVf$GA.202@forums.sybase.com> <347_fhoGxgVf$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28121
Article PK: 160010


bobby wrote:
>
> Well I currently have a CORBA object written in PB and deployed to Jaguar.
> It uses a datastore sourced by a stored procedure to check the validity of a
> username/password combination. I'm going to attempt to convert this object
> to an EJB. It'll be the first EJB we've done so I'm starting to fish for
> info and looking for good places to find examples, etc.
>
> I'd appreciate any help.

I would suggest that you use direct JDBC calls in this case. Just take
a sample component that uses JDBC and modify it to use a CallableStatement
to call the stored procedure. Using a Java DataStore just to call a simple
stored procedure that doesn't return row data seems like overkill.

> Thanks.
>
> Bobby R
>
> Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> news:5tg7cKVf$GA.202@forums.sybase.com...
> > Nothing I have as I dont normally use a DataStore. Can you tell me where
> > you want to use it and for what? Its really no different for an EJB than
> > any of our other samples for CORBA objects.
> >
> > Dave Wolf
> > Internet Applications Division
> >
> > bobby <brosenberger@genam.com> wrote in message
> > news:HN7dlFVf$GA.202@forums.sybase.com...
> > > Hey Dave,
> > >
> > > Is there an example of how to do this somewhere?
> > >
> > > Thanks,
> > >
> > > Bobby R
> > >
> > > Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> > > news:JYgsqlUf$GA.151@forums.sybase.com...
> > > > Yes you could.
> > > >
> > > > Dave Wolf
> > > > Internet Applications Division
> > > >
> > > > bobby <brosenberger@genam.com> wrote in message
> > > > news:YwzjrhUf$GA.274@forums.sybase.com...
> > > > > Can you use a datastore within an EJB (using PowerJ 3.5)? Just
> > curious.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >

--
________________________________________________________________________________

Evan Ireland Sybase EA Server Engineering eireland@sybase.com
Wellington - New Zealand +64 4 934-5856


bobby Posted on 2000-02-24 16:26:30.0Z
Newsgroups: sybase.public.easerver
From: "bobby" <brosenberger@genam.com>
Subject: Re: EJB and datastores
Date: Thu, 24 Feb 2000 10:26:30 -0600
Lines: 86
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: general.american.genam.com 208.209.229.251
Message-ID: <347_MTcJ$Suf$GA.201@forums.sybase.com>
References: <347_YwzjrhUf$GA.274@forums.sybase.com> <347_JYgsqlUf$GA.151@forums.sybase.com> <347_HN7dlFVf$GA.202@forums.sybase.com> <347_5tg7cKVf$GA.202@forums.sybase.com> <347_fhoGxgVf$GA.202@forums.sybase.com> <347_38B32F17.A95A21B1@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27921
Article PK: 159617

Evan,

I've over-simplified the situation for clarity's sake. I do return row data.
However, if you know of a sample component that implements a stored proc.,
as you suggest in your post, I'd certainly like to take a look at it.

Thanks,

Bobby R

Evan Ireland <eireland@sybase.com> wrote in message
news:38B32F17.A95A21B1@sybase.com...
> bobby wrote:
> >
> > Well I currently have a CORBA object written in PB and deployed to
Jaguar.
> > It uses a datastore sourced by a stored procedure to check the validity
of a
> > username/password combination. I'm going to attempt to convert this
object
> > to an EJB. It'll be the first EJB we've done so I'm starting to fish for
> > info and looking for good places to find examples, etc.
> >
> > I'd appreciate any help.
>
> I would suggest that you use direct JDBC calls in this case. Just take
> a sample component that uses JDBC and modify it to use a CallableStatement
> to call the stored procedure. Using a Java DataStore just to call a simple
> stored procedure that doesn't return row data seems like overkill.
>
> > Thanks.
> >
> > Bobby R
> >
> > Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> > news:5tg7cKVf$GA.202@forums.sybase.com...
> > > Nothing I have as I dont normally use a DataStore. Can you tell me
where
> > > you want to use it and for what? Its really no different for an EJB
than
> > > any of our other samples for CORBA objects.
> > >
> > > Dave Wolf
> > > Internet Applications Division
> > >
> > > bobby <brosenberger@genam.com> wrote in message
> > > news:HN7dlFVf$GA.202@forums.sybase.com...
> > > > Hey Dave,
> > > >
> > > > Is there an example of how to do this somewhere?
> > > >
> > > > Thanks,
> > > >
> > > > Bobby R
> > > >
> > > > Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> > > > news:JYgsqlUf$GA.151@forums.sybase.com...
> > > > > Yes you could.
> > > > >
> > > > > Dave Wolf
> > > > > Internet Applications Division
> > > > >
> > > > > bobby <brosenberger@genam.com> wrote in message
> > > > > news:YwzjrhUf$GA.274@forums.sybase.com...
> > > > > > Can you use a datastore within an EJB (using PowerJ 3.5)? Just
> > > curious.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
>
> --
>

____________________________________________________________________________
____
>
> Evan Ireland Sybase EA Server Engineering
eireland@sybase.com
> Wellington - New Zealand +64 4
934-5856


Dave Wolf [Sybase] Posted on 2000-02-22 17:21:15.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: EJB and datastores
Date: Tue, 22 Feb 2000 12:21:15 -0500
Lines: 252
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: dwolf-nt.sybase.com 157.133.41.127
Message-ID: <347_hIL#8mVf$GA.274@forums.sybase.com>
References: <347_YwzjrhUf$GA.274@forums.sybase.com> <347_JYgsqlUf$GA.151@forums.sybase.com> <347_HN7dlFVf$GA.202@forums.sybase.com> <347_5tg7cKVf$GA.202@forums.sybase.com> <347_fhoGxgVf$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28172
Article PK: 160053

Here is an example simple EJB from SVU that returns a ResultSet.

Dave Wolf
Internet Applications Division

bobby <brosenberger@genam.com> wrote in message
news:fhoGxgVf$GA.202@forums.sybase.com...
> Well I currently have a CORBA object written in PB and deployed to Jaguar.
> It uses a datastore sourced by a stored procedure to check the validity of
a
> username/password combination. I'm going to attempt to convert this object
> to an EJB. It'll be the first EJB we've done so I'm starting to fish for
> info and looking for good places to find examples, etc.
>
> I'd appreciate any help.
>
> Thanks.
>
> Bobby R
>
> Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> news:5tg7cKVf$GA.202@forums.sybase.com...
> > Nothing I have as I dont normally use a DataStore. Can you tell me
where
> > you want to use it and for what? Its really no different for an EJB
than
> > any of our other samples for CORBA objects.
> >
> > Dave Wolf
> > Internet Applications Division
> >
> > bobby <brosenberger@genam.com> wrote in message
> > news:HN7dlFVf$GA.202@forums.sybase.com...
> > > Hey Dave,
> > >
> > > Is there an example of how to do this somewhere?
> > >
> > > Thanks,
> > >
> > > Bobby R
> > >
> > > Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> > > news:JYgsqlUf$GA.151@forums.sybase.com...
> > > > Yes you could.
> > > >
> > > > Dave Wolf
> > > > Internet Applications Division
> > > >
> > > > bobby <brosenberger@genam.com> wrote in message
> > > > news:YwzjrhUf$GA.274@forums.sybase.com...
> > > > > Can you use a datastore within an EJB (using PowerJ 3.5)? Just
> > curious.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>


bobby Posted on 2000-02-22 18:21:05.0Z
Newsgroups: sybase.public.easerver
From: "bobby" <brosenberger@genam.com>
Subject: Re: EJB and datastores
Date: Tue, 22 Feb 2000 12:21:05 -0600
Lines: 81
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: general.american.genam.com 208.209.229.251
Message-ID: <347_9srOoJWf$GA.201@forums.sybase.com>
References: <347_YwzjrhUf$GA.274@forums.sybase.com> <347_JYgsqlUf$GA.151@forums.sybase.com> <347_HN7dlFVf$GA.202@forums.sybase.com> <347_5tg7cKVf$GA.202@forums.sybase.com> <347_fhoGxgVf$GA.202@forums.sybase.com> <347_hIL#8mVf$GA.274@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:28160
Article PK: 160041

Ok... I see. This example embeds the SQL statement right into the code and
returns the result set into a variable of type "TabularResults.ResultSet".

So, I just need to figure out how to utilize our stored procedure and then
also how to access the data in the ResultSet. Do you recommend using the
TabularResults.ResultSet instead of a datastore?

Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
news:hIL#8mVf$GA.274@forums.sybase.com...
> Here is an example simple EJB from SVU that returns a ResultSet.
>
> Dave Wolf
> Internet Applications Division
>
>
> bobby <brosenberger@genam.com> wrote in message
> news:fhoGxgVf$GA.202@forums.sybase.com...
> > Well I currently have a CORBA object written in PB and deployed to
Jaguar.
> > It uses a datastore sourced by a stored procedure to check the validity
of
> a
> > username/password combination. I'm going to attempt to convert this
object
> > to an EJB. It'll be the first EJB we've done so I'm starting to fish for
> > info and looking for good places to find examples, etc.
> >
> > I'd appreciate any help.
> >
> > Thanks.
> >
> > Bobby R
> >
> > Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> > news:5tg7cKVf$GA.202@forums.sybase.com...
> > > Nothing I have as I dont normally use a DataStore. Can you tell me
> where
> > > you want to use it and for what? Its really no different for an EJB
> than
> > > any of our other samples for CORBA objects.
> > >
> > > Dave Wolf
> > > Internet Applications Division
> > >
> > > bobby <brosenberger@genam.com> wrote in message
> > > news:HN7dlFVf$GA.202@forums.sybase.com...
> > > > Hey Dave,
> > > >
> > > > Is there an example of how to do this somewhere?
> > > >
> > > > Thanks,
> > > >
> > > > Bobby R
> > > >
> > > > Dave Wolf [Sybase] <dwolf@sybase.com> wrote in message
> > > > news:JYgsqlUf$GA.151@forums.sybase.com...
> > > > > Yes you could.
> > > > >
> > > > > Dave Wolf
> > > > > Internet Applications Division
> > > > >
> > > > > bobby <brosenberger@genam.com> wrote in message
> > > > > news:YwzjrhUf$GA.274@forums.sybase.com...
> > > > > > Can you use a datastore within an EJB (using PowerJ 3.5)? Just
> > > curious.
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
>