Do you have a link to these drivers? Are they type 4 JDBC? I didn't come across any in my original googling. only the MS and DataDirect ones.
Cheers, Steve > -----Original Message----- > From: Simon Horwith [mailto:[EMAIL PROTECTED] > Sent: 17 September 2003 19:00 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] OT: JRun database connectivity best practices > > > I don't know of any best practices for JRun 3.1 but I can > tell you that even > in JRun 4 I experience the EXACT SAME error messages when > using third-party > JDBC drivers via EJBs. The cause of the problem (in my case > it was Oracle > Thin Client JDBC) was directly related to the threading > engine - JRun just > doesn't seem to handle multiple simultaneous requests to > third party drivers > very well. The fix in my situation was to use Macromedia's drivers ;) > Don't know if that helps? > > ~Simon > > Simon Horwith > CTO, Etrilogy Ltd. > Member of Team Macromedia > Macromedia Certified Instructor > Certified Advanced ColdFusion MX Developer > Certified Flash MX Developer > CFDJList - List Administrator > http://www.how2cf.com/ > > > -----Original Message----- > From: Steve Martin [mailto:[EMAIL PROTECTED] > Sent: 17 September 2003 18:46 > To: [EMAIL PROTECTED] > Subject: [ cf-dev ] OT: JRun database connectivity best practices > > > 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] > > > > -- ** 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]
