jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Call SQL Script from JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Call SQL Script from JSP" Watch "Call SQL Script from JSP" New topic

Call SQL Script from JSP

Albert Hopkins

Joined: Jul 21, 2007
Posts: 21
I have a sql script called student.sql .

How can I call that script directly using JSP.

Example : Query = student.sql;


p.s : I hope I'm in the right topic.
Tom Johnson
Ranch Hand

Joined: May 11, 2005
Posts: 142
I had a look at the JSTL sql tags and couldnt see anything how to do this. Possibly the reason is you shouldnt! Better not to have this sort of thing in JSP. I would recommend putting the database access in a business logic code i.e. a java class....

<a href="http://faq.javaranch.com/java/UseCodeTags" target="_blank" rel="nofollow">Use Code Tags!!</a>
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63225

Tom has it correct. A JSP is no place to be doing SQL access. Write this as a standalone Java class that you could trigger from a JSP if necessary, but do not perform database access in UI classes or JSPs.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3740

This post (along with many like it) inspired me to write a blog article about why adding JDBC to JSP is really bad: http://www.selikoff.net/blog/2009/02/24/why-jdbc-jsp-bad/

Hopefully, it helps explain the issue in detail.

[OCA 8 Book] [Blog]
I agree. Here's the link: http://aspose.com/file-tools
subject: Call SQL Script from JSP
jQuery in Action, 3rd edition