MS Access is ubiquitous in many places. But it’s not very portable. Although CF supports access databases via odbc, this requires windows. I know it’s not a jdbc driver, so you can’t use cfquery with it, but if you need to support reading from access db’s in CF on another platform (or anything pure java), check out jackcess. I’m hoping that somebody might be able to pull in the code from this and work it into a proper jdbc driver.
June 28, 2007
SQLite JDBC Driver
There’s finally a working, pure java jdbc driver for sqlite — it should make it pretty darn easy to use with CF (or anything else java for that matter). I’ve been look for something like this for awhile, but the implementations I’ve seen have always relied upon JNI. This should work on macs, solaris, linux, windows, etc.
Trudging On
I haven’t written in a good long while. My frustrations with moving to wordpress.com have kept me away. They’ve been unable to resolve the problems with my blog import, other than to tell me I can manually re-add the 50+ comments on the CFMX for intel macs entry. I guess it’s time to get over all that though.
I’m currently in DC attending CFUNITED. It’s an ok conference, and I’ve been able to pick up some great performance tips. It seems a little to geared to the newbie CF’er for me. Having been doing CF for about 10 years now, in enterprise class environments, there isn’t much with CF that’s new to me.
