I am using spring an hibernate annotations. for
jsp page i am asking the user to enter details and i am trying to save the details in db.
>And i am giving the @generated value for the ContactId
but ia m getting the error saying like this .
/////////////////
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: isAdminRole=null
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate emp id=1
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate emp name=s
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate created by =0
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate created on = 2012-01-31 11:11:15.562
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate modified by = 0
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate modified on = 2012-01-31 11:11:15.562
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associate password = 1
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact contact id=0
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact emp team=s
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact emp tcs mail=s
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact emp created by =0
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: associatecontact emp created on = 2012-01-31 11:11:15.562
5639324 [http-8080-1] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: -1, SQLState: 42X04
5639324 [http-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - Column 'NEXT_HI' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NEXT_HI' is not a column in the target table.
Jan 31, 2012 11:11:15 AM com.tcs.rdt.associate.web.AssociateController associateDoAdd
INFO: org.springframework.dao.InvalidDataAccessResourceUsageException: could not get or update next value; SQL [null]; nested exception is org.hibernate.exception.SQLGrammarException: could not get or update next value