Easy way to add a new parameter?

[RTT46410]

I need to add the parameter connectionCollation. I tried by adding this.value.connectionCollation = "utf8mb4";, but no luck.

[cfsimplicity]

I would suggest defining your datasource in your Application.cfc which will allow you to add any additional parameters to the connection string. For example:

this.datasource = {
  class: "org.mariadb.jdbc.Driver",
  connectionString: "jdbc:mariadb://localhost:3306/mydatabase?connectionCollation=utf8mb4",
  username: "myuser",
  password:  "secret"
}

Lucee Docs