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.

from WebPB to Jaguar - problems with the transaction object

5 posts in General Discussion (old) Last posting was on 2000-04-01 02:37:27.0Z
André Luiz Posted on 2000-03-29 23:18:29.0Z
Newsgroups: sybase.public.easerver
From: "André Luiz" <andremineiro@uol.com.br>
Subject: from WebPB to Jaguar - problems with the transaction object
Date: Wed, 29 Mar 2000 20:18:29 -0300
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
NNTP-Posting-Host: 200.187.194.76
Message-ID: <347_SGGioZdm$GA.298@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25292
Article PK: 155408

Hi all!

I have a WebPB based application and want to migrate it to the Jaguar
environment.
This application connects to an Oracle database and executes a series of
stored procedures.
It's a query system.

The application follows the guidelines below:
1 - There's a standard transaction object.
2 - There's a non-visual user object that inherits from the transaction
object. This NVO (called RPC),
contains references to a set of stored procedures to the Oracle database.
These references are declared as
local external functions.
3 - There's another NVO that inherits from RPC (called DB). This NVO
encapsulates the calls to the stored
procedures. It's composed by a set of user object functions.
4 - There's another NVO composed by a set of user object functions that
simply generates HTML code.
These functions call the user objects functions of the DB object and format
the results in HTML.
5 - My SQLCA is of type DB.

It works nicely using WebPB.

But I'm experiencing some problems in migrating to Jaguar, especially cause
the standard transaction object.
It seems Jaguar doesn't like that.
Any suggestions to make this transition simple?

Thanks very much to all answers.

Regards, André.


Larry Cermak[Team Sybase] Posted on 2000-03-30 04:03:47.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: from WebPB to Jaguar - problems with the transaction object
Date: Wed, 29 Mar 2000 22:03:47 -0600
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node18.dhcpchi.dslspeed.zyan.com 208.41.199.18
Message-ID: <347_N7t185fm$GA.290@forums.sybase.com>
References: <347_SGGioZdm$GA.298@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25265
Article PK: 155390

Check the SDN, and previous threads here, about the JAWS utility. That
might be what you're looking for.

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

Web DataWindow Training
EAServer Training

"André Luiz" <andremineiro@uol.com.br> wrote in message
news:SGGioZdm$GA.298@forums.sybase.com...
> Hi all!
>
> I have a WebPB based application and want to migrate it to the Jaguar
> environment.
> This application connects to an Oracle database and executes a series of
> stored procedures.
> It's a query system.
>
> The application follows the guidelines below:
> 1 - There's a standard transaction object.
> 2 - There's a non-visual user object that inherits from the transaction
> object. This NVO (called RPC),
> contains references to a set of stored procedures to the Oracle database.
> These references are declared as
> local external functions.
> 3 - There's another NVO that inherits from RPC (called DB). This NVO
> encapsulates the calls to the stored
> procedures. It's composed by a set of user object functions.
> 4 - There's another NVO composed by a set of user object functions that
> simply generates HTML code.
> These functions call the user objects functions of the DB object and
format
> the results in HTML.
> 5 - My SQLCA is of type DB.
>
> It works nicely using WebPB.
>
> But I'm experiencing some problems in migrating to Jaguar, especially
cause
> the standard transaction object.
> It seems Jaguar doesn't like that.
> Any suggestions to make this transition simple?
>
> Thanks very much to all answers.
>
> Regards, André.
>
>


Jim O'Neil [Sybase] Posted on 2000-03-30 02:53:44.0Z
Newsgroups: sybase.public.easerver
Date: Wed, 29 Mar 2000 21:53:44 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: from WebPB to Jaguar - problems with the transaction object
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 45
NNTP-Posting-Host: nomad6-45.sybase.com 157.133.176.45
Message-ID: <347_38E2C1B8.F4B2A63B@sybase.com>
References: <347_SGGioZdm$GA.298@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25271
Article PK: 155398

What kind of problems are you running into - this seems doable. From the
description below, the only NVO that seems like it would need to be a Jaguar
component is described in your point 4. That NVO could do a CREATE of NVO 3
and call the functions it needs to. If that's not capturing what you want to
do, can you post a few more details of what error or problems you are seeing.

--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc

"André Luiz" wrote:

> Hi all!
>
> I have a WebPB based application and want to migrate it to the Jaguar
> environment.
> This application connects to an Oracle database and executes a series of
> stored procedures.
> It's a query system.
>
> The application follows the guidelines below:
> 1 - There's a standard transaction object.
> 2 - There's a non-visual user object that inherits from the transaction
> object. This NVO (called RPC),
> contains references to a set of stored procedures to the Oracle database.
> These references are declared as
> local external functions.
> 3 - There's another NVO that inherits from RPC (called DB). This NVO
> encapsulates the calls to the stored
> procedures. It's composed by a set of user object functions.
> 4 - There's another NVO composed by a set of user object functions that
> simply generates HTML code.
> These functions call the user objects functions of the DB object and format
> the results in HTML.
> 5 - My SQLCA is of type DB.
>
> It works nicely using WebPB.
>
> But I'm experiencing some problems in migrating to Jaguar, especially cause
> the standard transaction object.
> It seems Jaguar doesn't like that.
> Any suggestions to make this transition simple?
>
> Thanks very much to all answers.
>
> Regards, André.


André Luiz Posted on 2000-04-01 01:52:13.0Z
Newsgroups: sybase.public.easerver
From: "André Luiz" <andremineiro@uol.com.br>
Subject: Re: from WebPB to Jaguar - problems with the transaction object
Date: Fri, 31 Mar 2000 22:52:13 -0300
Lines: 80
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
NNTP-Posting-Host: 200.187.198.164
Message-ID: <347_mSdd843m$GA.52@forums.sybase.com>
References: <347_SGGioZdm$GA.298@forums.sybase.com> <347_38E2C1B8.F4B2A63B@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25017
Article PK: 154150

