On 10/11/07, Deepal Jayasinghe <[EMAIL PROTECTED]> wrote:
>
> Hi VF
> > Hi all,
> > I would like to ask u, how can i utilize database connection in my web
> > service. I have one web service with more methods in it. Id like to
> create
> > database connection just once and not with each call (each operation
> works
> > with the same database connection) Is it enough to create this service
> with
> > application scope?
> >
> Well if you deploy the service in application scope and inside the
> following method you can have the DB initialization code and store the
> DB properties in ServiceContext.
>
> public void init(ServiceContext sc){
> //Db handling code goes here
> }
Deepal, If you enable clustering then u might have to mark this property for
filtering.
Which is not a problem, but I thought worth mentioning.
Or there is some other way of doing that. In that way you do not need to
> worry about the scope of the service , you can create the DB once and
> store in AxisService or in ConfigurationContext and access it inside
> your method call. To do that you need to have an implementation of
> "ServiceLifeCycle" interface and you can include that in your
> services.xml as follows. In the above impl write your code to start the
> DB inside the startUp and DB closing steps in side the shutDown method.
Deepal, when is lifecycle methods being called?
What is the relationship between the service scope and the life cycle?
<service class="org.sample.MyServiceLifeCycleImpl">
>
> </service>
>
> Thanks
> Deepal
> > It looks like this:
> >
> > Available services
> > stkdds
> >
> > Service Description : stkdds
> > Service Status : Active
> > Available Operations
> >
> > * getFinishedOrderBin
> > * getOrderInfo
> > * updateOrder
> > * getUserInfo
> > * cancelOrder
> > * updateUser
> > * testOperation
> > * getOrdersOverview
> > * getAllAccountsInfo
> > * getFinishedOrder
> > * getAccountInfo
> > * newOrder
> >
> >
> > And my code for database connection smth like this:
> >
> > public Connection setConnection() throws Exception {
> >
> > if(conn != null){
> > return conn;
> > }
> >
> > Class.forName("org.firebirdsql.jdbc.FBDriver");
> > conn = DriverManager.getConnection (p_connect_string,
> > sqlProps);
> > return conn;
> >
> >
> >
> >
> > Thanks Vladi
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
> >
>
> --
> Thanks,
> Deepal
> ................................................................
> "The highest tower is built one brick at a time"
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
> --
Rajith Attapattu
Red Hat
Blog http://mutlix.blogspot.com/
