Our office is new in implementing J2E technology. We are set up with JRun and ms sql server. The db admin was horrifed when he opened the sql server log and saw all the connections by one of my applications.
Basically, the site queries the db almost at every page, to collect, display the different info. So everytime the user browses a page, data is being pulled from sql. Am I doing anything wrong? I thought that everytime I connect, I should close the connection. I posted this q to javaranch, and one person replied that i should store in app level, and another one that JDBC2 Datasource would do that for me. I'm embarrassed to admit but am clueless of what they mean. Can someone please explain? Thanks! ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
