Hi,
First, I would like to point the restrictions Access
will place in using standard SQL, when you are
using JDBC or JDBC-ODBC.
You may not have the same flexibility in your SQL as with
SQL server or oracle.
Assuming you know the limitations, you are better off
using ASP, if you are using Access. I am not discouraging
you from using JSP. You can as well persuade to use
SQL server and starting working on JSP.
Working with JDBC/tomcat/JSP is simple, I don't have
any problems in my application.
However, considering the deployment question, we
are still thing of deployment, as you may have to
write scripts to set the datasource (if you are using jdbc-odbc).
-Aswath
>From: Alexandre Bouchard <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: tomcat-user <[EMAIL PROTECTED]>
>Subject: JDBC/ODBC: Technological choice
>Date: Wed, 23 May 2001 20:34:29 -0400
>
>Hello guys
>
> I am building an intranet on a window NT environment. I hate ASP, so I
>decided to use JSP as the server-side language. I chose Tomcat to run my
>JSP
>and I installed it as a IIS plugin.
>
> Now, I have to connect my JSPs with the databases (they use Access --
>ouch! ) I never did that before and I don't know if I should use JDBC I or
>IV. So my questions are:
>
>-first, is it possible to use a JDBC IV sheme with Tomcat
>
>-if so, how is it possible? How is it made? In other words, where can i
>find
>documentation about that?
>
>-why it is recommended to use JDBC IV when dealing with intranet?
>
>-JDBC-ODBC bridge vs JDBC IV: how slower? Which one is simplier to setup?
>
>-Finally, is it difficult to deal with JDBC, to deploy it?
>
>A lot of question, isn't it?
>I would also apreciate if some of you could share their experience of
>building a JDBC/JSP/Tomcat infrastructure.
>
>Thx !
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