Thanks Jim and Larry!

Things are going well now. The problem is that I was trying to publish the
RPC and DB objects into Jaguar.
I've just published the object described on item 4 and things worked.

But let me know a couple more things:
Is it possible to take advantage of connection caches using OCI and ODBC
drivers to connect to my Oracle database?
Or are connection caches only available to JDBC drivers and SYC and SYJ
interfaces?

Thank you all guyz.

André.

Jim O'Neil [Sybase] <joneil@sybase.com> wrote in message
news:38E2C1B8.F4B2A63B@sybase.com...
> What kind of problems are you running into - this seems doable. From the
> description below, the only NVO that seems like it would need to be a
Jaguar
> component is described in your point 4. That NVO could do a CREATE of NVO
3
> and call the functions it needs to. If that's not capturing what you want
to
> do, can you post a few more details of what error or problems you are
seeing.
>
> --
> Jim O'Neil
> Senior Technical Support Engineer
> Sybase, Inc
>
>
>
> "André Luiz" wrote:
>
> > Hi all!
> >
> > I have a WebPB based application and want to migrate it to the Jaguar
> > environment.
> > This application connects to an Oracle database and executes a series of
> > stored procedures.
> > It's a query system.
> >
> > The application follows the guidelines below:
> > 1 - There's a standard transaction object.
> > 2 - There's a non-visual user object that inherits from the transaction
> > object. This NVO (called RPC),
> > contains references to a set of stored procedures to the Oracle
database.
> > These references are declared as
> > local external functions.
> > 3 - There's another NVO that inherits from RPC (called DB). This NVO
> > encapsulates the calls to the stored
> > procedures. It's composed by a set of user object functions.
> > 4 - There's another NVO composed by a set of user object functions that
> > simply generates HTML code.
> > These functions call the user objects functions of the DB object and
format
> > the results in HTML.
> > 5 - My SQLCA is of type DB.
> >
> > It works nicely using WebPB.
> >
> > But I'm experiencing some problems in migrating to Jaguar, especially
cause
> > the standard transaction object.
> > It seems Jaguar doesn't like that.
> > Any suggestions to make this transition simple?
> >
> > Thanks very much to all answers.
> >
> > Regards, André.
>
>
>
>


Jim O'Neil [Sybase] Posted on 2000-04-01 02:37:27.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 31 Mar 2000 21:37:27 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: from WebPB to Jaguar - problems with the transaction object
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 71
NNTP-Posting-Host: nomad6-39.sybase.com 157.133.176.39
Message-ID: <347_38E560E6.889B1258@sybase.com>
References: <347_SGGioZdm$GA.298@forums.sybase.com> <347_38E2C1B8.F4B2A63B@sybase.com> <347_mSdd843m$GA.52@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25016
Article PK: 154149

Yes you can use ODBC, OCI 7 and OCI 8 caches with the PBODB, PBO73 and PBO84
database interfaces.

--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc

"André Luiz" wrote:

> Thanks Jim and Larry!
>
> Things are going well now. The problem is that I was trying to publish the
> RPC and DB objects into Jaguar.
> I've just published the object described on item 4 and things worked.
>
> But let me know a couple more things:
> Is it possible to take advantage of connection caches using OCI and ODBC
> drivers to connect to my Oracle database?
> Or are connection caches only available to JDBC drivers and SYC and SYJ
> interfaces?
>
> Thank you all guyz.
>
> André.
>
> Jim O'Neil [Sybase] <joneil@sybase.com> wrote in message
> news:38E2C1B8.F4B2A63B@sybase.com...
> > What kind of problems are you running into - this seems doable. From the
> > description below, the only NVO that seems like it would need to be a
> Jaguar
> > component is described in your point 4. That NVO could do a CREATE of NVO
> 3
> > and call the functions it needs to. If that's not capturing what you want
> to
> > do, can you post a few more details of what error or problems you are
> seeing.
> >
> > --
> > Jim O'Neil
> > Senior Technical Support Engineer
> > Sybase, Inc
> >
> >
> >
> > "André Luiz" wrote:
> >
> > > Hi all!
> > >
> > > I have a WebPB based application and want to migrate it to the Jaguar
> > > environment.
> > > This application connects to an Oracle database and executes a series of
> > > stored procedures.
> > > It's a query system.
> > >
> > > The application follows the guidelines below:
> > > 1 - There's a standard transaction object.
> > > 2 - There's a non-visual user object that inherits from the transaction
> > > object. This NVO (called RPC),
> > > contains references to a set of stored procedures to the Oracle
> database.
> > > These references are declared as
> > > local external functions.
> > > 3 - There's another NVO that inherits from RPC (called DB). This NVO
> > > encapsulates the calls to the stored
> > > procedures. It's composed by a set of user object functions.
> > > 4 - There's another NVO composed by a set of user object functions that
> > > simply generates HTML code.
> > > These functions call the user objects functions of the DB object and
> format
> > > the results in HTML.
> > > 5 - My SQLCA is of type DB.
> > >
> > > It works nicely using WebPB.
> > >
> > > But I'm experiencing some problems in migrating to Jaguar, especially
> cause
> > > the standard transaction object.
> > > It seems Jaguar doesn't like that.
> > > Any suggestions to make this transition simple?
> > >
> > > Thanks very much to all answers.
> > >
> > > Regards, André.
> >
> >
> >
> >