I did some preliminary work on the feasibility of using Domino Server as a database and configuring it with weblogic. It has been a long time though and I have forgotten a lot of things... However, here are my findings(those what I remember....)
1. Lotus notes is not a RDBMS. Thus it doesn't have tables. However if you use a
JDBC driver then the views defined in the database translates to RDBMS tables.
2. JDBC for Lotus Notes is quite non-standard since lotus notes data does not map easily to RDBMS structure.
3. A better approach is to use the APis provided with the Java-Corba Toolkit to interface with Lotus notes.
4. However, the above approach has lots of configuration issues. It provides you with lots of jar files(NCSO.jar NCSOW.jar and notes.jar) If it is a standalone
java application then the problems are minimal. But, when I tried weblogic, I got lots of meaningless exceptions... ultimately solved the problem but I don't remember the configurations off hand
5. I have heard that it integrates seamlessly with websphere using NCSOW.jar
6. In my experience it is not very scalable(with WebLogic). Some connections abort with exceptions when many try to connect together.
7. The best option (IMHO) is to use C apis to connect and then use JNI wrappers over these.