Sybase JConnect driver code hangs indefinitely !!!



Hi,

Sorry for the cross-posting. I know this is not a relevant group. But I
am unable to find any solution (responses) from any group. So please
dont mind my posting.

===================================================


I am facing the following problem consistently. The driver (Jconnect
5.5 and 6.0 from Sybase)
code hangs in the read socket call and the rest of my threads
wait indefinitely resulting in a deadlock.

The problem occurs during insertion into the DB. Though my application
is multi-threaded, I have taken of sychronization at the application
level.

Have you faced similar problems before?. Could you please explain the
causes for the driver to wait indefinitely? Also, what do you suggest
to prevent these situations?

I have tried the code with Sybase ASA 9.0.1 with jconnect 5.5 and
jconnect 6.0 drivers on Sun JRE1.4(Win).

I had posted the message in sybase forums but got no response. Sorry
for the cross-posting.

============================ Stack Trace ===========================
"RMI TCP Connection(173)-192.168.3.85" daemon prio=5 tid=0x24638618
nid=0xfe4 runnable [29b8e000..29b8fdb4]
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:129)
at
com.sybase.jdbc3.timedio.RawDbio.reallyRead(RawDbio.java:234)
at com.sybase.jdbc3.timedio.Dbio.doRead(Dbio.java:243)
at
com.sybase.jdbc3.timedio.InStreamMgr.readIfOwner(InStreamMgr.java:512)
at
com.sybase.jdbc3.timedio.InStreamMgr.doRead(InStreamMgr.java:273)
at
com.sybase.jdbc3.tds.TdsProtocolContext.getChunk(TdsProtocolContext.java:572)
at
com.sybase.jdbc3.tds.PduInputFormatter.readPacket(PduInputFormatter.java:229)
at
com.sybase.jdbc3.tds.PduInputFormatter.read(PduInputFormatter.java:62)
at
com.sybase.jdbc3.tds.TdsInputStream.read(TdsInputStream.java:81)
at
com.sybase.jdbc3.tds.TdsInputStream.readUnsignedByte(TdsInputStream.java:114)
at com.sybase.jdbc3.tds.Tds.nextResult(Tds.java:2192)
at
com.sybase.jdbc3.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at
com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:220)
at
com.sybase.jdbc3.jdbc.SybStatement.nextResult(SybStatement.java:203)
at
com.sybase.jdbc3.jdbc.SybStatement.updateLoop(SybStatement.java:1811)
at
com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(SybStatement.java:1794)
at
com.sybase.jdbc3.jdbc.SybStatement.executeUpdate(SybStatement.java:441)
at
com.abc.mo.persmo.PersistentMO.dbInsertRow(PersistentMO.java:945)
at
com.abc.mo.persmo.PersistentMO.dbUpdate(PersistentMO.java:1581)
at com.abc.mo.util.UpdateMO.process(UpdateMO.java:183)
- locked <0x12362c80> (a com.proactivenet.mo.util.UpdateMO)
at com.abc.api.mo.MOCache.createMO(MOCache.java:1833)
at com.abc.api.mo.MOCache.create(MOCache.java:1472)
at com.abc.api.mo.MOCache.update(MOCache.java:1243)
at com.abc.api.mo.MOPlatformImpl.update(MOPlatformImpl.java:84)
at com.abc.api.mo.MO.update(MO.java:688)
at
com.abc.api.sla.SLACache.checkSLAThreshold(SLACache.java:1589)
- locked <0x12362e58> (a java.util.ArrayList)
at
com.abc.api.sla.SLACache.createSLAInstance(SLACache.java:1224)
at com.proactivenet.api.sla.SLACache.create(SLACache.java:932)
- locked <0x12362f70> (a java.util.ArrayList)
- locked <0x12176528> (a com.proactivenet.api.sla.SLACache)
at
com.abc.api.sla.SLAPlatformImpl.createSLA(SLAPlatformImpl.java:206)
at
com.abc.api.sla.SLAClientHelper.createRupdateSLA(SLAClientHelper.java:1402)
at
com.abc.api.jsp.JSPPlatformImpl.createRupdateSLA(JSPPlatformImpl.java:3980)
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:324)
at
sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:261)
at sun.rmi.transport.Transport$1.run(Transport.java:148)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:144)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:534)

============================ Stack Trace ===========================

Regards,
Manjunath

.



Relevant Pages

  • Re: digest 2453240
    ... responses to those newsgroups. ... Given that you are one of those cross-posting their responses, ... Classic reading comprehension problem on your part, ...
    (sci.astro)
  • Re: * off-topic * Re: R.I.P. Robert Jordan
    ... but Andre Plotkin responded by cross-posting to ... By scanning the responses in original format we can see ... It seems his posts have run into ... Perhaps more troll posts that have been ...
    (rec.arts.sf.written)
  • Force classic theme and default wallpaper for all users
    ... I'm sorry for cross-posting this, but I haven't received any responses since ... my first post in microsoft.public.windowsxp.security_admin on 10/6. ... my own default wallpaper bitmap that should be applied to the profile rather ...
    (microsoft.public.windowsxp.general)
  • Netrexx in JSP
    ... My advance apologies for cross-posting: I'd posted this question to the ... Netrexx mailing list and I've received no responses yet, therefore, I ... If anyone has any recommendations on this particular topic, ...
    (comp.lang.rexx)
  • Re: Force classic theme and default wallpaper for all users
    ... > I'm sorry for cross-posting this, but I haven't received any responses ... These machines are running XP Pro and are in a ...
    (microsoft.public.windowsxp.general)