Solved

Readng from a lotus notes database

Posted on 2002-07-19
6
181 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
tomcat startup error 5 133
eclipse buid path vs tomcat lib path 10 37
CSV file parsing thru Java 13 39
ejb entity bean example issue 2 25
For beginner Java programmers or at least those new to the Eclipse IDE, the following tutorial will show some (four) ways in which you can import your Java projects to your Eclipse workbench. Introduction While learning Java can be done with…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
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.

735 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