loathe wrote: > > 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. The client wants to get rid of Neon as it is very > expensive, and DB 2 Connect isn't as fast as it is. > > Is there a different third party driver or client that can do the same > thing? > > 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?
I seriously doubt it, since user management isn't a function of the database, it's RACF. We've been using DB2 Connect for years, due to issues with Macromedia's implementation of the JDBC Driver in Coldfusion MX. These issues *MAY* have been resolved with CFMX 7 and we're testing the JDBC drivers next week for all our applications. The problem in CFMX was that the stupid JDBC driver was returning column labels instead of column names. In most cases they are the same, but it still seemed like a stupid decision on the part of Macromedia. It ONLY affected people connecting to DB2 on OS/390 and z/OS. However, if it turns out that it's not a problem any more, we're gonna go back to the JDBC drivers. Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:247567 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
