OCI error with Jaguar 3.6.1 and PB 7.0.3 build 10108 #2

We have/had a problem in the disconnect event of an NVO which was deployed
on Jaguar. The component uses instance Datastores - a frowned-upon action
for said versions - but we are reluctant to change as the code will be
replaced within the next 6 months with Java EJBs. Our problem is thus:
When the auto-demarcate component has finished its processing, it logs a
message to srv.log, then should return a blob to the client. Instead, we get
the following message in srv.log, and the client never receives the response
to its request:
Oct 03 11:11:02 2002: OCI8: Exec Stmt Error: -2
Oct 03 11:11:02 2002: OCI8: Get Server Attr Error: -2
From the Oracle (8.1.6) documentation, it seems to be using an invalid
handle - possibly statement handle, but any of 3, it a call to OCIStmtExec.
This should - guessing here - return a valid statement handle which is then
used in OCIAttrGet.
This problem is intermittent - if one component is instantiated, it runs
fine, but it will often fail on the last instance of the component when 2 or
more are active at the same time.

Our component properties are:
Concurrency = TRUE
Bind Object = FALSE
Bind Thread = TRUE
Pooling = FALSE
Sharing = FALSE
and the transaction attributes are set to "Not Supported"

If we set Bind Object = TRUE (other properties unchanged), then our problem
disappears. However the Jaguar documentation states "Applies to stateful
components only (Automatic Demarcation/Deactivation must be disabled on the
Transactions tab or the component must be a stateful session EJB)." for this
property.
Please can someone give a hint as to the cause and possible solution to the
problem, and/or explain the negative implications of setting the Bind Object
property to TRUE for an auto-demarcate component.

Regards,
grants




0
Grant
10/3/2002 11:52:37 AM
sybase.easerver.powerbuilder 3902 articles. 0 followers. Follow

0 Replies
829 Views

Similar Articles

[PageSpeed] 20

Reply:

Similar Artilces:

OCI error with Jaguar 3.6.1 and PB 7.0.3 build 10108
We have/had a problem in the disconnect event of an NVO which was deployed on Jaguar. The component uses instance Datastores - a frowned-upon action for said versions - but we are reluctant to change as the code will be replaced within the next 6 months with Java EJBs. Our problem is thus: When the auto-demarcate component has finished its processing, it logs a message to srv.log, then should return a blob to the client. Instead, we get the following message in srv.log, and the client never receives the response to its request: Oct 03 11:11:02 2002: OCI8: Exec Stmt Error: -2 Oct 03 11...

OCI error with Jaguar 3.6.1 and PB 7.0.3
Sybase, can you please respond to my earlier posting. Your documentation advises against our solution, but does not explain the potential implications. We are using Jaguar 3.6.1 ESD 3 (Build 36112) and PB 7.0.3 build 10108, and using Oracle 8.1.6 database and OCI. Earlier post follows... We have/had a problem in the disconnect event of an NVO which was deployed on Jaguar. The component uses instance Datastores - a frowned-upon action for said versions - but we are reluctant to change as the code will be replaced within the next 6 months with Java EJBs. Our problem is thus: When the...

#EBF1 -EAServer 3.6.1 C1/PowerBuilder 7.0.3 C5 Release 7.0.3 02 Mar 2001 EBF/Patch
why is the #EBF1 not placed right - It is placed Under Powerbuilder EBFs/Downloads. Platform: Windows EAServer 3.6.1 C1/PowerBuilder 7.0.3 C5 Release 7.0.3 02 Mar 2001 EBF/Patch PowerBuilder 7.0.3 C5 Localized Files 7.0.3 16 Feb 2001 EBF/Patch Sybase PowerBuilder and Sybase PowerBuilder Enterprise 7.0.3 C5 7.0.3 09 Feb 2001 EBF/Patch PowerBuilder Enterprise 7.0.3 Maintenance Release 7.0.3 08 Dec 2000 EBF/Patch Sybase PowerBuilder Enterprise - PowerBuilder Enterprise 7.0.2 C4 Release 7.0.2 22 Nov 2000 EBF/Patch PowerBuilder DeskTop 7.0.2 (EBF) C3 Rele...

selecting ? selecting of 1., 2. , 3., 4., 5., 6. is slow (1-3 second) then selecting of 7.,8.,9. go on is so fast (0.1 second or more fast).. how can i get fast for selecting of 1., 2. , 3., 4., 5., 6
hello friends selecting of 1., 2. , 3., 4.(sometime even 5., 6.) is slow (1-3 second) then selecting of 7.,8.,9.(sometimes 5., 6.,) go on is so fast (0.1 second or more fast).. how can i get fast for selecting of 1., 2. , 3., 4., 5., 6. is slow ?? recordcount is almost 1.050.000.. i do selecting 1.2.3. go on same page with treeview1.. treeview1 in masterpage.master.. gridview1 and datasource1 are in pagelist.aspx (it connets datasource1)..productnumber is primarykey for index.. kategori, kategori1 and kategori2, price, datemin are index from keys/index in table1 (right clicking menu)....

