how to connect jsp with oracle database

There is plenty of documentation on how to do JDBC out on the internet. Especially with connecting to an oracle database.

However, you might want to re-think doing JDBC code inside of a JDBC and instead place that code inside of a servlet.

Regards,

Nate

how to connect oracle in JSP ,while tomcat running and what is type 4 drivers.

You've not done a lot have you?
Any JDBC tutorial or book will tell you how to do your thing.

u can use ODBC driver or OCi driver that can be downloaded from the net. Follow the documentation present in the download to esablish the Connection

u can use ODBC driver or OCi driver that can be downloaded from the net. Follow the documentation present in the download to esablish the Connection

The ODBC driver is not recommended since there are limited features available. Oracle supports a lot more features than what the bridge driver could. The OCI driver requires an Oracle client installation (i.e. native libraries). There is a type 4 driver (pure Java) available for Oracle [classes12.jar or ojdbc.jar depending on the version] which could be used.