Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I access a database from my servlet or JSP?

April 26, 2017database JSP servlet

0

Posted

How do I access a database from my servlet or JSP?

1 Answer

0

Posted

JDBC allows you to write SQL queries as Java Strings, pass them to the database, and get back results that you can parse. To access database from your servlet, make sure JDBC driver for the database you are accessing is accessible to Web Server (Tomcat). For example, in Tomcat to access Oracle database through JDBC driver for Oracle, you need to place classes111.zip (renamed to classess111.jar) or classes12.jar in /WEB-INF/lib directory of the application or /common/lib directory of Tomcat.