SQL 에러=================================================
java.sql.SQLException:
ORA-00900: invalid SQL statement
==>프로퍼티 에러
[java.sql.SQLException: ORA-01006: bind variable does not exist
==> 넘겨준값하고 받은값하고 다를때
[java.sql.SQLException: ORA-00936: missing expression
==> 문자열이 하나더 추가됐을시..(쉼표나)
java.sql.SQLException: ORA-00933: SQL command not properly ended
==> sql조건문에 문자가 잘못됐을시 (and 가 aand 로 되어있음 , 쿼리문을 "where 이런식으루 붙여썼을때)
java.sql.SQLException: 부적합한 열 이름
==> 쿼리결과에 받는값이 잘못됐을시..(DAO 확인)
받는값이 2개인데..쿼리문에서 1개만 넘겨줄때
[java.sql.SQLException: ORA-01722: Invalid number
==> 1.dao 에서 setInt 를 setString으루 변환해보기
2.데이터가 잘못 조회(이유모름) ...
System.out.println("1111");
rs = pstmt.executQuery 확인해볼거
System.out.println("2222"); 이런식으루 해볼거...
java.sql.SQLException: ORA-00911: invalid character
==>
[java.sql.SQLException: ORA-00907: missing right parenthesis
==>
table미생성이 됐을시.. where 문이나 and 문 확인해볼것
[java.sql.SQLException: ORA-01427: single-row subquery returns more than one row
==> 서브쿼리에 리턴값이..1가 아니고..여러개 나올때..
[java.sql.SQLException: ORA-01476: divisor is equal to zero
==> 분모가 0 일경우 나눴을때 나는 에러..
[java.sql.SQLException: 부적합한 열 이름]
==> 쿼리문에서 데이터값을 못넘겨줄때...
weblogic.common.ResourceException:
Could not create pool connection. The DBMS driver exception was:
java.sql.SQLException: ORA-00020: maximum number of processes (450) exceeded
==>
java.sql.SQLException: ORA-00923: FROM keyword not found where expected
==> from 앞에 필드사이에 , 빠졌나 확인
java.sql.SQLException: ORA-00907: missing right parenthesis
==> 1.테이블 미생성 2.프로퍼티에 공백 들어갔나 확인
java.sql.SQLException:ORA-01861: literal does not match format string
==> 날짜 포멧이 안맞을때..에러
java.sql.SQLException: ORA-01009: missing mandatory parameter
==> sql.append 썻을시 확인해볼거... (/**/) 주석문 확인
java.sql.SQLException: 교집합, 합집합 에러
==> 단일건에 대해서 .. 1.while(rs.next()) 확인여부
2.화면단에서 size()가 0 이면 값을 셋팅안하게 하고
size()가 0 이 아니면 값을 셋팅하게 하고
================================1015=================================================
FATAL: javax.naming.NameNotFoundException: Unable to resolve 'com.dbcon.es.syste
m.ejb.APEsListMgrSRemoteHome' Resolved: 'com.dbcon.es.system.ejb' Unresolved:'AP
EsListMgrSRemoteHome' ; remaining name 'APEsListMgrSRemoteHome'
===>
1.다시 디플로이 시킴
2. 관련된 jndiName 맞나 확인
============================1016====================================================
==>jsp 파일이 적용이 안될때..
1.이클립스 에 있는 j2src 를 지운다
2.웹로직에 jsp 파일이 반영되어 있나 확인
3.콘솔에서 확인..
============================1017=================================================
java.lang.NullPointerException
Unable to deploy EJB: APEsListMgrSBean from ApEsListMgrSBean.jar:
There is a mismatch between the bean code and generated code.com.dbcon.es.system
.ejb.APEsListMgrSRemoteHome . Please rerun ejbc on the bean code.The error wa
s java.lang.NoSuchFieldException
==> jar 파일 지우고 다시 deploy 함
===========================1115=====================================================
log4j:WARN No appenders could be found for logger (org.apache.struts.util.PropertyMessageResources).
log4j:WARN Please initialize the log4j system properly.
Struts.xml 에 주석에 한글을 나타낼시
===============================1119====================================================
디플로이 시킬때..빨간색으로 에러 마니 났을시
build.xml 파일에...classpath 안에
==>이런식으루
C:eclipseworkspaceFrameworklibjdom.jar
===========================1120============================================================
[javac] Modern compiler not found - looking for classic compiler
[javac] BUILD FAILED: file:C:/eclipse/workspace/ESProject/xml/com/dbcon/sc/system/ejb/SCCommon/SCCommonBuild.xml:54: Cannot use classic compiler, as it is not available. A common solution is to set the environment variable JAVA_HOME to your jdk directory.
bulid.xml 수정...잘된걸 copy해서 해봄
=============================1124===========================================================
ejbc:
[java] <2003-09-24 오후 09시00분04초>
[java]
[java] <2003-09-24 오후 09시00분04초>
[java] ERROR: Error from ejbc:
[java] <2003-09-24 오후 09시00분04초>
[java] In EJB RequestOfAddBidSBean, method deleteAddBidOfJobType defined in the remote interface either does not exist in the bean class, or it is not a public method. Each method in the remote interface must have a corresponding public method in the bean class.
[java] In EJB RequestOfAddBidSBean, method deleteDetailData defined in the remote interface either does not exist in the bean class, or it is not a public method. Each method in the remote interface must have a corresponding public method in the bean class.
[java] In EJB RequestOfAddBidSBean, method deleteTradeData defined in the remote interface either does not exist in the bean class, or it is not a public method. Each method in the remote interface must have a corresponding public method in the bean class.
[java] ERROR: ejbc found errors
[java] Java Result: 1
====> 관련된 메소드 있나 소스 확인.
===============================1128==================================================
****************
Another exception has been detected while we were handling last error.
Dumping information about last error:
ERROR REPORT FILE = (N/A)
PC = 0x3924B38A
SIGNAL = -1073741819
FUNCTION NAME = (N/A)
LIBRARY NAME = (N/A)
Please check ERROR REPORT FILE for further information, if there is any.
===========================================1201================================================
<2003-10-01 오후 04시30분55초> erException
java.lang.NullPointerException
at java.lang.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:981)
at java.lang.Double.parseDouble(Double.java:179)
at com.dbcon.es.domain.ejb.ActtenderEBean.ejbCreate(Unknown Source)
at com.dbcon.es.domain.ejb.ActtenderEBean_am7sz5__WebLogic_CMP_RDBMS.ejbCreate(ActtenderEBea
n_am7sz5__WebLogic_CMP_RDBMS.java:1758)
at java.lang.reflect.Method.invoke(Native Method)
at weblogic.ejb20.manager.DBManager.create(DBManager.java:524)
at weblogic.ejb20.manager.DBManager.localCreate(DBManager.java:503)
at weblogic.ejb20.internal.EntityEJBLocalHome.create(EntityEJBLocalHome.java:167)
at com.dbcon.es.domain.ejb.ActtenderEBean_am7sz5_LocalHomeImpl.create(ActtenderEBean_am7sz5_
LocalHomeImpl.java:101)
================================1201============================================================
<2003-10-01 오후 05시15분06초> matException: empty String
java.lang.NumberFormatException: empty String
=====>
==================================0107==============================================================
[java] ERROR: Error from ejbc:
[java] In EJB EstEBean, the ejbCreate method: ejbCreate(com.dbcon.es.business.model.ApestcostDTO) must return the primary key type.
[java] ERROR: ejbc found errors
[java] Java Result: 1
===> Bean.java 에서 메소드 확인해볼꺼(이름)
==================================0216===============================================================
Unable to deploy EJB: C:eaprojectsesdomainapplicationsesearCOEJB.jar from COEJB.jar:
weblogic.ejb20.deployer.DeploymentDescriptorException: For cmp-field 'strVal1' of bean 'ClosingInfoEBean', we expected to find a c
orresponding 'getStrVal1' method in the abstract bean class. Compilation cannot continue without this 'get' method
디플로이 에러시 ===> C:eaprojectsesdomainapplicationsesearAPP-INFlib 에 있는 SAEJB.JAR 안쓰면 지워버리고
C:eaprojectsesdomainesserver.wlnotdelete 에 있는 extract 파일 지워버릴것
=====================================0219==================================================================
Unable to deploy EJB: TcoCodeEBean from COEJB.jar:
[EJB:010101]A mismatch exists between the bean code and generated code.TcoCodeEBean(Application: esear, EJBComponent: COEJB.jar) .
Please rerun ejbc on the bean code. The error was java.lang.NoSuchFieldException: md_eo_setRegdate_java_sql_Date