This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes Spring and the fly likes Set Catalogue and Schema in Spring JdbcTemplate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "Set Catalogue and Schema in Spring JdbcTemplate" Watch "Set Catalogue and Schema in Spring JdbcTemplate" New topic
Author

Set Catalogue and Schema in Spring JdbcTemplate

Sid Moitra
Greenhorn

Joined: Aug 15, 2012
Posts: 6
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. . But this sounds creepy.

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

Joined: Mar 07, 2010
Posts: 1648
    
    7

Nope, sorry.


[How To Ask Questions][Read before you PM me]
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Set Catalogue and Schema in Spring JdbcTemplate