Right, Barry, I've not heard of it happening much on CF9. As for solving this...
In 8 I would have recommended making sure you had any suitable CF hotfixes. In CF9, there has of course been at least one CHF (http://kb2.adobe.com/cps/825/cpsid_82536.html), but while it mentions NullPointerExceptions, it's only in the context of CAR file deployment. I would also suggest you confirm that any hotfix files in the [cf]\lib\updates directory is in fact for CF9 (they have the version number in the jar file name). I've helped more than a few shops where they had inadvertently put uploaded to the CF Admin (or placed there in that directory, which it does for you) jars for the wrong CF version. In past releases I might also have recommend to check if Adobe had come out with an updated jdbc driver, since those always had to be applied separate from cumulative hotfixes. But there've been none for CF9 yet (there have been updates by DataDirect, but not packaged by Adobe for us). I will point out that there is a Microsoft JDBC driver which you could try. Still, it's reasonable that the built-in one should work. Will be curious to hear how it turns out for you. /charlie > -----Original Message----- > From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf > Of > BarryC > Sent: Sunday, July 18, 2010 9:56 PM > To: cfaussie > Subject: [cfaussie] Coldfusion 9, MSSQL and random > java.lang.nullpointerexception errors > > Hello, > > We have some nul null (java.lang.nullpointerexception) errors randomly > occuring on our servers, I've googled a bit and most of the posts > refer to CF 8 and MySQL, but they all seem to point to database > connection related things as being the issue. > > You can request the same page multiple times and maybe once out of 30 > odd requests will you see the error. > > Has anyone else had these null type errors, and what databases do you > guys run and what connection properties or database drivers do you > use? What different things could I try, another database driver > perhaps? > > Our database connection settings are: > Driver: MSSQLServer > Select Method: Direct > Maintain connections is on. > Max pooled statements: 1000 > Timeout: 20mins , Interval 7seconds > Query Timeout: 0 > Login Timeout: 30 seconds > CLOB enabled > Long text buffer (chr) 256000 > Blob buffer (bytes) 64000 > > Database is MS SQL server 2008 > > Thanks > Barry Chesterman. > > -- > You received this message because you are subscribed to the Google Groups > "cfaussie" group. > To post to this group, send email to cfaus...@googlegroups.com. > To unsubscribe from this group, send email to > cfaussie+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.