Solved

Readng from a lotus notes database

Posted on 2002-07-19
6
179 Views
Last Modified: 2013-11-24
Hi,
  This is not really a Java question bhut as I would be developing this in Java - then I guess I thught it best to place the question in this section as unsure what other area to place it in.
  Basically all I wanted to know is if you know if it is possible to read from a Lotus Notes database using SQL (i.e. through a ODBC connection).
  I would be running the SQl statement from a Java servlet.
0
Comment
Question by:seoirse
  • 2
  • 2
  • 2
6 Comments
 
LVL 86

Accepted Solution

by:
CEHJ earned 50 total points
ID: 7164712
0
 
LVL 4

Expert Comment

by:pellep
ID: 7164747
As far as I know there is no easy way. AFIK Lotus deliberately didn't create an ODBC interface to their db's since they incorporate a lot more features than standard RDBMS's. They do have an API (or used to, at least) for C/C++. (check http://www14.software.ibm.com/webapp/download/search.jsp?q=toolkit+jdbc+notessql&k=any&cat=groupware&sb=&go=y&sr=1&rs=&S_TACT=&S_CMP=&pf=&dt=&x=28&y=8 to find the proper one for you).
In order to use it from JAVA you'd have to encapsulate it in a JNI (java native interface) module.
0
 
LVL 4

Expert Comment

by:pellep
ID: 7164752
Well, CEHJ wrote his comment as I was writing mine. The info I was going on dates back to 1996. Ignore my previous comment.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:seoirse
ID: 7164929
Cheers CEHJ,
as an aside - do you know if this can be done (a connection being made) from asp (as opposed to Java) also?
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 7164937
I would have thought that the answer is almost certainly yes - via ODBC.
0
 

Author Comment

by:seoirse
ID: 7164992
That's what I thought also. Cheers
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

An old method to applying the Singleton pattern in your Java code is to check if a static instance, defined in the same class that needs to be instantiated once and only once, is null and then create a new instance; otherwise, the pre-existing insta…
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This tutorial explains how to use the VisualVM tool for the Java platform application. This video goes into detail on the Threads, Sampler, and Profiler tabs.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question