Author: Steven Neiland

Warning: This blog entry was written two or more years ago. Therefore, it may contain broken links, out-dated or misleading content, or information that is just plain wrong. Please read on with caution.

Step 6: Close the Connection

Finally we need to remember to close the connection to the database to free up resources.

<!--- Close the connection --->
<cfset connection.Close()>

Complete Code

So there we have it. A simple way to connect to a database from Coldfusion without creating a datasource. For reference the complete code is below, you will obviously need to put in error handling.

<!--- Load the database driver using java class loader --->
<cfset classLoader = createObject("java", "java.lang.Class")>
<cfset classLoader.forName("com.mysql.jdbc.Driver")>

<!--- Create a driver manager instance --->
<cfset driverManager = createObject("java","java sql.DriverManager")>

<!--- Create the connection to the DB --->
<cfset connection = driverManager.getConnection(

<!---Create a connection statement and run our query string --->
<cfset statement = connection.createStatement()>      
<cfset resultSet = statement.ExecuteQuery("SELECT * FROM testtable")>

<!---Convert the resultset into a coldfusion query object --->
<cfset queryObj = createObject("java", "coldfusion sql.QueryTable").init(resultSet)>

<!--- Close the connection --->
<cfset connection.Close()>
1 2 3

What Do You Think?

Reader Comments

Post a Comment

Comment Etiquette:

  • Please keep comments on-topic.
  • Please do not post unrelated questions or large chunks of code.
  • Please do not engage in flaming/abusive behaviour.
  • Comments that contain or appear to be advertisments, will not be published.
  • Comments that appear to be created for the purpose of linkbuilding to commercial sites will be removed.

We are all adults here so play nice.


Archives Blog Listing

Tag Listing

Learn CF In A Week


Fork me on GitHub