Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Tye 2 Driver

 
Uma Korukonda
Greenhorn
Posts: 6
  • 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
  • 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
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank You
 
Uma Korukonda
Greenhorn
Posts: 6
  • 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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic