LC Connector (*lsxlc)

HCL Domino Domino Forum
1

I connect to Oracle 9.2 using LC Connector object, eg:…

Set LCSource=New LCConnection(“Oracle”)

LCSource.Server=“schema”

LCSource.UserID=“UserXXX”

LCSource.Password=“XxX123”

LCSource.Connect

…

A scheduled LS agent does the normal “Execute”, “Commit” and “Disconnect” methods.

All works well, but every now and again the connection to Oracle freezes (on “Execute”), meaning we have to:

  1. restart AgentManager; or

  2. kill the ‘UserXXX’ session in Oracle.

There is no trend: when we do 1) or 2) above, the same sql command that caused the freeze, executes fine.

Is this an Oracle or Domino issue?

2

Subject: LC Connector (*lsxlc)

On the Domino side:

Make sure you properly close the Oracle connection by using a lcConnection.Disconnect method. Always make sure to clean up memory also by setting your LCxxxxx objects = Nothing after you are done using them.

3

Subject: RE: LC Connector (*lsxlc)

Thanx, I’ll check that out.