I’m attempting to test out creating/updating datasources with the cfadmin
tag and the updateDatasource action.
When I attempt to rename a datasource, it updates correctly but then when I
try to run a query right after the datasource is changed any table I try
and call a query against is returned “Invalid Object name”.
After the above script is run and after I get the error, if I try and
validate the connection from Server Admin, it validates successfully. I
can see the table exists in the database.
If I delete the datasource prior to running the updateDatasource script, I
still receive the same error. However, if I delete the datasource and
create the datasource using the Admin interface (using same info from
updateDatasource), then the queries start working correctly.
I’m puzzled why the script doesn’t work, but the interface does.
have a luck a the lucee config file for the datasource created by cfadmin
and web admin
if web admin home page
Configuration File/var/www//WEB-INF/lucee/lucee-web.xml.cfmOn 11 February 2015 at 04:03, Adam De Lay <@Adam_De_Lay> wrote:
I’m attempting to test out creating/updating datasources with the cfadmin
tag and the updateDatasource action.
When I attempt to rename a datasource, it updates correctly but then when
I try to run a query right after the datasource is changed any table I try
and call a query against is returned “Invalid Object name”.
After the above script is run and after I get the error, if I try and
validate the connection from Server Admin, it validates successfully. I
can see the table exists in the database.
If I delete the datasource prior to running the updateDatasource script, I
still receive the same error. However, if I delete the datasource and
create the datasource using the Admin interface (using same info from
updateDatasource), then the queries start working correctly.
I’m puzzled why the script doesn’t work, but the interface does.
I did comparisons in the past and that’s actually why I added the custom
attribute to my code, because I saw it in the config when I added one using
the admin interface. Just for good measure, I did run some tests again and
it looks like the custom attribute is being ignored when using the cfadmin
tag. It looks like anything inside that attribute is being removed/ignored.
AdamOn Thursday, February 12, 2015 at 1:04:12 AM UTC-5, AJ Mercer wrote:
have a luck a the lucee config file for the datasource created by cfadmin
and web admin
if web admin home page
Configuration File/var/www//WEB-INF/lucee/lucee-web.xml.cfm
On 11 February 2015 at 04:03, Adam De Lay <adam.n...@gmail.com <javascript:>> wrote:
I’m attempting to test out creating/updating datasources with the cfadmin
tag and the updateDatasource action.
When I attempt to rename a datasource, it updates correctly but then when
I try to run a query right after the datasource is changed any table I try
and call a query against is returned “Invalid Object name”.
After the above script is run and after I get the error, if I try and
validate the connection from Server Admin, it validates successfully. I
can see the table exists in the database.
If I delete the datasource prior to running the updateDatasource script,
I still receive the same error. However, if I delete the datasource and
create the datasource using the Admin interface (using same info from
updateDatasource), then the queries start working correctly.
I’m puzzled why the script doesn’t work, but the interface does.