[TxConnectionManager] Connection error occured

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cwinay
    New Member
    • Jan 2010
    • 8

    [TxConnectionManager] Connection error occured

    Hi,
    I'm using hibernate, mysql 5.0.22 and struts 2 in my application.
    In struts2, I'm using REST plugin and classes that extends ActionSupport and implements ModelDriven interface (webservice classes). These classes interact with the database.

    I'm using external datasource configuration xml which looks like:

    <xa-datasource>
    <jndi-name>jdbc/MyDS</jndi-name>
    <track-connection-by-tx>true</track-connection-by-tx>
    <isSameRM-override-value>false</isSameRM-override-value>
    <xa-datasource-class>com.mysql .jdbc.jdbc2.opt ional.MysqlXADa taSource</xa-datasource-class>
    <xa-datasource-property name="URL">jdbc :mysql://remote-machine-ip:3306/temp_mydb</xa-datasource-property>
    <xa-datasource-property name="DatabaseN ame">temp_mydb </xa-datasource-property>
    <user-name>user</user-name>
    <password>psw d</password>
    <min-pool-size>5</min-pool-size>
    <max-pool-size>10</max-pool-size>
    <blocking-timeout-millis>5000</blocking-timeout-millis>
    <idle-timeout-minutes>3</idle-timeout-minutes>

    <exception-sorter-class-name>
    com.mysql.jdbc. integration.jbo ss.ExtendedMysq lExceptionSorte r
    </exception-sorter-class-name>
    <valid-connection-checker-class-name>
    com.mysql.jdbc. integration.jbo ss.MysqlValidCo nnectionChecker
    </valid-connection-checker-class-name>


    <!-- corresponding type-mapping in the standardjbosscm p-jdbc.xml (optional) -->
    <metadata>
    <type-mapping>mySQL</type-mapping>
    </metadata>
    </xa-datasource>
    --------------------------------------------------------------------------------
    Coming to my problem: I can view any entity from the database using the webservice classes but I'm unable to create a record in the database from these classes. I've tried creating records from mysql clients like toad. But using my application it gives me following exception.

    -------------------------------------------------------------------------------
    WARN [TxConnectionMan ager] Connection error occured: org.jboss.resou rce.connectionm anager.TxConnec tionManager$TxC onnectionEventL istener@17bd154[state=NORMAL mc=org.jboss.re source.adapter. jdbc.xa.XAManag edConnection@97 e765 handles=1 lastUse=1268205 838466 permit=true trackByTx=true mcp=org.jboss.r esource.connect ionmanager.JBos sManagedConnect ionPool$OnePool @1d40b0 context=org.jbo ss.resource.con nectionmanager. InternalManaged ConnectionPool@ 821522 xaResource=org. jboss.resource. adapter.jdbc.xa .XAManagedConne ction@97e765 txSync=null]
    java.lang.NullP ointerException
    at org.jboss.resou rce.adapter.jdb c.WrappedPrepar edStatement.set String(WrappedP reparedStatemen t.java:316)
    at org.hibernate.t ype.StringType. set(StringType. java:26)
    at org.hibernate.t ype.NullableTyp e.nullSafeSet(N ullableType.jav a:136)
    at org.hibernate.t ype.NullableTyp e.nullSafeSet(N ullableType.jav a:107)
    at org.hibernate.p ersister.entity .AbstractEntity Persister.dehyd rate(AbstractEn tityPersister.j ava:2002)
    at org.hibernate.p ersister.entity .AbstractEntity Persister.dehyd rate(AbstractEn tityPersister.j ava:1979)
    at org.hibernate.p ersister.entity .AbstractEntity Persister$3.bin dValues(Abstrac tEntityPersiste r.java:2157)
    at org.hibernate.i d.insert.Abstra ctReturningDele gate.performIns ert(AbstractRet urningDelegate. java:32)
    at org.hibernate.p ersister.entity .AbstractEntity Persister.inser t(AbstractEntit yPersister.java :2163)
    at org.hibernate.p ersister.entity .AbstractEntity Persister.inser t(AbstractEntit yPersister.java :2643)
    at org.hibernate.a ction.EntityIde ntityInsertActi on.execute(Enti tyIdentityInser tAction.java:51 )
    at org.hibernate.e ngine.ActionQue ue.execute(Acti onQueue.java:27 9)
    at org.hibernate.e vent.def.Abstra ctSaveEventList ener.performSav eOrReplicate(Ab stractSaveEvent Listener.java:2 98)
    at org.hibernate.e vent.def.Abstra ctSaveEventList ener.performSav e(AbstractSaveE ventListener.ja va:181)
    at org.hibernate.e vent.def.Abstra ctSaveEventList ener.saveWithGe neratedId(Abstr actSaveEventLis tener.java:107)
    at org.hibernate.e vent.def.Defaul tSaveOrUpdateEv entListener.sav eWithGeneratedO rRequestedId(De faultSaveOrUpda teEventListener .java:187)
    at org.hibernate.e vent.def.Defaul tSaveOrUpdateEv entListener.ent ityIsTransient( DefaultSaveOrUp dateEventListen er.java:172)
    at org.hibernate.e vent.def.Defaul tSaveOrUpdateEv entListener.per formSaveOrUpdat e(DefaultSaveOr UpdateEventList ener.java:94)
    at org.hibernate.e vent.def.Defaul tSaveOrUpdateEv entListener.onS aveOrUpdate(Def aultSaveOrUpdat eEventListener. java:70)
    at org.hibernate.i mpl.SessionImpl .fireSaveOrUpda te(SessionImpl. java:507)
    at org.hibernate.i mpl.SessionImpl .saveOrUpdate(S essionImpl.java :499)
    at org.hibernate.i mpl.SessionImpl .saveOrUpdate(S essionImpl.java :495)
    at com.usemgmt.omd .ems.upgrade.My Dao.saveMyModel (MyDao.java:107 )
    at com.usemgmt.omd .actions.ems.My Controller.upda te(MyController .java:34)
    at sun.reflect.Nat iveMethodAccess orImpl.invoke0( Native Method)
    at sun.reflect.Nat iveMethodAccess orImpl.invoke(U nknown Source)
    at sun.reflect.Del egatingMethodAc cessorImpl.invo ke(Unknown Source)
    at java.lang.refle ct.Method.invok e(Unknown Source)
    at org.apache.stru ts2.rest.RestAc tionInvocation. invokeAction(Re stActionInvocat ion.java:100)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invokeAction Only(DefaultAct ionInvocation.j ava:279)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:242)
    at org.apache.stru ts2.rest.RestWo rkflowIntercept or.doIntercept( RestWorkflowInt erceptor.java:2 28)
    at com.opensymphon y.xwork2.interc eptor.MethodFil terInterceptor. intercept(Metho dFilterIntercep tor.java:87)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.valida tor.ValidationI nterceptor.doIn tercept(Validat ionInterceptor. java:249)
    at org.apache.stru ts2.interceptor .validation.Ann otationValidati onInterceptor.d oIntercept(Anno tationValidatio nInterceptor.ja va:68)
    at com.opensymphon y.xwork2.interc eptor.MethodFil terInterceptor. intercept(Metho dFilterIntercep tor.java:87)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.Conversio nErrorIntercept or.intercept(Co nversionErrorIn terceptor.java: 122)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at org.apache.stru ts2.rest.Conten tTypeIntercepto r.intercept(Con tentTypeInterce ptor.java:67)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.Parameter sInterceptor.do Intercept(Param etersIntercepto r.java:195)
    at com.opensymphon y.xwork2.interc eptor.MethodFil terInterceptor. intercept(Metho dFilterIntercep tor.java:87)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.StaticPar ametersIntercep tor.intercept(S taticParameters Interceptor.jav a:148)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at org.apache.stru ts2.interceptor .CheckboxInterc eptor.intercept (CheckboxInterc eptor.java:93)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at org.apache.stru ts2.interceptor .FileUploadInte rceptor.interce pt(FileUploadIn terceptor.java: 235)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.ModelDriv enInterceptor.i ntercept(ModelD rivenIntercepto r.java:89)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.ScopedMod elDrivenInterce ptor.intercept( ScopedModelDriv enInterceptor.j ava:128)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.Parameter sInterceptor.do Intercept(Param etersIntercepto r.java:195)
    at com.opensymphon y.xwork2.interc eptor.MethodFil terInterceptor. intercept(Metho dFilterIntercep tor.java:87)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at org.apache.stru ts2.interceptor .ProfilingActiv ationIntercepto r.intercept(Pro filingActivatio nInterceptor.ja va:104)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at org.apache.stru ts2.interceptor .debugging.Debu ggingIntercepto r.intercept(Deb uggingIntercept or.java:267)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.ChainingI nterceptor.inte rcept(ChainingI nterceptor.java :126)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.I18nInter ceptor.intercep t(I18nIntercept or.java:148)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.PrepareIn terceptor.doInt ercept(PrepareI nterceptor.java :138)
    at com.opensymphon y.xwork2.interc eptor.MethodFil terInterceptor. intercept(Metho dFilterIntercep tor.java:87)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at org.apache.stru ts2.interceptor .MessageStoreIn terceptor.inter cept(MessageSto reInterceptor.j ava:204)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at org.apache.stru ts2.interceptor .ServletConfigI nterceptor.inte rcept(ServletCo nfigInterceptor .java:164)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.AliasInte rceptor.interce pt(AliasInterce ptor.java:128)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.interc eptor.Exception MappingIntercep tor.intercept(E xceptionMapping Interceptor.jav a:176)
    at com.opensymphon y.xwork2.Defaul tActionInvocati on.invoke(Defau ltActionInvocat ion.java:236)
    at com.opensymphon y.xwork2.Defaul tActionProxy.ex ecute(DefaultAc tionProxy.java: 129)
    at org.apache.stru ts2.dispatcher. Dispatcher.serv iceAction(Dispa tcher.java:468)
    at org.apache.stru ts2.dispatcher. ng.ExecuteOpera tions.executeAc tion(ExecuteOpe rations.java:77 )
    at org.apache.stru ts2.dispatcher. ng.filter.Strut sPrepareAndExec uteFilter.doFil ter(StrutsPrepa reAndExecuteFil ter.java:76)
    at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:202)
    at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:173)
    at org.jboss.web.t omcat.filters.R eplyHeaderFilte r.doFilter(Repl yHeaderFilter.j ava:96)
    at org.apache.cata lina.core.Appli cationFilterCha in.internalDoFi lter(Applicatio nFilterChain.ja va:202)
    at org.apache.cata lina.core.Appli cationFilterCha in.doFilter(App licationFilterC hain.java:173)
    at org.apache.cata lina.core.Stand ardWrapperValve .invoke(Standar dWrapperValve.j ava:213)
    at org.apache.cata lina.core.Stand ardContextValve .invoke(Standar dContextValve.j ava:178)
    at org.jboss.web.t omcat.security. SecurityAssocia tionValve.invok e(SecurityAssoc iationValve.jav a:175)
    at org.apache.cata lina.authentica tor.Authenticat orBase.invoke(A uthenticatorBas e.java:524)
    at org.jboss.web.t omcat.security. JaccContextValv e.invoke(JaccCo ntextValve.java :74)
    at org.apache.cata lina.core.Stand ardHostValve.in voke(StandardHo stValve.java:12 6)
    at org.apache.cata lina.valves.Err orReportValve.i nvoke(ErrorRepo rtValve.java:10 5)
    at org.jboss.web.t omcat.tc5.jca.C achedConnection Valve.invoke(Ca chedConnectionV alve.java:156)
    at org.apache.cata lina.core.Stand ardEngineValve. invoke(Standard EngineValve.jav a:107)
    at org.apache.cata lina.connector. CoyoteAdapter.s ervice(CoyoteAd apter.java:148)
    at org.apache.coyo te.http11.Http1 1Processor.proc ess(Http11Proce ssor.java:869)
    at org.apache.coyo te.http11.Http1 1BaseProtocol$H ttp11Connection Handler.process Connection(Http 11BaseProtocol. java:664)
    at org.apache.tomc at.util.net.Poo lTcpEndpoint.pr ocessSocket(Poo lTcpEndpoint.ja va:527)
    at org.apache.tomc at.util.net.Mas terSlaveWorkerT hread.run(Maste rSlaveWorkerThr ead.java:112)
    at java.lang.Threa d.run(Unknown Source)

    -------------------------------------------------------------------------------

    Please help and try to be elaborate about why this is happening.

    Thanks a lot
Working...