|
Hi,
as part of my Apache Karaf Tutorial about database access I have written some handy Karaf shell commands for databases. They are described with screen dumps in my Tutorial http://www.liquid-reality.de/x/LYBk . The code is on github: https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command Especially for embedded databases like derby and h2 I missed a simple access to the database for a long time. So I think these commands could be interesting for many developers. Those commands might fit nicely into the scope of servicemix as they support integration developers. I am also planning to add a command set for jms that works in a similar way: jms:select -> select ConnectionFactory to use jms:create-dest -> create destination jms:delete-dest -> delete destination jms:list -> list destinations jms:browse -> browse queue jms:send -> send message jms:move -> move a message from one dest to another jms:listen -> Watch live messages So what do you think? Christian -- Christian Schneider http://www.liquid-reality.de Open Source Architect Talend Application Integration Division http://www.talend.com |
|
Administrator
|
L.S.,
Those sound like really nice additions for Apache ServiceMix - a lot of our user are probably interacting with database and jms queues on a daily basis during their development efforts. We probably have to look into a good way of securing these things in production systems, but for development and probably even testing, they should be very useful, so I think they would be a very nice new feature for Apache ServiceMix 4.5.0 Regards, Gert Vanthienen ------------------------ FuseSource Web: http://fusesource.com Blog: http://gertvanthienen.blogspot.com/ On Thu, Jan 19, 2012 at 11:24 AM, Christian Schneider < [hidden email]> wrote: > Hi, > > as part of my Apache Karaf Tutorial about database access I have written > some handy Karaf shell commands for databases. > They are described with screen dumps in my Tutorial > http://www.liquid-reality.de/**x/LYBk<http://www.liquid-reality.de/x/LYBk>. > The code is on github: https://github.com/cschneider/** > Karaf-Tutorial/tree/master/db/**command<https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command> > > Especially for embedded databases like derby and h2 I missed a simple > access to the database for a long time. So I think these commands could be > interesting for many developers. > Those commands might fit nicely into the scope of servicemix as they > support integration developers. > > I am also planning to add a command set for jms that works in a similar > way: > > jms:select -> select ConnectionFactory to use > jms:create-dest -> create destination > jms:delete-dest -> delete destination > jms:list -> list destinations > jms:browse -> browse queue > jms:send -> send message > jms:move -> move a message from one dest to another > jms:listen -> Watch live messages > > So what do you think? > > Christian > > -- > Christian Schneider > http://www.liquid-reality.de > > Open Source Architect > Talend Application Integration Division http://www.talend.com > >
Regards,
Gert Vanthienen ------------------------ Open Source SOA: http://fusesource.com Blog: http://gertvanthienen.blogspot.com/ |
|
In reply to this post by Christian Schneider
Hi Christian,
for me, it makes sense to have it in ServiceMix. It should be a kind of "isolated" module which can be loaded in Karaf **without** ServiceMix. I have a set of others commands in mind that could be interesting. I already have more or less these commands in Kalumet. Anyway, +1 for that Christian, and thanks. Regards JB On 01/19/2012 11:24 AM, Christian Schneider wrote: > Hi, > > as part of my Apache Karaf Tutorial about database access I have written > some handy Karaf shell commands for databases. > They are described with screen dumps in my Tutorial > http://www.liquid-reality.de/x/LYBk . > The code is on github: > https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command > > Especially for embedded databases like derby and h2 I missed a simple > access to the database for a long time. So I think these commands could > be interesting for many developers. > Those commands might fit nicely into the scope of servicemix as they > support integration developers. > > I am also planning to add a command set for jms that works in a similar > way: > > jms:select -> select ConnectionFactory to use > jms:create-dest -> create destination > jms:delete-dest -> delete destination > jms:list -> list destinations > jms:browse -> browse queue > jms:send -> send message > jms:move -> move a message from one dest to another > jms:listen -> Watch live messages > > So what do you think? > > Christian > -- Jean-Baptiste Onofré [hidden email] http://blog.nanthrax.net Talend - http://www.talend.com |
|
Hi Gert and JB,
thanks for your responses. Can you give me some hints where to put the code. I can then provide a jira issue and a patch. Christian Am 19.01.2012 12:41, schrieb Jean-Baptiste Onofré: > Hi Christian, > > for me, it makes sense to have it in ServiceMix. > > It should be a kind of "isolated" module which can be loaded in Karaf > **without** ServiceMix. > > I have a set of others commands in mind that could be interesting. > I already have more or less these commands in Kalumet. > > Anyway, +1 for that Christian, and thanks. > > Regards > JB > > On 01/19/2012 11:24 AM, Christian Schneider wrote: >> Hi, >> >> as part of my Apache Karaf Tutorial about database access I have written >> some handy Karaf shell commands for databases. >> They are described with screen dumps in my Tutorial >> http://www.liquid-reality.de/x/LYBk . >> The code is on github: >> https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command >> >> Especially for embedded databases like derby and h2 I missed a simple >> access to the database for a long time. So I think these commands could >> be interesting for many developers. >> Those commands might fit nicely into the scope of servicemix as they >> support integration developers. >> >> I am also planning to add a command set for jms that works in a similar >> way: >> >> jms:select -> select ConnectionFactory to use >> jms:create-dest -> create destination >> jms:delete-dest -> delete destination >> jms:list -> list destinations >> jms:browse -> browse queue >> jms:send -> send message >> jms:move -> move a message from one dest to another >> jms:listen -> Watch live messages >> >> So what do you think? >> >> Christian >> > -- Christian Schneider http://www.liquid-reality.de Open Source Architect Talend Application Integration Division http://www.talend.com |
|
Administrator
|
L.S.,
Personally, I would add them to the features project, something features/shell/jdbc and features/shell/jms probably. That will make it easy for them to get released together with the rest of the project. We're planning to both a 4.4.1 and 4.5.0 release in the next few weeks or months, so those bundles could be part of both of those releases. Once the shell bundles have been released, they can always be used outside of ServiceMix in a plain Karaf as well if people would want to do that, so I would just keep them in the main project source tree for now. Regards, Gert Vanthienen ------------------------ FuseSource Web: http://fusesource.com Blog: http://gertvanthienen.blogspot.com/ On Thu, Jan 19, 2012 at 1:46 PM, Christian Schneider < [hidden email]> wrote: > Hi Gert and JB, > > thanks for your responses. Can you give me some hints where to put the > code. I can then provide a jira issue and a patch. > > Christian > > Am 19.01.2012 12:41, schrieb Jean-Baptiste Onofré: > > Hi Christian, >> >> for me, it makes sense to have it in ServiceMix. >> >> It should be a kind of "isolated" module which can be loaded in Karaf >> **without** ServiceMix. >> >> I have a set of others commands in mind that could be interesting. >> I already have more or less these commands in Kalumet. >> >> Anyway, +1 for that Christian, and thanks. >> >> Regards >> JB >> >> On 01/19/2012 11:24 AM, Christian Schneider wrote: >> >>> Hi, >>> >>> as part of my Apache Karaf Tutorial about database access I have written >>> some handy Karaf shell commands for databases. >>> They are described with screen dumps in my Tutorial >>> http://www.liquid-reality.de/**x/LYBk<http://www.liquid-reality.de/x/LYBk>. >>> The code is on github: >>> https://github.com/cschneider/**Karaf-Tutorial/tree/master/db/**command<https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command> >>> >>> Especially for embedded databases like derby and h2 I missed a simple >>> access to the database for a long time. So I think these commands could >>> be interesting for many developers. >>> Those commands might fit nicely into the scope of servicemix as they >>> support integration developers. >>> >>> I am also planning to add a command set for jms that works in a similar >>> way: >>> >>> jms:select -> select ConnectionFactory to use >>> jms:create-dest -> create destination >>> jms:delete-dest -> delete destination >>> jms:list -> list destinations >>> jms:browse -> browse queue >>> jms:send -> send message >>> jms:move -> move a message from one dest to another >>> jms:listen -> Watch live messages >>> >>> So what do you think? >>> >>> Christian >>> >>> >> > > -- > Christian Schneider > http://www.liquid-reality.de > > Open Source Architect > Talend Application Integration Division http://www.talend.com > >
Regards,
Gert Vanthienen ------------------------ Open Source SOA: http://fusesource.com Blog: http://gertvanthienen.blogspot.com/ |
|
Agree with Gert,
shell module of the features project is the most logical. Regards JB On 01/19/2012 02:18 PM, Gert Vanthienen wrote: > L.S., > > > Personally, I would add them to the features project, something > features/shell/jdbc and features/shell/jms probably. That will make it > easy for them to get released together with the rest of the project. We're > planning to both a 4.4.1 and 4.5.0 release in the next few weeks or months, > so those bundles could be part of both of those releases. Once the shell > bundles have been released, they can always be used outside of ServiceMix > in a plain Karaf as well if people would want to do that, so I would just > keep them in the main project source tree for now. > > > Regards, > > Gert Vanthienen > ------------------------ > FuseSource > Web: http://fusesource.com > Blog: http://gertvanthienen.blogspot.com/ > > > On Thu, Jan 19, 2012 at 1:46 PM, Christian Schneider< > [hidden email]> wrote: > >> Hi Gert and JB, >> >> thanks for your responses. Can you give me some hints where to put the >> code. I can then provide a jira issue and a patch. >> >> Christian >> >> Am 19.01.2012 12:41, schrieb Jean-Baptiste Onofré: >> >> Hi Christian, >>> >>> for me, it makes sense to have it in ServiceMix. >>> >>> It should be a kind of "isolated" module which can be loaded in Karaf >>> **without** ServiceMix. >>> >>> I have a set of others commands in mind that could be interesting. >>> I already have more or less these commands in Kalumet. >>> >>> Anyway, +1 for that Christian, and thanks. >>> >>> Regards >>> JB >>> >>> On 01/19/2012 11:24 AM, Christian Schneider wrote: >>> >>>> Hi, >>>> >>>> as part of my Apache Karaf Tutorial about database access I have written >>>> some handy Karaf shell commands for databases. >>>> They are described with screen dumps in my Tutorial >>>> http://www.liquid-reality.de/**x/LYBk<http://www.liquid-reality.de/x/LYBk>. >>>> The code is on github: >>>> https://github.com/cschneider/**Karaf-Tutorial/tree/master/db/**command<https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command> >>>> >>>> Especially for embedded databases like derby and h2 I missed a simple >>>> access to the database for a long time. So I think these commands could >>>> be interesting for many developers. >>>> Those commands might fit nicely into the scope of servicemix as they >>>> support integration developers. >>>> >>>> I am also planning to add a command set for jms that works in a similar >>>> way: >>>> >>>> jms:select -> select ConnectionFactory to use >>>> jms:create-dest -> create destination >>>> jms:delete-dest -> delete destination >>>> jms:list -> list destinations >>>> jms:browse -> browse queue >>>> jms:send -> send message >>>> jms:move -> move a message from one dest to another >>>> jms:listen -> Watch live messages >>>> >>>> So what do you think? >>>> >>>> Christian >>>> >>>> >>> >> >> -- >> Christian Schneider >> http://www.liquid-reality.de >> >> Open Source Architect >> Talend Application Integration Division http://www.talend.com >> >> > -- Jean-Baptiste Onofré [hidden email] http://blog.nanthrax.net Talend - http://www.talend.com |
|
Here is my +1.
I really like the idea of commands. I think that will be a huge improvement for these persons who use ServiceMix as data hub. Best regards, Łukasz Dywicki -- Code-House http://code-house.org Wiadomość napisana przez Jean-Baptiste Onofré w dniu 2012-01-19, o godz. 15:21: > Agree with Gert, > > shell module of the features project is the most logical. > > Regards > JB > > On 01/19/2012 02:18 PM, Gert Vanthienen wrote: >> L.S., >> >> >> Personally, I would add them to the features project, something >> features/shell/jdbc and features/shell/jms probably. That will make it >> easy for them to get released together with the rest of the project. We're >> planning to both a 4.4.1 and 4.5.0 release in the next few weeks or months, >> so those bundles could be part of both of those releases. Once the shell >> bundles have been released, they can always be used outside of ServiceMix >> in a plain Karaf as well if people would want to do that, so I would just >> keep them in the main project source tree for now. >> >> >> Regards, >> >> Gert Vanthienen >> ------------------------ >> FuseSource >> Web: http://fusesource.com >> Blog: http://gertvanthienen.blogspot.com/ >> >> >> On Thu, Jan 19, 2012 at 1:46 PM, Christian Schneider< >> [hidden email]> wrote: >> >>> Hi Gert and JB, >>> >>> thanks for your responses. Can you give me some hints where to put the >>> code. I can then provide a jira issue and a patch. >>> >>> Christian >>> >>> Am 19.01.2012 12:41, schrieb Jean-Baptiste Onofré: >>> >>> Hi Christian, >>>> >>>> for me, it makes sense to have it in ServiceMix. >>>> >>>> It should be a kind of "isolated" module which can be loaded in Karaf >>>> **without** ServiceMix. >>>> >>>> I have a set of others commands in mind that could be interesting. >>>> I already have more or less these commands in Kalumet. >>>> >>>> Anyway, +1 for that Christian, and thanks. >>>> >>>> Regards >>>> JB >>>> >>>> On 01/19/2012 11:24 AM, Christian Schneider wrote: >>>> >>>>> Hi, >>>>> >>>>> as part of my Apache Karaf Tutorial about database access I have written >>>>> some handy Karaf shell commands for databases. >>>>> They are described with screen dumps in my Tutorial >>>>> http://www.liquid-reality.de/**x/LYBk<http://www.liquid-reality.de/x/LYBk>. >>>>> The code is on github: >>>>> https://github.com/cschneider/**Karaf-Tutorial/tree/master/db/**command<https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command> >>>>> >>>>> Especially for embedded databases like derby and h2 I missed a simple >>>>> access to the database for a long time. So I think these commands could >>>>> be interesting for many developers. >>>>> Those commands might fit nicely into the scope of servicemix as they >>>>> support integration developers. >>>>> >>>>> I am also planning to add a command set for jms that works in a similar >>>>> way: >>>>> >>>>> jms:select -> select ConnectionFactory to use >>>>> jms:create-dest -> create destination >>>>> jms:delete-dest -> delete destination >>>>> jms:list -> list destinations >>>>> jms:browse -> browse queue >>>>> jms:send -> send message >>>>> jms:move -> move a message from one dest to another >>>>> jms:listen -> Watch live messages >>>>> >>>>> So what do you think? >>>>> >>>>> Christian >>>>> >>>>> >>>> >>> >>> -- >>> Christian Schneider >>> http://www.liquid-reality.de >>> >>> Open Source Architect >>> Talend Application Integration Division http://www.talend.com >>> >>> >> > > -- > Jean-Baptiste Onofré > [hidden email] > http://blog.nanthrax.net > Talend - http://www.talend.com |
|
Definitely a good idea. Regards.
On Jan 19, 2012 6:10 PM, "Łukasz Dywicki" <[hidden email]> wrote: > Here is my +1. > I really like the idea of commands. I think that will be a huge > improvement for these persons who use ServiceMix as data hub. > > Best regards, > Łukasz Dywicki > -- > Code-House > http://code-house.org > > Wiadomość napisana przez Jean-Baptiste Onofré w dniu 2012-01-19, o godz. > 15:21: > > > Agree with Gert, > > > > shell module of the features project is the most logical. > > > > Regards > > JB > > > > On 01/19/2012 02:18 PM, Gert Vanthienen wrote: > >> L.S., > >> > >> > >> Personally, I would add them to the features project, something > >> features/shell/jdbc and features/shell/jms probably. That will make it > >> easy for them to get released together with the rest of the project. > We're > >> planning to both a 4.4.1 and 4.5.0 release in the next few weeks or > months, > >> so those bundles could be part of both of those releases. Once the > shell > >> bundles have been released, they can always be used outside of > ServiceMix > >> in a plain Karaf as well if people would want to do that, so I would > just > >> keep them in the main project source tree for now. > >> > >> > >> Regards, > >> > >> Gert Vanthienen > >> ------------------------ > >> FuseSource > >> Web: http://fusesource.com > >> Blog: http://gertvanthienen.blogspot.com/ > >> > >> > >> On Thu, Jan 19, 2012 at 1:46 PM, Christian Schneider< > >> [hidden email]> wrote: > >> > >>> Hi Gert and JB, > >>> > >>> thanks for your responses. Can you give me some hints where to put the > >>> code. I can then provide a jira issue and a patch. > >>> > >>> Christian > >>> > >>> Am 19.01.2012 12:41, schrieb Jean-Baptiste Onofré: > >>> > >>> Hi Christian, > >>>> > >>>> for me, it makes sense to have it in ServiceMix. > >>>> > >>>> It should be a kind of "isolated" module which can be loaded in Karaf > >>>> **without** ServiceMix. > >>>> > >>>> I have a set of others commands in mind that could be interesting. > >>>> I already have more or less these commands in Kalumet. > >>>> > >>>> Anyway, +1 for that Christian, and thanks. > >>>> > >>>> Regards > >>>> JB > >>>> > >>>> On 01/19/2012 11:24 AM, Christian Schneider wrote: > >>>> > >>>>> Hi, > >>>>> > >>>>> as part of my Apache Karaf Tutorial about database access I have > written > >>>>> some handy Karaf shell commands for databases. > >>>>> They are described with screen dumps in my Tutorial > >>>>> http://www.liquid-reality.de/**x/LYBk< > http://www.liquid-reality.de/x/LYBk>. > >>>>> The code is on github: > >>>>> > https://github.com/cschneider/**Karaf-Tutorial/tree/master/db/**command< > https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command> > >>>>> > >>>>> Especially for embedded databases like derby and h2 I missed a simple > >>>>> access to the database for a long time. So I think these commands > could > >>>>> be interesting for many developers. > >>>>> Those commands might fit nicely into the scope of servicemix as they > >>>>> support integration developers. > >>>>> > >>>>> I am also planning to add a command set for jms that works in a > similar > >>>>> way: > >>>>> > >>>>> jms:select -> select ConnectionFactory to use > >>>>> jms:create-dest -> create destination > >>>>> jms:delete-dest -> delete destination > >>>>> jms:list -> list destinations > >>>>> jms:browse -> browse queue > >>>>> jms:send -> send message > >>>>> jms:move -> move a message from one dest to another > >>>>> jms:listen -> Watch live messages > >>>>> > >>>>> So what do you think? > >>>>> > >>>>> Christian > >>>>> > >>>>> > >>>> > >>> > >>> -- > >>> Christian Schneider > >>> http://www.liquid-reality.de > >>> > >>> Open Source Architect > >>> Talend Application Integration Division http://www.talend.com > >>> > >>> > >> > > > > -- > > Jean-Baptiste Onofré > > [hidden email] > > http://blog.nanthrax.net > > Talend - http://www.talend.com > > |
|
In reply to this post by Łukasz Dywicki
Hi
Yes a nice addition of commands. Just the security aspect that would concern me if they were default enabled, allow any to execute SQL against any of the data source. But this seems to be addressed when Karaf introduced a richer security model in the future. 2012/1/19 Łukasz Dywicki <[hidden email]>: > Here is my +1. > I really like the idea of commands. I think that will be a huge improvement for these persons who use ServiceMix as data hub. > > Best regards, > Łukasz Dywicki > -- > Code-House > http://code-house.org > > Wiadomość napisana przez Jean-Baptiste Onofré w dniu 2012-01-19, o godz. 15:21: > >> Agree with Gert, >> >> shell module of the features project is the most logical. >> >> Regards >> JB >> >> On 01/19/2012 02:18 PM, Gert Vanthienen wrote: >>> L.S., >>> >>> >>> Personally, I would add them to the features project, something >>> features/shell/jdbc and features/shell/jms probably. That will make it >>> easy for them to get released together with the rest of the project. We're >>> planning to both a 4.4.1 and 4.5.0 release in the next few weeks or months, >>> so those bundles could be part of both of those releases. Once the shell >>> bundles have been released, they can always be used outside of ServiceMix >>> in a plain Karaf as well if people would want to do that, so I would just >>> keep them in the main project source tree for now. >>> >>> >>> Regards, >>> >>> Gert Vanthienen >>> ------------------------ >>> FuseSource >>> Web: http://fusesource.com >>> Blog: http://gertvanthienen.blogspot.com/ >>> >>> >>> On Thu, Jan 19, 2012 at 1:46 PM, Christian Schneider< >>> [hidden email]> wrote: >>> >>>> Hi Gert and JB, >>>> >>>> thanks for your responses. Can you give me some hints where to put the >>>> code. I can then provide a jira issue and a patch. >>>> >>>> Christian >>>> >>>> Am 19.01.2012 12:41, schrieb Jean-Baptiste Onofré: >>>> >>>> Hi Christian, >>>>> >>>>> for me, it makes sense to have it in ServiceMix. >>>>> >>>>> It should be a kind of "isolated" module which can be loaded in Karaf >>>>> **without** ServiceMix. >>>>> >>>>> I have a set of others commands in mind that could be interesting. >>>>> I already have more or less these commands in Kalumet. >>>>> >>>>> Anyway, +1 for that Christian, and thanks. >>>>> >>>>> Regards >>>>> JB >>>>> >>>>> On 01/19/2012 11:24 AM, Christian Schneider wrote: >>>>> >>>>>> Hi, >>>>>> >>>>>> as part of my Apache Karaf Tutorial about database access I have written >>>>>> some handy Karaf shell commands for databases. >>>>>> They are described with screen dumps in my Tutorial >>>>>> http://www.liquid-reality.de/**x/LYBk<http://www.liquid-reality.de/x/LYBk>. >>>>>> The code is on github: >>>>>> https://github.com/cschneider/**Karaf-Tutorial/tree/master/db/**command<https://github.com/cschneider/Karaf-Tutorial/tree/master/db/command> >>>>>> >>>>>> Especially for embedded databases like derby and h2 I missed a simple >>>>>> access to the database for a long time. So I think these commands could >>>>>> be interesting for many developers. >>>>>> Those commands might fit nicely into the scope of servicemix as they >>>>>> support integration developers. >>>>>> >>>>>> I am also planning to add a command set for jms that works in a similar >>>>>> way: >>>>>> >>>>>> jms:select -> select ConnectionFactory to use >>>>>> jms:create-dest -> create destination >>>>>> jms:delete-dest -> delete destination >>>>>> jms:list -> list destinations >>>>>> jms:browse -> browse queue >>>>>> jms:send -> send message >>>>>> jms:move -> move a message from one dest to another >>>>>> jms:listen -> Watch live messages >>>>>> >>>>>> So what do you think? >>>>>> >>>>>> Christian >>>>>> >>>>>> >>>>> >>>> >>>> -- >>>> Christian Schneider >>>> http://www.liquid-reality.de >>>> >>>> Open Source Architect >>>> Talend Application Integration Division http://www.talend.com >>>> >>>> >>> >> >> -- >> Jean-Baptiste Onofré >> [hidden email] >> http://blog.nanthrax.net >> Talend - http://www.talend.com > -- Claus Ibsen ----------------- FuseSource Email: [hidden email] Web: http://fusesource.com Twitter: davsclaus, fusenews Blog: http://davsclaus.blogspot.com/ Author of Camel in Action: http://www.manning.com/ibsen/ |
|
Hi Claus,
I am not concerned about enablement by default as anyone with access to the karaf shell could install the commands at any time. Christian Am 20.01.2012 09:44, schrieb Claus Ibsen: > Hi > > Yes a nice addition of commands. > > Just the security aspect that would concern me if they were default > enabled, allow any to execute SQL against any of the data source. > But this seems to be addressed when Karaf introduced a richer security > model in the future. > > -- Christian Schneider http://www.liquid-reality.de Open Source Architect Talend Application Integration Division http://www.talend.com |
| Powered by Nabble | Edit this page |