[ANN] Release of Bugzilla 3.2.7, 3.4.7, 3.6.1, and 3.7.1
Today we have four new releases! One new development snapshot (3.7.1), two new stable releases (3.6.1 and 3.4.7) and one update for the legacy 3.2 branch (3.2.7). Bugzilla 3.6.1 is our latest stable release. It contains some significant bug fixes for the 3.6 branch. Bugzilla 3.4.7 is the last bug-fix release for the 3.4 series. After this, there will only be additional 3.4 releases if there are security issues discovered in the 3.4 series. Bugzilla 3.2.7 is a security update for the 3.2 branch. Bugzilla 3.7.1 is our first unstable development release on the road to ...

[ANN] Release of Bugzilla 3.2.1, 3.0.7, 2.22.7, and 3.3.2
Today we have some major security improvements for Bugzilla in the form of four releases. We strongly recommend that all Bugzilla administrators read the Security Advisory for these releases, which is linked below in this email. Bugzilla 3.2.1 is our latest stable release. It contains various useful bug fixes in addition to major security improvements. Bugzilla 3.0.7 and Bugzilla 2.22.7 are security updates for their branches. Bugzilla 3.3.2 is an unstable development release. In addition to the security fixes that all the other releases contain, this release contains n...

[ANN] Security Advisory for Bugzilla 3.2.7, 3.4.7, 3.6.1, and 3.7.2
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Summary ======= Bugzilla is a Web-based bug-tracking system used by a large number of software projects. The following security issues have been discovered in Bugzilla: * It was possible to (at least partially) determine the membership of any group using the Search interface. * It was possible to use the 'sudo' feature without sending a notification to the user being impersonated. * The 'Reports' and 'Duplicates' pages let you guess the name of products you could not see, due to the error message ...

EAServer 3.6.1 C3 Solaris / PB 7.0.3 / Oracle 8.3) Empty Blob passed to Client
Hi all, I have a problem with PB 7.0.3 and EAS 3.6.1 C3 on Solaris 2.8. I defined a datawindow with PB that is supposed to show a list of all customers from an Oracle DB. On the server side it all seems to work well. The return status is ok and the number of rows inside the blob is exactly the number of rows in the customer table. When I check the blob after it's transfered to the client, the number of rows is 0. Any help is highly appreciated! Kind regards, Markus ...

From 2.1.2 to 3.1 or 2.1.2 to 3.0.13 to 3.1
I'm checking back in after being away for a couple of months and I missed the 3.1 release. I can't seem to find any info on what's new in 3.1 and also what the upgrade path should be. So, is the recommended path for upgrading from v 2.1.2 to go directly to 3.1 or do I need to go to 3.0.13 first? Are there any big issues in 3.1 that make it a "gotta have it" version?I did a couple of 2.1.2 to 3.0.12 upgrades but haven't upgraded to or tested 3.1 yet. I have one 2.1.2 site that is commercial and I need it to be down as little time as possible. It also has a lot of third party modules...

EAServer 3.6.1 (36115) & PB 7.0.3
Hello, Which version of PowerBuilder 7.0.3 is supposed to be used with EAServer 3.6.1 ESD5 (build 36115)? The document included with EAServer states to use PB 7.0.3 build 10180 - which I am not sure if it really exists. Could this be a typo? What PB7 version does the EAServer documentation refer to? The previous build of EAServer (ESD4 - build 36114) documented that it (EAServer) should work with PB 7.0.3 build 10135.... Currently we are using EAServer 3.6.1 ESD3 (build 36112) with PowerBuilder 7.0.3 EBF (build 10108). There were some specific bug fixes in EAServer 3.6.1 ESD...

PD 3.0.1, Netscape 3.6 an Jaguar 3.0.1
I've installed both Jag and PD on Solaris 2.6. I want to use Netscape as a Web Server. I have configurated PD, created a pdynamo.ini on th PC an d modified the path to some static file mappning. After restarting of the Netscape, I have tryed to reach some of the static file sites without success. For example, I have in my pdynamo.ini: [HKEY_LOCAL_MACHINE\Software\Sybase\PowerDynamo\3.0\Mappings] /docs=<1>/opt/sybase/jaguar/html/docs/;"FILE";1;2048;2048;"";"" /intranet=<1>ow_intranet;"DB";1;2048;2048;"";"" ...

