搭建好了 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:
看不懂 求高手指教 在线
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:
看不懂 求高手指教 在线
解决方案 »
- struts2中的一个小问题
- 给大家上堂课,一个简单而又让无数想做搜索的程序员心动的课,看完只要不是傻子都能自己开发搜索引擎了
- 使用jsp上传文件时,上传好的文件保存在什么地方??急呀!!!!
- 谁在jsp里面用过序列???急求,那位高手指教???
- s:select选择值后自动给其它文本框赋值
- 用JFreeChart画柱状图的问题
- tomcat的classpath配置问题???
- 很急!JSP中如何通过JavaBeans去访问COM组件?
- 高难度问题:java mysql海量数据复制 一致性问题
- java启动后错误
- java如何与flex 保持持久的socket连接
- Hibernate Spring的整合求高手指导快要崩溃了
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赋值了没有。