Nov 3, 2011 3:23 PM
66 Posts

How do you connect to SQL database? Where do you keep the shared database connection?

  • Category: Managed Beans in NSF
  • Platform: All
  • Release: 8.5.3
  • Role:
  • Tags:
  • Replies: 3
 How do you connect to SQL database? Where do you keep the shared database connection? Managed bean with application scope seems to be suitable but I cant find any information whether there is any managed bean life cycle ...  so I could close such connection safely on application(managed bean) restart. Making the new connection on every request seems to me very ineficient and not suitable for production. How do you use this? Or should I use static object property ...?  http://stackoverflow.com/questions/6448758/manage-connection-database-with-jdbc-in-jsf
Nov 4, 2011 3:40 AM
150 Posts
Re: How do you connect to SQL database? Where do you keep the shared database connection?
 
are you using the extension library?
http://www.notessidan.se/blogg.nsf/xstart.xsp?post=FFAEA75F380D2B55C1257930005879BE
 
 
/Thomas
Nov 4, 2011 5:41 AM
66 Posts
Re: How do you connect to SQL database? Where do you keep the shared database connection?
 No, I dont use extension library and do want to use it. Application is running at customer on 12 servers (8.5.2. and 8.5.3) ... I can't image to maintaint extension library on all servers across the Domino versions ...
Nov 4, 2011 7:35 AM
150 Posts
Re: How do you connect to SQL database? Where do you keep the shared database connection?
 
Ok, Sorry if I mess up your original question.
 
You really should consider making Extlib part of your Domino installations. ( it is IBM's way of shipping new features to xPages) If you are missing features in xPages you might find them in extlib.

There is an automated way of adding extlib to your servers. you simply use a plugin database and import the new versions. Domino will then automatically install new version when http task is restarted.
 
Thomas