Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

In my last entry, I mentioned briefly the new "JDBC Spy" feature that's available in the new 3.5 JDBC drivers for CFMX. I want to point out some more info for those interested in investigating the Spy feature further.

First, notice that there is a site at the DataDirect site (from whom Adobe purchases the JDBC drivers):

http://media.datadirect.com/download/docs/jdbc/alljdbc/reference/spy.html

It discusses some additional attributes. And still more useful info is offered at another page on their site:

http://media.datadirect.com/download/docs/jdbc/alljdbc/reference/diagnostics2.html

This actually shows what the log of info would look like, if you want to decide first if its info is worth the bother setting up.

This other page also talks about ways to turn the spy logging on and off at runtime, using Java method calls. Perhaps someone with more familiarity with the underlying Java classes for these drivers can translate the code there into something we can use in CFML. (It's late, and I don't have the energy.)

As such, be aware that the spy feature could generate a lot of data, so you may want to consider creating two datasource for each DB you may want to monitor. Either rename them to enable whichever you want to be in effect, or change if your code lets you specify a DSN via a variable, you can change the value to the "spying" version when you need it.

I did test and determined that also you can just add/remove the connection string from the end of the JDBC URL (see the technote for more), and immediately the logging stopped against the datasource. As a trick, I stuck the connectionstring value into the "description" field of the datasource definition, to keep it readily accessible if I wanted to add it back. (See my previous entry for a warning about putting it into the ConnectionString field instead.)

Finally, I should clarify that this Spy feature is not to be confused with the much older (and more powerful) p6Spy project, which has gone from open source to commercial to kind of stagnant. It still has great use, and in fact has a useful related SQL Profiler that's worth looking at. Still more at http://www.p6spy.com/, and maybe I'll write more about it later.

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

Had you noticed the JDBC updater at http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=42dcb10a? It applies updates to both the Merant DataDirect and Sequelink (ODBC) drivers.

I have a few questions/observations for others who have run it or may consider it, and they apply to 7.02 and 6.1 users, such as whether you need to apply it manually and about the various new features it adds, like integrated NT authentication for SQL Server, and a new JDBC Spy feature for any DBMS? More on them in a moment.

Do you need to update this for 7.02? 6.1?

First, do you need to apply the update manually if you're running 7.02, or even one of the later cumulative hotfixes (CHFs)? It doesn't say specifically. While it may seem we should presume it was included in 7.02, I think we should not. Some features it adds (below) are not in the C:\CFusionMX7\lib\macromedia_drivers.jar (whose date is also from 2004, at least on my 7.02 install.)

(UPDATE: In fact, it appears that the updated drivers were NOT in fact included in 7.02, or any CHF. First, as mentioned in the comments below a discussion on the Adobe Forums confirmed that these drivers were NOT included in 7.02. Also, note that CHF 1 for 7.02 lists the link for the driver updates as something you need to do yourself, under "additional information". There's also no mention of the JDBC drivers in the technotes for 7.02 CHF's 2 or 3, so it seems safe to conclude that 7.02 users do need to apply the update individually to get the updated JDBC drivers.

But better still, if you have 7.02 installed and wonder what version you have, you can find out for yourself. Check out this later entry of mine which helps you determine what version of the DB drivers you are indeed now running.)

As for 6.1, it's not clear but do we need to apply it if we have the latest 6.1 updater (6,1,0,83762 )? Again that build's macromedia_drivers.jar also lacks some of the files added by this updater, so I would assume so. I applied the update to my CFMX 6.1 updater release including also the important updating of the Sequelink ODBC Server as indicated in the technote. Don't miss that, if you're running on 6.1 (not needed on 7). After restarting, things are working.

Warning for those with 6.1 and 5 installed

I should note that I did find that my CF5 server (also running on this same dev box) suddenly, and for the first time ever since this box was created a few months ago, started raging with a persistent 55% cpu utilization for ntconsolejava.exe. I certainly would have assumed that the problem was in my CFMX 6.1 services, but by process of elimination it was the stopping of "ColdFusion Management Repository Server" (from CF5) that did the trick. That runs a JRun instance in the CF5 server.

