Hi, this might not only be a problem for your client resolving the servers IP from a hostname....even if you just use the IP instead of the hostname these DNS timeouts may also happen because your server is unable to do a reverse name lookup (ip to host) to get the hostname of the client. I don't know if the SAPDB server does this, but its possible.
Greetings, Marco ----- Original Message ----- From: "ajit_cus" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 12:37 PM Subject: slow connection establishment jdbc > > 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 > > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
