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