When you specify a MySQL* datasource to CFMX (Administrator), the standard way of doing it is to select "MysQL" from the driver type dropdown. Then you are presented with a special datasource configuration form that doesn't show any jdbc driver information, e.g.
CF Data Source Name: MySQLTest Database: test Server: localhost Port: 3306 Username: mysqluser Password: mysqlpassword Description: MySQL interface using standard CFMX definition An alternate way of specifying a MySQL* datasource to CFMX (Administrator) is to select "Other" from the driver type dropdown. Then you are presented with a more generalized jdbc datasource configuration form, e.g. CF Data Source Name: MySQLTest JDBC URL: jdbc:mysql://localhost:3306/test Driver Class: org.gjt.mm.mysql.Driver Driver Name: MySQLJDBC (Must not be MySQL or the jdbc information will be discarded) Username: mysqluser Password: mysqlpassword Description: MySQL Interface using MySQL JDBC Driver from CFMX *This also applies to DB2, Orcale... or any of the DBs that CFMX lists in the driver type dropdown Now, I want to use a Java GUI SQL client (ViennaSQL) to manipulate the databases, test queries, etc. This has many advantages, for example: during application development I can interactively create and test the queries then copy/paste them into my CFMX programs, When you specify a datasource (connection) to ViennaSQL, you must provide the jdbc URL and Driver class found in the second format of the CFMX datasource specification (above). I would prefer to keep Datasource specification for CFMX and the Connection specification for ViennaSQL as similar as possible, to avoid confusion. Therefore, I want to use the jdbc (second) format when specifying datasources to CFMX. My questions are: Is there any advantage/disadvantage to using the jdbc format of datasource specification in the CFMX Administrator? I assume that Macromedia has reasons for having the default (non-jdbc) format -- will I get in trouble using the non-standard jdbc format? I assume that the underlying database server is responsible for managing concurrent connections using whatever drivers, so any interface I use in a program is OK as long as it complies with the database's requirements -- Is this a correct assumption? TIA Dick ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