I can't see how this would be connected, but I point it out in case it happens to others. I don't know what to do about it. I may just stop my CF5 server until I ever need it. I suppose I could also just set the management service to manual. I don't recall what the mgt service did in CF5. A quick review of the docs shows it had to do with archiving and admin reporting.

New Features in the Update Driver

But perhaps more important, as for the features it adds, did anyone notice the "sql server nt authentication" it enables? It seems that would solve a useful problem, but I could not get it to work. I followed all the steps including extracting the DLL (it's in the zip) and creating an "other" datasource type with the provided "authenticationmethod" in the JDBC URL. Has it worked for anyone?

Note also the interesting new spy feature, which can provide some useful diagnostics (think SQL Profiler, but for any DB and all the info tracked in a log file on the CF server). I was able to get it working successfully with a SQL Server database (using the "other datasource type" as explained in the technote), but when I tried to add it to an odbc dsn against an Access DB, using the connection string approach listed, nothing happened (no spy log created, until I used the "other datasource approach).

Note as well that the updates offer various fixes for SQL Server, Oracle, and Informix. It's also an update that pure JRun 4 users can/should run. I will point out that one blogger has found a change in behavior regarding multiple statements on a single SQL line: http://www.feed-squirrel.com/blog/index.cfm/2006/6/8/CREATE-TABLE-from-CF-7.

See the technote (linked at the top here) to learn more. I've also opened a question in the Adobe forums with this same info: http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=143&threadid=1180864&enterthread=y, as I can't assume as many people read my blog as will read that.

I'll be curious to hear (here or there) what others have experienced and what they think of these new features.

I should warn that the technote indicates a couple of times that you should not try to put these new connection string values into the "connection string" field of a DSN, instead creating an "other" datasource type and providing them on the JDBC URL for that DSN. When I made the mistake, I found that I could not query any ODBC datasources nor could I even start the CFMX Admin or get debugging on any page. All complained that the "DataSource service is not available.". I found no neo-query.bak to recover from, so was quite stuck. A careful analysis of the new-query file found that inappropriate CRLF character codes had made their way into the file (As 0a and 0d values that made for bad xml). I removed them (not trivial to do correctly) to get things back in order, so FOREWARNED IS FOREARMED.

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

In case folks have missed it, and as I alluded to in a previous post, a couple of folks are doing us all a nice service and putting together a nice update of the week's news in the CFML community.

First is Andy Allan's weekly summary of top news from the blogs, and you can find the latest each week at:

http://www.creative-restraint.co.uk/blog/index.cfm/Blog-Round-Up

Second is Ryan Hartwich's summary of the top news (blogs or not). For now, there is no place listing all his posts of that sort, but the latest is here:

http://www.fusionauthority.com/News/4642-Adobe-ColdFusion-News-Brief-August-8-2006.htm

Finally, there are also the podcasts (and their sites) that I mentioned in my earlier blog entry. I won't point these out each month, but I do want to bump up their visibility. These guys are all doing us a great service. Thanks.

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

Folks, did you know that you can easily sign up to receive an email whenever I post a new blog entry? It's a feature that Ray's nifty BlogCFC makes quite simple. Just see the "subscribe pod" on the right toolbar.

I'm surprised how many other blogs don't offer such an option, instead relying on folks to understand RSS. As I talked about in an earlier entry on watching the RSS feeds of the CF news aggregators, not everyone is quite yet versed in using RSS readers. I have been thinking about creating a new entry as a plea to other bloggers, but that's for another time.

And it may seem rudimentary that I should point out that this subscription option exists, but I've had a few people comment that they're "surprised to come and find out how many blog entries I've posted" since they last visited. If they signed up for the subscription feature, they'd get them delivered to their door...er, inbox.

Come on in, the water's fine. :-) I won't use the subscription for any purpose other than notifications about the blog. Promise.

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

Some of us have been hearing about or seen previews of SeeFusion 4, with its nifty new Flash-based interface. Well, it's now available in production. Check it out at http://www.seefusion.com/.

More on each of the following new features is available at the what's new page:

• Flex 2 rich user interface, including real-time charting
• Active monitoring rules
• Enhanced database logging, including user-defined event logging
• Stack trace filtering
• Debug output filtering by IP Address
• Streaming running requests
• Improved trace() method

More important, check out the live demo at:

http://www.seefusion.com/index.cfm?do=c.livedemo

Note the comments about firewalls and then click the "live demo" icon to see the new Flash-based interface running against a live server at SeeFusion HQ.

Finally, I'll add that, yes, I'm well aware of FusionReactor, and the fact that it's had a Flash-based interface for a long time. Be that as it may, I've always had a soft spot for SeeFusion and the guys at WebApper.

I also really appreciate that they offer a free trial that does not expire after x days (FR stops after 10 days). Instead, an unlicensed edition of SF runs for the first two hours after CFMX (or BD/J2EE) has been started, and then is stops. Honestly, I fear that some use it that way and never pay. If is solves problems for you, I hope your conscience will lead you to do the right thing. :-)

I won't belabor here what all the tool can do for you. Check out the site and its many pages and screenshots (and that live demo) to learn more.

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

Though I've been trying to spread this word for years, I still find people don't realize it. If you were a fan of CF Studio, while it's no longer available, you will find that HomeSite+ is effectively the same tool. And it's FREE--as long as you have a license for Dreamweaver MX or Studio MX.

You can't download it, nor can you buy it. (You can by HomeSite, but that's not the same as HomeSite+.) You'll find HS+ as an installer file on the DWMX CD, but not on the installer menu (though that's been addressed finally in DWMX 8).

