Fred, You are right about the Type 2 Driver, however:
Correct me if I am wrong, but I thought that a Type 3 Driver is a pure Java driver that translates JDBC calls into a database-independent network protocol, and this protocol is implemented using a middleware server (third party vendor). A Type 4 is a pure Java driver that uses a native protocol to convert JDBC calls into the database server network protocol. Using this type of driver, the application can make direct calls from a Java client to the database. A type 4 driver, is what typically offered by the database vendor. Ellen Klebaner-Reys Data Management Services Inovant - a Visa Solutions Company [EMAIL PROTECTED]/650-432-1746 m/s: 3125-1D -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 10:36 AM Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [DB2EUG] UDB Java connectivity Mike Patterson writes: >I would like to know if I remove the 2 >entries in /etc/services for the JDBC listener if that >will prevent external java applications (one not >running on the same physical machine as the database >server) from connecting via JDBC. It depends on which JDBC driver the Java programs are using. If your programs are using the Type 2 driver, COM.ibm.db2.jdbc.app.DB2Driver, then they will be able to connect without the db2jd server process running. The Type 2 driver uses the same inbound TCP port as any other CLI client, typically port 50000. Disabling the port used by db2jd (or simply killing the db2jd process) will only block connections from Java programs that use the Type 3 JDBC driver, COM.ibm.db2.jdbc.net.DB2Driver, the thin driver which does not require the installation of the DB2 client. If it is your intent to block remote Java programs only, then disabling the db2jd process will accomplish that goal, but only if all local Java programs use the Type 2 driver and all remote Java programs only use the Type 3 exclusively. If a remote program uses the Type 2 driver, then shutting down db2jd will not block connections from those programs. Hope this helps, Fred Sobotka Database Administrator IBM Certified Solutions Expert - DB2 UDB V7.1 Administration for Unix, Windows, and OS/2 CollegeNET, Inc. - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
