File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes JDBC Tye 2 Driver Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Tye 2 Driver" Watch "JDBC Tye 2 Driver" New topic
Author

JDBC Tye 2 Driver

Uma Korukonda
Greenhorn

Joined: Sep 29, 2007
Posts: 6
Ihave DB2 8.2 installed on remote Database Server and have jdbc cliet jars on a client machine. In this scenario can I access/query remote DB2 from client jars?
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968

You can use the db2 net client driver to access the database remotely, although I rarely see that in production.

Usually, the db2 client application is installed on the remote machine. I think it used to be called db2connect, but it's been rebranded. When that's installed, you connect locally to db2connect, as though it were a local database. Then, db2connect takes care of the network communication in a reliable manner that maintains all XA transaction semantics.

-Cameron McKenzie
Uma Korukonda
Greenhorn

Joined: Sep 29, 2007
Posts: 6
Thank You
Uma Korukonda
Greenhorn

Joined: Sep 29, 2007
Posts: 6
So if we can use Remote DB having client jars on local machine , then what will the connection URL?I mean where do we need to mention the Remote DB host name in the Connection URL String in JDBC program?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JDBC Tye 2 Driver
 
Similar Threads
Problem with the JDBC driver.
How to connect to remote Database Using IPAddress
Works with JDBC/ODBC but not Direct JDBC
Jar file for DB2 Connection?
Uncommitted transaction state