Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How Do I use a variable for a datasource

gchammer
Level 2
Level 2

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'.

3 Replies
WASIL
Employee
Employee

Here is how I do this :

jdbcTest.jpg                               dataSRC.jpg

Thanks,

Wasil

gchammer
Level 2
Level 2

I still get:

Exception: Invalid object name 'address'.

Untitled-1.jpg

Untitled-2.jpg

WASIL
Employee
Employee

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.

sqlQuery.jpg

Thanks,

Wasil