Local Notes down with JDBC and NotesSQL

HCL Domino Domino Forum
1

Hi

Our configuration is Windows 2000 Server SP4 with Websphere 5 App.Server, Notes 6.0.2 Client and Domino 6.0.1 Server, JDBC Domino driver and NotesSQL 3.0.1.

We are using JDBC and NotesSQL to use content databases from Domino databases.

As we are migrating our site from asp to websphere, there are still asp pages and jsp pages using domino server simultaneously.

Our problem is that:

Sometimes (almost everyday) Local Notes session hangs so both asp and jsp pages cannot connect to domino.

There is no specific code that crashes sessions. That makes me think it is an accumulation of sessions/memory/thread/handles staff.

Few hours before the crash, IIS and websphere restarts themselves without any error code.

I have found that: Both JDBC and NotesSQL are using Local Notes program files to connect. Some errors accumulate this and crash local notes.

Anybody knows how to configure Notes SQL and JDBC driver to use server dll’s instead of client?

Thanks for responses…

2

Subject: Local Notes down with JDBC and NotesSQL

NotesSQL will use the Notes dlls first if it finds the same major version of Notes and Domino. You should let NotesSQL use the Notes dlls instead of Domino’s because if NotesSQL hangs / crashes and NotesSQL is using the Domino dlls, it will bring Domino down with it.

The only way to get NotesSQL to use Domino over Notes would be to change the major version in the registry… This is not supported.

Thanks,

Ron

3

Subject: Local Notes down with JDBC and NotesSQL

I suggest you investigate using the Notes Java API instead of NotesSQL for this task. It’s likely to give you better performance (in addition to not crashing).