web based sql client

Hi experts,

I'm planning to develop a basic web-based SQL client application that can connect to a database server, send SQL statements from the browser to the database server and display the results from the database server in the browser.

I think there should be a 3 - tier architecture. Browser - Application Server - Database Server to accomplish this.

I have knowledge of core java and jdbc, but don't not much about server side programming.

I need guidance as to how to start on this project. What all java server technologies I need to learn at a minimum in order to achieve this?

Thanks in advance.
D Tom

I would look at using JSP/Servlets if you wanted to do this application via Java. I would also look into Spring/Hibernate to use as an interface for the JDBC connections.

You would obviously need to use Tomcat to act as the server you need.

I would recommended reading the following book on the topic "Murach's Java Servlets and JSP: 2nd Edition (Murach: Training & Reference)"

James Reeves wrote:You would obviously need to use Tomcat to act as the server you need.

Tomcat is only one of many Java app containers that could be used.

As a novice to JSP and servlets, I recommend you read these articles:

The Secret Life of JSPs

The Front Man

The first will ensure that you understand what JSP is all about, and the latter discusses properly structuring web applications.

Bear Bibeault wrote:

James Reeves wrote:You would obviously need to use Tomcat to act as the server you need.

Tomcat is only one of many Java app containers that could be used.

Yeah I agree, but I found that Tomcat was easier to use. But I suppose that is down to preference.

Yes, I like Tomcat myself, but he doesn't "need" to use it as was implied.

Yes I agree

Sorry I should of worded that sentence better.

I see you're fairly new... welcome to the Ranch!

James Reeves wrote:I would also look into Spring/Hibernate to use as an interface for the JDBC connections.

Since the point is to create a SQL client that is probably not such a good idea. Straight JDBC would be a good way to transport SQL queries from the web browser to the DB.

Thank you all for your replies and the learning material links.