Author: Steven Neiland
Published:

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(
"jdbc:mysql://localhost:3306/demodb?user=demouser&password=demopass")>


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

Treehouse

 
Fork me on GitHub