• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

web based sql client

 
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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



 
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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)"
 
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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.
 
Bear Bibeault
Sheriff
Posts: 67746
173
Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
     
    James Reeves
    Greenhorn
    Posts: 4
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    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.
     
    Bear Bibeault
    Sheriff
    Posts: 67746
    173
    Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Yes, I like Tomcat myself, but he doesn't "need" to use it as was implied.
     
    James Reeves
    Greenhorn
    Posts: 4
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Yes I agree

    Sorry I should of worded that sentence better.
     
    Bear Bibeault
    Sheriff
    Posts: 67746
    173
    Mac Mac OS X IntelliJ IDE jQuery TypeScript Java iOS
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    I see you're fairly new... welcome to the Ranch!
     
    Saloon Keeper
    Posts: 7585
    176
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator

    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.
     
    D Tom
    Greenhorn
    Posts: 9
    • Mark post as helpful
    • send pies
      Number of slices to send:
      Optional 'thank-you' note:
    • Quote
    • Report post to moderator
    Thank you all for your replies and the learning material links.
     
    Consider Paul's rocket mass heater.
    reply
      Bookmark Topic Watch Topic
    • New Topic