Coldbox datasource setting and Wirebox

A reader sent me a question and wanted to know why something wasn't working. In the ColdBox config we have the following setting. //Datasources datasources = { mysite = {name="myDSN", dbType="mysql", username="root", password="pass"} }; Then in your model you have 2 ways that you can access this datasource object both of which work off of the alias. The alias is the left side of the assignment in our settings here so in our case mysite is the datasource alias. We can wire up the property using wirebox and the correct dsl coldbox:datasource:alias property name="ds" inject="coldbox:datasource:mysite"; The easier way is to use the ColdBox Model Integration features and use the shortcut. ds = getDatasource('mysite') Then in your code you can access the name in a query by using getName() <cfquery name="#ds.getName()#"> select * from users <cfquery>

What happend in the case of our reader is he might of got the wrong idea about alias. In his code he had the following datasource setting. //Datasources datasources = { dsn = {alias="Abc", name="mycurrentdsn", dbType="oracle"} }; And when he was trying to wire up the datasource object he was using the following which will end up throwing a dsn is not defined error when you trying accessing the object. <cfproperty name='DSN' inject='coldbox:datasource:Abc>

So moral of the story is the alias is what you assign the structure to, in the case of our reader it will be dsn.

This entry was posted on June 10, 2011 at 11:58 AM and has received 1501 views. Comments 1 | Print this entry.