hsql错误: user lacks privilege or object not found: LAST_INSERT_ID

1.1.1、问题现象
环境：windows vista+JDK1.6+Apusic7.0+cfconsole+hsqldb2.2.6



从hsqldb中查询数据时报错，提示用户权限缺失或者对象不存在。

1.1.2、日志情况
错误日志如下：

org.springframework.dao.InvalidDataAccessResourceUsageException: could not retrieve generated id after insert: [com.wondersgroup.framework.security.bo.UserLoginHistory]; nested exception is org.hibernate.exception.SQLGrammarException: could not retrieve generated id after insert: [com.wondersgroup.framework.security.bo.UserLoginHistory]

at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)

at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)

at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)

at org.springframework.orm.hibernate3.HibernateTemplate.saveOrUpdate(HibernateTemplate.java:748)

at com.wondersgroup.framework.core.dao.impl.AbstractHibernateDAOImpl.save(AbstractHibernateDAOImpl.java:131)

at com.wondersgroup.framework.security.service.impl.UserServiceImpl.addUserLoginHistory(UserServiceImpl.java:922)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)

at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)

at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at $Proxy24.addUserLoginHistory(Unknown Source)

at com.wondersgroup.framework.common.web.login.action.LoginAction.recordUserLogin(LoginAction.java:127)

at com.wondersgroup.framework.common.web.login.action.LoginAction.operate(LoginAction.java:297)

at com.wondersgroup.framework.core.web.struts2.action.BaseAction.execute(BaseAction.java:42)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:404)

at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:267)

at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:229)

at com.wondersgroup.framework.core.web.struts2.interceptor.AjaxExceptionMappingInterceptor.intercept(AjaxExceptionMappingInterceptor.java:44)

at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)

at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(Default