起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

12
返回列表 发新帖
楼主: xiaowu8342

[结贴] AIX集群注册服务启动问题,不能分享使用

[复制链接]

12

主题

109

帖子

139

积分

初级会员

Rank: 2

积分
139
 楼主| 发表于 2014-9-18 10:19:23 | 显示全部楼层
jishuang 发表于 2014-9-18 10:03
FAILED :9090: java.net.BindException: Address already in use

应该是9090端口被占用了

2014-09-18 09:03:56 Connection refused
java.net.ConnectException: Connection refused

2014-09-18 09:03:56 ??: JUSTEP150009; ??: ??????????
com.justep.exception.BusinessException: ??: JUSTEP150009; ??: ??????????
这些代表什么意思?

回复 支持 反对

使用道具 举报

12

主题

109

帖子

139

积分

初级会员

Rank: 2

积分
139
 楼主| 发表于 2014-9-18 10:49:23 | 显示全部楼层

启动正常啦,有个配置iP写错了,但后台报错“java.sql.SQLSyntaxErrorException: ORA-00904: "ANNUAL": invalid identifier”
请问该报错使用使用吗,是找不到对应的年度吗?
Sep 18, 2014 9:36:36 AM GMT+08:00> <Warning> <netuix> <BEA-423420> <Redirect is executed in begin or refresh action. Redirect url is /console/console.portal?_nfpb=true&_pageLabel=WebAppApplicationOverviewPage&WebAppApplicationOverviewPortlethandle=com.bea.console.handles.AppDeploymentHandle%28%22com.bea%3AName%3DUIServer%2CType%3DAppDeployment%22%29.>
2014-09-18 09:36:40 Execute prepared sql[select a,a1,b,b1,c,c1,d,d1,e,e1,f,f1,g,g1,h,h1,i,i1,j,j1,k,k1,l,l1,m,m1,n,n1,o,o1,p,p1,q,q1,r,r1,s,s1,t,t1,u,u1,v,v1,w,w1,x,x1,y,y1   from (select * from B_SZYSFUNC)  where 1=1  and AGENCY_ITEM_ID=? and ANNUAL=?    ] failed:
java.sql.SQLSyntaxErrorException: ORA-00904: "ANNUAL": invalid identifier
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:300)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3637)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
        at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
        at com.frameworkset.common.poolman.PreparedDBUtil.doPrepareSelectCommon(PreparedDBUtil.java:1855)
        at com.frameworkset.common.poolman.PreparedDBUtil.innerExecute(PreparedDBUtil.java:1442)
        at com.frameworkset.common.poolman.PreparedDBUtil.executePrepared(PreparedDBUtil.java:1760)
        at com.frameworkset.common.poolman.PreparedDBUtil.executePrepared(PreparedDBUtil.java:1080)
        at com.mofit.common.util.DBHelper.query(DBHelper.java:143)
        at com.mofit.common.util.DBHelper.query(DBHelper.java:261)
        at com.mofit.bgtMgr.reportTempDefine.dao.RptTempDefineDao.DataSourceXml(RptTempDefineDao.java:374)
        at com.mofit.bgtMgr.reportTempDefine.service.RptTempDefineService.DataSourceXml(RptTempDefineService.java:114)
.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                 at com.mofit.bgtMgr.reportTempDefine.dao.RptTempDefineDao.DataSourceXml(RptTempDefineDao.java:374)
        at com.mofit.bgtMgr.reportTempDefine.service.RptTempDefineService.DataSourceXml(RptTempDefineService.java:114)
        ... 36 more
java.lang.Exception: ??103?????bgt_dsxml??????????ORA-00904: "ANNUAL": invalid identifier
        at com.mofit.common.service.BusDispatch.serivceDispatch(BusDispatch.java:98)
        at com.mofit.common.web.BusAction.execute(BusAction.java:116)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
        at java.lang.reflect.Method.invoke(Method.java:611)
        at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
                at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
        at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
        at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
        at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
        at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
        at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
        at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
        at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
2014-09-18 09:36:40 com.mofit.common.web.BusAction:??103?????bgt_dsxml??????????ORA-00904: "ANNUAL": invalid identifier
2014-09-18 09:36:40 Execute prepared sql[select ysamount,czbk,sjbzsr,xj,czzhglzj,jysr,fsdwjk,qtsr,mbszce,snjzhjy   from (select * from B_XMJF)  where 1=1  and AGENCY_ITEM_ID=? and ANNUAL=?    ] failed:
java.sql.SQLSyntaxErrorException: ORA-00904: "ANNUAL": invalid identifier
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:300)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
             at java.lang.reflect.Method.invoke(Method.java:611)
        at com.mofit.common.service.BusDispatch.serivceDispatch(BusDispatch.java:92)
        at com.mofit.common.web.BusAction.execute(BusAction.java:116)
2014-09-18 09:36:40 com.mofit.common.web.BusAction:??103?????bgt_dsxml??????????ORA-00904: "ANNUAL": invalid identifier
2014-09-18 09:36:40 Execute prepared sql[select ysamount,czbk,sjbzsr,xj,czzhglzj,jysr,fsdwjk,qtsr,mbszce,snjzhjy   from (select * from B_GYJF)  where 1=1  and AGENCY_ITEM_ID=? and ANNUAL=?    ] failed:
java.sql.SQLSyntaxErrorException: ORA-00904: "ANNUAL": invalid identifier
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:300)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3593)
        2014-09-18 09:36:40 com.mofit.common.web.BusAction:??103?????bgt_dsxml??????????ORA-00904: "ANNUAL": invalid identifier
2014-09-18 09:36:40 Execute prepared sql[select ysamount,czbk,sjbzsr,xj,czzhglzj,jysr,fsdwjk,qtsr,mbszce,snjzhjy   from (select * from B_RYJF)  where 1=1  and AGENCY_ITEM_ID=? and ANNUAL=?    ] failed:
java.sql.SQLSyntaxErrorException: ORA-00904: "ANNUAL": invalid identifier
                   at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:838)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
             at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "ANNUAL": invalid identifier
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:300)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
      

问题.rar

2.22 KB, 下载次数: 223

回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
35962
发表于 2014-9-18 10:58:31 | 显示全部楼层
ORA-00904:这个错误是oracle数据报的错误,可以到网上查找相关的资料http://heisetoufa.iteye.com/blog/344306
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-6-14 16:39 , Processed in 0.113180 second(s), 24 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表