Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Does JSP with SQL Server on Windows Make Sense?

 
Mark Frankel
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am writing an application for a well run $20M revenues mail order company with five permanent employees (everything else is outsourced).
I need an easy to administer environment so I am considering SQL Server on a Windows NT Server (SQL Server is much easier to administer than Oracle)
Question Number 1 - Is there are a JSP Server which can be easily administered by end users?
Question Number 2 - If I go with SQL Server I will not be able to port to UNIX platforms thus limiting the cross platform benefits of JAVA and JSP.
Any thoughts and suggestions would be greatly appreciated.
Best Regards
Mark Frankel
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Your JSP code should be portable to any SQL database provided you stick to "standard" SQL and don't go for any proprietary enhancements. Your JSP code should also be portable between servlet/JSP containers provided you stick to the standards there too.
What sort of aadministration of the JSP server are you expecting to have to do? Once set up, JSP is simplicity itself, you just write the JSP files and plop them on the server which takes care of everything else.
 
Mark Frankel
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Frank Carver:
Your JSP code should be portable to any SQL database provided you stick to "standard" SQL and don't go for any proprietary enhancements. Your JSP code should also be portable between servlet/JSP containers provided you stick to the standards there too.
[Question 1]
If I use store procedures, the SQL will not be portable because of the difference between SQL Servers Transaction-SQL and Oracles PL-SQL. If I don't use store procedures, there is a performance hit. [/Question 1]
What sort of aadministration of the JSP server are you expecting to have to do? Once set up, JSP is simplicity itself, you just write the JSP files and plop them on the server which takes care of everything else.

[Question 2]
End users, not programmers will be maintain the server. Is it that easier for non technical people to administer any JSP server. If yes, which ones are the easiest.
[/Question 2]
[Question 3]
Are you or anybody out there using SQL Server with JSP.
[/Question 3]
Thanks for your help
Mark
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you really, really sure about the performance issues with stored procedures? We have a large (tens of thousands of lines) PL/SQL application here, which runs really slowly. We are in the process of rewriting it as pure Java using JDBC and it is much more responsive.
As with any peformance issue, it is vital that you actually test things rather than making assumptions. And a pure-Java/JDBC solution is so much more portable that it is well worth doing if you can.
 
Farooq Ali
Ranch Hand
Posts: 43
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
sorry frank & mark
this might be some what off topic to your discussion...
but is there a pure java or jdbc driver for sql server 2000??
instead of using the jdbc-odbc bridge??
I need to use sql server with my servlet/jsp project as well
farooq
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic