You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Amit Handa (JIRA)" <de...@db.apache.org> on 2005/03/29 08:30:18 UTC

[jira] Created: (DERBY-187) Starting derby network server as a service in Win OS

Starting derby network server as a service in Win OS
----------------------------------------------------

Key: DERBY-187
URL: http://issues.apache.org/jira/browse/DERBY-187
Project: Derby
Type: New Feature
Components: Services
Versions: 10.0.2.1
Environment: OS will be only any flavour of Windows.
Reporter: Amit Handa
Priority: Minor

The Derby Network Server Database could be started/stopped as a service in Windows OS.
This may involve updating the win registry. Further work needs to be done to understand what all will it require to do such a thing.

I am putting below Andrew McIntyre's comments if they can help in getting a solution to this problem.

If you would like to see this functionality added, please add a JIRA entry for it. The easiest way to do this would be to provide a registry key file for Derby Network Server and provide instructions on how to install it as a Windows service using instsrv and srvany. However, we obviously can't redistribute those two utilities, but it would be nice to provide all the parts to the solution. So, a little searching turned up this public domain srvany replacement:

http://iain.cx/src/nssm/

I haven't tried it, but I suggest trying it out to see how well it works.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira

Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS

Posted by Mamta Satoor <ms...@gmail.com>.

Hi,

I have been looking at making Network Server available as a Windows service. 

According to Apache Daemons project, I should use procrun to make a
java application as a windows service. But I haven't been able to
locate the procrun exectable, After little research on the web, I
found that in the absence of procrun executable on Windows, people
have been using tomcat to install their java applications as a
service. I will start investigating into it but if someone has any
input on this, please post it to the list. It will certainly help the
ball rolling on this issue.

thanks,
Mamta

On 4/12/05, Mamta Satoor <ms...@gmail.com> wrote:
> Hi,
> 
> I have been looking around on the Jakarta Commons Daemon page
> (http://jakarta.apache.org/commons/daemon/) to find out how a java
> application can be installed as a service on Windows. The page talks
> about using procrun for Win32 platforms but I see no binaries for the
> utility. The site has binaries page but nothing for Windows platform.
> 
> I looked around a little bit on the web to find out more about procrun
> but have only encountered some success stories about other 2 products
> in the area namely
> 1)JavaService by ObjectWeb Open Source Middleware javaservice.objectweb.org
> 2)Java Service Wrapper by Tanuki Software
> http://wrapper.tanukisoftware.org/doc/english/introduction.html
> 
> I have no idea about the licensing terms of the 2 products above but
> in the absence of generally available binaries for Jakarta Common
> Daemon project for Windows, it seems like we might need to look at
> other options.
> 
> If anybody knows more about this, please send in your thoughts. In the
> mean time I will explore JavaService and Java Service Wrapper.
> 
> Mamta
> 
> On 3/28/05, Samuel Andrew McIntyre (JIRA) <de...@db.apache.org> wrote:
> >     [ http://issues.apache.org/jira/browse/DERBY-187?page=comments#action_61703 ]
> >
> > Samuel Andrew McIntyre commented on DERBY-187:
> > ----------------------------------------------
> >
> > Another, probably better solution than my previous suggestion would be one based around the Jakarta Commons Daemon project, which lives here:
> >
> > http://jakarta.apache.org/commons/daemon/
> >
> > andrew
> >
> > > Starting derby network server as a service in Win OS
> > > ----------------------------------------------------
> > >
> > >          Key: DERBY-187
> > >          URL: http://issues.apache.org/jira/browse/DERBY-187
> > >      Project: Derby
> > >         Type: New Feature
> > >   Components: Services
> > >     Versions: 10.0.2.1
> > >  Environment: OS will be only any flavour of Windows.
> > >     Reporter: Amit Handa
> > >     Priority: Minor
> >
> > >
> > > The Derby Network Server Database could be started/stopped as a service in Windows OS.
> > > This may involve updating the win registry. Further work needs to be done to understand what all will it require to do such a thing.
> > > I am putting below Andrew McIntyre's comments if they can help in getting a solution to this problem.
> > > If you would like to see this functionality added, please add a JIRA entry for it.  The easiest way to do this would be to provide a registry key file for Derby Network Server and provide instructions on how to install it as a Windows service using instsrv and srvany. However, we obviously can't redistribute those two utilities, but it would be nice to provide all the parts to the solution. So, a little searching turned up this public domain srvany replacement:
> > > http://iain.cx/src/nssm/
> > > I haven't tried it, but I suggest trying it out to see how well it works.
> >
> > --
> > This message is automatically generated by JIRA.
> > -
> > If you think it was sent incorrectly contact one of the administrators:
> >   http://issues.apache.org/jira/secure/Administrators.jspa
> > -
> > If you want more information on JIRA, or have a bug to report see:
> >   http://www.atlassian.com/software/jira
> >
> >
>

Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS

Posted by Mamta Satoor <ms...@gmail.com>.

Hi,

I have been looking around on the Jakarta Commons Daemon page
(http://jakarta.apache.org/commons/daemon/) to find out how a java
application can be installed as a service on Windows. The page talks
about using procrun for Win32 platforms but I see no binaries for the
utility. The site has binaries page but nothing for Windows platform.

I looked around a little bit on the web to find out more about procrun
but have only encountered some success stories about other 2 products
in the area namely
1)JavaService by ObjectWeb Open Source Middleware javaservice.objectweb.org 
2)Java Service Wrapper by Tanuki Software
http://wrapper.tanukisoftware.org/doc/english/introduction.html

