Thank you Sagara, If I implement the ServiceLifeCycle interface, can you give me a simple example of how I would access the connection from a POJO, and how the startup method saves the connection to a parameter, please.
Many regards, John. John Wilkinson. Product Engineer. ----x-y-r-a-t-e-x---- e-mail: john_wilkin...@xyratex.com Tel: +44 (0)2392 6225 Mobile: +44 (0)7810 497152 -----Original Message----- From: Sagara Gunathunga [mailto:sagara.gunathu...@gmail.com] Sent: 23 September 2009 09:41 To: axis-user@ws.apache.org Subject: Re: persistance using POJO's This is also possible by implementing ServiceLifeCycle interface [1], it contains two methods called startUp (..) and shutDown(..) that can be used to open db connection at service deployment time and close at db connection at system shut down time. So you can use startUp (..) method to open the db connection and set it as a parameter in AxisService. Once you have a implementation class you can define it using "class" attribute on service.xml file as follows . <service name="MyServiceName" class="MyServiceLifeCycleImpl" > [1] - http://ws.apache.org/axis2/1_4_1/api/org/apache/axis2/engine/ServiceLifeCycle.html Thanks, On Wed, Sep 23, 2009 at 1:48 PM, Upul Godage <upulg....@gmail.com> wrote: > Hi, > > You should use a database connection pooling of some sort. > > http://onjava.com/pub/a/onjava/2006/04/19/database-connection-pooling-with-tomcat.html > > Upul > > On Wed, Sep 23, 2009 at 1:41 PM, John Wilkinson > <john_wilkin...@xyratex.com> wrote: >> Hi, >> >> I wish to have my service persist POJO's to a postgresql database. >> >> >> >> Every time I call a service, do I need to connect to a database, and then >> at the end close the connection. Or is there a way to open the connection >> when the service is first called, and then close when I stop using the >> service, say by a method call? >> >> >> >> >> >> Many regards, >> >> John. >> >> >> >> >> >> ______________________________________________________________________ >> This email may contain privileged or confidential information, which should >> only be used for the purpose for which it was sent by Xyratex. No further >> rights or licenses are granted to use such information. If you are not the >> intended recipient of this message, please notify the sender by return and >> delete it. You may not use, copy, disclose or rely on the information >> contained in it. >> >> Internet email is susceptible to data corruption, interception and >> unauthorised amendment for which Xyratex does not accept liability. While we >> have taken reasonable precautions to ensure that this email is free of >> viruses, Xyratex does not accept liability for the presence of any computer >> viruses in this email, nor for any losses caused as a result of viruses. >> >> Xyratex Technology Limited (03134912), Registered in England & Wales, >> Registered Office, Langstone Road, Havant, Hampshire, PO9 1SA. >> >> The Xyratex group of companies also includes, Xyratex Ltd, registered in >> Bermuda, Xyratex International Inc, registered in California, Xyratex >> (Malaysia) Sdn Bhd registered in Malaysia, Xyratex Technology (Wuxi) Co Ltd >> registered in The People's Republic of China and Xyratex Japan Limited >> registered in Japan. >> ______________________________________________________________________ >> > > > > -- > http://upulgodage.com > -- Sagara Gunathunga Blog - http://ssagara.blogspot.com Web - http://people.apache.org/~sagara/ ______________________________________________________________________ This email may contain privileged or confidential information, which should only be used for the purpose for which it was sent by Xyratex. No further rights or licenses are granted to use such information. If you are not the intended recipient of this message, please notify the sender by return and delete it. You may not use, copy, disclose or rely on the information contained in it. Internet email is susceptible to data corruption, interception and unauthorised amendment for which Xyratex does not accept liability. While we have taken reasonable precautions to ensure that this email is free of viruses, Xyratex does not accept liability for the presence of any computer viruses in this email, nor for any losses caused as a result of viruses. Xyratex Technology Limited (03134912), Registered in England & Wales, Registered Office, Langstone Road, Havant, Hampshire, PO9 1SA. The Xyratex group of companies also includes, Xyratex Ltd, registered in Bermuda, Xyratex International Inc, registered in California, Xyratex (Malaysia) Sdn Bhd registered in Malaysia, Xyratex Technology (Wuxi) Co Ltd registered in The People's Republic of China and Xyratex Japan Limited registered in Japan. ______________________________________________________________________
