Hi,
The problem occurs due to no DNS.An entry in winNT\system32\drivers\etc\host fixes
this.
Note that this happens despite the jdbc connection string having an IP address
instead of machine name.
I think this should be fixed.I should be able to use ip addresses only and work
without DNS.
regards,
Ajit
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Monday, January 27, 2003 4:15 PM
To: [EMAIL PROTECTED]
Subject: sapdb.general digest, Vol 1 #788 - 1 msg
Today's Topics:
1. RE: slow connection establishment jdbc (Schroeder, Alexander)
--__--__--
Message: 1
From: "Schroeder, Alexander" <[EMAIL PROTECTED]>
To: "'ajit_cus'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: slow connection establishment jdbc
Date: Mon, 27 Jan 2003 11:51:02 +0100
Hi Ajit,
it must have something to do with the network, and there is no
known problem in that area for JDBC (as the other 'slow connection'
problems do massively affect the query execution time too).
So I can only suggest e.g. making a small Java Server & Client application
and check the speed and reliability of the network connections between
the affected computers, or use other network monitoring/checking/testing
tools if available and appropriate.
Regards
Alexander Schr�der
SAP Labs Berlin
> -----Original Message-----
> From: ajit_cus [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 27, 2003 8:51 AM
> To: [EMAIL PROTECTED]
> Subject: slow connection establishment jdbc
>
>
>
> Hi,
> I'm running sapdb 7.3.0.30 when connecting to from a machine
> on the same lan it takes over 12 secs to get a connection
> however queries execute under 20 ms.What could the problem be.
> It runs fine in another test environment. JDBC ver is
> 7.4.04.00b .Part of jdbc trace follows ..
> regards,
> Ajit
> PS:listserv search is down!!!!
>
> ---- Thread 5a8767 main Timestamp: 2003-01-27 12:20:53.765
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG,
> 7.4.4 Build 000-000-156-685 on Java 1.3.1_02
> new Connection 'jdbc:sapdb://10.48.2.61/mmp'
>
> ---- Thread 6e70c7 Finalizer Timestamp: 2003-01-27 12:21:36.796
> new RTEException: -708 Could not send data.
> whereAmI
> java.lang.Throwable
> at com.sap.dbtech.util.Tracer.whereAmI(Tracer.java:426)
> at
> com.sap.dbtech.rte.comm.RTEException.<init>(RTEException.java:69)
> at
> com.sap.dbtech.rte.comm.SocketComm.sendData(SocketComm.java:732)
> at
> com.sap.dbtech.rte.comm.SocketComm.release(SocketComm.java:620)
> at
> com.sap.dbtech.rte.comm.SocketComm.finalize(SocketComm.java:344)
> at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
> at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:86)
> at java.lang.ref.Finalizer.access$100(Finalizer.java:17)
> at
> java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:163)
>
> ---- Thread 5a8767 main Timestamp: 2003-01-27 12:21:36.906
> using com.sap.dbtech.rte.comm.SocketComm@2a1e44 on
> Socket[addr=OMBCLTEL/10.48.2.61,port=7210,localport=1492]
> => com.sap.dbtech.jdbc.ConnectionSapDB@50a5d9
> [EMAIL PROTECTED] (2)
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG,
> 7.4.4 Build 000-000-156-685 on Java 1.3.1_02
> new Connection 'jdbc:sapdb://10.48.2.61/mmp'
>
> ---- Thread 6e70c7 Finalizer Timestamp: 2003-01-27 12:22:19.968
> new RTEException: -708 Could not send data.
> whereAmI
> java.lang.Throwable
> at com.sap.dbtech.util.Tracer.whereAmI(Tracer.java:426)
> at
> com.sap.dbtech.rte.comm.RTEException.<init>(RTEException.java:69)
> at
> com.sap.dbtech.rte.comm.SocketComm.sendData(SocketComm.java:732)
> at
> com.sap.dbtech.rte.comm.SocketComm.release(SocketComm.java:620)
> at
> com.sap.dbtech.rte.comm.SocketComm.finalize(SocketComm.java:344)
> at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
> at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:86)
> at java.lang.ref.Finalizer.access$100(Finalizer.java:17)
> at
> java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:163)
>
> ---- Thread 5a8767 main Timestamp: 2003-01-27 12:22:19.968
> using com.sap.dbtech.rte.comm.SocketComm@52906a on
> Socket[addr=OMBCLTEL/10.48.2.61,port=7210,localport=1494]
> => com.sap.dbtech.jdbc.ConnectionSapDB@72ffb
> [EMAIL PROTECTED] (2)
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG,
> 7.4.4 Build 000-000-156-685 on Java 1.3.1_02
> new Connection 'jdbc:sapdb://10.48.2.61/mmp'
> using com.sap.dbtech.rte.comm.SocketComm@16a786 on
> Socket[addr=OMBCLTEL/10.48.2.61,port=7210,localport=1496]
> => com.sap.dbtech.jdbc.ConnectionSapDB@507fb2
> [EMAIL PROTECTED] (2)
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG,
> 7.4.4 Build 000-000-156-685 on Java 1.3.1_02
> new Connection 'jdbc:sapdb://10.48.2.61/mmp'
> using com.sap.dbtech.rte.comm.SocketComm@26e85f on
> Socket[addr=OMBCLTEL/10.48.2.61,port=7210,localport=1498]
> => com.sap.dbtech.jdbc.ConnectionSapDB@61f10f
> [EMAIL PROTECTED] (2)
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG,
> 7.4.4 Build 000-000-156-685 on Java 1.3.1_02
> new Connection 'jdbc:sapdb://10.48.2.61/mmp'
> using com.sap.dbtech.rte.comm.SocketComm@916a2 on
> Socket[addr=OMBCLTEL/10.48.2.61,port=7210,localport=1500]
> => com.sap.dbtech.jdbc.ConnectionSapDB@2ce908
> [EMAIL PROTECTED] (2)
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG,
> 7.4.4 Build 000-000-156-685 on Java 1.3.1_02
> new Connection 'jdbc:sapdb://10.48.2.61/mmp'
>
> ---- Thread 6e70c7 Finalizer Timestamp: 2003-01-27 12:25:11.953
> new RTEException: -708 Could not send data.
> whereAmI
> java.lang.Throwable
> at com.sap.dbtech.util.Tracer.whereAmI(Tracer.java:426)
> at
> com.sap.dbtech.rte.comm.RTEException.<init>(RTEException.java:69)
> at
> com.sap.dbtech.rte.comm.SocketComm.sendData(SocketComm.java:732)
> at
> com.sap.dbtech.rte.comm.SocketComm.release(SocketComm.java:620)
> at
> com.sap.dbtech.rte.comm.SocketComm.finalize(SocketComm.java:344)
> at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
> at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:86)
> at java.lang.ref.Finalizer.access$100(Finalizer.java:17)
> at
> java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:163)
> new RTEException: -708 Could not send data.
> whereAmI
> java.lang.Throwable
> at com.sap.dbtech.util.Tracer.whereAmI(Tracer.java:426)
> at
> com.sap.dbtech.rte.comm.RTEException.<init>(RTEException.java:69)
> at
> com.sap.dbtech.rte.comm.SocketComm.sendData(SocketComm.java:732)
> at
> com.sap.dbtech.rte.comm.SocketComm.release(SocketComm.java:620)
> at
> com.sap.dbtech.rte.comm.SocketComm.finalize(SocketComm.java:344)
> at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method)
> at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:86)
> at java.lang.ref.Finalizer.access$100(Finalizer.java:17)
> at
> java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:163)
> new RTEException: -708 Could not send data.
> <More -708 exceptions after this>
>
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
>
--__--__--
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
End of sapdb.general Digest
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
