Transaction Error due to whether JBoss or SQL Server Driver

G

Ganapathi sundaram

Hi All,

We did not have any Transaction Failure Exception when we used JBoss
4.0.2 AS before.It was working fine.

We have upgraded the JBoss server from 4.0.2 to 4.2.2.

Now, I am getting Transaction Failure Error often in my JBoss 4.2.2
AS.

Could you please anyone help me out from the below Transation Error ,
as well tell me reason why this is happening often ..?

Expecting reply soon.

Thanks in Advance.

Code:

2009-02-24 17:46:59,836 INFO [STDOUT] --@I-- location=T0141
2009-02-24 17:46:59,883 INFO [STDOUT]
--@I-- Exception when saveInvoiceByCustomer method called
2009-02-24 17:46:59,883 ERROR [STDERR]
com.microsoft.sqlserver.jdbc.SQLServerException: The server f
ailed to resume the transaction. Desc:930000018e.
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromD
atabaseError(Unknown Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unkn
own Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextRe
sult(Unknown Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecute
Statement(Unknown Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerStatement$Statement
ExecutionRequest.executeStatement(Unknown Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Un
known Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeR
equest(Unknown Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQu
ery(Unknown Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getMaxFie
ldSize(Unknown Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.CachedPreparedStatement.<init>
(CachedPreparedStatement.java:71)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnect
ion.prepareStatement(BaseWrapperManagedConnection.java:338)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrappedConnection.prepare
Statement(WrappedConnection.java:187)
2009-02-24 17:46:59,883 ERROR [STDERR] at
lrp.arp.exportinvoice.bean.ExpInvBean.saveInvoiceByCustom
er(ExpInvBean.java:1242)
2009-02-24 17:46:59,883 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Metho
d)
2009-02-24 17:46:59,883 ERROR [STDERR] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodA
ccessorImpl.java:39)
2009-02-24 17:46:59,883 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegatin
gMethodAccessorImpl.java:25)
2009-02-24 17:46:59,883 ERROR [STDERR] at
java.lang.reflect.Method.invoke(Method.java:597)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.invocation.Invocation.performCall(Invocation.ja
va:359)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer$ContainerIntercep
tor.invoke(StatelessSessionContainer.java:237)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.resource.connectionmanager.CachedConnectionInte
rceptor.invoke(CachedConnectionInterceptor.java:158)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor
..invoke(StatelessSessionInstanceInterceptor.java:169)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.CallValidationInterceptor.invoke(Ca
llValidationInterceptor.java:63)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Ab
stractTxInterceptor.java:121)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransaction
s(TxInterceptorCMT.java:350)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxIntercept
orCMT.java:181)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(Security
Interceptor.java:168)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogIntercepto
r.java:205)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invok
e(ProxyFactoryFinderInterceptor.java:138)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.SessionContainer.internalInvoke(SessionCont
ainer.java:648)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.Container.invoke(Container.java:960)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(
BaseLocalProxyFactory.java:430)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(
StatelessSessionProxy.java:103)
2009-02-24 17:46:59,883 ERROR [STDERR] at
$Proxy1944.saveInvoiceByCustomer(Unknown Source)
2009-02-24 17:46:59,883 ERROR [STDERR] at
lrp.arp.exportinvoice.ExpInvServlet.saveByCustomerServlet
(ExpInvServlet.java:156)
2009-02-24 17:46:59,883 ERROR [STDERR] at
lrp.arp.exportinvoice.ExpInvServlet.processRequest(ExpInv
Servlet.java:61)
2009-02-24 17:46:59,883 ERROR [STDERR] at
lrp.arp.exportinvoice.ExpInvServlet.doPost(ExpInvServlet.
java:333)
2009-02-24 17:46:59,883 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:7
27)
2009-02-24 17:46:59,883 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:8
20)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalD
oFilter(ApplicationFilterChain.java:290)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:206)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(R
eplyHeaderFilter.java:96)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalD
oFilter(ApplicationFilterChain.java:235)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:206)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(Stan
dardWrapperValve.java:230)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(Stan
dardContextValve.java:175)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.in
voke(SecurityAssociationValve.java:179)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(Jac
cContextValve.java:84)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(Standar
dHostValve.java:128)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorR
eportValve.java:104)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.in
voke(CachedConnectionValve.java:156)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(Stand
ardEngineValve.java:109)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(Coyot
eAdapter.java:241)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.j
ava:437)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.pr
ocess(AjpProtocol.java:381)
2009-02-24 17:46:59,883 ERROR [STDERR] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndp
oint.java:447)
2009-02-24 17:46:59,883 ERROR [STDERR] at java.lang.Thread.run
(Thread.java:619)
2009-02-24 17:46:59,883 INFO [STDOUT] After the bean method
2009-02-24 17:46:59,883 INFO [STDOUT] Successfully Sent
2009-02-24 17:46:59,883 INFO [STDOUT] --@I-- output Object =
[[B@430266c9, 190]
2009-02-24 17:47:00,539 INFO [STDOUT] Type is getSettingsValue
2009-02-24 17:47:00,539 INFO [STDOUT] getSettingsValue method
called.....
2009-02-24 17:47:00,539 INFO [STDOUT] Exception raised in
getAllSupportedVersions() :com.microsoft.
sqlserver.jdbc.SQLServerException: The server failed to resume the
transaction. Desc:930000018e.
2009-02-24 17:47:00,539 ERROR [STDERR]
com.microsoft.sqlserver.jdbc.SQLServerException: The server f
ailed to resume the transaction. Desc:930000018e.
2009-02-24 17:47:00,539 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromD
atabaseError(Unknown Source)
2009-02-24 17:47:00,539 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unkn
own Source)
2009-02-24 17:47:00,539 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.g
etPrepExecResponse(Unknown Source)
2009-02-24 17:47:00,539 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.d
oExecutePreparedStatement(Unknown Source)
2009-02-24 17:47:00,539 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$P
reparedStatementExecutionRequest.executeStatement(Unknown Source)
2009-02-24 17:47:00,539 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Un
known Source)
2009-02-24 17:47:00,539 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeR
equest(Unknown Source)
2009-02-24 17:47:00,539 ERROR [STDERR] at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.e
xecuteQuery(Unknown Source)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.CachedPreparedStatement.e
xecuteQuery(CachedPreparedStatement.java:90)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.
executeQuery(WrappedPreparedStatement.java:236)
2009-02-24 17:47:00,539 ERROR [STDERR] at
main.bean.MenuBean.getSettingsValue(MenuBean.java:1115)
2009-02-24 17:47:00,539 ERROR [STDERR] at
sun.reflect.GeneratedMethodAccessor294.invoke(Unknown Sou
rce)
2009-02-24 17:47:00,539 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegatin
gMethodAccessorImpl.java:25)
2009-02-24 17:47:00,539 ERROR [STDERR] at
java.lang.reflect.Method.invoke(Method.java:597)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.invocation.Invocation.performCall(Invocation.ja
va:359)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.StatelessSessionContainer$ContainerIntercep
tor.invoke(StatelessSessionContainer.java:237)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.resource.connectionmanager.CachedConnectionInte
rceptor.invoke(CachedConnectionInterceptor.java:158)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor
..invoke(StatelessSessionInstanceInterceptor.java:169)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.plugins.CallValidationInterceptor.invoke(Ca
llValidationInterceptor.java:63)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(Ab
stractTxInterceptor.java:121)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransaction
s(TxInterceptorCMT.java:350)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxIntercept
orCMT.java:181)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(Security
Interceptor.java:168)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogIntercepto
r.java:205)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invok
e(ProxyFactoryFinderInterceptor.java:138)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.SessionContainer.internalInvoke(SessionCont
ainer.java:648)
2009-02-24 17:47:00,539 ERROR [STDERR] at
org.jboss.ejb.Container.invoke(Container.java:960)
2009-02-24 17:47:00,555 ERROR [STDERR] at
sun.reflect.GeneratedMethodAccessor258.invoke(Unknown Sou
rce)
2009-02-24 17:47:00,555 ERROR [STDERR] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegatin
gMethodAccessorImpl.java:25)
2009-02-24 17:47:00,555 ERROR [STDERR] at
java.lang.reflect.Method.invoke(Method.java:597)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.mx.interceptor.ReflectedDispatcher.invoke(Refle
ctedDispatcher.java:155)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.mx.server.Invocation.dispatch(Invocation.java:9
4)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractM
BeanInvoker.java:264)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImp
l.java:659)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.invocation.local.LocalInvoker$MBeanServerAction
..invoke(LocalInvoker.java:169)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.invocation.local.LocalInvoker.invoke(LocalInvok
er.java:118)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.invocation.InvokerInterceptor.invokeLocal(Invok
erInterceptor.java:209)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.invocation.InvokerInterceptor.invoke(InvokerInt
erceptor.java:195)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.proxy.TransactionInterceptor.invoke(Transaction
Interceptor.java:61)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterc
eptor.java:70)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(St
atelessSessionInterceptor.java:112)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.proxy.ClientContainer.invoke(ClientContainer.ja
va:100)
2009-02-24 17:47:00,555 ERROR [STDERR] at $Proxy2494.getSettingsValue
(Unknown Source)
2009-02-24 17:47:00,555 ERROR [STDERR] at
main.web.MenuServlet.getSettingsValue(MenuServlet.java:13
4)
2009-02-24 17:47:00,555 ERROR [STDERR] at
main.web.MenuServlet.processRequest(MenuServlet.java:55)
2009-02-24 17:47:00,555 ERROR [STDERR] at main.web.MenuServlet.doPost
(MenuServlet.java:306)
2009-02-24 17:47:00,555 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:7
27)
2009-02-24 17:47:00,555 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:8
20)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalD
oFilter(ApplicationFilterChain.java:290)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:206)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(R
eplyHeaderFilter.java:96)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalD
oFilter(ApplicationFilterChain.java:235)
2009-02-24 17:47:00,555 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(
ApplicationFilterChain.java:206)



Regards,
Ganapathi sundaram.G
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

java.lang.ClassFormatError: Truncated class file 2
ClassCastException thrown from oracle.sql.ArrayDescriptor 1
issue locating error in JSP/compiled Java web application 1
class loading problem 1
Cannot start JBoss3 from latest Eclipse/MyEclipse 1
Validator error . . . 2
JBoss EJB MessageContext Exception 0
JBoss: Error instantiating org.apache.jasper.servlet.JspServlet 0

Members online

Total: 31 (members: 2, guests: 29)
Robots: 267

Forum statistics

Threads
473,755
Messages
2,569,534
Members
45,007
Latest member
obedient dusk

Latest Threads

Top