Migrate from PB 7.0.2 Build 8046 to PB 7.0.3 Build 10009
Is it a good move ? I use PB 7.0.2 C3 Build 8047 on Windows NT 4 sp 6a, but I want to move to Windows 2000 soon. I read than only the version 7.0.3 and above are Windows 2000 compilant. Do I have to expect some problems if I move to the version 7.0.3 Build 10009 than I dwonloaded from the sybase web site. Thank for your answers... Franc. Hi, I don't know if there is a technical problem. But my app. and PB works on Winnt 4.0 and Win2K server very fine. And i've don't received any problem reports since a long time. (The versions i've tested are 7.0, 7.0.2 ...

EAServer 4.2.3 compatibility with PB 7.0.3 build 10213
Is PowerBuilder 7.x compatible with EAServer 4.2.3 on Windows? My problem is if I use EAServer 4.2.2 then there is a bug related to Oracle and If I upgrade to EAServer 4.2.3 then PB 7.x VM is not supported. Can someone help? After upgrading to 4.2.3 the PB client application gives a memory exception at runtime... ...

Russian Mozilla 1.7.2, Firefox 0.9.3 and thunderbird 0.7.3 builds
Dear (new) MPL staf (welcome) could you please upload these files: Mozilla 1.7.2 Win32: http://lakostis.elektrostal.ru/mozilla.ru/new/mozilla-1.7.2-win32-installer-ru-RU-0.1.exe Thunderbird 0.7.3 Win32: http://www.mozilla.ru/unghost/thunderbird/0.7.3/Thunderbird-0.7.3-win32-installer-ruRU.exe Firefox 0.9.3 Win32: http://www.mozilla.ru/unghost/firefox/0.9.3/MozillaFirefox-0.9.3-win32-installer-ruRU.exe -- Sincerely yours, Alexander L. Slovesnik a.k.a. Unghost ==>Web-page: http://mozilla.ru/unghost/ ==>Jabber ID: als@mozilla.ru ==>ICQ:205497659 R...

Web resources about - OCI error with Jaguar 3.6.1 and PB 7.0.3 build 10108 #2 - sybase.easerver.powerbuilder

Chery Jaguar Land Rover - Wikipedia, the free encyclopedia
Chery Jaguar Land Rover (officially Chery Jaguar Land Rover Automotive Company Ltd. ) is an automotive manufacturing company headquartered in ...

Jacksonville Jaguars (@jaguars) on Twitter
Sign in Sign up You are on Twitter Mobile because you are using an old version of Internet Explorer. Learn more here Jacksonville Jaguars @ jaguars ...

Jacksonville Jaguars Football News, Photos, Rosters & more for iPhone, iPod touch, and iPad on the iTunes ...
Get Jacksonville Jaguars Football News, Photos, Rosters & more on the App Store. See screenshots and ratings, and read customer reviews.

Jaguar XJ220 cruisin on the freeway - Flickr - Photo Sharing!
It isn't every day you seen a Jaguar XJ220 on the streets. Thankfully the owner was nice and agreed to let us take some rolling shots.

NFL: Jacksonville Jaguars wear one of sport’s ugliest uniforms
SOMETIMES our job requires us to wear things we don’t like. Think a suit and tie at the office on a 38-degree day, or that unnecessarily formal ...

2016 Jaguar XJR meets 1988 XJR9-LM at Silverstone
Filed under: Videos , Jaguar , Sedan , Luxury , Performance , Racing Jaguar brings the 2016 XJR out to Silverstone to meet its spiritual progenitor ...

NFL admits officiating error in Ravens-Jaguars ending - Baltimore Sun
... Dumervil&amp;rsquo;s 15-yard face mask penalty nor kicker Jason Myers&amp;rsquo; 53-yard game-winning field goal in the Jacksonville Jaguars&amp;rsquo; ...

Conservative Play-Calling Limiting Jacksonville Jaguars' Special Playmakers
... between conservative, safe play-calling and a more aggressive approach is difficult for any offensive coordinator. For Jacksonville Jaguars ...

Uber Will Sell Cheaper, Day-Of Tickets to Jaguars Home Games
... an experiment in selling tickets alongside taxi rides, Uber Technologies Inc. will sell discounted game-day tickets to the Jacksonville Jaguars, ...

Check out the $1 million Jaguar villain car from James Bond's 'Spectre'
... more than, 007's iconic Aston Martin (a DB10, this time around). In the film, a villainous henchman, called "Mr. Hinx," driving an orange Jaguar ...

Resources last updated: 11/22/2015 7:45:28 PM