I have no idea about the licensing terms of the 2 products above but
in the absence of generally available binaries for Jakarta Common
Daemon project for Windows, it seems like we might need to look at
other options.

If anybody knows more about this, please send in your thoughts. In the
mean time I will explore JavaService and Java Service Wrapper.

Mamta

On 3/28/05, Samuel Andrew McIntyre (JIRA) <de...@db.apache.org> wrote:
>     [ http://issues.apache.org/jira/browse/DERBY-187?page=comments#action_61703 ]
> 
> Samuel Andrew McIntyre commented on DERBY-187:
> ----------------------------------------------
> 
> Another, probably better solution than my previous suggestion would be one based around the Jakarta Commons Daemon project, which lives here:
> 
> http://jakarta.apache.org/commons/daemon/
> 
> andrew
> 
> > Starting derby network server as a service in Win OS
> > ----------------------------------------------------
> >
> >          Key: DERBY-187
> >          URL: http://issues.apache.org/jira/browse/DERBY-187
> >      Project: Derby
> >         Type: New Feature
> >   Components: Services
> >     Versions: 10.0.2.1
> >  Environment: OS will be only any flavour of Windows.
> >     Reporter: Amit Handa
> >     Priority: Minor
> 
> >
> > The Derby Network Server Database could be started/stopped as a service in Windows OS.
> > This may involve updating the win registry. Further work needs to be done to understand what all will it require to do such a thing.
> > I am putting below Andrew McIntyre's comments if they can help in getting a solution to this problem.
> > If you would like to see this functionality added, please add a JIRA entry for it.  The easiest way to do this would be to provide a registry key file for Derby Network Server and provide instructions on how to install it as a Windows service using instsrv and srvany. However, we obviously can't redistribute those two utilities, but it would be nice to provide all the parts to the solution. So, a little searching turned up this public domain srvany replacement:
> > http://iain.cx/src/nssm/
> > I haven't tried it, but I suggest trying it out to see how well it works.
> 
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
>   http://issues.apache.org/jira/secure/Administrators.jspa
> -
> If you want more information on JIRA, or have a bug to report see:
>   http://www.atlassian.com/software/jira
> 
>

Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS

Posted by TomohitoNakayama <to...@basil.ocn.ne.jp>.

+1

However, I wonder this may be an issue of documentation about using sc 
command on Windows when using Derby ....

How to Create a Windows Service Using Sc.exe :
    http://support.microsoft.com/kb/251192

Best regards.


Riyaz Mansoor (JIRA) wrote:

>    [ http://issues.apache.org/jira/browse/DERBY-187?page=comments#action_12442371 ] 
>            
>Riyaz Mansoor commented on DERBY-187:
>-------------------------------------
>
>
>Guys i think this needs to be implemented. Recently Tomcat did the same for their project. Please vote for this feature.
>
>Riyaz
>
>  
>
>>Starting derby network server as a service in Win OS
>>----------------------------------------------------
>>
>>                Key: DERBY-187
>>                URL: http://issues.apache.org/jira/browse/DERBY-187
>>            Project: Derby
>>         Issue Type: New Feature
>>         Components: Services
>>   Affects Versions: 10.0.2.1
>>        Environment: OS will be only any flavour of Windows.
>>           Reporter: Amit Handa
>>           Priority: Minor
>>
>>The Derby Network Server Database could be started/stopped as a service in Windows OS.
>>This may involve updating the win registry. Further work needs to be done to understand what all will it require to do such a thing.
>>I am putting below Andrew McIntyre's comments if they can help in getting a solution to this problem.
>>If you would like to see this functionality added, please add a JIRA entry for it.  The easiest way to do this would be to provide a registry key file for Derby Network Server and provide instructions on how to install it as a Windows service using instsrv and srvany. However, we obviously can't redistribute those two utilities, but it would be nice to provide all the parts to the solution. So, a little searching turned up this public domain srvany replacement:
>>http://iain.cx/src/nssm/
>>I haven't tried it, but I suggest trying it out to see how well it works. 
>>    
>>
>
>  
>

-- 
/*

        Tomohito Nakayama
        tomonaka@basil.ocn.ne.jp
        tomohito@rose.zero.ad.jp
        tmnk@apache.org

        Naka
        http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/

[jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS

Posted by "Riyaz Mansoor (JIRA)" <de...@db.apache.org>.

    [ http://issues.apache.org/jira/browse/DERBY-187?page=comments#action_12442371 ] 
            
Riyaz Mansoor commented on DERBY-187:
-------------------------------------


Guys i think this needs to be implemented. Recently Tomcat did the same for their project. Please vote for this feature.

Riyaz

> Starting derby network server as a service in Win OS
> ----------------------------------------------------
>
>                 Key: DERBY-187
>                 URL: http://issues.apache.org/jira/browse/DERBY-187
>             Project: Derby
>          Issue Type: New Feature
>          Components: Services
>    Affects Versions: 10.0.2.1
>         Environment: OS will be only any flavour of Windows.
>            Reporter: Amit Handa
>            Priority: Minor
>
> The Derby Network Server Database could be started/stopped as a service in Windows OS.
> This may involve updating the win registry. Further work needs to be done to understand what all will it require to do such a thing.
> I am putting below Andrew McIntyre's comments if they can help in getting a solution to this problem.
> If you would like to see this functionality added, please add a JIRA entry for it.  The easiest way to do this would be to provide a registry key file for Derby Network Server and provide instructions on how to install it as a Windows service using instsrv and srvany. However, we obviously can't redistribute those two utilities, but it would be nice to provide all the parts to the solution. So, a little searching turned up this public domain srvany replacement:
> http://iain.cx/src/nssm/
> I haven't tried it, but I suggest trying it out to see how well it works. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS

Posted by "Samuel Andrew McIntyre (JIRA)" <de...@db.apache.org>.

     [ http://issues.apache.org/jira/browse/DERBY-187?page=comments#action_61703 ]
     
Samuel Andrew McIntyre commented on DERBY-187:
----------------------------------------------

Another, probably better solution than my previous suggestion would be one based around the Jakarta Commons Daemon project, which lives here:

http://jakarta.apache.org/commons/daemon/

andrew

> Starting derby network server as a service in Win OS
> ----------------------------------------------------
>
>          Key: DERBY-187
>          URL: http://issues.apache.org/jira/browse/DERBY-187
>      Project: Derby
>         Type: New Feature
>   Components: Services
>     Versions: 10.0.2.1
>  Environment: OS will be only any flavour of Windows.
>     Reporter: Amit Handa
>     Priority: Minor

>
> The Derby Network Server Database could be started/stopped as a service in Windows OS.
> This may involve updating the win registry. Further work needs to be done to understand what all will it require to do such a thing.
> I am putting below Andrew McIntyre's comments if they can help in getting a solution to this problem.
> If you would like to see this functionality added, please add a JIRA entry for it.  The easiest way to do this would be to provide a registry key file for Derby Network Server and provide instructions on how to install it as a Windows service using instsrv and srvany. However, we obviously can't redistribute those two utilities, but it would be nice to provide all the parts to the solution. So, a little searching turned up this public domain srvany replacement:
> http://iain.cx/src/nssm/
> I haven't tried it, but I suggest trying it out to see how well it works. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira

Re: [Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS)

Posted by Andrew McIntyre <mc...@gmail.com>.

On 1/4/07, Jean T. Anderson <jt...@bristowhill.com> wrote:
> Andrew McIntyre wrote:
> ...
> > I think at this point it should be sufficient to point users to the
> > Tomcat distributions and provide some basic instructions on how to
> > extract, rename, and configure tomcat5.exe to run the network server
> > as a service on Windows. These instructions could be added to the FAQ
> > and/or the wiki and then DERBY-187 can be closed.
>
> you probably already know about the existing wiki page:
>
> http://wiki.apache.org/db-derby/DerbyWindowsService
>
> maybe more tips could be added there. I'll go ahead and add a pointer to
> that wiki page from http://db.apache.org/derby/faq.html.

I had forgotten about it, thanks for the pointer. We should definitely
add additional instructions regarding using tomcat5.exe as well, since
that's an Apache-licensed solution and the others listed there are
not.

andrew

Re: [Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS)

Posted by "Jean T. Anderson" <jt...@bristowhill.com>.

Andrew McIntyre wrote:
...
> I think at this point it should be sufficient to point users to the
> Tomcat distributions and provide some basic instructions on how to
> extract, rename, and configure tomcat5.exe to run the network server
> as a service on Windows. These instructions could be added to the FAQ
> and/or the wiki and then DERBY-187 can be closed.

you probably already know about the existing wiki page:

http://wiki.apache.org/db-derby/DerbyWindowsService

maybe more tips could be added there. I'll go ahead and add a pointer to
that wiki page from http://db.apache.org/derby/faq.html.

 -jean

Re: [Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS)

Posted by TomohitoNakayama <to...@basil.ocn.ne.jp>.

Hello Andrew.

I think your idea is one of possible choices and
does not beat you.

Best regards.


Andrew McIntyre wrote:

> On 10/18/06, Andrew McIntyre <mc...@gmail.com> wrote:
>
>> On 10/18/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
>> > > Now I'm thinking to include tomcat5.exe into derby as derby.exe as
>> > > resolution for DERBY-187.
>> >
>> > Are the following two statements true?
>> >
>> > 1) This derby.exe program would be useful to Windows users, not to 
>> other users
>>
>> Correct, since tomcat5.exe is just a renamed procrun/prunsrv from the
>> Jakarta Commons Daemon project.
>>
>> While I don't see any problem with Derby redistributing procrun, I
>> don't think we necessarily need to be redistributing it either. It
>> would be sufficient to provide a pointer to the commons daemon project
>> and instructions in our documentation for those that want this
>> functionality.
>>
>> But, since you can't actually get procrun as a Windows executable
>> anywhere that I could find from the links at
>> http://jakarta.apache.org/commons/daemon/index.html, I suppose
>> redistributing it is probably the best way of providing this
>> functionality for users.
>>
>> Maybe there's some reason why they don't redistribute their own code
>> in binary form? I find it sort of odd, but I haven't gone to look for
>> the reasons yet.
>>
>> If it were possible to download procrun as a binary from the Commons
>> Daemon project, I would prefer that users pick it up from there, and
>> we could provide Derby-specific instructions on using it with the
>> network server.
>
>
> It's been a while but I finally got around to looking into it. It
> appears even the commons-dev folks don't have any forthcoming answers
> as to why there's no Win32 download for the Commons Daemon:
>
> http://www.nabble.com/-daemon--Re%3A-Obtaining-procrun-for-Win32-tf2558402.html#a7129565 
>
> http://mail-archives.apache.org/mod_mbox/jakarta-commons-user/200606.mbox/%3C7.0.1.0.0.20060613234131.04c53c98@visi.com%3E 
>
>
> I think at this point it should be sufficient to point users to the
> Tomcat distributions and provide some basic instructions on how to
> extract, rename, and configure tomcat5.exe to run the network server
> as a service on Windows. These instructions could be added to the FAQ
> and/or the wiki and then DERBY-187 can be closed.
>
> I'll add this comment to DERBY-187 and will put it on my list to add
> to the FAQ unless someone beats me to it.
>
> andrew
>
>

-- 
/*

        Tomohito Nakayama
        tomonaka@basil.ocn.ne.jp
        tomohito@rose.zero.ad.jp
        tmnk@apache.org

        Naka
        http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/

Re: Re: [Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS)

Posted by Andrew McIntyre <mc...@gmail.com>.

On 10/18/06, Andrew McIntyre <mc...@gmail.com> wrote:
> On 10/18/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
> > > Now I'm thinking to include tomcat5.exe into derby as derby.exe as
> > > resolution for DERBY-187.
> >
> > Are the following two statements true?
> >
> > 1) This derby.exe program would be useful to Windows users, not to other users
>
> Correct, since tomcat5.exe is just a renamed procrun/prunsrv from the
> Jakarta Commons Daemon project.
>
> While I don't see any problem with Derby redistributing procrun, I
> don't think we necessarily need to be redistributing it either. It
> would be sufficient to provide a pointer to the commons daemon project
> and instructions in our documentation for those that want this
> functionality.
>
> But, since you can't actually get procrun as a Windows executable
> anywhere that I could find from the links at
> http://jakarta.apache.org/commons/daemon/index.html, I suppose
> redistributing it is probably the best way of providing this
> functionality for users.
>
> Maybe there's some reason why they don't redistribute their own code
> in binary form? I find it sort of odd, but I haven't gone to look for
> the reasons yet.
>
> If it were possible to download procrun as a binary from the Commons
> Daemon project, I would prefer that users pick it up from there, and
> we could provide Derby-specific instructions on using it with the
> network server.

It's been a while but I finally got around to looking into it. It
appears even the commons-dev folks don't have any forthcoming answers
as to why there's no Win32 download for the Commons Daemon:

http://www.nabble.com/-daemon--Re%3A-Obtaining-procrun-for-Win32-tf2558402.html#a7129565
http://mail-archives.apache.org/mod_mbox/jakarta-commons-user/200606.mbox/%3C7.0.1.0.0.20060613234131.04c53c98@visi.com%3E

I think at this point it should be sufficient to point users to the
Tomcat distributions and provide some basic instructions on how to
extract, rename, and configure tomcat5.exe to run the network server
as a service on Windows. These instructions could be added to the FAQ
and/or the wiki and then DERBY-187 can be closed.

I'll add this comment to DERBY-187 and will put it on my list to add
to the FAQ unless someone beats me to it.

andrew

Postpone the Vote (Re: [Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS))

Posted by TomohitoNakayama <to...@basil.ocn.ne.jp>.

Hello Andrew.

Andrew McIntyre wrote:

> On 10/18/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
>
>> > Now I'm thinking to include tomcat5.exe into derby as derby.exe as
>> > resolution for DERBY-187.
>>
>> Are the following two statements true?
>>
>> 1) This derby.exe program would be useful to Windows users, not to 
>> other users
>
<snip>

>
>
> I will vote on this later. I want to do some more research into
> procrun and think about how it might fit into the Derby -bin
> distribution.
>
> andrew
>
>

I see ....
I will postpone the vote and wait for your research.

Best regards.

-- 
/*

        Tomohito Nakayama
        tomonaka@basil.ocn.ne.jp
        tomohito@rose.zero.ad.jp
        tmnk@apache.org

        Naka
        http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/

Re: [Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS)

Posted by "Lance J. Andersen" <La...@Sun.COM>.

If I am reading this thread correctly, I am not in favor of including an 
*.exe as part of the base derby download.  If you want to provide an 
optional package, that is fine.  Let us keep the base bundle pure Java.

Andrew McIntyre wrote:
> On 10/18/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
>> > Now I'm thinking to include tomcat5.exe into derby as derby.exe as
>> > resolution for DERBY-187.
>>
>> Are the following two statements true?
>>
>> 1) This derby.exe program would be useful to Windows users, not to 
>> other users
>
> Correct, since tomcat5.exe is just a renamed procrun/prunsrv from the
> Jakarta Commons Daemon project.
>
>> 2) This derby.exe program can be used with any release of Derby (that 
>> is, we
>> don't have to modify the NetworkServerControl class to enable it to 
>> be run as
>> a service by Derby.exe).
>
> Procrun/prunsrv can be used to interface any program, not just java,
> with Windows' services. Consider it an Apache licensed srvany.exe.
>
> The question that I think needs to be asked is:
>
> 3) Why can't users get a native Windows binary for procrun from the
> Jakarta Commons Daemon project that they can use with Derby?
>
> There's even a JIRA that's over a year old (migrated from Bugzilla)
> with no comments that asks for exactly that:
>
> http://issues.apache.org/jira/browse/DAEMON-51
>
>> If both the above statements are true, then it occurs to me that it 
>> might be
>> nice to be able to distribute this new program separately, rather 
>> than as
>> part of the basic Derby release.
>
> While I don't see any problem with Derby redistributing procrun, I
> don't think we necessarily need to be redistributing it either. It
> would be sufficient to provide a pointer to the commons daemon project
> and instructions in our documentation for those that want this
> functionality.
>
> But, since you can't actually get procrun as a Windows executable
> anywhere that I could find from the links at
> http://jakarta.apache.org/commons/daemon/index.html, I suppose
> redistributing it is probably the best way of providing this
> functionality for users.
>
> Maybe there's some reason why they don't redistribute their own code
> in binary form? I find it sort of odd, but I haven't gone to look for
> the reasons yet.
>
>> That way users could decide whether or not to download this program, 
>> and we
>> also could release this program independently of releasing the basic 
>> Derby
>> software.
>
> If it were possible to download procrun as a binary from the Commons
> Daemon project, I would prefer that users pick it up from there, and
> we could provide Derby-specific instructions on using it with the
> network server.
>
> Since that doesn't seem to be possible, I think it's reasonable to
> consider redistributing it ourselves and having a vote on that.
> DERBY-187 is the 8th most popular issue in our JIRA, tied with full
> text search, so that indicates demand for the feature.
>
> I will vote on this later. I want to do some more research into
> procrun and think about how it might fit into the Derby -bin
> distribution.
>
> andrew

Re: Re: [Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS)

Posted by Andrew McIntyre <mc...@gmail.com>.

On 10/18/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
> > Now I'm thinking to include tomcat5.exe into derby as derby.exe as
> > resolution for DERBY-187.
>
> Are the following two statements true?
>
> 1) This derby.exe program would be useful to Windows users, not to other users

Correct, since tomcat5.exe is just a renamed procrun/prunsrv from the
Jakarta Commons Daemon project.

> 2) This derby.exe program can be used with any release of Derby (that is, we
> don't have to modify the NetworkServerControl class to enable it to be run as
> a service by Derby.exe).

Procrun/prunsrv can be used to interface any program, not just java,
with Windows' services. Consider it an Apache licensed srvany.exe.

The question that I think needs to be asked is:

3) Why can't users get a native Windows binary for procrun from the
Jakarta Commons Daemon project that they can use with Derby?

There's even a JIRA that's over a year old (migrated from Bugzilla)
with no comments that asks for exactly that:

http://issues.apache.org/jira/browse/DAEMON-51

> If both the above statements are true, then it occurs to me that it might be
> nice to be able to distribute this new program separately, rather than as
> part of the basic Derby release.

While I don't see any problem with Derby redistributing procrun, I
don't think we necessarily need to be redistributing it either. It
would be sufficient to provide a pointer to the commons daemon project
and instructions in our documentation for those that want this
functionality.

But, since you can't actually get procrun as a Windows executable
anywhere that I could find from the links at
http://jakarta.apache.org/commons/daemon/index.html, I suppose
redistributing it is probably the best way of providing this
functionality for users.

Maybe there's some reason why they don't redistribute their own code
in binary form? I find it sort of odd, but I haven't gone to look for
the reasons yet.

> That way users could decide whether or not to download this program, and we
> also could release this program independently of releasing the basic Derby
> software.

If it were possible to download procrun as a binary from the Commons
Daemon project, I would prefer that users pick it up from there, and
we could provide Derby-specific instructions on using it with the
network server.

Since that doesn't seem to be possible, I think it's reasonable to
consider redistributing it ourselves and having a vote on that.
DERBY-187 is the 8th most popular issue in our JIRA, tied with full
text search, so that indicates demand for the feature.

I will vote on this later. I want to do some more research into
procrun and think about how it might fit into the Derby -bin
distribution.

andrew

Re: [Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187) Starting derby network server as a service in Win OS)

Posted by Bryan Pendleton <bp...@amberpoint.com>.

> Now I'm thinking to include tomcat5.exe into derby as derby.exe as 
> resolution for DERBY-187.

Are the following two statements true?

1) This derby.exe program would be useful to Windows users, not to other users
2) This derby.exe program can be used with any release of Derby (that is, we
don't have to modify the NetworkServerControl class to enable it to be run as
a service by Derby.exe).

If both the above statements are true, then it occurs to me that it might be
nice to be able to distribute this new program separately, rather than as
part of the basic Derby release.

That way users could decide whether or not to download this program, and we
also could release this program independently of releasing the basic Derby
software.

thanks,

bryan