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.

Why can't change transaction object property 'Autocommit' to 'true'

6 posts in General Discussion (old) Last posting was on 2000-08-31 15:16:22.0Z
michael Posted on 2000-03-16 12:04:01.0Z
Newsgroups: sybase.public.easerver
From: "michael" <michael@khmail.fast.com.tw>
Subject: Why can't change transaction object property 'Autocommit' to 'true'
Date: Thu, 16 Mar 2000 20:04:01 +0800
Lines: 11
X-Newsreader: Microsoft Outlook Express 4.72.3612.1700
X-Mimeole: Produced By Microsoft MimeOLE V4.72.3612.1700
NNTP-Posting-Host: 203.73.26.1
Message-ID: <347_vH11PA0j$GA.261@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26311
Article PK: 156980

I create a component in Jaguar CTS 3.5
the component create a datastore, and connect using transaction object,
but I have to change the transaction object property 'autocommit' from
"false" to "true",
but it doesn't work......the property is still "false",

can anybody tell me why?

thanks a lot!


Jim O'Neil [Sybase] Posted on 2000-03-16 15:38:12.0Z
Newsgroups: sybase.public.easerver
Date: Thu, 16 Mar 2000 10:38:12 -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: Why can't change transaction object property 'Autocommit' to 'true'
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 15
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38D0FFE4.AB390645@sybase.com>
References: <347_vH11PA0j$GA.261@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26288
Article PK: 156957


michael wrote:

> I create a component in Jaguar CTS 3.5
> the component create a datastore, and connect using transaction object,
> but I have to change the transaction object property 'autocommit' from
> "false" to "true",
> but it doesn't work......the property is still "false",
>
> can anybody tell me why?
>
> thanks a lot!

PowerBuilder basically ignores the Autocommit setting when running inside
of Jaguar - as Dave said, it's Jaguar that's managing the transactions, so
PB is deferring.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


nneil Posted on 2000-08-31 06:28:16.0Z
Newsgroups: sybase.public.easerver
From: nneil@brewster.ca
Date: Thu, 31 Aug 2000 02:28:16 -0400
Subject: Re: Why can't change transaction object property 'Autocommit' to 'true'
Lines: 12
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <347_F55A086AA165F45600238C0F8525694C.0057A742852568A4@webforums>
References: <347_vH11PA0j$GA.261@forums.sybase.com> <347_38D0FFE4.AB390645@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.easerver:12647
Article PK: 141966

After reading several of these threads, I'm curious...

One of the strong selling features of EAS is the ability to use existing PB
code when porting an app to the web.

If I have an existing app that has many (100) dw's that are based on stored
proc's that create #temp tables, does this mean that I have to rewrite all
of them before I can use them in an HTHL datawindow?

Is this then a limitation of EAS or ASE 11.9.2 (or both)?

Norm


Jim O'Neil [Sybase] Posted on 2000-08-31 15:16:22.0Z
Newsgroups: sybase.public.easerver
From: joneil@sybase.com (Jim O'Neil [Sybase])
Subject: Re: Why can't change transaction object property 'Autocommit' to 'true'
Date: Thu, 31 Aug 2000 15:16:22 GMT
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 35
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_39ae75ac.10484916@forums.powersoft.com>
References: <347_vH11PA0j$GA.261@forums.sybase.com> <347_38D0FFE4.AB390645@sybase.com> <347_F55A086AA165F45600238C0F8525694C.0057A742852568A4@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:12613
Article PK: 141933

Well, it's a limitation of ASE that you can't issue DDL (create
tables, etc.) within the scope of a transaction and since the WebDW is
a transactional component, you run into the problem.

If you are using CREATE TABLE statements (versus SELECT INTO) then you
can issue actually DDL within a transaction by setting a database
option flag (as you may have noted in the postings you reviewed).

SELECT INTO will still not be allowed though, so your only way out
then is to make the WebDW not participate in a transaction, but by
doing so you change the transactional properties of that component and
so would need to address the ramifications of doing so. I don't know
if it's a really big deal or not, perhaps some of the people using the
WebDW extensively would have some better insight.

Jim O'Neil
Sybase Technical Support

On Thu, 31 Aug 2000 02:28:16 -0400, nneil@brewster.ca wrote:

>After reading several of these threads, I'm curious...
>
>One of the strong selling features of EAS is the ability to use existing PB
>code when porting an app to the web.
>
>If I have an existing app that has many (100) dw's that are based on stored
>proc's that create #temp tables, does this mean that I have to rewrite all
>of them before I can use them in an HTHL datawindow?
>
>Is this then a limitation of EAS or ASE 11.9.2 (or both)?
>
>Norm


Ashish Mahajan Posted on 2000-03-16 16:30:23.0Z
Newsgroups: sybase.public.easerver
From: "Ashish Mahajan" <ash@NOSPAM.com>
Subject: Re: Why can't change transaction object property 'Autocommit' to 'true'
Date: Thu, 16 Mar 2000 11:30:23 -0500
Lines: 32
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: pikachu.sybase.com 204.167.42.191
Message-ID: <347_rBTTBW2j$GA.201@forums.sybase.com>
References: <347_vH11PA0j$GA.261@forums.sybase.com> <347_38D0FFE4.AB390645@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26283
Article PK: 156952

Actually PB ignores this setting ONLY if the component is taking part in a
Jaguar Transaction. If you want to bypass the Jaguar Transaction mark the
component "Does not Support Transactions" and you should be able to set this
property to True or False...

-Ashish

"Jim O'Neil [Sybase]" <joneil@sybase.com> wrote in message
news:38D0FFE4.AB390645@sybase.com...
> michael wrote:
>
> > I create a component in Jaguar CTS 3.5
> > the component create a datastore, and connect using transaction object,
> > but I have to change the transaction object property 'autocommit' from
> > "false" to "true",
> > but it doesn't work......the property is still "false",
> >
> > can anybody tell me why?
> >
> > thanks a lot!
>
> PowerBuilder basically ignores the Autocommit setting when running inside
> of Jaguar - as Dave said, it's Jaguar that's managing the transactions, so
> PB is deferring.
> --
> Jim O'Neil
> Senior Technical Support Engineer
> Sybase, Inc
>
>


Dave Wolf [Sybase] Posted on 2000-03-16 12:49:37.0Z
Newsgroups: sybase.public.easerver
From: "Dave Wolf [Sybase]" <dwolf@sybase.com>
Subject: Re: Why can't change transaction object property 'Autocommit' to 'true'
Date: Thu, 16 Mar 2000 07:49:37 -0500
Lines: 22
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: vpn-eme-022.sybase.com 130.214.8.22
Message-ID: <347_U71Dta0j$GA.111@forums.sybase.com>
References: <347_vH11PA0j$GA.261@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26306
Article PK: 156976

Because you should never touch this. Since EAS is likely starting a
transaction it is resetting this. You should look into the documentation on
how EAS manages transactions.

Dave Wolf
Internet Applications Division

"michael" <michael@khmail.fast.com.tw> wrote in message
news:vH11PA0j$GA.261@forums.sybase.com...
> I create a component in Jaguar CTS 3.5
> the component create a datastore, and connect using transaction object,
> but I have to change the transaction object property 'autocommit' from
> "false" to "true",
> but it doesn't work......the property is still "false",
>
> can anybody tell me why?
>
> thanks a lot!
>
>