java - Table doesn't exist when deployed in server hibernate -


when deploy web app on test server (it works fine on localhost ), blo_blocked_mobiles table @ given line of code.

query query = this.getsession().createsqlquery(             strquery.append(" insert blo_blocked_mobiles (blo_customer_id_fk,blo_mobile,blo_newmobile,blo_passport,blo_status,blocked_by,blocked_at ) "              +"values( "+customer.getid() +", '"+ oldmobile +"','"+newmobile+"','"+customer.getpassportno()+"','y','user',current_timestamp)" ).tostring());     mtmrslogger.info(query.tostring());     int affectedrows = query.executeupdate();  

the db in mysql , app uses hibernate,struts 1 , spring. created new table , added on hibernate.cfg.xml

 < mapping class="com.mtmrs.model.branch.blockedmobile"/> 

and created model file blockedmobile.java

and when used, below error comes.

warn  org.hibernate.util.jdbcexceptionreporter  - sql error: 1146, sqlstate: 42s02 error org.hibernate.util.jdbcexceptionreporter  - table 'merchantrade.blo_blocked_mobiles' doesn't exist 

please let me know if information insufficient. don't see what's wrong.

peraphs 2 db (on localhost server , on test server) different. test server has not got table.


Comments