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.

HTML Datawindow & autocommit

4 posts in General Discussion (old) Last posting was on 2000-03-02 02:58:55.0Z
Warren Dosch Posted on 2000-02-29 02:16:18.0Z
Newsgroups: sybase.public.easerver
From: "Warren Dosch" <wdosch@cableregina.com>
Subject: HTML Datawindow & autocommit
Date: Mon, 28 Feb 2000 20:16:18 -0600
Lines: 25
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: ip75.net247251.cr.sk.ca 24.72.51.75
Message-ID: <347_q#izXulg$GA.295@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27614
Article PK: 158988

I am having a problem with some stored procedures behind some HTML data
windows. Any procedure which creates a temporary table dies saying you can
not create a temp table inside a transaction. I don't have this problem when
I run through PowerBuilder only through the HTML Datawindow. I think the
problem is that "autocommit" is not set to true. My Question is how do you
set "autocommit = true"? Where do you put this? Here is the syntax I am
using below.

By the way I am using
PowerSite 7.01
Jaguar 3.0
Open Client 11.??
Adaptive Server Enterprise 11.9.2

Using the PowerSite Object Model:

PSConnectionParmsClass("", "<userid>", "<password>", "SYJ",
"",<database>","<server name from SQL.INI>")

or, if using Cache by Name

PSConnectionParmsClass("CacheName='<cache name>'", "", "", "SYJ",
"","<database>")


Dean Jones [Team Sybase] Posted on 2000-02-29 02:49:19.0Z
Newsgroups: sybase.public.easerver
From: "Dean Jones [Team Sybase]" <dean_no_spam_@powerobjects.com>
Subject: Re: HTML Datawindow & autocommit
Date: Mon, 28 Feb 2000 20:49:19 -0600
Lines: 44
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: dsl131.outtech.com 216.207.145.131
Message-ID: <347_PBYFbBmg$GA.201@forums.sybase.com>
References: <347_q#izXulg$GA.295@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27609
Article PK: 158982

Two ideas.

1. Write a custom component so you can set autocommit to true.
2. There is a setting in your database that DDL to not commit. (I can't
remember what it is)

HTH

Dean Jones, CPD Professional
Team Sybase
PowerTeam, Inc.
http://www.powerobjects.com

Warren Dosch <wdosch@cableregina.com> wrote in message
news:q#izXulg$GA.295@forums.sybase.com...
> I am having a problem with some stored procedures behind some HTML data
> windows. Any procedure which creates a temporary table dies saying you can
> not create a temp table inside a transaction. I don't have this problem
when
> I run through PowerBuilder only through the HTML Datawindow. I think the
> problem is that "autocommit" is not set to true. My Question is how do you
> set "autocommit = true"? Where do you put this? Here is the syntax I am
> using below.
>
> By the way I am using
> PowerSite 7.01
> Jaguar 3.0
> Open Client 11.??
> Adaptive Server Enterprise 11.9.2
>
> Using the PowerSite Object Model:
>
> PSConnectionParmsClass("", "<userid>", "<password>", "SYJ",
> "",<database>","<server name from SQL.INI>")
>
> or, if using Cache by Name
>
> PSConnectionParmsClass("CacheName='<cache name>'", "", "", "SYJ",
> "","<database>")
>
>


Jim O'Neil [Sybase] Posted on 2000-02-29 04:38:50.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 28 Feb 2000 23:38:50 -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: HTML Datawindow & autocommit
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 18
NNTP-Posting-Host: nomad6-46.sybase.com 157.133.176.46
Message-ID: <347_38BB4D5A.104A7B58@sybase.com>
References: <347_q#izXulg$GA.295@forums.sybase.com> <347_PBYFbBmg$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27568
Article PK: 158944


"Dean Jones [Team Sybase]" wrote:

> Two ideas.
>
> 1. Write a custom component so you can set autocommit to true.
> 2. There is a setting in your database that DDL to not commit. (I can't
> remember what it is)
>
> HTH
>
> Dean Jones, CPD Professional
> Team Sybase
> PowerTeam, Inc.
> http://www.powerobjects.com
>

Actually, 1) won't work. I'm told by development that AutoCommit is ignored in
the context of Jaguar, since Jaguar Cache Management is handling the
connection. The analog of doing this would be to set the transactional
attribute of the HTMLDatawindow component to Does Not Support Tranasaction.


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


Warren Dosch Posted on 2000-03-02 02:58:55.0Z
Newsgroups: sybase.public.easerver
From: "Warren Dosch" <wdosch@cableregina.com>
Subject: Re: HTML Datawindow & autocommit
Date: Wed, 1 Mar 2000 20:58:55 -0600
Lines: 39
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
NNTP-Posting-Host: ip107.net247251.cr.sk.ca 24.72.51.107
Message-ID: <347_1RAlkP$g$GA.74@forums.sybase.com>
References: <347_q#izXulg$GA.295@forums.sybase.com> <347_PBYFbBmg$GA.201@forums.sybase.com> <347_38BB4D5A.104A7B58@sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:27367
Article PK: 158775

Thanks
I discovered there is one other work around
Put a commit at the top of the stored procedure.
Since this seems like a bad thing to do (confusing later(maintenace)) I will
set the attribute on the HTMLDatawindow component OR more likely create my
own HTMLDatawindow component and set the attribute on that.

Jim O'Neil [Sybase] wrote in message <38BB4D5A.104A7B58@sybase.com>...
>"Dean Jones [Team Sybase]" wrote:
>
>> Two ideas.
>>
>> 1. Write a custom component so you can set autocommit to true.
>> 2. There is a setting in your database that DDL to not commit. (I can't
>> remember what it is)
>>
>> HTH
>>
>> Dean Jones, CPD Professional
>> Team Sybase
>> PowerTeam, Inc.
>> http://www.powerobjects.com
>>
>
>Actually, 1) won't work. I'm told by development that AutoCommit is
ignored in
>the context of Jaguar, since Jaguar Cache Management is handling the
>connection. The analog of doing this would be to set the transactional
>attribute of the HTMLDatawindow component to Does Not Support Tranasaction.
>
>
>--
>Jim O'Neil
>Senior Technical Support Engineer
>Sybase, Inc
>
>