JSP front with SQL back...anyone?

[Atom]

I'm getting involved in a project where the boss wants to use Java Server
Pages (jsp), while accessing an SQL database. All of this will be done through
Lotus Notes webpages (domino server)

Is this something possible without any obvious problems?

Any input at all would be greatly appreciated.

A

[edavison]

I checked out a few web pages this moning and it seems that if you are using
the Domino server on a platform that will allow you to create an ODBC connection
to the SQL server then there shouldn't be any problem in doing that.

I saw that Domino has a servlet container and that you can use GNU JSP (http://www.keysolutions.com/NotesFAQ/howgnu.html)
to help run JSP pages or you could probably use something like JRun by Allaire
instead.

Anyway, once the system is set up you should be able to build new JSP pages
as normal and access the database from a JDBC driver for SQL.

I hope that I gave you some information that was helpful.

Eric

"Atom" <atomgage@hotmail.com> wrote:
>
>I'm getting involved in a project where the boss wants to use Java Server
>Pages (jsp), while accessing an SQL database. All of this will be done
through
>Lotus Notes webpages (domino server)
>
>Is this something possible without any obvious problems?
>
>Any input at all would be greatly appreciated.
>
>A