Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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
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: 1682
    
    7

Nope, sorry.


[How To Ask Questions][Read before you PM me]
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Set Catalogue and Schema in Spring JdbcTemplate
 
It's not a secret anymore!