I'm trying to use a variable as a datasource so changes are easy to make with out having to look through the entire process.
If I use SLC_ENGFC_DEV_DS as the literal value the select statement it works. If I create a string variable and set the default value to the same thing I get the error
Exception: Invalid object name 'FLUDDEPT'.
I assume you are using sql server, use the query like this :
select * from [database].[schema].[tablename];
Make sure the user (mentioned in Jboss datasource has access(to the database) as well as the required permissions (select, delete etc) for the table object.