If you are running ColdFusion MX 6.1 and using Oracle or SQL Server then it is highly recommended that you update the macromedia_drivers.jar due to several issues outlined in this technote. If you are not sure what version you have you can use the below code to find out what version of the driver you are using. The code will output the version number of each DataDirect driver into the System.out log. (e.g. into C:\CFusionMX\runtime\logs\default-out.log for standalone/Windows).
<cfset drivernames = "macromedia.jdbc.oracle.OracleDriver, macromedia.jdbc.db2.DB2Driver, macromedia.jdbc.informix.InformixDriver, macromedia.jdbc.sequelink.SequeLinkDriver, macromedia.jdbc.sqlserver.SQLServerDriver, macromedia.jdbc.sybase.SybaseDriver">
<cfset drivernames=Replace(drivernames," ","","ALL")><!--- replace all spaces --->
<cfloop index="drivername" list="#drivernames#">
<cfobject action="CREATE" class="#drivername#" name="driver" type="JAVA">
<cfset args= ArrayNew(1)>
<cfset driver.main(args)>
</cfloop>
The CFMX 6.1 version 3.2 drivers report this:
[Macromedia][Oracle JDBC Driver]Driver Version: 3.2.006918003414003124
[Macromedia][DB2 JDBC Driver]Driver Version: 3.2.006918003414005221
[Macromedia][Informix JDBC Driver]Driver Version: 3.2.006918003414001506
[DataDirect][SequeLink JDBC Driver]Driver Version: 5.3.001902
[Macromedia][SQLServer JDBC Driver]Driver Version: 3.2.006918003414004421
[Macromedia][Sybase JDBC Driver]Driver Version: 3.2.006918003414002406
The version 3.1+ drivers from the download (this is what you should be using currently)http://download.macromedia.com/pub/coldfusion/drivers/3.1/cfmx60_u3_plus.zip report this:
[Macromedia][Oracle JDBC Driver]Driver Version: 3.1.003921002406001721
[Macromedia][DB2 JDBC Driver]Driver Version: 3.1.003921002406002819
[Macromedia][Informix JDBC Driver]Driver Version: 3.1.003921002406001101
[DataDirect][SequeLink JDBC Driver]Driver Version: 5.3.001902
[Macromedia][SQLServer JDBC Driver]Driver Version: 3.1.003921002406002513
[Macromedia][Sybase JDBC Driver]Driver Version: 3.1.003921002406001307
The CFMX 6.0 Updater 3 version 3.1 drivers report this:
[Macromedia][Oracle JDBC Driver]Driver Version: 3.1.003918002406001718
[Macromedia][DB2 JDBC Driver]Driver Version: 3.1.003918002406002819
[Macromedia][Informix JDBC Driver]Driver Version: 3.1.003918002406001101
[DataDirect][SequeLink JDBC Driver]Driver Version: 5.3.001902
[Macromedia][SQLServer JDBC Driver]Driver Version: 3.1.003918002406002511
[Macromedia][Sybase JDBC Driver]Driver Version: 3.1.003918002406001307
Thanks to Tom Donovan for this tip.
Show it on the screen!
<cfset drivernames = "macromedia.jdbc.oracle.OracleDriver, macromedia.jdbc.db2.DB2Driver, macromedia.jdbc.informix.InformixDriver, macromedia.jdbc.sequelink.SequeLinkDriver, macromedia.jdbc.sqlserver.SQLServerDriver, macromedia.jdbc.sybase.SybaseDriver"> <cfset drivernames=Replace(drivernames," ","","ALL")><!--- replace all spaces ---> <cfloop index="drivername" list="#drivernames#"> <cfobject action="CREATE" class="#drivername#" name="driver" type="JAVA"> <cfset args= ArrayNew(1)> <cfset driver.main(args)> <cfoutput>#drivername# is #driver.getMajorVersion()#.#driver.getMinorVersion()#<br></cfoutput> </cfloop>
doesn't show whole version number
Thank you for this post! I've been searching for an answer to this for a week!!!
