File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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="" target="_blank" rel="nofollow">Use Code Tags!!</a>
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 62756

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:

Hopefully, it helps explain the issue in detail.

[OCA 8 Book] [Blog]
I agree. Here's the link:
subject: Call SQL Script from JSP