[JBoss-user] [Persistence & CMP/JBoss] - JBoss 4.0.0 STATUS_NO_TRANSACTION on commit
When doing an update on a list of locals we get a STATUS_NO_TRANSACTION error message. It looks like it appear when the transaction is to be commited, because it shows in the log with the ID of the first local that was changed/updated. We don't get this error if we run the same code on JBoss 3.2.3. Does anyone know of any bug in JBoss 4.0.0 that can create this error, or could it be some configuration that we haven't done correct in the JBoss 4.0.0 version? We have tried to use both Required and RequiresNew, but it makes no different as far as I can see. org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=ls03/147, BranchQual=, localId=147] status=STATUS_NO_TRANSACTION; - nested throwable: (javax.ejb.EJBException: Update failed. Expected one affected row: rowsAffected=0, id=1556) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:344) at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:457) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:370) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:149) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:128) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624) at org.jboss.ejb.Container.invoke(Container.java:854) at sun.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141) at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80) at org.jboss.mx.server.Invocation.invoke(Invocation.java:72) at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:242) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:642) at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:155) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:104) at org.jboss.invocation.MarshallingInvokerInterceptor.invoke(MarshallingInvokerInterceptor.java:55) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:55) at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:97) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:86) View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3852316#3852316 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3852316 --- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: jbosscmp-jdbc.xml syntax
There was nothing about "add column" in the MS SQL section so I tried to add ALTER TABLE ?1 ADD COLUMN ?2 ?3 but I got an error saying: Invalid XML: file=file:/.../standardjbosscmp-jdbc.xml Any Ideas? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3851513#3851513 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3851513 --- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - jbosscmp-jdbc.xml syntax
I'm trying to deploy an application with alter-table set, to update the tables in my database, but I get this error message: ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column 'ol_version' cannot be added to table 'STOCK' because it does not allow nulls and does not specify a DEFAULT definition. The definition for optimistic locking in my jbosscmp-jdbc.xml look like this: versionField ol_version INTEGER INTEGER How can I define a default value of e.g 0? /TK View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3851416#3851416 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3851416 --- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: JBossLocalXAException
Yes, the connection was closed. I'm trying to find out why? Can the warning about XA_UNKNOWN tell me anything? Could it be that the MS SQL server does not supprot the XA protocol? Does anyone know if that is something one can "turn on/off" in the MS SQL server? Are there any other hint in the stack trace, of why the connection was closed? -Trond View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3834388#3834388 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3834388 --- This SF.Net email is sponsored by Sleepycat Software Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver higher performing products faster, at low TCO. http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3 ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [JCA/JBoss] - Re: JBossLocalXAException
This should be the full trace:
2004-05-10 15:29:20,740 DEBUG [tcms.facade.ActorsFacadeSession]
insertCompany({comId=null comType=CUS comArea= comCode=ttt comName=ttt comAddress=
comPhoneNo= comFaxNo= comEmailAddress= comUrlAddress= comTelexNo=null
comTermsOfPayment=null comCustomsProcedureNo=null comBankAccountNo=null
comPostAccountNo=null comDescription=null})
2004-05-10 15:29:20,740 DEBUG [tcms.data.trim.actors.CompanyCMP$Proxy] ejbCreate()
2004-05-10 15:29:20,786 DEBUG [tcms.util.TcmsApplicationException]
ErrorCode: 1.01.0002
Arguments:
javax.ejb.CreateException: Expected one affected row but update returned0 for id=null
2004-05-10 15:29:20,880 WARN [org.jboss.tm.TransactionImpl] XAException:
tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=cphjlapp//4617, BranchQual=]
errorCode=XA_UNKNOWN(0)
org.jboss.resource.connectionmanager.JBossLocalXAException: could not commit local tx;
- nested throwable: (org.jboss.resource.JBossResourceException: SQLException; - nested
throwable: (java.sql.SQLException: [TDS Driver]Connection was closed from the SQL
Server site or network at header (0)))
at
org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.commit(TxConnectionManager.java:755)
at org.jboss.tm.TransactionImpl.commitResources(TransactionImpl.java:1593)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:375)
at
org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:398)
at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:277)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128)
at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191)
at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at
org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
at org.jboss.ejb.Container.invoke(Container.java:700)
at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at
org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546)
at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101)
at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90)
at
org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46)
at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45)
at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100)
at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85)
at $Proxy589.insertCompany(Unknown Source)
at tcms.service.ActorsEJBDelegate.insertCompany(ActorsEJBDelegate.java:292)
at com.tcms.refdata.CompanyExecute.doSave(CompanyExecute.java:123)
at com.tcms.refdata.CompanyAction.perform(CompanyAction.java:78)
at org.apache.struts.action.Action.execute(Action.java:420)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm.java:220)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at
org.apache.catalina.authenticator.Authenticat
[JBoss-user] [JCA/JBoss] - JBossLocalXAException
Hello! I'm having problem with inserting of data into my MS SQL 2000 database. I see that several others have had similar problems, but I haven't solve mine by looking at the forum, so here goes... We are using JBoss 3.2.3 and MS SQL 2000. In the test environment everything works fine, but when moving to the production environment we get the excpetion shown below. The production environment should have the same set up as the test environment, I think... I think the exception occures when inserting in tables that have a one/zero to many relation to other tables. (The relations has not been set up in the database) If we make the application on the production server use the database on the database server in the test environment, everyting works fine. If we make the test application use the database on the production server, it fails. So it seams to be the SQL 2000 server in the production environment that is missing something(?) We are using the Inet Merlia JDBC Driver for Microsoft SQL Server Databases. Any ideas? Regards Trond Kvarenes The exception: 2004-05-07 08:20:22,107 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException in method: public abstract tcms.data.trim.actors.CompanyValue tcms.facade.ActorsFacade.insertCompany(tcms.data.trim.actors.CompanyValue) throws tcms.util.TcmsApplicationException,java.rmi.RemoteException, causedBy: org.jboss.tm.JBossRollbackException: Unable to commit, tx=TransactionImpl:XidImpl [FormatId=257, GlobalId=cphjlapp//69, BranchQual=] status=STATUS_NO_TRANSACTION; - nested throwable: (org.jboss.resource.connectionmanager.JBossLocalXAException: wrong xid in rollback: expected: null, got: XidImpl [FormatId=257, GlobalId=cphjlapp//69, BranchQual=1]) at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:413) at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:398) at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:277) at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:128) at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:118) at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:191) at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122) at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331) at org.jboss.ejb.Container.invoke(Container.java:700) at sun.reflect.GeneratedMethodAccessor138.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at org.jboss.mx.capability.ReflectedMBeanDispatcher.invoke(ReflectedMBeanDispatcher.java:284) at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:546) at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:101) at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:90) at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:46) at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:45) at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:100) at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:85) at $Proxy589.insertCompany(Unknown Source) at tcms.service.ActorsEJBDelegate.insertCompany(ActorsEJBDelegate.java:292) at com.tcms.refdata.CompanyExecute.doSave(CompanyExecute.java:123) at com.tcms.refdata.CompanyAction.perform(CompanyAction.java:78) at org.apache.struts.action.Action.execute(Action.java:420) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(St
