Hi John,
Can you try for this ...
In your ServiceLifeCycle implementation class open and close the db
connection as follows.
Class MyServiceLifeCycle implements ServiceLifeCycle {
public void startUp(ConfigurationContext arg0, AxisService service) {
Connection conn=null;
// Open the DB connection as usual.
//set Connection object as a Parameter
service.addParameter("dbConnection", conn);
}
public void shutDown(ConfigurationContext arg0, AxisService service) {
//get DB Connection from the service
Connection conn=(Connection)service.getParameter("dbConnection");
//close the DB Connection
......................................
}
}
Then in your web service method you can access to above DB Connection
as follows .
public XXXX myServiceMethod(){
// get DB Connection
AxisService service=MessageContext.getCurrentMessageContext().getAxisService();
Connection conn=(Connection)service.getParameter("dbConnection");
}
HTH
Thanks ,
On Wed, Sep 23, 2009 at 4:25 PM, John Wilkinson
<[email protected]> wrote:
> 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: [email protected]
> Tel: +44 (0)2392 6225
> Mobile: +44 (0)7810 497152
> -----Original Message-----
> From: Sagara Gunathunga [mailto:[email protected]]
> Sent: 23 September 2009 09:41
> To: [email protected]
> 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 <[email protected]> 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
>> <[email protected]> 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.
> ______________________________________________________________________
>
--
Sagara Gunathunga
Blog - http://ssagara.blogspot.com
Web - http://people.apache.org/~sagara/
