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 TomohitoNakayama <to...@basil.ocn.ne.jp> on 2006/10/18 17:39:47 UTC
[Vote] Include tomcat5.exe as derby.exe (Re: [jira] Commented: (DERBY-187)
Starting derby network server as a service in Win OS)
Hello.
Now I'm thinking to include tomcat5.exe into derby as derby.exe as
resolution for DERBY-187.
tomcat5.exe is a program to register java program as Windows service and
was developed in Apache Tomcat (http://tomcat.apache.org/) based on
procrun developed in Jakarta Commons daemon
(http://jakarta.apache.org/commons/daemon/index.html).
Please vote for this proposal.
Best regards.
Tomohito Nakayama (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-187?page=comments#action_12443267 ]
>
>Tomohito Nakayama commented on DERBY-187:
>-----------------------------------------
>
>It seems that the program can be included in derby...
>
>http://mail-archives.apache.org/mod_mbox/www-legal-discuss/200610.mbox/%3c4534E39A.6080908@basil.ocn.ne.jp%3e
>http://mail-archives.apache.org/mod_mbox/www-legal-discuss/200610.mbox/%3cc5e632550610171157v13c2b506r72678a1934e71313@mail.gmail.com%3e
>
>
>
>>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
*/
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