Re: JDBC connections
With Access, AFAIK, you are going to need the ODBC Bridge driver (That would imply establishing a system DSN on the ODBC options and using the bridge driver just search the web) For SQL Server, use the lastest version of jTDS at http://jtds.sf.net Nelson, Jerry W, Contractor 146CF, SCB escribió: That would Microsoft Access and Microsoft SQL. //SIGNED// Jerry Nelson PS, I can't receive attachments unless you rename them. -Original Message- From: John Villar [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 1:39 PM To: Tomcat Users List Subject: Re: JDBC connections You need a JDBC driver for your selected DBMS Nelson, Jerry W, Contractor 146CF, SCB escribió: What do I need to download to establish/create a JDBC connection? //SIGNED// Jerry Nelson -- John Villar Gerente de Proyectos Computadores Flor Hard Soft 2058 C.A. www.florhard.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBC connections
You should be able to use the standard sun.jdbc.odbc.JdbcOdbcDriver class to connect to those DMBS's. Robert S. Harper 801.265.8800 ex. 255 > -Original Message- > From: Nelson, Jerry W, Contractor 146CF, SCB > [mailto:[EMAIL PROTECTED] > Sent: Friday, August 27, 2004 2:39 PM > To: 'Tomcat Users List' > Subject: RE: JDBC connections > > That would Microsoft Access and Microsoft SQL. > > //SIGNED// > > Jerry Nelson > > PS, > I can't receive attachments unless you rename them. > > -Original Message- > From: John Villar [mailto:[EMAIL PROTECTED] > Sent: Friday, August 27, 2004 1:39 PM > To: Tomcat Users List > Subject: Re: JDBC connections > > > You need a JDBC driver for your selected DBMS > > Nelson, Jerry W, Contractor 146CF, SCB escribió: > > >What do I need to download to establish/create a JDBC connection? > > > >//SIGNED// > > > >Jerry Nelson > > > > > > > > > > -- > John Villar > Gerente de Proyectos > Computadores Flor Hard Soft 2058 C.A. > www.florhard.com > > > > - > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: JDBC connections
That would Microsoft Access and Microsoft SQL. //SIGNED// Jerry Nelson PS, I can't receive attachments unless you rename them. -Original Message- From: John Villar [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 1:39 PM To: Tomcat Users List Subject: Re: JDBC connections You need a JDBC driver for your selected DBMS Nelson, Jerry W, Contractor 146CF, SCB escribió: >What do I need to download to establish/create a JDBC connection? > >//SIGNED// > >Jerry Nelson > > > > -- John Villar Gerente de Proyectos Computadores Flor Hard Soft 2058 C.A. www.florhard.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JDBC connections
You need a JDBC driver for your selected DBMS Nelson, Jerry W, Contractor 146CF, SCB escribió: What do I need to download to establish/create a JDBC connection? //SIGNED// Jerry Nelson -- John Villar Gerente de Proyectos Computadores Flor Hard Soft 2058 C.A. www.florhard.com - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: (JDBC Connections (was: Content Type)
epyonne, What is Tomcat's limitation on multiple connection to database? Tomcat has no limit on DB connections. Unless you are using a Realm, Tomcat does not have any control over db connections. I have a simple servlet application that connects to Oracle database for data. Since it is a very simple application, no connection pooling is used. Someone raised a question on whether Tomcat can handle hundreds of calls to the servlets and hundreds of connections to the Oracle database. Again, Tomcat doesn't care. The VM may care, though. Especially with Oracle, JDBC connections take a long time to establish and use of a lot of memory on the server, and often the client. You should use connection pooling for a number of reasons: 1. Performance (re-using connections takes less time than creating more) 2. Resource limiting (pool limits the number of total connections) 3. Configuration (easier to manage a connection pool than code to create connections on the fly and make sure they are closed/managed appropriately) -chris - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: JDBC Connections
> "s" == sibendud <[EMAIL PROTECTED]> writes: s> Hi, I feel its better to be used only when necessary and s> released as soon as possible. Best regards Sib I would qualify this advice by adding "only when using DB connection pools". The overhead in making and breaking DB connections is considerable. -- Gary Lawrence Murphy <[EMAIL PROTECTED]> TeleDynamics Communications Inc Business Innovations Through Open Source Systems: http://www.teledyn.com "Computers are useless. They can only give you answers."(Pablo Picasso)
RE: JDBC Connections
Mathew, It's been my experience to only use it when necessary and release it back to the pool when done. Otherwise, it is redundant to have a pool to being with. The pool's power comes in its management of "available" connections, if you minimize the available connections, the pool will try to grow and eventually lose it's effectiveness. You will also experience a performance hit for it. Persistance layer implementaions rely on that principal in managing its connection pool. Paulo Pereira Java/Web Developer Sentricity Inc., A Division of Sentex Communications Corp., www.sentricity.com -Original Message- From: Mathew Clark [mailto:[EMAIL PROTECTED]] Sent: Monday, May 28, 2001 11:38 AM To: [EMAIL PROTECTED] Subject: JDBC Connections Hi, We have implemented a simple JDBC connection pool for our servlet - do you think it is better to grab a connection once when a request is received and use that connection throughout the processing or should the connection be used only when necessary and released as soon as possible?? Regards, Matthew.
Re: JDBC Connections
Hi, I feel its better to be used only when necessary and released as soon as possible. Best regards Sib "Mathew Clark" <[EMAIL PROTECTED]> on 05/28/2001 10:07:34 PM Please respond to [EMAIL PROTECTED] To: <[EMAIL PROTECTED]> cc: Subject: JDBC Connections Hi, We have implemented a simple JDBC connection pool for our servlet - do you think it is better to grab a connection once when a request is received and use that connection throughout the processing or should the connection be used only when necessary and released as soon as possible?? Regards, Matthew.
RE: JDBC Connections
Your problem is that your session object (holding the connection) is not being notified when the session is dropped. nb, when a user closes a browser is not when the session will be dropped. You'll have to add i) a time out to the session (say 10 minutes?) and ii) give the user a logout button so that they can logout cleanly and promptly. See the Servlet specs for more details. An object in the session scope can request to be notified of when it is removed from the session (usually because the session is being closed down). Take a look at javax.servlet.http.HttpSessionBindingListener, it is an interface with 2 methods on it. Just make your object implement this interface and the bind/unbind method will be called when the object is added to the session/removed from the session respectively. Using these notifications your object will be able to open/close the database connection. Warning. If you're holding a connection open for such a long time, make sure that you're not locking any tables in the database between user requests otherwise the scaleable performance of the web site will drastically suffer. - Chris Brainbench MVP Java2. > -Original Message- > From: Raffaele Carlà [mailto:[EMAIL PROTECTED]] > Sent: 16 March 2001 13:15 > To: [EMAIL PROTECTED] > Subject: JDBC Connections > > > Can anyone help me? I have: > - SCO UnixWare 7.1.1 > - Informix Online 9.20 and JDBC 2.0 > - JDK 1.2.2 > - Tomcat 3.2.1 > When a make a JDBC connection to the DBMS with a JavaBean > (scope=session) > and i close the browser, the connection remain up and it will > go down only > after several hours. > How can i do to set up a connection that dies when i close > the browser? > Thank you. > >