> 2. Has anyone encountered this? What did you do? I haven't encountered this. But there are a couple of things I would suggest.
First, have you considered upgrading to CFMX 7.0.2? Second, have you considered upgrading the JVM? You should be able to upgrade to a later 1.4.2 JVM. > 3. How will you know what JDBC driver is suitable for you? I > thought CFMX comes with its own JDK, which is version 1.4, > thus JDBC3. How come JDBC2 works well, or does it really? CFMX does come with its own JVM, which for CFMX 6.1 is 1.4.2 base or 1.4.2_05, I forget which. The CF Administrator will tell you what JVM version you're using. Newer JVMs should still be able to run JDBC2 applications, I think. And, as for which JDBC driver is suitable, that's really up in the air. If you can use the JDBC drivers that come with CF, well, most people just do that. That obviously won't work with PostgreSQL, so you use whatever works for you. I've seen all sorts of different JDBC drivers used with CF, and there's typically no one "best answer" to this question. I've seen some odd cases where the ODBC bridge provides better performance than the type 4 JDBC drivers, and frankly that's just crazy to me. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
