----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
> I am trying to retrieve info from an MS-Access database through a servlet
> using JDBC-ODBC. I have simple test servlets working ( that don't talk to a
> db); I have a non-servlet Java class that can talk to the database. When I
> try essentially the same code in the Servlet, I get an access violation from
> java.exe.
I spent quite some time trying to get JDBC-ODBC with MS Acces working
properly within
Servlets and RMI servers. It won't. The JDBC-ODBC bridge is riddled with
bugs, it's not thread
safe (>= JDK 1.2) unless the ODBC driver is and it destabilises the JVM.
Using JDK 1.1 things weren't
too bad though I got JVM crashes at least once a day. Moving to JDK 1.2
my RMI servers or Servlets
wouldn't stay up more than a few minutes and some wouldn't even get past
the first call to the database
before the JVM crashed. I found that not using any PreparedStatement's
improved things a little. In
the end I gave up on Access and JDBC-ODBC and switched to a different
database, all the crashes stopped
and I could get on an turn my prototype into commercial grade software.
Even if you get the system
running reliably (I'd eat my hat if you did) you'll be plagued with
"Function sequence" errors and the like.
Moral of the story? Don't bother with JDBC-ODBC and Access with JDK 1.2
or JDK 1.3. Use something else, perhaps
Postgres or Interbase (when it goes open source).
andy s.
P.S. I was using NT 4, dual processor and tried JDBC-ODBC with JDK 1.3
RC1, JDK 1.2.2, JDK 1.2.1 and JDK 1.1.
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
