A HAPPY NEW YEAR TO ALL WEBAPPERS!

Microsoft Access can be a useful tool for designing a database schema in the early stages of a web application development. MS SQL Server via Enterprise Manager MMC has a convenient way to upsize Access db’’s. There is a handy looking tool located here for migrating MS Access and MySQL db’’s to PostgreSQL.

Jochem van Dieten a regular and widely respected contributor to Cf-Talk has a good resource for items ColdFusion and PostgreSQL related. PostgreSQL is an excellent open-source RDBMS with Enterprise level capabilities. The resource is located here.

There has been a lot of debate around how ColdFusion MX has changed the needs in locking of shared-scope variables. One myth that did surface is that locking using CFLOCK is no longer required, this is definitely not correct. This article from Macromedia explains the we must now guard against a non-CF specific [...]

Tom Donovan of Macromedia list 10 great tips for securing ColdFusion installations. The article can be found here.

This is an issue that is raised fairly frequently on the ColdFusion mailing lists. ColdFusion MX handles virtual web sites on multi-homed servers differently that other version of ColdFusion. This is a direct quote from the Macromedia Release notees for ColdFusion MX “On multi-homed servers it is important to change the cacheRealPath option of [...]

The “Element SQLExecutive is undefined in Request” error generated when first trying to access any datasource via the ColdFusion MX Administrator interface indicates that the neo.query-xml file in the CFusionMX/lib is either missing or corrupted, if corrupted you will see a 0-byte file size. The solution is to use the neo.query.bak file and rename [...]

This is from a recent post from Sean Corfield on CF-Talk relating to Oracle Native Driver installation. “You need to add the libraries to the path and then you set up the driver in CFMX like this: JDBC URL: jdbc:oracle:oci:@. Driver Class: oracle.jdbc.OracleDriver Driver Name: Oracle 9i OCI Client (note: this is only a comment! You need to ensure the [...]

This is imply a link to an exceptional article on CFGuru (second time in one day!) with pointers to using Postgres with ColdFusion MX. Postgres is often used as an alternative to other Open Source DB Engines as it has more features needed for Enterprise applications such as transactional support and stored procedure support.

ColdFusion MX has presented some challenges for those of us using Linux or other Unix derivatives with MX. Macromedia recently released Updater 2 plus a set of subsequent patches for Unix/Apache and for the benefit of all we are repeating extracts from a recent post by Phil Costa of Macromedia recently on CFGuru. [...]