Folks, Does anyone have any best practices for connecting to a database (MSSQL) in JRun (3.1)? I'm currently connecting through a type 4 JDBC driver using the DriverManager.getConnection(...) in a javabean approach, largely because when I installed Run there wasn't an MSSQL driver present in the datasource manager and I knew of the bean approach and so implemented that. Trouble is that the site has been intermittently bombing out with exceptions centred around the m$ driver classes (stack trace available upon request <g>) - requiring a JRun service restart to bring it back up. I installed a bunch of type 4 drivers from DataDirect Technologies as a replacement which have been thus far very stable, but I'm not too chuffed with he �2.5 price tag and would rather pursue other avenues than hand over the readies to a company who sent me an automated quotation email in response to my lovingly handcrafted request for a price ;-)
Cheers, Steve -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
