is sun.jdbc.odbc.JdbcOdbcDriver reliable? 
Author Message
 is sun.jdbc.odbc.JdbcOdbcDriver reliable?

Hi,

I have an application which uses the sun.jdbc.odbc.JdbcOdbcDriver in Java
Servlet to connect to MS SQL/Lotus Notes/whatever ODBC-compliant database.
We haven't yet been able to do any serious stress-testing but I was
wondering if someone has experienced any reliability problems with this
driver? My current implementation in the servlet opens only one DB
connection object and uses it for all incoming requests, is this wise? Is
some sort of collision possible when there are multiple threads due to
simultaneus client requests (that is, should I make things synchronized?).
Also if you happen to have tested MS com.ms.jdbc.odbc.JdbcOdbcDriver I'd be
interested to know some performance facts about that too. Somebody said that
MS version works only in MS environment... I thought ODBC 'standard' was
Windows-only anyway, or is it? All feedback is greatly appreciated,
especially if you can reply to my email address, thanks.

Cheers,
Jarkko



Tue, 06 Nov 2001 03:00:00 GMT
 is sun.jdbc.odbc.JdbcOdbcDriver reliable?

Hi. The jdbc-odbc bridge is not threadsafe, and it is buggy, and unsupported.

Quote:

> Hi,

> I have an application which uses the sun.jdbc.odbc.JdbcOdbcDriver in Java
> Servlet to connect to MS SQL/Lotus Notes/whatever ODBC-compliant database.
> We haven't yet been able to do any serious stress-testing but I was
> wondering if someone has experienced any reliability problems with this
> driver? My current implementation in the servlet opens only one DB
> connection object and uses it for all incoming requests, is this wise? Is
> some sort of collision possible when there are multiple threads due to
> simultaneus client requests (that is, should I make things synchronized?).
> Also if you happen to have tested MS com.ms.jdbc.odbc.JdbcOdbcDriver I'd be
> interested to know some performance facts about that too. Somebody said that
> MS version works only in MS environment... I thought ODBC 'standard' was
> Windows-only anyway, or is it? All feedback is greatly appreciated,
> especially if you can reply to my email address, thanks.

> Cheers,
> Jarkko

--
--------------------------------------------------------------------------------
                    The Weblogic Application Server from BEA
         JavaWorld Editor's Choice Award: Best Web Application Server
  Java Developer's Journal Editor's Choice Award: Best Web Application Server
     Crossroads A-List Award: Rapid Application Development Tools for Java
Intelligent Enterprise RealWare: Best Application Using a Component Architecture
               http://weblogic.beasys.com/press/awards/index.htm


Tue, 06 Nov 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. An error using JDBC with sun.jdbc.odbc.JdbcOdbcDriver

2. Unexpected behaviour of sun.jdbc.odbc.JdbcOdbcDriver

3. how to set the sun.jdbc.odbc.JdbcOdbcDriver

4. Loading sun.jdbc.odbc.JdbcOdbcDriver

5. ClassNotFoundException sun.jdbc.odbc.JdbcOdbcDriver

6. Database connection via sun.jdbc.odbc.JdbcOdbcDriver

7. java.lang.ClassNotFoundException: sun/jdbc/odbc/JdbcOdbcDriver on IE5

8. can't find sun.jdbc.odbc.JdbcOdbcdriver

9. Exception returns sun.jdbc.odbc.JdbcOdbcDriver error

10. Exception: sun.jdbc.odbc.JdbcOdbcDriver ; with VJ++

11. UnsatisfiedLinkError: sun/jdbc/odbc/JdbcOdbcDriver.trusted


 
Powered by phpBB® Forum Software