• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

Regarding accessing oracle

Hi,
I want to develop a website using JSP. I want to access Oracle from my JSP pages. Want to know what are the ways to do it and  which one will be the best.  Also i want know which are freeware in it.

0
pigeon5566
Asked:
pigeon5566
  • 2
  • 2
  • 2
1 Solution
 
pigeon5566Author Commented:
Also i need some good tutorial links for it accessing oracle from JSP pages
0
 
bloodredsunCommented:
Use JSTL. It's by far the easiest way if you are not an expert. See here for an oracle specific example http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jsps/jstlsql.html
0
 
cincin77Commented:
hi,

in my opinion use the connection pooling described in:
http://tomcat.apache.org/tomcat-5.0-doc/jndi-datasource-examples-howto.html

BR..
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
pigeon5566Author Commented:
i am planning to use tomcat only. Can i use jstl in that one.  Is it used only for oracle db.
0
 
cincin77Commented:
jstl has no relation with DBs, oracle , etc.
it is an easy way of writing JSPs.
0
 
bloodredsunCommented:
>>Can i use jstl in that one

Yes, very easily.

>>Is it used only for oracle db.

No, the sql library is only one of the 5 libraries of JSTL (core, xml, format, sql and function)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now