Informix JDBC driver connection keepalive

Posted in 2000

Topics: Connectivity: ODBC / JDBC / .NET, Java & JDBC Development, Versions, Editions & End-of-Life

Darrel Davis — Thu, 20 Apr 2000 17:49:08 -0400 — source: Informix-list mailing list archive (1991-1998)

I have an application that opens a DB connection and keeps it open for the duration of the thread. It passes around the connection and reuses it. We have just moved to Informix IDS 9.12 after having used MySQL type 4 drivers as well as JDBC-ODBC bridge connections. Today I have seen the connection close after a period of time (5 mins) and I am wondering if there is a parameter for the connection that will cause it to stay connected. I'm using the JDBC 2.0 driver under Linux. I chose Informix after having used it quite a bit years ago. I think Oracle's tool set is horrible and IDS is much easier to manage. I went to several book stores today looking for books Informix. None. I guess I'll have to get with Amazon. Any suggestions on an all-encompassing book for IDS 9.x? Any help appreciated. -darrel -- ============================================== Darrel Davis darrel@davisware.net AudioSonix, Inc. darreld@audiosonix.com ==============================================

↪ replying to Darrel Davis

Edward Rosenthal — Mon, 24 Apr 2000 20:11:58 GMT — source: Informix-list mailing list archive (1991-1998)

Object-Relational DBMSs - Michael Stonebraker , Paul Brown published by Morgan Kaufman isbn: 1-55860-452-9 excellent read. Informix Dynamic Server 2000 server side programming in C by Jacques Roy ,Prentice Hall 0-13-013709-x Informix Guide to SQL Tutorial covers the IDS 2000 sql ( informix Press) isbn: 0-13-016165-9 There are a bunch of other books but these are good references to start. Darrel Davis wrote: > I have an application that opens a DB connection and keeps it open > for the duration of the thread. It passes around the connection and > reuses it. We have just moved to Informix IDS 9.12 after having used > MySQL type 4 drivers as well as JDBC-ODBC bridge connections. > > Today I have seen the connection close after a period of time (5 mins) > and I > am wondering if there is a parameter for the connection that will cause > it to stay connected. I'm using the JDBC 2.0 driver under Linux. > > I chose Informix after having used it quite a bit years ago. I think > Oracle's > tool set is horrible and IDS is much easier to manage. I went to > several book > stores today looking for books Informix. None. I guess I'll have to > get with > Amazon. Any suggestions on an all-encompassing book for IDS 9.x? > > Any help appreciated. > > -darrel > -- > ============================================== > Darrel Davis darrel@davisware.net > AudioSonix, Inc. darreld@audiosonix.com > ==============================================

Glossary

IDS (Informix Dynamic Server)