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'.
Views
Replies
Total Likes
Here is how I do this :
Thanks,
Wasil
Views
Replies
Total Likes
I still get:
Exception: Invalid object name 'address'.
Views
Replies
Total Likes
OK !
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.
e.g.
Thanks,
Wasil
Views
Replies
Total Likes