CONNECTION OBJECT

I am using RMI to connect my client-app to an Informix Online Dynamic Server 7.2 I have a single connection object which is used (synchronized) by all the clients. I suspect there must be a limitation in requests to the same connection. Each remote method reuses the object for its propose (each creates a new CallableStatement) The question is: Although the connection uses are serialized, is there any problem with this system, or should I use a connection pool?

If everybody is using the same connection object, then utilising transactions would be difficult. ASC wrote in message <36B5C865.5704346@uco.es>... > I am using RMI to connect my client-app to an Informix Online >Dynamic Server 7.2 >I have a single connection object which is used (synchronized) by all >the clients. I suspect there must be a limitation in requests to the >same connection. Each remote method reuses the object for its propose >(each creates a new CallableStatement) The question is: >Although the connection uses are serialized, is there any problem with >this system, or should I use a connection pool? >

Richard Lewis wrote: > If everybody is using the same connection object, then utilising > transactions would be difficult. Actually, the procedures can be called from servlets, each with its own connection. > ASC wrote in message <36B5C865.5704346@uco.es>... > > I am using RMI to connect my client-app to an Informix Online > >Dynamic Server 7.2 > >I have a single connection object which is used (synchronized) by all > >the clients. I suspect there must be a limitation in requests to the > >same connection. Each remote method reuses the object for its propose > >(each creates a new CallableStatement) The question is: > >Although the connection uses are serialized, is there any problem with > >this system, or should I use a connection pool? > >

Alcea Technologies has become the 1st Certified Partner with Informix Canada. Alcea Technologies is one of Ottawa's fastest expanding IT consulting companies due to their outstanding client/consultant relationships. We are presently searching for any and all skilled Informix Professionals to meet our enormous demand. We are looking for you to work throughout Canada and the United States. Alcea Technologies Inc. is an Ottawa based IT consulting company, who opened their doors in April 1997. Our strengths are varied and cover numerous technical fields, including relational technologies such as Oracle, Informix and Sybase experience along with software development. We pride ourselves in having a strong selection of quality consultants whom operate under an open and honest relationship with the company. They have full access to the contracts and a clear mandate on what the client's expectations are when they go into a respective site. Contact us. Help us help you!! -- Charlene S. Hosein Marketing Executive Alcea Technologies Inc. IT Contract and Consulting Firm Ottawa, Canada (613) 798-9835 (613) 798-9836 Fax chosein@alceatech.com http://www.alceatech.com/