Set Catalogue and Schema in Spring JdbcTemplate

[Sid Moitra]

Hi,
I am using a simple Select statement using JdbcTemplate in Spring. But I don't find any setter methods so as to set the DB Name and Schema as the server contains multiple Databases and Schemas.
I found a workaround by using the full name e.g. select * from DB_NAME.SCHEMA_NAME.TABLE_NAME where intUserID = ? . But this sounds creepy.

Don't we have something like SimpleJdbcCall where we can set the catalogName and Schema.??

[Bill Gorder]

Nope, sorry.