For more details, see an article I did for Fusion Authority back in 2004 (which points at yet another article I did in the CFDJ in 2003:

http://www.fusionauthority.com/Tech_and_Tags/4231-Tipical-Charlie.htm

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

In my previous three entries, I've discussed how someone can keep up with the news of the CF world by leveraging blogs and blog aggregators. In this final installment, I want to point out a few resources that do all the work for you to keep up with a weekly update of what's going on in the CF world. One is a summary of the top CF blog entries (in that author's opinion), another is a summary of CF news (again, another author's opinion), and finally I want to point you to a couple of podcasts that include a focused summary of the news each edition.

Andy Allan's weekly blog summary

First, let me point out the nifty new weekly summary of top blog entries as determined by CF developer, Andy Allan, of the Scottish CFUG. His "roundup" of the CF blogosphere is just one of his regular blog postings, but he has demarked them by a category of "Blog Round Up", so you can keep an eye on just those particular new entries (if that's all you care to see) by watching the URL:

http://www.creative-restraint.co.uk/blog/index.cfm/Blog-Round-Up

As I noted in part 2 of this series, you can set up your browser to bookmark this URL in a way to make it easy to visit frequently.

Better still, as we discussed in part 3, you can leverage an RSS feed instead and Andy also offers such a feed for these "roundup" entries:

http://www.creative-restraint.co.uk/blog/rss.cfm?mode=full&mode2=cat&catid=93661280-C6C5-1A2A-16D86B1A3ADA948E

I first blogged about Andy's new service at http://carehart.org/blog/client/index.cfm/2006/7/21/andy_allens_weekly_cf_blog_roundup.

Ryan Hartwich's Weekly CF News Review for FusionAuthority

Now, where Andy is picking out the top blog entries, another take is Ryan Hartwich's new "News Brief", on the FusionAuthority site. So far, he has offered these two:

http://www.fusionauthority.com/News/4640-Adobe-ColdFusion-News-Brief-July-31-2006.htm

http://www.fusionauthority.com/News/4626-Adobe-ColdFusion-News-Brief-June-16-2006.htm

While there is no single page that keeps track of new entries to just the News Brief, it may be worth noting that for now you can use the following page that tracks all "news" items on the FA site, including the News Brief:

http://www.fusionauthority.com/News/

Sadly, it's not even presented in chronological order (for now), so you kind of have to wade through its contents to see what's new. Judith has told me that they are looking to address this challenge (of tracking what new entries are made in the News Brief and other article series), so look for that in the future.

Listen to the News: CF Podcasts with a News Focus

Finally, another outlet for CF news may appeal to those who just don't have time to read web pages, RSS readers, or emails. Of the several nifty CF-related podcasts, two in particular try to highlight the latest news each edition.

http://www.coldfusionpodcast.com/

http://www.coldfusionweekly.com/

Note as well that each of them also list the points they raise, including links, on a page for each podcast, which can itself be another avenue for keeping up on the week's news.

And a Summary of the Podcast (Summaries)!

OK, this may be getting a little too "meta", but for those who would like to keep tabs on what the CF podcasts are talking about, Charlie Griefer is offering another "meta" resource on FusionAuthority, in his somewhat regular podcast reviews. A couple of the latest entries (at this time) are:

http://www.fusionauthority.com/Reviews/4625-The-ColdFusion-Podcast-Roundup-Thursday-June-8-2006.htm

http://www.fusionauthority.com/Reviews/4624-The-ColdFusion-Podcast-Roundup-Wednesday-May-30-2006.htm

And, as with the News Brief discussed above, there is no one page that lists just new entries to the Podcast Reviews, but they are listed along with hundreds of other "news" pages (going back to 1999) on the page: http://www.fusionauthority.com/Reviews/.

CF Open Source Updates

Oh, let me share one more. I'm sorry I forgot it initially. Brian Rinaldi is now keeping a weekly update on the OpenSource part of the CF World. Here is the latest:

http://www.remotesynthesis.com/blog/index.cfm/2006/7/31/ColdFusion-OpenSource-Update--July-31

If he offers me a URL that lists them as they're updated, I'll offer that here.

OK, that's it. I hope you got some value from these 4 parts on "keepin' up on what's happening in the CF world".

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

In my two previous entries, I've been discussing how someone interested in keeping up with the news of the CF world can leverage the two popular Adobe-community blog aggregators. The last focused on browsing them, and this will focus on using their available RSS feeds.

Even if you don't know anything more about RSS than how to spell it, follow along. I'll share something that can help you leverage it from Email, to get your daily (or even hourly) dose of CF news delivered to your inbox. Finally, in the next and final part, I'll point out a couple ways to save you even that bother, with folks who have so kindly gathered up the latest news of the week.

The previous two entries were on the aggregators and browsing them.

While going to the sites to browse the latest news is one way to keep up, it's certainly not the most efficient. New entries are constantly being added, and all you need to do is go away for a few hours and there are several new entries. And what if you're gone for days?

Getting the RSS Feeds Instead

A still better solution to that problem is to get the posts delivered to you as they are discovered (added by the bloggers whose blogs are being aggregated). This is possible by using what's called the RSS feed (Really Simple Syndication). You don't need to understand much about them to take advantage of them. Indeed, I won't get into any detail here as others have covered the topic well.

Just know that it's an XML stream of data that's updates whenever a new entry is made, and some program can be set on your computer to watch that stream and take note of any such updates. RSS feeds are offered on both many blogs, and in fact it's the RSS feeds that these aggregators watch. Well, the aggregators themselves also offer RSS feeds of all the data they aggregate.

Recall in the first entry of this series, I shared with you the two URLs that you could use to keep en eye on the CFML-related entries that the aggregators detected.

Well, the corresponding URLs for the RSS feeds watching those entries at the two aggregators are, respectively: http://www.fullasagoog.com/xml/ColdFusionMX.xml

http://weblogs.macromedia.com/mxna/xml/rss.cfm?query=byCategory&languages=1&categoryId=1 If you're familiar with what to do with those URLs, take them and run with them. Otherwise, I'll explain in a moment how you can take advantage of them, even to get notified by email of the changes detected in the feeds.

Before that, though, let me point out that the MXNA feed URL can be generated for different characteristics, including particular languages (I've given the English one above) and even to watch the feed for a particular string. Visit the MXNA site to generate your own desired RSS feed URL.

Further, note that MXNA also offers a mechanism called "smart categories", which tries to be even more discerning about what gets delivered as related to a given category. The CFML feed for that would be: http://weblogs.macromedia.com/mxna/xml/rss.cfm?query=bySmartCategory&languages=1&smartCategoryId=1&smartCategoryKey=D0382F3A-9D2B-69E8-C7BC317066FA1CC2

I know how to spell RSS, but that's about it. I prefer Email

As helpful as an RSS feed is for those familiar with using RSS readers (or using email programs that know how to process them such as Firebird and Outlook 2007), what about those who don't use any of those yet? You can still get your constant drip of CFML goodness without having to visit the page every day or hour, and without having an RSS reader or email program that knows how to process such feeds.

On another blog of mine, I wrote about a couple of free services (Squeet, Feedblitz) that allow you to give them an RSS feed and they'll email you when new entries are posted to the feed. You can even control whether it's immediate or only a daily digest. Nifty. Learn more about that at my tipicalcharlie.com site (for generic, non-CF tips):

http://www.tipicalcharlie.com/blog_email_notification_by_squeet.htm ((Update: tipicalcharlie domain is no more, but page recovered using Archive.org.))

(Update: Sadly, squeet (a tool to send RSS feeds by email) is no more. But there are other alternatives, that I track in a category of my CF411 site: http://www.cf411.com/rss_email.)

And finally, for those who just can't keep up with a constant or even daily flow of the latest and greatest news, in my next entry I'll point out a couple of great resources that instead give you the news on a weekly basis.

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

In my previous entry, I started a multi-part series on keeping up with what's happening in the CF world. In this entry, I want to introduce a couple topics related to keeping an eye on those two aggregators I mentioned, FullAsAGoog and MXNA, by way of browsing them.

Of course, there are still better ways, including leveraging their RSS feeds, which I'll cover in the next entry. But for those who still prefer good ol' web pages, here are a couple tips that may help. These tips aren't unique to watching the aggregators, of course, and for some they may be old school. But I see plenty of folks who don't leverage them so it seemed worth mentioning.

We all know that having the URLs to the aggregator's CF category listings (as mentioned before) we can easily bookmark the pages to go visit whenever we want. But since these are pages that you may well want to visit frequently than most, you can take advantage of a couple of browser features to make them even more readily accessible.

Keeping an Eye on the Aggregators--by Quick Links

First, did you realize that both IE and Firefox have a unique toolbar-based list of favorites/bookmarks that you can see all the time? Many never bother to change them or pay attention. Here's how to use them in each browser.

In IE, when adding a favorite, you just want to put it in the special "Links" folder. Using the Favorites>Add to Favorites menu option, use the "create in" option to point to the "Links" folder. Then it will appear in the top IE toolbar area. Other things in there by default are "Windows Marketplace" and "Windows Media". You can remove them if you want, to make more room. If you don't see these links at all, make sure you've enabled View>Toolbars>Links. And if you can't see the entry/entries you just added, you may need to move the new entry around in the Links folder. Use Favorites>Organize Favorites, expanding the Links folder and moving the newly added entry up in the list of links.

In Firefox, there is a similar set of "toolbar bookmarks" that appear at the top of the screen. To add something to it, use Bookmarks>Bookmark This Page (or hit Ctrl-D) and then choose "create in" and point to "Bookmarks Toolbar". Other default items in there include "Customize Links" and "Free Hotmail". Again, if you don't see it at all, make sure that View>Toolbars>Bookmarks Toolbar is enabled. And as with IE, you may want to move the entries around in that list (or even delete some you'll never use), using Bookmarks>Manage Bookmarks and expanding the "Bookmarks Toolbar" folder to arrange things.

Keeping an Eye on the Aggregators--Making One of Them Your HomePage

One other trick to consider is that you think you just ALWAYS want to see one of the aggregator pages by default, you may know that you can set one of them up to be the "home page" for your browser. Then it appears each time you open the browser.

In IE, you do that with Tools>Internet Options>General>HomePage>Address and enter the desired URL.

In Firefox it's Tools>Options>General>Home Page>Location.

Honestly, I don't do it in either browser. For one thing, I want the browser to open as fast as possible and so just choose "use blank page" in both.

But better still, I keep my eye on the submissions using another approach, one that I'm sure many readers here know about and wonder why I'm not promoting. I will, in the next entry on leveraging the RSS feeds. If you don't know what that's about, I'll help you, even if you don't know what an RSS Reader is and don't want to install one! :-) That's coming up next.

Note: This blog post is from 2006. Some content may be outdated--though not necessarily. Same with links and subsequent comments from myself or others. Corrections are welcome, in the comments. And I may revise the content as necessary.

I was offering some info on a discussion list and decided I'd share it more broadly and expand upon it. If you want to keep up with the latest and greatest in the CFML community, you may know that there are dozens of blogs, but who has time to read them all?

In this multi-part entry, I want to share some tips to make it easier to keep up on what's happening, from simplifying your reading all those blog posts, to keeping up on them as they change, to (better yet) obtaining summaries of the week's news put together by others to save you the bother.

In this first part, I'll introduce you to the two great CFML blog aggregators.

The Community Blog Aggregators: FullasAGoog and MXNA

So how do you find all the great CFML-oriented blogs out there? Am I going to list them for you? I don't need to. There are two primary "aggregators" of all blogs related to the greater Adobe (and previously MM) space, FullAsAGoog and the Adobe MXNA. These have for long been all you needed to keep an eye on to stay on top of what people are discussing in the blogosphere.

And any blogger who wants to reach the CF community has (or should) submit their site (their site's RSS feed) to the two aggregators. Then, whenever a blogger adds a new entry, it's automatically picked up (sometimes taking minutes or hours) by the aggregators, so people can just keep an eye on one of them to see what's news.

The 'goog existed first, but naturally Adobe's has attracted its own audience. Both have a submission/acceptance process (and indeed MXNA is more than just Adobe bloggers), but most bloggers are on both (which also means some duplication if you watch both). BTW, you can read the history of the 'goog's silly sounding name via a link on the left at the site. :-)

Limiting The Aggregators to Just CFML-oriented Content

Since both aggregators cover the full spectrum of blogs related to Adobe/MM products, you will probably want to limit them to just show you the CF-related ones (or whichever topic/s you are interested in). Though many seem to miss it, each aggregator offers a way to do that in its interface. In the 'goog, it's done via the "choose your poison" drop down at the top of the page--perhaps you never thought to look at that. :-) In MXNA, you choose the desired category link on the right toolbar.

If you just want the URLs for the CF feeds, they would be:

http://www.fullasagoog.com/index.cfm?blogcat=ColdFusionMX

http://weblogs.macromedia.com/mxna/index.cfm?query=byCategory&categoryId=1&categoryName=ColdFusion

The URLS offered just above are to see the web-based (HTML) interface for reading each aggregator. You could certainly just set them as a bookmark to visit whenever you have a free moment, and I have a couple of tips on that, but then there is yet another approach which you may not know about: using RSS feeds--even via email. More on that in the next entry.

(I've decided to chop this up rather than make one big long entry, since some will be more interested in some aspects than others. I don't want anyone to miss out if they were to stop reading at some point in a long post. Following posts will cover making quick browser links to the aggregators, using RSS feeds, and getting weekly summaries already "baked" for you.)