Quantcast

Proposal: Commands for DB and JMS

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Proposal: Commands for DB and JMS

Christian Schneider
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

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Gert Vanthienen
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/
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Jean-Baptiste Onofré
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Christian Schneider
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

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Gert Vanthienen
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/
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Jean-Baptiste Onofré
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
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Łukasz Dywicki
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

Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Fernando Ribeiro
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
>
>
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Claus Ibsen-2
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/
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Proposal: Commands for DB and JMS

Christian Schneider
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

Loading...