Recent content by hsteigstra

I am not on location, so I can only tell that we use Oracle 10g. I presume client and server are installed from the same CD. Question about the thread safe parameter: what if I set it and it would not be necessary as all clients have their own thread. Does it cause overhead?

Yes, that is my opinion too. I just was not sure what function the "ThreadSafe" parameter has. I presume I can leave it to false, as the threading is done by Apache itself and each instance of the ApacheModule will get its own thread. There is no parallel action within the the SOAP module...

Some additional information: Tried to turn off TheadSafe but that does not help. Using Oracle Monitor the last crash displayed dramatically increase of responses for executions and logoffs: 7.5 or 15 sec. instead of apx. 0.1 sec

Just turned off Pooling (spNone), same result. Oracle Monitor not started, just the freezing of Apache.

Following a previous post, I now get an error captured with Oracle Monitor: ORA-01023: Cursor context not found (Invalid cursor number) It occurs when I run several client applications simultaneously requesting the same query in an Apache module. It occurs after several hundreds successful...

No, sorry, there are a number of queries that are refreshed. Normally there is no problem with the execution of either of them. Only when two instances request data in parallel the application crashes.....

Dear Marco, We have an Apache module that regularly freezes. Today we did a test with two clients doing the same refresh of the data repeatedly and simultanously and in 10 seconds both clients crashed, one with a general exception, the other with a ORA-01002 message (Fetch out of sequence)...

On a machine with a previous installed and deinstalled Client 8.1 we installed the client10g. We have established a connection with SQL*plus, SQL explorer and with PL/SQL developer but our application using DOA components fails with the following message box: Initialization error SQL*Net not...

I have been checking connection speed and some interesting numbers appeared: * Local or remote does not make any difference * OCI7 is 30% faster * Processor speed of the client is the most important factor * connecting from one Oracle database server to another is twice as fast, despite the...

Seems like a basic SQL problem: the string length of the data to be stored exceeds the size of the database column.....

I have an Oracle server running on my development PC (2Ghz) and don't see any difference in login time compared to the main Oracle Server (1.4 Ghz) both are 125 msec. At this moment we are running Oracle 8.1.7 As I understand Oracle 9.2 has a built in session pooling. If we would migrate to...

Does that mean that when I use the Oracle Session Pooling (spMTS) that it will not work either? I experimented with the spInternal setting as I don't have to install anything on the Oracle side for that.... I already have been experimenting with 3-Tier concepts, but that does not work as the...

In our cgi-bin application we would like to take advantage of the session pooling fascility of the TOracleSession component. The idea is now to create a simple server application that creates a set of TOracleSessions. The cgi-bin application then should fetch a session from this pool and open...

I have a small problem in using Cached Updates. I am "abusing" cached updates to do some temporary administration that will not be inserted into the database. So I have a SQL and unique rowid chosen arbitrary from one of the tables. After receiving a "record changed by another user" I found...

I use OracleMonitor in a cgi-bin application with Apache as webserver. No problem at all. Did you include in the uses clause the OracleMonitor unit?