[Design of Messaging on JBoss (Messaging/JBoss)] - ORA-014161 - Help with Bug on Oracle Driver
by clebert.suconic@jboss.com
I'm testing JBossMessaging for the release process, and I found what seems to be a bug on Oracle driver:
"java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column" site:oracle.com
I have a simple statement, insterting values into JBM_MSG:
INSERT INTO JBM_MSG (MESSAGE_ID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, HEADERS, PAYLOAD, TYPE) SELECT ?, ?, ?, ?, ?, ?, ?, ? FROM JBM_DUAL WHERE NOT EXISTS (SELECT MESSAGE_ID FROM JBM_MSG WHERE MESSAGE_ID = ?)
And this can't work when using LONGs on queries.
This is clearly a bug on the driver :-( Anyone know how to fix that?
I have googled for this of course, and the only conclusion I found was.. "this is a bug on the driver" and nothing more besides that.
It seems that everybody fixed it by just avoiding it the long.. replacing the long usage by store procedures or something else.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4078524#4078524
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4078524
18 years, 7 months
[Design of JBoss/Tomcat Integration] - Configuring Apache To Listen To Jboss
by shanportal
I am using Mod Jk in the Apache Server to connect to Jboss 4.2.1. However i am getting the following error in the browser.
| Service Temporarily Unavailable
| The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
|
when i looke at the ModJk Logs It shows
| Mon Aug 27 09:44:41 2007][5824:1224] [info] mod_jk.c (2277): Service error=0 for worker=loadbalancer
| [Mon Aug 27 09:56:37 2007][5824:1224] [info] jk_connect.c (473): connect to 127.0.0.1:8009 failed (errno=61)
| [Mon Aug 27 09:56:37 2007][5824:1224] [info] jk_ajp_common.c (891): Failed opening socket to (127.0.0.1:8009) (errno=61)
| [Mon Aug 27 09:56:37 2007][5824:1224] [info] jk_ajp_common.c (1311): (node1) error connecting to the backend server (errno=61)
| [Mon Aug 27 09:56:37 2007][5824:1224] [info] jk_ajp_common.c (2085): (node1) sending request to tomcat failed, recoverable operation attempt=1
| [Mon Aug 27 09:56:38 2007][5824:1224] [info] jk_connect.c (473): connect to 127.0.0.1:8009 failed (errno=61)
| [Mon Aug 27 09:56:38 2007][5824:1224] [info] jk_ajp_common.c (891): Failed opening socket to (127.0.0.1:8009) (errno=61)
| [Mon Aug 27 09:56:38 2007][5824:1224] [info] jk_ajp_common.c (1311): (node1) error connecting to the backend server (errno=61)
| [Mon Aug 27 09:56:38 2007][5824:1224] [info] jk_ajp_common.c (2085): (node1) sending request to tomcat failed, recoverable operation attempt=2
| [Mon Aug 27 09:56:38 2007][5824:1224] [error] jk_ajp_common.c (2097): (node1) Connecting to tomcat failed. Tomcat is probably not started or is listening on the wrong port
| [Mon Aug 27 09:56:38 2007][5824:1224] [info] jk_lb_worker.c (1128): service failed, worker node1 is in error state
| [Mon Aug 27 09:56:38 2007][5824:1224] [info] jk_lb_worker.c (1191): All tomcat instances are busy or in error state
| [Mon Aug 27 09:56:38 2007]loadbalancer localhost 1.921912
| [Mon Aug 27 09:56:38 2007][5824:1224] [info] mod_jk.c (2277): Service error=0 for worker=loadbalancer
|
I followed the Instructions provided in the URL. Is there any other setting I need to change in the Jboss Server to make it work. Or is there any other method other than Mod_Jk would be better, Any help is highly apprictaed
|
| http://wiki.jboss.org/wiki/Wiki.jsp?page=UsingMod_jk1.2WithJBoss
|
|
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4078368#4078368
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4078368
18 years, 7 months
[Design of EJB 3.0] - Re: Transaction behavior of clustered SFSB caching
by bstansberry@jboss.com
Sacha,
Yep, that's the goal. There's really 2 levels to what you're talking about:
1) Batching all the SFSB replication from various beans accessed in the request into one replication event. What I described above should handle that nicely, since all the beans are cached in the same JBC instance. When the BTM tx is committed, they all replicate in one event.
2) Doing the web session replication with the SFSBs. Currently this won't work, because web sessions and SFSBs are stored in different JBC instances, and each cache will replicate separately. I can use the same BatchModeTransactionManager for both services, so getting the batching control to properly span the entire request should be doable. But I also need to get everything into one cache. I *might* be able to do that with the current infrastructure, since both caches use largely the same configuration (pretty likely I can). If not, this will need http://jira.jboss.com/jira/browse/JBCACHE-64 completed, which is a next year thing.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4078362#4078362
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4078362
18 years, 7 months
[Design of Clustering on JBoss (Clusters/JBoss)] - jboss 4.2.1 causes org.springframework.transaction.NoTransac
by bucegiomu
The integration between Spring and JBOSS does not work properly anymore after upgrading jboss from 4.0.4 to 4.2.1. Basically I have a CMT Stateless Session Bean EJB (SubscrFacadeBean) which is calling a spring bean (KtfPerformerImpl) as follows:
| ... SubscrFacadeBean.createSubscr(...)
| {
| // Get KtfPerformerImpl from Bean Factory
| KtfPerformerImpl impl = ...;
|
| // Call implementation
| impl.createSubscr(...);
| }
|
The EJB method createSubscr is marked (CMT) with a "Required" transaction attribute.
The KtfPerformerImpl.createSubscr method is marked "PROPAGATION_REQUIRED, -Exception" using an TransactionProxyFactoryBean.
In spring I'm using the JTA transaction manager as follows:
<bean id="txManager"
| class="org.springframework.transaction.jta.JtaTransactionManager">
| <property name="transactionManagerName" value="java:/TransactionManager"/>
| <property name="userTransactionName" value="UserTransaction"/>
| </bean>
|
So, having enabled the DEBUG logging level for "org.springframework.transaction", I can see (while debugging) after entering KtfPerformerImpl.createSubscr(...):
2007-08-24 15:59:36,146 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Using transaction object [org.springframework.transaction.jta.JtaTransactionObject@c82a01]
| 2007-08-24 15:59:36,146 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Using transaction object [org.springframework.transaction.jta.JtaTransactionObject@c82a01]
| 2007-08-24 15:59:39,646 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Participating in existing transaction
| 2007-08-24 15:59:39,646 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Participating in existing transaction
| 2007-08-24 15:59:39,646 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Initializing transaction synchronization
| 2007-08-24 15:59:39,646 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Initializing transaction synchronization
| 2007-08-24 15:59:39,646 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] Getting transaction for [com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl.createSubscr]
| 2007-08-24 15:59:39,646 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] Getting transaction for [com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl.createSubscr]
So far it's cool: KtfPerformerImpl.createSubscr(...) was enlisted in the transaction opened by EJB CMT. Then an application exception is raised in KtfPerformerImpl.createSubscr(...):
com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
which SHOULD rollback the transaction, but look what I get in the log:
2007-08-24 16:00:34,396 ERROR [EzineSubscrSrv.SUBSCR_REG_ALG__KTF_PERF_IMPL] CREATE SUBSCR: KTF request NOK after 2 tries => ABANDONING!
| com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
| ErrorCode=SUBSCR_EXTERNAL_CREATE_FAILED
| at com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl.createSubscr(KtfPerformerImpl.java:203)
| at com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl$$FastClassByCGLIB$$1834b76.invoke(<generated>)
| at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
| at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:695)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:139)
| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
| at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:630)
| at com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl$$EnhancerByCGLIB$$aed746d5.createSubscr(<generated>)
| at com.picsel.server.ezine.subscr.ejb.SubscrFacadeBean.createSubscr(SubscrFacadeBean.java:165)
| ...
| 2007-08-24 16:00:35,021 WARN [EzineSubscrSrv.SUBSCR_REG_ALG__KTF_PERF_IMPL] CREATE SUBSCR: NOK: using reqData {msisdn=987656789, magId=98627ed10a03127f0047f959316507ea}!SUBSCR_EXTERNAL_CREATE_FAILED: com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
| 2007-08-24 16:00:35,990 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] Completing transaction for [com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl.createSubscr] after exception: com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
| ErrorCode=SUBSCR_EXTERNAL_CREATE_FAILED
| 2007-08-24 16:00:35,990 DEBUG [org.springframework.transaction.interceptor.TransactionInterceptor] Completing transaction for [com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl.createSubscr] after exception: com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
| ErrorCode=SUBSCR_EXTERNAL_CREATE_FAILED
| 2007-08-24 16:00:35,990 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] Applying rules to determine whether transaction should rollback on com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
| ErrorCode=SUBSCR_EXTERNAL_CREATE_FAILED
| 2007-08-24 16:00:35,990 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] Applying rules to determine whether transaction should rollback on com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
| ErrorCode=SUBSCR_EXTERNAL_CREATE_FAILED
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] Winning rollback rule is: RollbackRuleAttribute with pattern [Exception]
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.interceptor.RuleBasedTransactionAttribute] Winning rollback rule is: RollbackRuleAttribute with pattern [Exception]
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Triggering beforeCompletion synchronization
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Triggering beforeCompletion synchronization
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Participating transaction failed - marking existing transaction as rollback-only
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Participating transaction failed - marking existing transaction as rollback-only
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Setting JTA transaction rollback-only
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Setting JTA transaction rollback-only
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Registering after-completion synchronization with existing JTA transaction
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.jta.JtaTransactionManager] Registering after-completion synchronization with existing JTA transaction
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Clearing transaction synchronization
| 2007-08-24 16:00:36,006 DEBUG [org.springframework.transaction.support.TransactionSynchronizationManager] Clearing transaction synchronization
| 2007-08-24 16:00:36,006 ERROR [org.springframework.transaction.interceptor.TransactionInterceptor] Application exception overridden by rollback exception
| com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
| ErrorCode=SUBSCR_EXTERNAL_CREATE_FAILED
| at com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl.createSubscr(KtfPerformerImpl.java:203)
| ...
| 2007-08-24 16:00:36,006 ERROR [org.springframework.transaction.interceptor.TransactionInterceptor] Application exception overridden by rollback exception
| com.picsel.server.ezine.subscr.exception.SubscriptionException: "ERROR_CODE 2 (not 0!) received!
| ErrorCode=SUBSCR_EXTERNAL_CREATE_FAILED
| at com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl.createSubscr(KtfPerformerImpl.java:203)
| 2007-08-24 16:00:36,006 ERROR [org.jboss.ejb.plugins.LogInterceptor] RuntimeException in method: public abstract com.picsel.server.ezine.subscr.dto.Subscription com.picsel.server.ezine.subscr.ejb.interfaces.SubscrFacadeLocal.createSubscr(com.picsel.server.ezine.subscr.dto.ProviderAccountDto,java.util.Map) throws com.picsel.server.ezine.subscr.exception.SubscriptionException:
| org.springframework.transaction.NoTransactionException: No active JTA transaction
| at org.springframework.transaction.jta.JtaTransactionManager.registerAfterCompletionWithExistingTransaction(JtaTransactionManager.java:903)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerAfterCompletion(AbstractPlatformTransactionManager.java:885)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:782)
| at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:730)
| at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:332)
| at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:111)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)
| at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:630)
| at com.picsel.server.ezine.subscr.domain.subscrregalg.impl.KtfPerformerImpl$$EnhancerByCGLIB$$aed746d5.createSubscr(<generated>)
| at com.picsel.server.ezine.subscr.ejb.SubscrFacadeBean.createSubscr(SubscrFacadeBean.java:165)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
| at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)
| at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
| at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)
| at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
| at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
| at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
| at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
| at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
| at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
| at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
| at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
| at org.jboss.ejb.Container.invoke(Container.java:960)
| at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)
| at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)
| at $Proxy263.createSubscr(Unknown Source)
| at com.picsel.server.ezine.subscr.web.servlet.CreateSubscrServlet.doPost(CreateSubscrServlet.java:133)
| at com.picsel.server.ezine.subscr.web.servlet.CreateSubscrServlet.doGet(CreateSubscrServlet.java:70)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
| at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at com.picsel.server.common.web.filter.RemoteIpAddrFilter.doFilter(RemoteIpAddrFilter.java:78)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
| at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
| at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
| at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
| at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
| at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
| at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
| at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
| at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
| at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
| at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:543)
| at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
| at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241)
| at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
| at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580)
| at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
| at java.lang.Thread.run(Thread.java:595)
| ...
So the transaction is marked for rollback by spring, but afterwards an org.springframework.transaction.NoTransactionException is thrown, WHICH WAS NOT HAPPENING WHEN USING JBOSS 4.0.4. The result is that the application exception is overridden by the rollback exception.
Could somebody from JBOSS team help me with this, please.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4078324#4078324
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4078324
18 years, 7 months