{"id":1453,"date":"2014-05-30T11:13:48","date_gmt":"2014-05-30T09:13:48","guid":{"rendered":"http:\/\/hasselba.ch\/blog\/?p=1453"},"modified":"2014-05-30T11:13:48","modified_gmt":"2014-05-30T09:13:48","slug":"xpages-create-a-database-without-template","status":"publish","type":"post","link":"https:\/\/hasselba.ch\/blog\/?p=1453","title":{"rendered":"XPages: Create a Database without Template"},"content":{"rendered":"

On stackoverflow.com, an interessting topic was asked about how to create a notes database programmatically without using a template. The problem is, that it will not contain a Icon document. But in this document are all database properties stored. So the question is: How can you create this document<\/a>?<\/p>\n

Jesse Gallagher<\/a> came up with the idea to use the DXL import and create the Icon document this way, which works fine. But the next problem is, that there is no ACL note in the database and no default view.<\/p>\n

That’s why I modified his idea and created a Java Utility class. This class creates a new database which includes all of the required design elements.<\/p>\n

package ch.hasselba.core;\r\n\r\nimport lotus.domino.ACL;\r\nimport lotus.domino.Base;\r\nimport lotus.domino.Database;\r\nimport lotus.domino.DbDirectory;\r\nimport lotus.domino.DxlImporter;\r\nimport lotus.domino.Session;\r\n\r\n\/**\r\n\u00a0* DB Utilities\r\n\u00a0* \r\n\u00a0* @author Sven Hasselbach\r\n\u00a0* @version 1.1\r\n\u00a0*\/\r\npublic class DBUtil {\r\n\r\n\u00a0\u00a0 \u00a0\/**\r\n\u00a0\u00a0 \u00a0 * creates a new database \r\n\u00a0\u00a0 \u00a0 * the database is identically to a database created by the -blank- template in designer.\r\n\u00a0\u00a0 \u00a0 * The default access is set to Manager\r\n\u00a0\u00a0 \u00a0 * \u00a0\r\n\u00a0\u00a0 \u00a0 * @param session\r\n\u00a0\u00a0 \u00a0 * \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0the session used to create the database\r\n\u00a0\u00a0 \u00a0 * @param dbTitle\r\n\u00a0\u00a0 \u00a0 * \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0the database title\r\n\u00a0\u00a0 \u00a0 * @param dbPath\r\n\u00a0\u00a0 \u00a0 * \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0the path of the database\r\n\u00a0\u00a0 \u00a0 * @param dbServer\r\n\u00a0\u00a0 \u00a0 * \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0the server \r\n\u00a0\u00a0 \u00a0 * \r\n\u00a0\u00a0 \u00a0 * @version 1.1\r\n\u00a0\u00a0 \u00a0 *\/\r\n\u00a0\u00a0 \u00a0public static void createDatabase( Session session,\u00a0 final String dbTitle, final String dbPath, final String dbServer ) {\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0DbDirectory dbDir = null;\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0Database db = null;\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0DxlImporter importer = null;\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0ACL acl = null;\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0try{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ create a new database\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0dbDir = session.getDbDirectory( dbServer );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0db = dbDir.createDatabase( dbPath );\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ initialize dxl importer\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0importer = session.createDxlImporter();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0importer.setDesignImportOption( DxlImporter.DXLIMPORTOPTION_REPLACE_ELSE_CREATE );\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ generate DXL\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0String dxl = generateDXL( dbTitle, dbPath, db.getReplicaID() );\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ import DXL\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0importer.importDxl(dxl, db);\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\/\/ set ACL: Default to Manager\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0acl = db.getACL();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0acl.getFirstEntry().setLevel(ACL.LEVEL_MANAGER);\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0acl.save();\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}catch(Exception e){\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0e.printStackTrace();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}finally{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0recycleObj( acl );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0recycleObj( importer );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0recycleObj( db );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0recycleObj( dbDir );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}\r\n\r\n\u00a0\u00a0 \u00a0}\r\n\r\n\u00a0\u00a0 \u00a0\/**\r\n\u00a0\u00a0 \u00a0 * generates the DXL for a blank database\r\n\u00a0\u00a0 \u00a0 * \r\n\u00a0\u00a0 \u00a0 * @param dbTitle\r\n\u00a0\u00a0 \u00a0 *\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0the title of the database\r\n\u00a0\u00a0 \u00a0 * @param dbPath\r\n\u00a0\u00a0 \u00a0 * \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0the path of the database\r\n\u00a0\u00a0 \u00a0 * @param dbReplicaId\r\n\u00a0\u00a0 \u00a0 * \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0the replica of the database\r\n\u00a0\u00a0 \u00a0 * @return\u00a0\u00a0 \u00a0String with DXL\r\n\u00a0\u00a0 \u00a0 * \r\n\u00a0\u00a0 \u00a0 * @version 1.1\r\n\u00a0\u00a0 \u00a0 * \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\r\n\u00a0\u00a0 \u00a0 *\/\r\n\u00a0\u00a0 \u00a0private static String generateDXL( final String dbTitle, final String dbPath , final String dbReplicaId ){\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0StringBuilder str = new StringBuilder();\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<?xml version='1.0' encoding='utf-8'?>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<!DOCTYPE database SYSTEM 'xmlschemas\/domino_8_5_3.dtd'>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<database xmlns='http:\/\/www.lotus.com\/dxl' version='8.5' maintenanceversion='3.0' \");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"replicaid='\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append( dbReplicaId );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"' path='\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append( dbPath );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"' title='\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append( dbTitle );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"' allowstoredforms='false' \");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"usejavascriptinpages='false' increasemaxfields='true' showinopendialog='false'>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<databaseinfo dbid='\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append( dbReplicaId );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append( \"' odsversion='51' \");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"numberofdocuments='0'><\/databaseinfo>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<note default='true' class='icon'>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<noteinfo noteid='11e'>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<\/noteinfo>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<item name='IconBitmap' summary='true'>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<rawitemdata type='6'>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"AiAgAQAA\/\/\/\/\/\/\/wD\/\/\/gAH\/\/gAAf\/wAAD\/4AAAf8AAAD+AAAAfgAAAHwAAAA8AAAAPAAAADgAAA\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"AYAAAAGAAAABgAAAAYAAAAGAAAABgAAAAYAAAAHAAAADwAAAA8AAAAPgAAAH4AAAB\/AAAA\/4AAAf\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"\/AAAP\/4AAH\/\/gAH\/\/\/AP\/\/\/\/\/\/8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAiIiIiAAAAAAAAAAAAAAI\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"jPZmZm\/IgAAAAAAAAAAIjGZmZmZmZsiAAAAAAAAAjGZmZmZmZmZmyAAAAAAACMZmZmZmZmZmZmyA\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"AAAAAIxmZmZmZmZmZmZmyAAAAAjGZmZmZmZmZmZmZmyAAAAIZmbyL2byL2byL2ZmgAAAjGZmIiJm\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"IiJmIiJmZsgAAIZmZiIiZiIiZiIiZmZoAADGZmYiImYiImYiImZmbAAI9mZmIiJmIiJmIiJmZm+A\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"CGZmZiIiZiIiZiIiZmZmgAhmZmYiImYiImYiImZmZoAIZmZmIiJmIiJmIiJmZmaACGZvIiIiZiIi\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"ZiIiIvZmgAhmYiIiImYiImYiIiImZoAIZm8iIi9m8i9m8iIi9maACPZmZmZmZmZmZmZmZmZvgADG\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"ZmbyL2byL2byL2ZmbAAAj2ZmIiJmIiJmIiJmZvgAAIxmZiIiZiIiZiIiZmbIAAAI9mbyL2byL2by\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"L2ZvgAAACMZmZmZmZmZmZmZmbIAAAACMZmZmZmZmZmZmZsgAAAAACMZmZmZmZmZmZmyAAAAAAACM\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"9mZmZmZmZm\/IAAAAAAAACIz2ZmZmZm\/IgAAAAAAAAAAIiMZmZmyIgAAAAAAAAAAAAACIiIiIAAAA\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"AAAAUEECICABAAD\/\/\/\/\/+A4DgA==\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<\/rawitemdata><\/item>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<item name='$Daos'><text>0<\/text><\/item>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<item name='$TITLE'><text>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append( dbTitle );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<\/text><\/item>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<item name='$Flags'><text>7f<\/text><\/item>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<item name='$FlagsNoRefresh'><text\/><\/item><\/note>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<view xmlns='http:\/\/www.lotus.com\/dxl' version='8.5' maintenanceversion='3.0' \");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"replicaid='\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append( dbReplicaId );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"' showinmenu='true' publicaccess='false' default='true' noviewformat='true'>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<noteinfo noteid='11a' sequence='1'><\/noteinfo>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<code event='selection'><formula>SELECT @All<\/formula><\/code>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<item name='$FormulaClass'><text>1<\/text><\/item><\/view>\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0str.append(\"<\/database>\");\r\n\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0return str.toString();\r\n\r\n\u00a0\u00a0 \u00a0}\r\n\r\n\u00a0\u00a0 \u00a0\/**\r\n\u00a0\u00a0 \u00a0 * recycles notes objects\r\n\u00a0\u00a0 \u00a0 * \r\n\u00a0\u00a0 \u00a0 * @param obj\r\n\u00a0\u00a0 \u00a0 * \u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0the notes object to recycle\r\n\u00a0\u00a0 \u00a0 *\/\r\n\u00a0\u00a0 \u00a0private static void recycleObj( Base obj ){\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0try{\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0if( obj != null )\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0obj.recycle();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}catch( Exception e ){}\r\n\u00a0\u00a0 \u00a0}\r\n}<\/code><\/pre>\n
Here is an example XPage how to use the class:<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<xp:view xmlns:xp=\"http:\/\/www.ibm.com\/xsp\/core\">\r\n\r\n\u00a0\u00a0 \u00a0DB Path:<xp:inputText id=\"inputTextDBPath\" value=\"#{viewScope.dbPath}\" \/><xp:br \/>\r\n\u00a0\u00a0 \u00a0DB Title:<xp:inputText id=\"inputText1\" value=\"#{viewScope.dbTitle}\" \/><xp:br \/>\r\n\r\n\u00a0\u00a0 \u00a0<xp:button value=\"Create DB\" id=\"buttonCreateDB\">\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<xp:eventHandler event=\"onclick\" submit=\"true\" refreshMode=\"complete\">\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<xp:this.action>\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<![CDATA[#{javascript:\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0importPackage( ch.hasselba.core );\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0var dbUtil = new ch.hasselba.core.DBUtil();\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0dbUtil.createDatabase(session, viewScope.dbTitle, viewScope.dbPath, \"\");\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0}]]>\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<\/xp:this.action>\r\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0<\/xp:eventHandler>\r\n\u00a0\u00a0 \u00a0<\/xp:button>\r\n\r\n<\/xp:view><\/code><\/pre>\n
You can enter the database Title and the database path. After clicking the button „Create DB“, the database is created on the server (assuming you have the right to do that).<\/p>\n
\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"
On stackoverflow.com, an interessting topic was asked about how to create a notes database programmatically without using a template. The problem is, that it will not contain a Icon document. But in this document are all database properties stored. So … Weiterlesen →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[89,74],"tags":[33,47,7,31,32,3],"class_list":["post-1453","post","type-post","status-publish","format-standard","hentry","category-java","category-xpages","tag-8-5-3","tag-9-0","tag-domino","tag-java","tag-tipp","tag-xpages"],"_links":{"self":[{"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1453"}],"version-history":[{"count":4,"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1453\/revisions"}],"predecessor-version":[{"id":1457,"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1453\/revisions\/1457"}],"wp:attachment":[{"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hasselba.ch\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}