How to connect a Jaguar connection cache from a C/C++ CORBA component
I am using Jaguar CTS 3.6.1 (#36108) running on MS Windows 2000
I also installed Sybase Adaptive Server Enterprise PC Client to connect
a remote ASE 12.0 database...
I have successfully created a connection cache to the database (Connection
cache ping OK)...
However, i am in trouble making a C/C++ CORBA component to use this conn
I added jagCMGetConnection API to get a connection from available cache as
retcode = JagCmGetConnection (&cache,
(unsigned char *)"us...Who can give me a simple example on Jaguar component connect to a connection cache?
My script is:
CONNECT USING SQLCA;
If SQLCA.SQLCode<>0 Then
errlog.log("Error Code:"+string(SQLCA.SQLCode)+" ; "+SQLCA.SQLErrText)
But the srv.log report:
Jul 25 09:30:11 2001: Error Code:-1 ; Error: Failed to get a valid Database
Connecti...Connection cache problems with Direct Connect on Jaguar CTS 3.6.1
I need to connect to CICS and execute transactions using Jaguar CTS
3.6.1, powerbuilder component and UNIX Sun Solaris 8.0. I've made a
connection cache (via Jaguar Manager) using Open Client driver and it seems
to work fine, because i can ping it. But, the problem is: When i try to
access the connection cache within a powerbuilder 7.0 component using the
Direct Connect driver (DBMS property) and specifying the connection cache
name in the DBParm property, in NT (Win 2K) the connection cache is not used
(Direct Connect bypasses Jaguar), in Solaris 8.0 it says it do...Jaguar CTS 3.0 Prob connecting to oracle via connection cache
Connection Cache settings
Cache Name oracle_tlo1
Description TLO1 - Temp Live Oracle
Enable cache by name access No
Enable connection sanity check Yes
No of connections in cache 10
Service Name <nothing>
When I ping the connection it fails with..
Ping of oracle_tlo1 OCI_7 Con...Jaguar CTS connection cache ??
The Jaguar CTS connection cache could be setup the timeout
The Jaguar CTS instance pool could be setup the maximum
The Jaguar CTS 3.5 could support the automatic failover
How about with the stateful and stateless object work on
Thanks a lot.
> The Jaguar CTS connection cache could be setup the timeout
> The Jaguar CTS instance pool could be setup the maximum
> instance number??
...Connection caching on jaguar cts
I am using a Jaguar CTS connection cache in my jaguar component. As
described in "PowerBuilder Application Techniques" I perform CONNECT in
the activate() event and DISCONNECT in the deactive() event.
The component works terribly slow, it seems, that the connection caching
does not work: Tracing the odbc-api calls shows that the jaguar server
performs SQLConnect() and SQLDisconnect() to the database instead of
caching the connection.
What might be wrong ?
On Tue, 15 Feb 2000 17:53:20 +0100, Manfred Huber
>I am using a Jag...Where is connection cache info stored? - Can't find cache "props" files in \Repository\ConnCache
I have three connection caches I'd like to copy to another machine, so I was
going to copy the associated "props" files to the other machine. The
\Repository\ConnCache folder on the machine with the three connection caches
Where are the connection cache properties stored?
Windows NT 4.0
Jaguar CTS 3.6
They live inside of the afconfig.dat file.
Why not sync the server?
Internet Applications Division
"John Lund" <email@example.com> wrote in message
news:LS9Ab8iWAHA.firstname.lastname@example.org...ActiveX component get Connection Cache
Do anyone have a sampe of how to get connection cache from an ActiveX
component (both VB / PB are ok)?
...Shared PowerBuilder Components in Jaguar CTS
Is there any recommended way to use a shared component. We cached a subset
of data from a table into a shared component (35,000 records) and use
another component to filter data from that cache. It does not seem to
perform very well. Would it make more sense to just have the middle-tier
component hit the table directly.
That's what I would do. The db will use a index to get the needed data.
Dean Jones, CPD Professional
Chuck Kiefriter <email@example.com> wrote in message
ne...Jaguar connection caches and stateless PB components
I've encountered a strange ocurrence with my EAS-Web application.
I'm using an EAS C5 configuration with PB 7.0.3 and PD 7.0.2.
I reported earlier that I had a problem with the Jaguar server crashing when
I put a bit of load on it while I specified the threads of both HTTP and
Jaguar to over a 1000.
The cause of this was the fact that I had instance pooling on for my PB
components. When I deactivated this property for my PB components , It could
handle 27 of the heaviest queries my application had ( 1 minute retrieval
time, about 700 rows a query). SO far so good.
...pb component using Jaguar Connection Cache
When I use my pb component to connect to db through a connection Cache,
If I set
"Release Connection Option" of the connection cache property to
"JAG_CM_UNUSED", if some client use the component simultaneously, the
program is "frozen" when they connect to db through the connection
Cache. How can I resolve this problem?
Never tried it. Why are you using this option?
Dynamic Data Solutions, Inc.
Enterprise Application Studio 3.5...connection cache DBParm in PB jaguar component
I'm trying to use a connection cache from my powerbuilder component deployed
in Jaguar. I set the transaction object as such:
The cache works fine when I use it with Java components within Jaguar, but
does not work from within my PB component. The "ping" test in Jaguar
manager works fine.
I tried two different connection caches: a JDBC one and an ODBC (both of
which I know are valid).
However, I get an error when I try to do any database operation (no valid db
connection) when attempting to use the ca...Altering the connection cache used by Jaguar Components
My application consists of a Powerbuilder client and a number of
Powerbuilder NVOs deployed to a Jaguar Server. The server objects are
stateless; they connect to the database through a connection cache in the
Activate event and disconnect in the Deactivate event.
I would like to modify these objects to use a different connection cache
dependant upon a client side setting. The only way I can see of doing this
is to move the connect to database code from the activate event into each
function and add the connection cache name to every function as a parameter.
Is this correct or i...Jaguar CTS 3.5 Connection Cache to Oracle9I
We are in the process of ugrading Oracle to 9I and need to reconfigure
the connection cache to look at the new database, however there does not
appear to be a choice for 9I. (there is no radio button on the Driver Tab
of the Connection properties for Oracle9i). We have not installed to
Oracle9i Client Software on the Jaguar machine to date. (we are hesitant to
due this until we are actually going to use the new database. Will
installing Oracle Client fix this problem, or is something else needed?
Nope, you'll need to upgrade to EAServer 4.x...