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
Post a Comment