This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread 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 Murach's Java Servlets and JSP this week in the Servlets 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: 1646
    
    7

Nope, sorry.


[How To Ask Questions][Read before you PM me]
 
 
subject: Set Catalogue and Schema in Spring JdbcTemplate
 
Similar Threads
Dependency Injection Problem.
Http Status 404 - Servlet DataAccessServlet is currently unavailable
jdbcTemplate, Transaction Rollback issue with "defaultAutoCommit" (Env - Tomcat, Spring, Sybase)
Secure DataSource configuration in Spring
Spring + JDBC + Servlet