202 Lotus blogs updated hourly. Who will post next? Home | Blogs | Search | About 
 
Latest 7 Posts
XPages JDBC Configuration via NotesDocuments
Tue, Dec 5th 2017 154
My New Approach for Sharing XPages Controls and Extensions
Fri, Dec 1st 2017 38
Embedded Experiences not rendering after IBM Notes FP9
Wed, Sep 27th 2017 8
BuildXPages Deployment Automation Tools – v1.0.0
Thu, Sep 21st 2017 7
Generating and Downloading Files Using XPages’ Persistence Service
Wed, Sep 13th 2017 8
Bundle Inspector – Diagnosing XPages Plugin Resolution problems
Wed, Aug 2nd 2017 8
Swiper Official Version 2 Release
Fri, Jul 21st 2017 6
Top 10
XPages JDBC Configuration via NotesDocuments
Tue, Dec 5th 2017 154
My New Approach for Sharing XPages Controls and Extensions
Fri, Dec 1st 2017 38
Preventing pasting of remotely hosted images in CKEditor
Mon, Nov 14th 2016 12
Webmail UI – You must learn about MIME
Wed, Apr 20th 2016 11
Preventing Pasting of Images in CKEditor
Mon, Nov 14th 2016 11
Pasting Images into XPages CKEditor
Sun, Feb 12th 2017 11
XPages PhoneNumber Control - Part 2 Upgrades to the Converter
Mon, Feb 23rd 2015 10
XPages webmail – Using Mime Inspector to debug Mime
Tue, Feb 14th 2017 9
Tips for Creating a Webmail UI with XPages
Tue, Apr 19th 2016 8
Bundle Inspector – Diagnosing XPages Plugin Resolution problems
Wed, Aug 2nd 2017 8


XPages JDBC Configuration via NotesDocuments
Twitter Google+ Facebook LinkedIn Addthis Email Gmail Flipboard Reddit Tumblr WhatsApp StumbleUpon Yammer Evernote Delicious
camerongregor    

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.

As mentioned in my previous post, I have decided to release all my future contributions through the ExtLibX project.

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.

Basically:

  • 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!

 



---------------------
http://camerongregor.com/2017/12/05/jdbcnotesdocuments/
Dec 05, 2017
154 hits



Recent Blog Posts
154
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
38
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
8
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
7
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
8
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. For example: 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
8
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
6
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
1
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
1
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
3
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




Created and Maintained by Yancy Lent - About - Planet Lotus Blog - Advertising - Mobile Edition