A small note to everyone, if you didn't know, the JDBC-ODBC bridge from Sun
is BETA and unsupported. Not multithreaded (which is why it is crashing)
and only supports one result set per connection. See Sun's JDBC Java page
for more information. If you plan to deploy anything, use mySQL, oracle
(It's free for dev) or buy a real driver. BTW, access doesn't scale very
well.
-----Original Message-----
From: Robert Wohleb [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 12, 2001 3:49 PM
To: [EMAIL PROTECTED]
Subject: Re: Tomcat Crashing
I agree with Jon; get mysql. Your problem might be caused by a bad dll
somewhere os\r buggy software in the JDBC-ODBC bridge. Problems with
dlls cause huge memry leaks and weird crashes like you are experiencing.
~Rob
Jon Baer wrote:
>
> Sounds like an ODBC/SQL database problem, you should not use JDBC-ODBC
bridge.
>
> I would download MySQL (free):
> http://www.mysql.net
>
> And use the JDBC API for it (Type IV):
> http://www.mysql.net/downloads/api-jdbc.html
>
> - Jon
>
> Suleyman Serkan GURDAL wrote:
>
> > Hello;
> >
> > We are 4th year students who are studying at Middle East Technical
> > University, in the department of Computer Engineering. We are
> > developing a senior design project named web-based seat reservation
> > system for large and distributed computer laboratory
> > environments. We are using the following software;
> >
> > Java Servlets Technology
> > Jdk 1.2.2
> > JDBC Api
> > MS Access
> > JDBC-ODBC Bridge Driver
> > Tomcat (as servlet engine)
> > Apache (as web-server)
> >
> > We have a problem. When we run our servlets by using Tomcat.
> > It crashes down after 4-5 process, like querying the database, updating
> > some records or inserting some records, that is it crashes down after
2-3
> > minutes.
> >
> > When we look at the log messages, because we have caught SQLExceptions
> > we get "Function Sequence Error" or no error messages. We could not
> > understand the problem source.
> >
> > We ask u for help. If you can help us or tell somethings what can be
the
> > problem about, we will be very grateful.
> >
> > Thanks in advance...
> >
> > S. Serkan GURDAL
> > mail : [EMAIL PROTECTED]
> > url : www.ceng.metu.edu.tr/~e109746
> >
> > Department of Computer Enginnering
> > Middle East Technical University
> > Ankara/TURKEY
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, email: [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, email: [EMAIL PROTECTED]
--
_______________________________________
Robert Wohleb
Web Applications Development Manager
Parafoil Software, Inc.
_______________________________________
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]