• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Tim Holloway
  • Carey Brown
  • salvin francis

migration problem j2ee1.2 -j2ee1.3 in WSAD 5.0

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi


previously my application level

VERSION :J2EE 1.2(EJB1.1(CMP1.1,SESSION BEANS 1.1,servlet 2.2)
appserver :webspher 4.0
OS :windows XP

After the migration application level

VERSION :J2EE1.3(EJB 2.0(CMP1.1,SESSION BEANS 2.0),SERVLETS 2.3)
APPSERVER : WEBSPHERE 5.0
OS :WINDOWS XP

my application is in webspher4.0 working perfectly....
before the migration....

but after the migration to websphere 5.0 and j2ee1.3 level all the session beans and normal beans working perfectly but all entity beans (cmp1.1) not working properly...
At the time of insert a record i get the following error...

[12/17/04 13:00:52:581 GMT+05:30] 41026be7 TraceNLS u No message text associated with key MAP_SQL_EXCEPTION in bundle IBMDataStoreAdapterNLS
[12/17/04 13:00:52:721 GMT+05:30] 41026be7 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_MAJ"."REC_UPDT_DT")
; nested exception is:
java.sql.SQLException: ORA-01400: cannot insert NULL into ("KSOWN"."T_MAJ"."REC_UPDT_DT")

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

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.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.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:565)
at com.coke.systemdata.ebeans.EJSJDBCPersisterCMPMajorBean_7ebfa47f._create(EJSJDBCPersisterCMPMajorBean_7ebfa47f.java:71)
at com.ibm.ejs.persistence.EJSJDBCPersister.create(EJSJDBCPersister.java:504)
at com.ibm.ejs.container.ContainerManagedBeanO.postCreate(ContainerManagedBeanO.java:280)
at com.ibm.ejs.container.EJSHome.postCreateCommon(EJSHome.java:1916)
at com.ibm.ejs.container.EJSHome.postCreate(EJSHome.java:1808)
at com.ibm.ejs.container.EJSHome.postCreate(EJSHome.java:1871)
at com.coke.systemdata.ebeans.EJSCMPMajorHomeBean_7ebfa47f.create(EJSCMPMajorHomeBean_7ebfa47f.java:36)
at com.coke.systemdata.ebeans.EJSRemoteCMPMajorHome_7ebfa47f.create(EJSRemoteCMPMajorHome_7ebfa47f.java:44)
at com.coke.systemdata.ebeans._MajorHome_Stub.create(_MajorHome_Stub.java:284)
at com.coke.systemdata.sbeans.SystemDataSessionBean.addMajorInfo(SystemDataSessionBean.java:500)
at com.coke.systemdata.sbeans.EJSRemoteStatelessSystemDataSession_9810748f.addMajorInfo(EJSRemoteStatelessSystemDataSession_9810748f.java:953)
at com.coke.systemdata.sbeans._SystemDataSession_Stub.addMajorInfo(_SystemDataSession_Stub.java:433)
at com.coke.servlet.SystemDataActionServlet.addMajorInfo(SystemDataActionServlet.java:2151)
at com.coke.servlet.SystemDataActionServlet.performTask(SystemDataActionServlet.java:512)
at com.coke.servlet.SystemDataActionServlet.doPost(SystemDataActionServlet.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.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.servlet.InvokerServlet.service(InvokerServlet.java:255)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:187)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)
----- Begin backtrace for detail
java.sql.SQLException: ORA-01400: cannot insert NULL into ("KSOWN"."T_MAJ"."REC_UPDT_DT")

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.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.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:565)
at com.coke.systemdata.ebeans.EJSJDBCPersisterCMPMajorBean_7ebfa47f._create(EJSJDBCPersisterCMPMajorBean_7ebfa47f.java:71)
at com.ibm.ejs.persistence.EJSJDBCPersister.create(EJSJDBCPersister.java:504)
at com.ibm.ejs.container.ContainerManagedBeanO.postCreate(ContainerManagedBeanO.java:280)
at com.ibm.ejs.container.EJSHome.postCreateCommon(EJSHome.java:1916)
at com.ibm.ejs.container.EJSHome.postCreate(EJSHome.java:1808)
at com.ibm.ejs.container.EJSHome.postCreate(EJSHome.java:1871)
at com.coke.systemdata.ebeans.EJSCMPMajorHomeBean_7ebfa47f.create(EJSCMPMajorHomeBean_7ebfa47f.java:36)
at com.coke.systemdata.ebeans.EJSRemoteCMPMajorHome_7ebfa47f.create(EJSRemoteCMPMajorHome_7ebfa47f.java:44)
at com.coke.systemdata.ebeans._MajorHome_Stub.create(_MajorHome_Stub.java:284)
at com.coke.systemdata.sbeans.SystemDataSessionBean.addMajorInfo(SystemDataSessionBean.java:500)
at com.coke.systemdata.sbeans.EJSRemoteStatelessSystemDataSession_9810748f.addMajorInfo(EJSRemoteStatelessSystemDataSession_9810748f.java:953)
at com.coke.systemdata.sbeans._SystemDataSession_Stub.addMajorInfo(_SystemDataSession_Stub.java:433)
at com.coke.servlet.SystemDataActionServlet.addMajorInfo(SystemDataActionServlet.java:2151)
at com.coke.servlet.SystemDataActionServlet.performTask(SystemDataActionServlet.java:512)
at com.coke.servlet.SystemDataActionServlet.doPost(SystemDataActionServlet.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.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.servlet.InvokerServlet.service(InvokerServlet.java:255)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:258)
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:872)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:491)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:173)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:199)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:187)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:331)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:432)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:343)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:592)

[12/17/04 13:00:54:299 GMT+05:30] 41026be7 SystemOut O RemoteException--->java.rmi.ServerException: RemoteException occurred in server thread; nested exception is:
com.ibm.websphere.cpi.CPIException: java.sql.SQLException: ORA-01400: cannot insert NULL into ("KSOWN"."T_MAJ"."REC_UPDT_DT")
; nested exception is:
java.sql.SQLException: ORA-01400: cannot insert NULL into ("KSOWN"."T_MAJ"."REC_UPDT_DT")

[12/17/04 13:00:54:299 GMT+05:30] 41026be7 SystemOut O final key word--->Error
[12/17/04 13:00:54:346 GMT+05:30] 41026be7 WebGroup I SRVE0180I: [cokeWeb] [/cokeWeb] [Servlet.LOG]: /jsp/systemdata/SystemDataMessages.jsp: init
[12/17/04 13:00:54:346 GMT+05:30] 41026be7 SystemOut O actionFlag = back
[12/17/04 13:00:54:346 GMT+05:30] 41026be7 SystemOut O actionPage = AddMajorInfo

if any one know the details about the problem please help me

by
antham
 
Evacuate the building! Here, take this tiny ad with you:
create, convert, edit or print DOC and DOCX in Java
https://products.aspose.com/words/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!