Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Refresh Materialized View though Java

 
sankar
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic