DataSource Script in Lucee Admin

dev support
1

Using Lucee 6.1.0.243

After configuring a PostgreSQL Datasource - the admin has the following code - that you’re supposed to be able to use in Application.cfc to configure a datasource programatically.

However the text provided is not correct.

this.datasources["myDSN"] = {
	class: "org.postgresql.Driver", 
	bundleName: "org.postgresql.jdbc", 
	bundleVersion: "42.7.3",
	connectionString: "jdbc:postgresql://127.0.0.1:5432/myDSN",
	username: "postgres",
	password: "encrypted:f9b7f69697ad4cf96e40ea8571efa9f32771def52e7c69049fd77b3948f62a38",
	
	// optional settings
	blob:true, // default: false
	clob:true, // default: false
	connectionLimit:-1, // default:-1
	liveTimeout:10, // default: -1; unit: minutes
	timezone:'GMT'
	storage:true, // default: false
	validate:true, // default: false
};
  • The timezone attribute DOES NOT have a comma after it - despite it not being the last atttribute
  • the validate attribute DOES have a comma after it - and it is the last attribute.
2

It works the same, right? :sunglasses: