[opencms-dev] Opencms 6.2.3 + oracle DB random errors

[Jordi Martí]

Hi everybody,

I'm getting some errors with opencms 6.2.3 and oracle, and I would be very
grateful if anyone could address me or point me to the direction of any
solution. 

I'm using Oracle Db (9i), with OpenCms 6.2.3. There's more than one instance
of OpenCms pointing to the same database (without any OCE cluster), but
there's just one database.

Randomly, in some of these instances (not always the same), SQL errors show
up.

Errors are usually one of these two:

- org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the
following query: oracle.jdbc.driver.OraclePreparedStatement at 538c2...
ORA-01003: no statement parsed at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)

- Oracle cursors exceded.

After asking in this list because of the second error, it seemed the problem
had gone away (I increased number of cursors and decreased number of
parseable statements), but it hasn't (oracle cursors error show up less
frecuently, or even never, not sure).

What do you people think?

- Both errors are related? I mean, could "the preparedstatement error" be a
consecuence of "oracle cursors exceded"?
- Why is it that one statement could not be parsed, but then it is executed
(without success, of course)?
- I'm wondering if the first error could it be something related to Garbage
Collector?

I don’t have physical access to these machines, and I haven't been able to
reproduce the error on my own development environment.

Any clue?

Thanks everybody.  
 
JORDI MARTI
jmarti _AT_ THEINIT *dot*! @theinit.com