XPages SSJS - Creating a Document in Another Database

Question

I get the error "Exception occurred calling method NotesDatabase.createDocument() null" for the following:

var db:NotesDatabase = session.getDatabase("", viewScope.targetDb);
if (db != null) {
   if(db.isOpen()){
   }else{
        db.open();
    }
} else {
}
var doc:NotesDocument = db.createDocument();

Comments: The database db is available and "open". The user has enough rights in the targetDb to create documents.

What is wrong?

I changed db.isOpen to db.isOpen(), according to Paul Stephen Withers tips. And now db.open() gives the error "Exception occurred calling method NotesDatabase.open() null" although that I can get, in viewScope variables, the server, FilePath, etc.

is this the full code? can you provide the full script as well as the full error message? can you output the title of db before you create the document using println(db.getTitle()); ? — Michael Ruhnau
The targetDb equals a URL set in another place in the application, in other words "/" is used. — Rolf Walter

Simon Delicata Simon Delicata · Accepted Answer · 2017-02-16T15:00:25

Change

var db:NotesDatabase = session.getDatabase("", viewScope.targetDb);

to

var db:NotesDatabase = session.getDatabase(currentDatabase.getServer(), viewScope.targetDb);

This works on the web as well as XPinC.

XPages isn't the same as formula, it doesn't like the empty string definition for the server name, which is contrary to the documentation which states (for the server parameter of NotesSession.getDatabase - javascript):]

The name of the server on which the database resides. Use null to indicate the session's environment, for example, the current computer

Using null or "" gives error 500, it would appear.

The code from the question will work, if :

the if block is removed entirely
the viewScope.targetDb variable has a properly specified notes database file path, which exists on the same server as the current database
the current user has access to the target database ( by the ACL ), with the Create Database right
the target database has a Maximum Internet name and password above Reader as per @Paul

XPages SSJS - Creating a Document in Another Database

3 Answers