Loathe said: > What is the best way from CF (potentially on a web sphere > server) to have FULL access to DB 2. By this I mean user > management, stored procedures, and regular SQL statements. > ... snipped ... > Can I do user management through JDBC? I hear there are a > ton of performance gains to be had by using JDBC, is this true?
We have a test Windows server set up with CF6.1 (soon to be upgraded to CF7) that accesses DB2 on z/OS. Our DBAs made us use the IBM DB2 Type 2 JDBC drivers specifically because it would allow them to take 'full advantage of DB2's capabilities' - whatever that means. We run successfully against DB2 using both stored procedures and pass through SQL. I don't know about user management through JDBC and I cannot answer your performance gains question because we are still deep into the CF5 to CF7 migration project that won't end, but we ran some pretty heavy load testing (for our environment) and we didn't run into any issues. I should say that we do only reads, no creates, updates, deletes. George ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247536 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
