how to connect jsp with oracle database
hsharma65
0
Newbie Poster
Recommended Answers
Jump to PostThere 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
Jump to PostYou've not done a lot have you?
Any JDBC tutorial or book will tell you how to do your thing.
All 6 Replies
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.