Hi i am calling a doa from a SF bean, i am managing transaction in SF usiong JTA, but it htrows following exception, what could be the reason
14:37:47,796 INFO [STDOUT] GOT INITIALCONTEXT......................... 14:37:47,796 INFO [STDOUT] GOT USER TRANSACTION......................... 14:37:47,796 INFO [STDOUT] BEFGIN TRANSACTION......................... 14:37:47,828 FATAL [OraContributionDetailsDAO] Fatal error occured in class OraContributionDetailsDAO - maintainContributionDetailsVO java.sql.SQLException: ORA-01722: invalid number ORA-06512: at "SIYAYAUSER.PROC_INSERTCONTRIBUTIONDETAILS", line 33 ORA-06512: at line 1 14:37:47,828 INFO [STDOUT] BEFORE ROLLBACK......................... 14:37:47,843 ERROR [STDERR] com.dol.common.exception.DAOException: 14:37:47,843 ERROR [STDERR] at com.dol.siyaya.dao.contribution.OraContributionDetailsDAO.maintainContributionDetailsVO(OraContributionDetailsDAO.java:162) 14:37:47,843 ERROR [STDERR] at com.dol.siyaya.ejb.facade.ContributionSFBean.maintainContributionDetails(ContributionSFBean.java:214) 14:37:47,843 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 14:37:47,843 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 14:37:47,843 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 14:37:47,843 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683) 14:37:47,843 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:185) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptorBMT.invokeNext(AbstractTxInterceptorBMT.java:144) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorBMT.invoke(TxInterceptorBMT.java:62) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331) 14:37:47,843 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:700) 14:37:47,843 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 14:37:47,843 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 14:37:47,843 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 14:37:47,843 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324) 14:37:47,843 ERROR [STDERR] at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) 14:37:47,843 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) 14:37:47,843 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101) 14:37:47,843 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90) 14:37:47,843 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) 14:37:47,843 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45) 14:37:47,843 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100) 14:37:47,843 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85) 14:37:47,843 ERROR [STDERR] at $Proxy45.maintainContributionDetails(Unknown Source) 14:37:47,843 ERROR [STDERR] at com.dol.siyaya.web.bd.ContributionBD.maintainContributionDetails(ContributionBD.java:168) 14:37:47,843 ERROR [STDERR] at com.dol.siyaya.web.controller.ContributionController.doBackEndProcessing(ContributionController.java:2027) 14:37:47,843 ERROR [STDERR] at com.dol.siyaya.web.controller.ContributionController.doPost(ContributionController.java:1115) 14:37:47,843 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) 14:37:47,843 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 14:37:47,843 ERROR [STDERR] at org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 14:37:47,843 ERROR [STDERR] at org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsValve.java:76) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 14:37:47,843 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:65) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) 14:37:47,843 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) 14:37:47,843 ERROR [STDERR] at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197) 14:37:47,843 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) 14:37:47,843 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) 14:37:47,843 ERROR [STDERR] at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605) 14:37:47,843 ERROR [STDERR] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:677) 14:37:47,843 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534) 14:39:23,578 WARN [TransactionImpl] Transaction TransactionImpl:XidImpl [FormatId=257, GlobalId=ggnhmp03//23, BranchQual=] timed out. status=STATUS_ACTIVE View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3840117#3840117 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3840117 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user