com.mysql.jdbc.Driver

[Pekka]

I need to create a 'standalone' connection to a MySQL database. Using this
code works: <cfset clazz = CreateObject('java', 'java.lang.Class') /> <cfset
clazz.forName('com.mysql.jdbc.Driver') /> <cfset driverManager =
CreateObject('java','java.sql.DriverManager') /> <cfset jdbcUrl =
'jdbc:mysql://127.0.0.1:3306/db?user=user&amp;password=pass' /> <cfset
connection = DriverManager.getConnection(jdbcUrl) /> But apparently, the
driver manager returns the wrong /old version of the driver: Version: 2.0.11
Driver: org.gjt.mm.mysql.Driver I only have the newest version of Connector/J
in my classpath: mysql-connector-java-3.1.6-bin.jar Is CF possibly using some
old internal version of the driver? Can I make a connection in any other way?
I have some external java objects that needs a connection sent from CF. Any
Ideas ? - Per

[Pekka]

Solvetd it: <cfset dss =
CreateObject('java','coldfusion.server.ServiceFact ory').getDataSourceService()
/> <cfset conn = dss.getDataSource('myDataSource') /> <cfset conn =
conn.getConnection('user','pass') />