Site Contents
Home
My Blog
ColdFusion
JRun
Flex
Wireless & Networking
Hardware & Gadgets
HDTV
Software Picks
Pictures
Contact Me
Search


My Articles & Papers
Flex Performance
Server/Client
mm.com Under the Hood
Multiple Instances of CFMX
Multiple Instance Config
NLB with ColdFusion
Clustering CFMX for J2EE
Multi-Tier Hardware LB w CFMX
Cisco CSS & Coldfusion MX
JRun 4 Jini based Clustering
WiFi Growth

2ID Tacweb

Other Hobbys
Body-For-Life Challenge

Personal Projects
Family Pool
Deck Gate

username:
password:
 

 
Building burcell.org

Welcome to bpurcell.org, the personal homepage of Brandon Purcell. I started building bpurcell.org many, many years ago to share information I ran across everyday in my role as a Support Engineer and Consultant for Macromedia/Adobe. As a support engineer and consultant I always had a lot to blog about but as I moved into managment roles at Adobe my technical content dwindled.

I currently work as the Director of Technology for Universal Mind. My primary responsiblity is managing the SpatialKey project and it has been an amazing experience. I have been spending a lot of time working with Amazon Ec2 and will share my experiences through the blog in the future. I truly believe that Cloud Computing is the IT platform of the future and we have built the SpatialKey architecture on top of Ec2.

Viewing Individual Entry / Main
January 5, 2004

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.

Comments

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!!!


 

Calendar
SunMonTueWedThuFriSat
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30            

Subject Archives
Amazon EC2 (15)
ColdFusionMX (155)
Corvette (3)
Flash Lite (4)
Flash Media Server (5)
Flash Player (3)
Flex (39)
General Web Dev (14)
HDTV (3)
Jboss (1)
Jquery (2)
JRun (59)
Max 2003 (3)
Other (33)
PC Hardware (16)
Software (17)
SpatialKey (7)
Wireless (8)
Working Out (1)

Search
RSS Feed
Feed Listing

www.flickr.com
Corvette - October 2005 brandonpurcell's Corvette - October 2005 photoset
Macromedia ColdFusion MX

Featured Links
Stock Footage
Page Render Time:172 user:""