somehow I don't think this will help since I think your quest lies deeper than this... but to directly answer your question -- you can drop tables with:
//if Oracle only! (from the test code).
Code:
if ( !( getDialect() instanceof Oracle9Dialect ) ) return;
Session s = openSession();
Statement st = s.connection().createStatement();
try {
st.execute( "drop table Point");
}
catch( Throwable t ) {
// ignore
}
st.execute("create table Point (\"x\" number(19,2) not null, \"y\"" +
" number(19,2) not null, description varchar2(255) )");
s.close();
the part I am having trouble understanding with your question is:
Quote:
The problem I have is that if I access a dev database and then alter my properties file to point to prod, all of the cached data I am reading from would be invalid.
"access a dev database" via how?
"alter my properties" - hibernate properties?
"all the cached data" - hibernate cached? at server or client
Can you explain your intended config a little more...
thx.