aspose file tools*
The moose likes JDBC and the fly likes Connection to Database thru JDBC driver is doing a DNS Lookup Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connection to Database thru JDBC driver is doing a DNS Lookup" Watch "Connection to Database thru JDBC driver is doing a DNS Lookup" New topic
Author

Connection to Database thru JDBC driver is doing a DNS Lookup

Anusha verrma
Greenhorn

Joined: May 11, 2006
Posts: 3
I have an application coded in Java which checks the oracle database if any new record is added.
so the line of code for eastablishing the conection is :
java.sql.Connection conn = DriverManager.getConnection ( "jdbc racle:thin:@10.3.7.197:1521 EV", "lot3","lot3" );

the application checks the database every 2 mins for any new records.
everytime the appln tries connecting to the DB, it is doing a DNS lookup. IS there any way to stop this DNS lookup?
the appln is running on AIX Unix machine.
Can anybody please help me?

otherwise, can anybody please tell me whether Connection to Database thru JDBC driver really does a DNS Lookup always....
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

I am not very sure but JDBC driver does not make a DNS look up unless you use a host name in your URL.

The connection string posted by you is using an IP address for creating connection, so I dont think it will be looking for DNS. Might be there is another piece of code is doing DNS lookup.

Is there any problem you are facing because of this

Shailesh
[ May 11, 2006: Message edited by: Shailesh Chandra ]

Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
Anusha verrma
Greenhorn

Joined: May 11, 2006
Posts: 3
Am not facing any problems as such, but clients are finding it as a bug and they don't want it to happen.
so i need to somehow stop this DNS lookup.
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1081

Ok, but how did they identify there is a DNS lookup ? I am not quite sure about it?

Shailesh
Anusha verrma
Greenhorn

Joined: May 11, 2006
Posts: 3
i used this command :
" tcpdump -p dst port 53 "
then, i cud see the number of dns requests being sent.
It can also be found by the log on the dns server.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection to Database thru JDBC driver is doing a DNS Lookup
 
Similar Threads
syntax for connection of jdbc with sql server
embedded derby - doesn't start automatically
connection pooling issue in production environment -
Connection pooling in weblogic8.1
java.sql.SQLException: No suitable driver