creating and droping table using hibernate

I am trying to insert data from XL sheet into the database. i am not creating table driectly into the oracle database. instead i am doing it through java.so that next time when the updated XL sheet comes ,i will drop old table and create new one so that i can insert updated data from XL sheet.

using normal jdbc code it is working fine.

but through hibernate i am facing problem while droping and creating table.

i was using

q= session.createSQLQuery("drop table empmaster);

q = session.createSQLQuery("create table empmaster(PFNO varchar2(8),TOKENNO varchar2(12),NAME varchar2(100),GENDER varchar2(1),DESIGNATION varchar2(3),WEEKLY_OFF varchar2(10))");

hibernate is not throwing any exception but it showing message like "it cannot create table".

correct me if i am wrong.

darshan.karlea at 2007-7-12 19:49:03 >