Dear Friends , I really appreciate your suggestions and guidance ...Let me explain the requirement in details
1. The application is kind of BI ( Business Intelligence ) tool . 2. System will automate the report generation process , i.e kind of query builder ..Which will connect to the data base and user can generate query using user interface ( i.e selecting table/view and select display columns and apply where clause conditions , apply group by and order by condition , output type(pdf/html ) ) and output will be generated based on above conditions 3. This is designed for MySQL data base 4. Earlier the db connection properties are configured in the hibernate.cfg.xml file 5. Now the requirement is Client wants to turn this to dynamic ..i.e In the very first screen user should provide the connection details through screen ...( Server , user name , password ,database ).. 6. System should connect the DB based on the properties through application ...Then user generates the queries and generate reports ..... There is one db connection is possible for single deployment ( i.e user can not have more than one db connections , only one is allowed ) In tapestry ..hibernate session object is been build on start up as singleton ... As of now I am injecting the hibernate session in each page class to establish the connection ... But how to change the session object based on user in puts .. in my case DB is MySQL , User provides following details 1. DB Name 2. Server Location 3. User Name 4. Password Please let me know if you need more details on this .. Thanks again for the quick response ..Please guide me how to solve the scenario ...... Thanks and Regards Ramprasath -- View this message in context: http://tapestry.1045711.n5.nabble.com/Tapestry-Change-hibernate-properties-on-fly-tp5469203p5471536.html Sent from the Tapestry - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org For additional commands, e-mail: users-h...@tapestry.apache.org