搭建好了 JBOSS和JDR
ds也配置好连上了
但是打开登陆界面的时候报以下错误信息。
15:39:15,546 INFO [STDOUT] Hibernate: select * from ( select coresyserr0_.ID as
ID29_, coresyserr0_.ERROR_COUNT as ERROR2_29_, coresyserr0_.ERROR_LOGIN_DATE as
ERROR3_29_, coresyserr0_.ERROR_LOGIN_IP as ERROR4_29_, coresyserr0_.STATE as ST
ATE29_ from SYS_ERROR_LOGIN_COUNT coresyserr0_ where 1=1 and coresyserr0_.ERROR_
COUNT>=3 and coresyserr0_.ERROR_LOGIN_IP=? ) where rownum <= ?
15:39:15,562 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 942, SQ
LState: 42000
15:39:15,562 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-00942: 表或视
图不存在
15:39:15,562 ERROR [org.jboss.ejb3.tx2.impl.CMTTxInterceptor] javax.ejb.EJBTrans
actionRolledbackException: org.hibernate.exception.SQLGrammarException: could no
t execute query
15:39:15,562 ERROR [com.cloudlib.core.service.sys.bean.SysErrorLoginCountService
Bean] javax.ejb.EJBTransactionRolledbackException: org.hibernate.exception.SQLGr
ammarException: could not execute query
15:39:15,593 INFO [STDOUT] 2012-06-29 15:39:15 LoginController [ERROR] com.clou
dlib.core.exception.ServiceException:
看不懂 求高手指教 在线
------解决方案--------------------------------------------------------
这个是你的SQL语句问题，上面已经写得很清楚了。
select * from ( select coresyserr0_.ID as
ID29_, coresyserr0_.ERROR_COUNT as ERROR2_29_, coresyserr0_.ERROR_LOGIN_DATE as
ERROR3_29_, coresyserr0_.ERROR_LOGIN_IP as ERROR4_29_, coresyserr0_.STATE as ST
ATE29_ from SYS_ERROR_LOGIN_COUNT coresyserr0_ where 1=1 and coresyserr0_.ERROR_
COUNT>=3 and coresyserr0_.ERROR_LOGIN_IP=? ) where rownum <= ?
把这条SQL去执行一下看看。
还有你的rownum赋值了没有。