*
The moose likes JDBC and the fly likes Lotus Notes DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Lotus Notes DB" Watch "Lotus Notes DB" New topic
Author

Lotus Notes DB

Tom Ben
Ranch Hand

Joined: Aug 17, 2001
Posts: 109
I am trying to query some data out of a Lotus Notes DB and no I do not know the layout and trying to the person that created it in my company is a joke. So my question for one is how come when I see that the field name is say "FirstName" and I type that in rec.getString("FirstName") i get a response that says that the name is not valid. Does anyone have any help on Lotus Notes Database use?


Sun Certified Programmer on the Java 2 Platform
Shubhrajit Chatterjee
Ranch Hand

Joined: Aug 23, 2001
Posts: 356
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.


Shubhrajit
Axel Janssen
Ranch Hand

Joined: Jan 08, 2001
Posts: 2164
The corba is very slow. Perhaps its more intelligent to use the Domino-Object Model classes.
You do have a programmer reference in your R5 or R4 client.

Axel
Shubhrajit Chatterjee
Ranch Hand

Joined: Aug 23, 2001
Posts: 356
Originally posted by Axel Janssen:
The corba is very slow. Perhaps its more intelligent to use the Domino-Object Model classes.
You do have a programmer reference in your R5 or R4 client.

Axel

I agree.... CORBA is very slow in making the connection... I think after the connection is ready it seems to be quite OK. Perhaps if you use CORBA then it would be a good idea to pool the connections
Axel Janssen
Ranch Hand

Joined: Jan 08, 2001
Posts: 2164
Shubhrajit,
...there are also lots of opportunities to integrate with a rdbms in a way where you push the data from notes --> rdbms (LSX classes, JDBC, DECS task) in a I think mostly sheduled way.
In Rnext (which will be released in the second half of this year or later) there will be WebSphere integrated (in the current beta they integrated Tomcat).
A really good ressource for Lotus-Domino is www.notes.net (good discussion forums (they call it gold release. dont ask why), free code in Iris Sandbox, etc.)
Axel
[ January 05, 2002: Message edited by: Axel Janssen ]
 
wood burning stoves
 
subject: Lotus Notes DB
 
Similar Threads
Sending mail to lotus notes server
JavaMail error
Help
Export from Oracle to Lotus Notes Domino
HTML Table Border showing up thick , when viewed on lotus notes