This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Refresh Materialized View though Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Refresh Materialized View though Java" Watch "Refresh Materialized View though Java" New topic
Author

Refresh Materialized View though Java

sankar
Greenhorn

Joined: Jan 28, 2003
Posts: 4
How to refresh the materialized view from java code?

The following code using the spring jdbc support worked..

String materiallizedViewSQL= "call dbms_snapshot.refresh('"+materiallizedView+"','C')";

getJdbcTemplate().update(materiallizedViewSQL);
[ July 08, 2008: Message edited by: sankar ]
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"sankar",
Welcome to the JavaRanch.

We're a friendly group, but we do require members to have valid display names.

Display names must be two words: your first name, a space, then your last name. Fictitious names are not allowed.

Please edit your profile and correct your display name since accounts with invalid display names get deleted.

Please note this is your third and final warning.

/Dave
 
Have you checked out Aspose?
 
subject: Refresh Materialized View though Java
 
jQuery in Action, 3rd edition