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: 63844

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] [About Bear] [Books by Bear]
Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3753

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
It's not a secret anymore!