In my application my backend databse is Oracle 8 and webserver is Tomcat So if use Type 1 Driver JDBC ODBC then should I had to install Oracle 8 client in my Tomcat machine or if i use Type 4 Pure Java driver then to should I had to install Oracle 8 client. Regards, aakash.
Hi Aakash, I will try to explain what can be done at your end.. Type 1 JDBC drivers use ODBC to get connected to the database. Since it uses ODBC driver your installation has to be on Microsoft platform. If tomcat is installed on win2k machine then just create a DSN pointing to the Database server and that will take care of all things. But this approach is used only in the development scenario. If the installation is on non-Microsoft platform then you will need to use Type 3 or Type 4 JDBC driver. Type 4 drivers are native net drives and use direct connection to the database. So while connecting to database use net driver and in the database url, mention the database name and port. I am not very much confident about driver 3 but I think that, the application server takes care of getting connected to database. Hope this helps. Rajesh