HI..

Presently am using

APP SERVER : WSAD 5.0(WEBSPHERE 5.0)
DATABASE : ORACLE 9I
PLATFORM : WINDOWS XP
presently am trying to develop one ejb application (J2EE 1.3 LEVEL EJB2.0(CMP1.1))....

at the time of execution i get the below error....

[12/15/04 17:25:57:019 GMT+05:30] 1b2cba1c SystemOut O SQL for unique code :select SCHL_SATACT_ID from T_SCHL WHERE UPPER(TRIM(SCHL_SATACT_ID)) = '1926'
[12/15/04 17:26:10:191 GMT+05:30] 1b2cba1c TraceNLS u No message text associated with key MAP_SQL_EXCEPTION in bundle IBMDataStoreAdapterNLS
[12/15/04 17:26:10:363 GMT+05:30] 1b2cba1c ExceptionUtil E CNTR0019E: Non-application exception occurred while processing method "create". Exception data: com.ibm.websphere.cpi.CPIException: java.sql.SQLException: ORA-01400: cannot insert NULL into ("KSOWN"."T_SCHL"."BTLR_CD")
; nested exception is:
    java.sql.SQLException: ORA-01400: cannot insert NULL into ("KSOWN"."T_SCHL"."BTLR_CD")

java.sql.SQLException: ORA-01400: cannot insert NULL into ("KSOWN"."T_SCHL"."BTLR_CD")

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:168)
    at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 08)
    at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1405)
    at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TT C7Protocol.java:822)
    at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:1446)
    at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.java:1371)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:1900)
    at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:363)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. executeUpdate(WSJdbcPreparedStatement.java:565)
    at com.coke.systemdata.ebeans.EJSJDBCPersisterCMPScho olsBean_10744676._create(EJSJDBCPersisterCMPSchool sBean_10744676.java:71)
    at com.ibm.ejs.persistence.EJSJDBCPersister.create(EJ SJDBCPersister.java:504)
    at com.ibm.ejs.container.ContainerManagedBeanO.postCr eate(ContainerManagedBeanO.java:280)
    at com.ibm.ejs.container.EJSHome.postCreateCommon(EJS Home.java:1916)
    at com.ibm.ejs.container.EJSHome.postCreate(EJSHome.j ava:1808)
    at com.ibm.ejs.container.EJSHome.postCreate(EJSHome.j ava:1871)
    at com.coke.systemdata.ebeans.EJSCMPSchoolsHomeBean_1 0744676.create(EJSCMPSchoolsHomeBean_10744676.java :90)
    at com.coke.systemdata.ebeans.EJSRemoteCMPSchoolsHome _10744676.create(EJSRemoteCMPSchoolsHome_10744676. java:44)
    at com.coke.systemdata.ebeans._SchoolsHome_Stub.creat e(_SchoolsHome_Stub.java:381)
    at com.coke.systemdata.sbeans.SystemDataSessionBean.a ddSchoolInfo(SystemDataSessionBean.java:201)
    at com.coke.systemdata.sbeans.EJSRemoteStatelessSyste mDataSession_9810748f.addSchoolInfo(EJSRemoteState lessSystemDataSession_9810748f.java:988)
    at com.coke.systemdata.sbeans._SystemDataSession_Stub .addSchoolInfo(_SystemDataSession_Stub.java:273)
    at com.coke.servlet.SystemDataActionServlet.addSchool Info(SystemDataActionServlet.java:893)
    at com.coke.servlet.SystemDataActionServlet.performTa sk(SystemDataActionServlet.java:428)
    at com.coke.servlet.SystemDataActionServlet.doPost(Sy stemDataActionServlet.java:147)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
    at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
    at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
    at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:258)
    at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
    at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:872)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:491)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:173)
    at com.ibm.ws.webcontainer.servlet.InvokerServlet.ser vice(InvokerServlet.java:255)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
    at com.ibm.ws.webcontainer.servlet.StrictServletInsta nce.doService(StrictServletInstance.java:110)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet._service(StrictLifecycleServlet.java:174)
    at com.ibm.ws.webcontainer.servlet.IdleServletState.s ervice(StrictLifecycleServlet.java:313)
    at com.ibm.ws.webcontainer.servlet.StrictLifecycleSer vlet.service(StrictLifecycleServlet.java:116)
    at com.ibm.ws.webcontainer.servlet.ServletInstance.se rvice(ServletInstance.java:258)
    at com.ibm.ws.webcontainer.servlet.ValidServletRefere nceState.dispatch(ValidServletReferenceState.java: 42)
    at com.ibm.ws.webcontainer.servlet.ServletInstanceRef erence.dispatch(ServletInstanceReference.java:40)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.handleWebAppDispatch(WebAppRequestDispatcher. java:872)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.dispatch(WebAppRequestDispatcher.java:491)
    at com.ibm.ws.webcontainer.webapp.WebAppRequestDispat cher.forward(WebAppRequestDispatcher.java:173)
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForwar d(WebAppInvoker.java:79)
    at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleIn vocationHook(WebAppInvoker.java:199)
    at com.ibm.ws.webcontainer.cache.invocation.CachedInv ocation.handleInvocation(CachedInvocation.java:71)
    at com.ibm.ws.webcontainer.cache.invocation.Cacheable InvocationContext.invoke(CacheableInvocationContex t.java:114)
    at com.ibm.ws.webcontainer.srp.ServletRequestProcesso r.dispatchByURI(ServletRequestProcessor.java:187)
    at com.ibm.ws.webcontainer.oselistener.OSEListenerDis patcher.service(OSEListener.java:331)
    at com.ibm.ws.webcontainer.http.HttpConnection.handle Request(HttpConnection.java:56)
    at com.ibm.ws.http.HttpConnection.readAndHandleReques t(HttpConnection.java:432)
    at com.ibm.ws.http.HttpConnection.run(HttpConnection. java:343)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.j ava:592)
----- Begin backtrace for detail
java.sql.SQLException: ORA-01400: cannot insert NULL into ("KSOWN"."T_SCHL"."BTLR_CD")

Please any one know above the problem help me....

by
antham



antham