Thanks Charlie, Some good ideas there, I will have a look at those things and let you know how I get on.
Regards Barry On Jul 19, 2:57 pm, "charlie arehart" <charlie_li...@carehart.org> wrote: > 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.
