Solved

Readng from a lotus notes database

Posted on 2002-07-19
6
178 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
groupNoAdj 7 87
Securing Jmx Console and web console 2 66
custom annotations 9 33
web services creation SOAP vs REST 5 21
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
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 video teaches viewers about errors in exception handling.

863 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now