xpages - What is the best way of using dynamic JDBC username and password? -


we creating xpages application mysql backend. application used several customers. each has own nsf database , corresponding mysql database. each customer have own mysql username. using extension library jdbc components (connectionmanager).

we planning store username , password in notesdocument. way nsf's design can updated ntf template without affecting data. however, connectionmanager component , @getjdbcconnection ssjs function both read username, password , other connection info file stored in web-inf/jdbc folder. files stored there overwritten when nsf design updated, losing customer-specific information.

there seems no way of making these files dynamic (web-inf specification read-only) or include dynamic elements inside them (see previous question).

we use dynamic jdbc url in connectionmanager, extlib book warns against practice. seems lose connection pooling. , besides, @getjdbcconnection function not accept jdbc urls.

so, best way of storing nsf-specific jdbc connection information?

edit: solved

i created subclass of jdbcconnectionmanager component. procedure detailed here: http://lazynotesguy.net/blog/2013/08/09/subclassing-an-extlib-component/

best subclass extlib classes. since extlib source provided should not hard. other option use version control system maintain branches per customer differ in config file


Comments