how to connect jsp with oracle database
hsharma65 0 Newbie Poster
hooknc 1 Posting Whiz in Training
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
hsharma65 0 Newbie Poster
thanx
chubby 0 Newbie Poster
how to connect oracle in JSP ,while tomcat running and what is type 4 drivers.
jwenting 1,889 duckman Team Colleague
You've not done a lot have you?
Any JDBC tutorial or book will tell you how to do your thing.
ponloges 0 Newbie Poster
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
aniseed 38 Posting Whiz
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.