developerWorks  >  Lotus  >  Forums & community  >  IBM Lotus Notes/Domino 8.5 Forum (includes Lotus Notes Traveler)

IBM Lotus Notes/Domino 8.5 Forum (includes Lotus Notes Traveler)



Feedback Type Problem
Subject Java to Lotus Notes connection issue
Product Area Domino Server
Technical Area Accessibility
Platform ALL
Release 8.5.3
I am trying to access the data from Lotus Notes database into an external Java program, but no luck.

On my laptop, I have configured IBM Domino 9.0.1 server, where I have created a demo database. My target is, to access the data from this database through external Java code. I have also installed Netbeans and Eclipse on the same laptop where Domino server is configured. Now, I am trying to access the demo lotus notes database in my java program (netbeans/eclipse) using the classes provided in Notes.jar package, but unable to open database.

To accomplish the task, I have followed below steps:

Added the path 'C:\Program Files\IBM\Domino' to 'Path' system variable, and rebooted the laptop.
In Netbeans (also tried in Eclipse), created Java class (console application), added Notes.jar file (IBM/Domino/JVM/lib/ext/Notes.jar) in the classpath (in netbeans, added Notes.jar in Resources section. In Eclipse, copied Notes.jar in lib folder).
Added the following code in the class: (assume lotus.domino.* is already imported in the code)



public static void main(String [] args)
{
try{
NotesThread.sInitThread();
//Case1
Session session = NotesFactory.createSession()//Connect the server with server ID. Throws error 'Database has not been opened yet';
//Also tried following options. Note that I have assigned full access/manager rights to anonymous user on the demo database
//Case2
//Session session = NotesFactory.createSession((String)null);//Same result as first one [NotesFactory.createSession()]
//Case3
//Session session = NotesFactory.createSession((String)null,"Romil Handoo/dev","My_Domino_Internet_Password");//Connect the server as Romil Handoo/dev login. Throws error- Invalid User Id/Password. I am giving correct ID/password
//Case4
//Session session = NotesFactory.createSession((String)null,"","");//Access with anonymous user. Throws error 'Database has not been opened yet'**
Database dbDemo = session.getDatabase(session.getServer(), "demo/DemoDB.nsf");
//session.getServer() is returning my server name, which is Development/home.
//Also tried these, but same result each time:
//session.getDatabase("localhost:9595","demo/DemoDB.nsf")
//session.getDatabase("localhost","demo/DemoDB.nsf")
//session.getDatabase("127.0.0.1:9595","demo/DemoDB.nsf")
//session.getDatabase("127.0.0.1","demo/DemoDB.nsf")
//session.getDatabase("","demo/DemoDB.nsf")
//session.getDatabase((String)null,"demo/DemoDB.nsf")
//Following line throws exception 'Database has not been opened yet'
View vwDemo = dbDemo.getView("vwDemo");
}
catch(Exception ex)
{
System.out.println(ex.toString());
//For case 1, case 2, and case 4, error message is 'Database has not been opened yet'
//For case 3, error message is 'Invalid login id/password'

}
finally
{
NotesThread.stermThread();
}
}




Please someone guide me how I may connect to domino database through external java code? For all these steps, I have referred the page https://www.ibm.com/support/knowledgecenter/en/SSVRGU_9.0.1/basic/H_NOTESDATABASE_CLASS_JAVA.html

Many thanks

Feedback number WEBBB64APZ created by Romil Handoo on 04/19/2019

Go back