> -first, is it possible to use a JDBC IV sheme with Tomcat
Yes.
> -if so, how is it possible? How is it made?
The same way you use any JDBC implementation.
> In other words, where can i find documentation about that?
The obvious place would be Sun's JDBC home page:
http://java.sun.com/products/jdbc/
You should also check the home page of your JDBC implementation's vendor
(e.g., www.oracle.com .)
> -why it is recommended to use JDBC IV when dealing with intranet?
Type 1 and 2 generally require direct access to the database (i.e., that
it's sitting on your own computer); and types 1 through 3 use JNI (which may
be restricted by "sandbox" permissions).
> -JDBC-ODBC bridge vs JDBC IV: how slower? Which one is
> simplier to setup?
Sun's JDBC-ODBC isn't supported for production environments. Your best bet
is to use the vendor's own JDBC implementation (if available), or a
third-party's.
> -Finally, is it difficult to deal with JDBC, to deploy it?
No more than any Java code, especially with a type 4 driver.
-- Bill K.
> -----Original Message-----
> From: Alexandre Bouchard [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 23, 2001 5:34 PM
> To: tomcat-user
> Subject: JDBC/ODBC: Technological choice
>
>
> 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 !
>
