Creating a MySql Datasource in OpenBlueDragon
Sep 07 2008 - By George Webster
As numerous people have blogged about and the fine folks at openbluedragon.org have show its simply a matter of droping the openbluedragon.war file into your webapps directory and your up and running...well cfml but not a data source.
After much trial and error this too really is simple.
You need to edit your bluedragon.xml file located in:
path/to/openBD/WEB-INF/bluedragon.xml
Locate the cfquery xml tags and add the following:
true
name-of-your-datasource
120
name-of-your-mysql-database
0
120
name-of-your-mysql-user
true
jdbc:mysql://localhost:3306/name-of-your-mysql-database?useOldAliasMetadataBehavior=true
true
true
com.mysql.jdbc.Driver
true
your-mysql-password
true
true
24
Save the file and restart tomcat. And now you should be up and running with a Mysql Datasource in OpenBlueDragon.
*Note: in the hoststring declaration i have added ?useOldAliasMetadataBehavior=true after the database name. This was put in to account for a problem with OpenBlueDragon not respecting Mysql Aliasing. Most notably with Blog.cfc you will notice this right away if you've left it out.
You can read further at new atlanta