If you have used the Extension Library’s Relational controls, then you are probably familiar with the process of configuring your JDBC Connection details.
You have the option of setting up a ‘named’ connection so you can reference a database connection by name. This involves creating an xml file <yourconnection>.jdbc in the WebContentWEB-INFjdbc directory. This xml file specifies the driver, url, username, password, and perhaps some information about connection pooling.
Alternatively your can just build your own connection url and use this directly in your Java code or XPages controls.
Named connections are a much nicer way to go, and they allow for connection pooling, however the method of using the xml file within the WEB-INFjdbc directory is a little annoying.
This is not a very accessible or flexible way to manage your connection information. Often your local development SQL Database will have different username / password / url etc. So you often end up changing the config files back and forth everytime you want to develop and deploy.
So I decided to come up with a way to store JDBC Connection information somewhere else, and it seemed logical to store it in NotesDocuments. This way the JDBC connections are configurable at run-time and do not require a change to a design.
Additionally, these JDBC configuration documents can be protected from read-access so that only admins and database signer’s can access them. The session as signer should be able to access them with elevated rights.
Short Demonstration Video
If you would like to see the JDBC Provider in action please have a look at this video
How can I use this JDBCNotesDocumentProvider system?
Download the Alpha Release in my fork of the ExtLibX project and have a look at the documentation in the PDF in the release. You can also have a look in the demo video above.
If this solution is working for you then you should be fine to use it in production but I am just calling it a alpha release because I am looking to get some feedback before making a final ‘release’.
How does the JDBCNotesDocumentProvider work?
I basically copied the way the Extension Library initializes it’s JDBC Information from the xml files in the WEB-INF/jdbc folder, and modified it to instead look in NotesDocuments! Sounds simple but there was a little bit of fiddling around.
Someone Access the XPages application
The JDBC Configuration Initialization is triggered
If it is set to use ‘local’ configuration it will search the current database for JDBCConnection info
If it is set to use ‘global’ configuration it will search the central configuration database for JDBCConnection info
Actually in my original solution, I was using an ‘ApplicationInitializer’ however this runs before you have access to sessionAsSigner, so this was a bit of a problem. I had trouble getting a full-access session but managed to do it with some trickery, however I don’t think this ‘trickery’ is suitable to be shared, so I came up with an alternative.
I moved the initialization code to a PhaseListener, and set it up so the initialization will only run if it hasn’t been successfully done yet. I still don’t like this so much but it works.
Feedback / Comments
Would love to hear if this is something you think you would use. If you have any suggestions / improvements please let me know!
XPages JDBC Configuration via NotesDocuments
Tue, Dec 5th 2017 11:34a Cameron Gregor If you have used the Extension Library’s Relational controls, then you are probably familiar with the process of configuring your JDBC Connection details.
You have the option of setting up a ‘named’ connection so you can reference a database connection by name. This involves creating an xml file .jdbc in the WebContentWEB-INFjdbc directory. This xml file specifies the driver, url, username, password, and perhaps some information about connection pooling.
Alternatively your can
My New Approach for Sharing XPages Controls and Extensions
Fri, Dec 1st 2017 12:33p Cameron Gregor Over the past few years I have shared a handful of controls and techniques on my blog, and most of these I have made available on github in one way or another. Originally I was creating a separate github project for each one such as EmailValidator, PhoneNumberControl and the Messages Controls. After these few I decided it would be more efficient to create a single project that I could put them all into, so I then began to contribute them via my GregorbyteXspLibrary.
From time to time I had a fe
Embedded Experiences not rendering after IBM Notes FP9
Wed, Sep 27th 2017 5:36a Cameron Gregor Embedded Experiences are no longer rendering after upgrading to FP9.
I suspect it is something to do with the changes to Embedded Browser, either removing it or upgrading it or something else.
I haven’t had a chance to investigate fully. Perhaps there may be a workaround, or perhaps this is specific to the way we are using embedded experiences.
We use embedded experiences quite a bit at our company so we have rolled back for now. If I figure anything out I will post an update but just be a
BuildXPages Deployment Automation Tools – v1.0.0
Thu, Sep 21st 2017 12:47p Cameron Gregor After quite a bit of work I have finally published the first release of BuildXPages!
What is BuildXPages?
BuildXPages is a project which is useful if you are interested in Automating tasks that are involved in building XPages.
For example you may be interested in automating some of these tasks:
Building NSFs from an On-Disk Project
Building Plugins and Features
Refreshing NSF Designs
Setting Template Inheritance of NSFs
Start, Stop and Restart Http server
Uploading Plugins to an NSF Update
Generating and Downloading Files Using XPages’ Persistence Service
Wed, Sep 13th 2017 4:42p Cameron Gregor When developing an XPages application you may run into the need to generate files to be downloaded by the user.
Generating a PDF Report
Exporting Data to Excel Spreadsheet
Creating a Zip File of several attachments
Achieving these tasks usually raises 2 main problems to solve;
What temporary place can I use to generate the files?
How do I allow the user to download the generated files?
For the temporary place problem, some common solution is to either generate the files to some
Bundle Inspector – Diagnosing XPages Plugin Resolution problems
Wed, Aug 2nd 2017 12:26p Cameron Gregor A common task with XPages development is to installing some plugins that provide additional functionality.
If you do any plugin development of your own, you end up doing this task a lot more as you create new plugins, install new versions etc.
It is also common to encounter some problems after installing plugins to your Domino Server! Maybe your expected plugin doesn’t load up at all? maybe the wrong version is loading?
The standard method of diagnosing these problems is to use the OSGi c
Swiper Official Version 2 Release
Fri, Jul 21st 2017 1:52p Cameron Gregor So I have finally posted Swiper version 2 to OpenNTF! (and Github of course)
Swiper OpenNTF Project Page
Swiper Github Releases
The latest version is 2.0.1, and is the same as 2.0.0beta but with a bug fix for the toolbar buttons.
Swiper 2.0.0 beta has been available on the Github project site for a few months, and the core functionality of it works as planned. There was however a bug within the shortcut buttons that I added to the menu bar, and this is a bit of a nasty bug that can cause del
Auto-width Bootstrap Column XPages Controls
Tue, Mar 21st 2017 1:13p Cameron Gregor I’ve been stuck working with OneUI Version 3 for the past couple of years, due to a regretful decision made at the beginning of my major project. OneUI was better than nothing but very frustrating at times.
Finally, I have moved on to my next project and I am now using bootstrap (version 3)
A common task when laying out a page using bootstrap is to divide sections up into rows and columns, and use the appropriate css styles to do so. I’m going to assume you are familiar with bo
Swiper FP8 Version Beta Release
Thu, Mar 16th 2017 12:50p Cameron Gregor Last week I released the ‘alpha’ version of Swiper which was untested on FP8 but presumed to be ok. So far I have only had good reports from the pioneers who have gone ahead and installed FP8 + the alpha version.
I have since managed to ugrade my home office setup to FP8 which unfortunately has broken my ability to launch designer from eclipse but I am seeking some advice on fixing this up.
In the meantime I have to test the slow way of building plugins, import plugins, restart R
Swiper FP8 Integration Rollout
Wed, Mar 8th 2017 12:43p Cameron Gregor Notes Domino 9.0.1 FP8 is finally here and as far as I know (I have yet to download it) it includes the necessary changes which will allow Swiper to swipe whatever it wants, whenever it wants, which is good news for people who don’t like to have ‘Build Automatically’ turned on.
Plan of Attack for release of Swiper version 2.0.0
So, I haven’t actually downloaded FP8 yet, so I can’t say for sure that the updated version works perfectly. Here is a bit of backgrou