• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Tye 2 Driver

 
Uma Korukonda
Greenhorn
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 4968
1
Hibernate Spring Tomcat Server
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank You
 
Uma Korukonda
Greenhorn
Posts: 6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic