Hi again,
thank you for your answers. I describe my problem in details.
I have more 11000 users but I think that no more than 1000 will work in the
same time.
I work with DB2 but with SNA protocol. So I access to DB2 with Hit ODBC with
SNA Server to read data.
All the data will be transfered to the informix dynamic server installed on
client machine. Well
I think I will have no problem with informix because I have the Informix
JDBC driver. But for ODBC
I have some doubt because I've read that sun JDBC It's not thread safe and
this is not good for me.
Please, help me. Which type of ODBC work well with ODBC in your experience?
Is there someone that have used SNA server and servlet togheter and know
problems about this environment?
Thank you in advanced.
-----Messaggio originale-----
Da: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]Per conto di Jan
Hendrickx
Inviato: mercoled� 12 luglio 2000 9.05
A: [EMAIL PROTECTED]
Oggetto: Re: JDBC_ODBC THREAD SAFE
Giovanni
1000 concurrent accesses to a database ??? (using ODBC ???)
Hope you won't try SQL server for that. (or access)
Think about the resources a database would need to support 1000 connections
at the same time (memory !!!)
You may might have 1000 concurrent users in your application, but they won't
use the dbase at the same time.
A connection pool could do wonders.
In our applications , we have peak concurrent users at about 500, but peak
dbase connections is about 50.
OK , it all depends on the data in the dbase and the queries you'll do.
Question to all other users : does anyone have an app that uses 1000
connections to a dbase ?
Jan
-----Original Message-----
From: harjit singh [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 11, 2000 21:17
To: [EMAIL PROTECTED]
Subject: Re: JDBC_ODBC THREAD SAFE
Try JDataConnect from softsyn. It is really a good product.....
- Harjit
-----Original Message-----
From: Giovanni Santini SZ3PGQ [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 11, 2000 6:59 AM
To: [EMAIL PROTECTED]
Subject: JDBC_ODBC THREAD SAFE
Hi,
could someone show me any jdbc-odbc product thread safe?
I tryed to use sun's jdbc-odbc with thread but I've met several problem with
more three threads.
We will be able to have 1000 concurrent accesses.
Hello.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
