How to auto drop or delete tables?

subferno · **Joined:** Mon Jan 09, 2006 8:14 pm **Posts:** 3

I have a properties file that determines which server of two I have to access data. The server will be either in development or production and they all contain different test data.

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.

Is there something I can do in Hibernate that would tell it to either auto drop those tables or delete all records when i switch servers?

Thanks

jt_1000 · **Posted:** Tue Mar 21, 2006 3:28 pm

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.