Hi Joe,
Appreciate you insight into and experience with
the IDC drivers. Good feedback.
OTOH, your comment:
> . . . you're moving into the Java native interface
> with ODBC calls, something bound to be able to
> cause a crash on Windows . . ."
Seems more like FUD raking.
Many millions of people have used ODBC since it's
release in 1991, and with great success. Few if any
experience the daily "crashes" you allude to due to
ODBC use.
To be honest, the real problem is in the thread management
issues between JAVA and the native OS, especially in that
SUN has stated that the JDBC-ODBC Bridge driver is known
to have been implemented with thread issues, namely that it
does not deal with the mangement issues of mulitple users
interacting with ODBC correctly.
Rather than foster one-sided political issues regarding OS
choice, it may be better if we focus on solving problems for
people with real issues in this forum.
Then again, maybe I just read your comments in a bad mood
and mis-interpreted their intent. If so, I appologize. I have
been down with the flu for a few days, and do not feel so well.
Thanks again for your other valuable contributions to this
forum, and support for JSP and JDBC.
Art
-----Original Message-----
From: Joe Shevland <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, January 09, 2000 2:47 PM
Subject: Re: JRUN-MS Access connection question
>See:
>
>http://java.sun.com/products/jdbc/drivers.html
>
>I used the IDS drivers for SQL Server once a while
>back and they worked nicely, I'm not sure how they
>would work with Access but I think you can
>get an eval. Anyway, there were a lot more there
>at a glance that supported MS Access.
>
>JVM crashing, well you're moving into the
>Java native interface with ODBC calls, something
>bound to be able to cause a crash on Windows :L
>That and also inhaling can cause Windows to crash.
>
>Servlets are multithreaded unless you use
>the SingleThreadedModel, otherwise you
>may be able to use a single server type
>beast to talk to the database on behalf of the
>servlets... you're using Access so I take it
>you're requirements are not large.
>
>Regards,
>Joe.
>
>
>----- Original Message -----
>From: "Greg Ames" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Sunday, January 09, 2000 9:42 AM
>Subject: JRUN-MS Access connection question
>
>
>> We are using JRUN 2.3.3 and are trying to connect to a Microsoft Access
>> Database. We are using Java 1.2 and Windows NT 4.0. We have tried:
>>
>> Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
>> Connection con =
>DriverManager.getConnection( "jdbc:odbc:WadeTest" );
>>
>> If we just retrieve data, everything seems fine. If we update, or
insert,
>> Dr. Watson is called about every 3d time, and JRUN dies. We had similar
>> problems with Oracle until we used their JDBC driver. A discussion on
>> Alliare's site indicated that the JDBC:ODBC driver was not thread safe
and
>> that would be problematic with Servlets.
>>
>> http://www.allaire.com/Handlers/index.cfm?ID=12409&Method=Full
>>
>> http://java.sun.com/products/jdbc/faq.html#20
>>
>>
>> Is there an alternative driver that works with MS Access. We could
switch
>> to the MS Java, and the problem would go away, but we also kiss off
>> portability. (Not a good choice as we are using 1.2 features.) I once
>> thought there was nothing I should be able to do to crash Java, but I was
>> wrong. Am I really the only person having this problem? Any help or
>> guidance would be appreciated.
>>
>> Greg
>>
>>
>===========================================================================
>> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>> FAQs on JSP can be found at:
>> http://java.sun.com/products/jsp/faq.html
>> http://www.esperanto.org.nz/jsp/jspfaq.html
>>
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
>FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
