Solved

Readng from a lotus notes database

Posted on 2002-07-19
6
180 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
How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

 

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
how to add new optional parameter to JSP 1 49
table example 4 32
What's wrong with this code? 4 25
Need Help! Getting a syntax error and don't understand why 3 31
Introduction Java can be integrated with native programs using an interface called JNI(Java Native Interface). Native programs are programs which can directly run on the processor. JNI is simply a naming and calling convention so that the JVM (Java…
In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.

790 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