> Hmmm... So there is no direct JDBC driver that come with CF? All of the drivers that come with CF are JDBC drivers. Whenever you pick any of the listed datasource types besides "Other", you're using JDBC drivers that come with CF. Pointbase is the only driver that comes with CF, for which you have to configure the JDBC URL yourself.
> Any JDBC connection must go through the ODBC bridge? No, only the "Microsoft Access" and "ODBC Socket" datasources use ODBC. All others are "pure Java" JDBC drivers. > Then were is the advantage of JDBC? I don't know if I'd call JDBC an "advantage" - JDBC is simply how Java applications connect to databases. Since CFMX is a Java application, it uses JDBC. JDBC drivers that connect directly to a database instead of connecting to another middleware layer like ODBC generally perform better than those that don't, so if you're going to use JDBC you're usually better off using "pure Java" JDBC Type 4 drivers. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:216613 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
