cfconfig datasource

Communities CommandBox CLI
1

Hi Guys, when server start .cfconfig file creates an old Mysql version, please check the bundleVersion

loaded from .cfconfig file

this.datasources[“test”] = {
class: ‘com.mysql.jdbc.Driver’
, bundleName: ‘com.mysql.jdbc’
, bundleVersion: ‘5.1.38’
, connectionString: ‘jdbc:mysql://localhost:3306/TEST?useUnicode=true&characterEncoding=UTF8&serverTimezone=America/Tegucigalpa&useLegacyDatetimeCode=true’
, username: ‘root’
, password: “encrypted:d005fa5f10019ddef7dac15f7e0be61119b8359ddbf8ce45fd5468fcd5589bd1”

// optional settings
, connectionLimit:100 // default:-1
, alwaysSetTimeout:true // default: false
, validate:false // default: false
};

this.datasources[“test”] = {
class: ‘com.mysql.cj.jdbc.Driver’
, bundleName: ‘com.mysql.cj’
, bundleVersion: ‘8.0.15’
, connectionString: ‘jdbc:mysql://localhost:3306/TEST?useUnicode=true&characterEncoding=UTF8&serverTimezone=America/Tegucigalpa&useLegacyDatetimeCode=true’
, username: ‘root’
, password: “encrypted:1f19f93ffed0d1b5e3a567501b120dfe5ffab71123c01f999b58a5514d85376c”

// optional settings
, connectionLimit:100 // default:-1
, alwaysSetTimeout:true // default: false
, validate:false // default: false
};

Thanks for the help.

2

Hi Bayron, is this a question? I’m not sure I follow.

3

Sorry, the issue I have is that when cfconfig creates the datasource im getting an error because the bundle version of Mysql is old.

4

CFConfig actually does set the bundle name or version at all. So whatever is showing in there is what Lucee put in by default. I’m not really sure how Lucee does that.

If you import the settings into your server and then go look at the config XML files in your Lucee home, you’ll see there are no bundle names or versions in the datasource definitions.