type 4 driver syntax and how to connect to oracle with type 4 drivers
i have just been throught the oracle site that it supports type 4 connectivity. so someone please guide me how to connect to oracle from a jsp page using type 4 drivers. do i have to look for some jar files in the pracle 9 installation that i need to specify in the classpath or is there a different approach to this scenario. please guide. thank you
[357 byte] By [
mihirdm] at [2007-9-30 20:41:31]
If you're using JSPs in a Web app, the correct way to do it is to put the Oracle ojdbc14.jar in your Web app's WEB-INF/lib directory. Consult your servlet/JSP engine's docs on how to set up a JNDI data source so you can take advantage of its database connection pooling support.%
No, ojdbc14.jar does not come with the default installation. You can download it here once you're registered:
http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.html
The URL string has this format - consult your docs from now on:
jdbc:oracle:thin:@host:1521:sid
%
> No, ojdbc14.jar does not come with the default> installation. It certainly comes with some installation because I have it and I never downloaded it.One probably has to check a box on the install screen. It might only be on the client install as well.
> It certainly comes with some installation because I have it and I never downloaded it.
I misspoke, obviously. I've ONLY had access to the Oracle JDBC driver in my role as a client. I've never been an Oracle DBA, so I've never done an install. Bad extrapolation. Thanks for correcting me, Joe.
%
