You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@servicemix.apache.org by Sanazj <sj...@aegismobility.com> on 2009/10/09 02:33:52 UTC
Problems doing a query from Serivce Mix to MySql
Hi,
I'm fairly new to Service-Mix and been trying to use service-mix to update a
MySql datatbase. I have been trying to do a sample MySql query from a
servicemix bean that I have created using the code that posted online here:
http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
I have been unable to do a simple query, and attached you can all the files
I'm using as well as the log file with the error messages that I get. The
attached files are mu camel-su java source and camel-context, my bean-su
java source and xbean file. In addition I have also attached my service-mix
log file.
I would greatly appreciate it if you could have a look and let me know what
I'm doing wrong,
Sanaz
http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
DatabaseQueryBean.java
http://www.nabble.com/file/p25813908/MyRouteBuilder.java MyRouteBuilder.java
http://www.nabble.com/file/p25813908/camel-context.xml camel-context.xml
http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
--
View this message in context: http://www.nabble.com/Problems-doing-a-query-from-Serivce-Mix-to-MySql-tp25813908p25813908.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: Problems doing a query from Serivce Mix to MySql
Posted by Sanazj <sj...@aegismobility.com>.
Hi JB,
Thanks for clarifying the steps, I followed the steps you outlined and here
is the error I get:
ERROR | Timer-3 | InstallationService |
.framework.InstallationService 450 | Deployment of Component failed
javax.jbi.management.DeploymentException: java.lang.ClassNotFoundException:
org.apache.servicemix.common.DefaultBootstrap in classloader
org.apache.servicemix.common.DefaultBootstrap
Attached you can find the log file; I still haven't been able to get SCTT to
send test messages to ServiceMix. I'd appreciate it if you could take a look
at the log file and let me know how I might be able to get the SMPP
component working.
Regards,
Sanaz
http://www.nabble.com/file/p25913719/servicemix.log servicemix.log
Jean-Baptiste Onofré wrote:
>
> Hi Sanaz,
>
> to install the SMPP component snapshot, you have to perform the
> following steps:
>
> 1/ Delete the hotdeploy/servicemix-smpp*.zip files
> 2/ Download the SMPP component installer zip
> https://repository.apache.org/content/groups/snapshots-group/org/apache/servicemix/servicemix-smpp/2009.02-SNAPSHOT/servicemix-smpp-2009.02-20091012.200809-12-installer.zip
> 3/ in your SMPP SU POM, replace the SMPP component dependency (which
> should be set to 2009.01 currently) with 2009.02-SNAPSHOT
> 4/ start SMX (after deleting data and activemq-data directories)
>
> Regards
> JB
>
> Sanazj wrote:
>> Hi JB,
>>
>> Following yesterday's email, I did a bit of experimentation with the
>> various
>> Jar files and when using the 2009.02-20091008.130308-11 snap shot and
>> it's
>> corresponding Jar file, if I remove servicemix-smpp-2009.01 from the
>> C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib
>> folder then I get a component not found error as can be seen in the
>> attached
>> error log.
>>
>> I'm still not sure what's causing this and why even when I have the
>> corresponding Jar file copied to
>> C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib,
>> servicemix still complains about the component not being present.
>>
>> Sanaz
>> http://www.nabble.com/file/p25900442/servicemix.log servicemix.log
>>
>>
>> Jean-Baptiste Onofré wrote:
>>> Hi Sanaz,
>>>
>>> OK, let me check the component code again. I will keep you posted.
>>>
>>> Regards
>>> JB
>>>
>>> Sanazj wrote:
>>>> Hi JB,
>>>>
>>>> Thanks for the link; I've tried using two of the snap shots posted
>>>> there:
>>>> 2009.02-20091012.200809-12 dated Oct 12th and
>>>> 2009.02-20091008.130308-11
>>>> dated Oct 8th; but have had no luck with SCTT and the exchange message
>>>> bug
>>>> still seems to be there. Please find the attached log file. In addition
>>>> I
>>>> wanted to mention that for each of these snapshots I copied over the
>>>> latest
>>>> .Jar and schema files to
>>>> C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib
>>>> and C:\ServiceMix\apache-servicemix-3.3.1\schemas respectively.
>>>>
>>>> Again your help is greatly appreciated,
>>>>
>>>> Sanaz
>>>> http://www.nabble.com/file/p25883006/servicemix.log servicemix.log
>>>>
>>>>
>>>> Jean-Baptiste Onofré wrote:
>>>>> Hi,
>>>>>
>>>>> You already have a servicemix-smpp snapshot dating from yesterday:
>>>>> https://repository.apache.org/content/groups/snapshots-group/org/apache/servicemix/servicemix-smpp/2009.02-SNAPSHOT/
>>>>>
>>>>> The snapshots are built every night.
>>>>>
>>>>> Take a look into the repository location and you should be able to
>>>>> find
>>>>> installer.zip and jar file of the SMPP component snapshot.
>>>>>
>>>>> Regards
>>>>> JB
>>>>>
>>>>> Sanazj wrote:
>>>>>> Hi JB,
>>>>>>
>>>>>> Thanks for pointing that out, I'm now able to do update and read from
>>>>>> MySql
>>>>>> table.
>>>>>> I was wondering if you have a time estimate of when the SMPP snapshot
>>>>>> will
>>>>>> be built and ready to use.
>>>>>>
>>>>>> Thanks in advance,
>>>>>>
>>>>>> Sanaz
>>>>>>
>>>>>>
>>>>>> Jean-Baptiste Onofré wrote:
>>>>>>> Hi,
>>>>>>>
>>>>>>> You got a NullPointerException when trying to transform the in
>>>>>>> message
>>>>>>> content into a SQL query.
>>>>>>>
>>>>>>> I think that the in message is null (or the content of the message
>>>>>>> is
>>>>>>> null).
>>>>>>>
>>>>>>> Could you add some logs around the line 78 of the bean ? I guess
>>>>>>> that
>>>>>>> the NullPointerException is raised by message.getContent()
>>>>>>> statement.
>>>>>>>
>>>>>>> Nota: I know that you're working with the SMPP component. I have
>>>>>>> corrected a bug yesterday where the SMPP consumer endpoint didn't
>>>>>>> really
>>>>>>> send the exchange. I advice you to use the 2009.02-SNAPSHOT SMPP
>>>>>>> component as soon as the snapshot had been built.
>>>>>>>
>>>>>>> Be careful, the message content has to be compliant with that the
>>>>>>> bean
>>>>>>> expects. The bean is waiting for a message content that contains a
>>>>>>> tag
>>>>>>> <query/>.
>>>>>>>
>>>>>>> Regards
>>>>>>> JB
>>>>>>>
>>>>>>> Sanazj wrote:
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I'm fairly new to Service-Mix and been trying to use service-mix to
>>>>>>>> update a
>>>>>>>> MySql datatbase. I have been trying to do a sample MySql query from
>>>>>>>> a
>>>>>>>> servicemix bean that I have created using the code that posted
>>>>>>>> online
>>>>>>>> here:
>>>>>>>> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>>>>>>>>
>>>>>>>> I have been unable to do a simple query, and attached you can all
>>>>>>>> the
>>>>>>>> files
>>>>>>>> I'm using as well as the log file with the error messages that I
>>>>>>>> get.
>>>>>>>> The
>>>>>>>> attached files are mu camel-su java source and camel-context, my
>>>>>>>> bean-su
>>>>>>>> java source and xbean file. In addition I have also attached my
>>>>>>>> service-mix
>>>>>>>> log file.
>>>>>>>>
>>>>>>>> I would greatly appreciate it if you could have a look and let me
>>>>>>>> know
>>>>>>>> what
>>>>>>>> I'm doing wrong,
>>>>>>>>
>>>>>>>> Sanaz
>>>>>>>>
>>>>>>>> http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
>>>>>>>> DatabaseQueryBean.java
>>>>>>>> http://www.nabble.com/file/p25813908/MyRouteBuilder.java
>>>>>>>> MyRouteBuilder.java
>>>>>>>> http://www.nabble.com/file/p25813908/camel-context.xml
>>>>>>>> camel-context.xml
>>>>>>>> http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
>>>>>>>> http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
>>>>>>>>
>>>
>>
>
>
--
View this message in context: http://www.nabble.com/Problems-doing-a-query-from-Serivce-Mix-to-MySql-tp25813908p25913719.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: Problems doing a query from Serivce Mix to MySql
Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
Hi Sanaz,
to install the SMPP component snapshot, you have to perform the
following steps:
1/ Delete the hotdeploy/servicemix-smpp*.zip files
2/ Download the SMPP component installer zip
https://repository.apache.org/content/groups/snapshots-group/org/apache/servicemix/servicemix-smpp/2009.02-SNAPSHOT/servicemix-smpp-2009.02-20091012.200809-12-installer.zip
3/ in your SMPP SU POM, replace the SMPP component dependency (which
should be set to 2009.01 currently) with 2009.02-SNAPSHOT
4/ start SMX (after deleting data and activemq-data directories)
Regards
JB
Sanazj wrote:
> Hi JB,
>
> Following yesterday's email, I did a bit of experimentation with the various
> Jar files and when using the 2009.02-20091008.130308-11 snap shot and it's
> corresponding Jar file, if I remove servicemix-smpp-2009.01 from the
> C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib
> folder then I get a component not found error as can be seen in the attached
> error log.
>
> I'm still not sure what's causing this and why even when I have the
> corresponding Jar file copied to
> C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib,
> servicemix still complains about the component not being present.
>
> Sanaz
> http://www.nabble.com/file/p25900442/servicemix.log servicemix.log
>
>
> Jean-Baptiste Onofré wrote:
>> Hi Sanaz,
>>
>> OK, let me check the component code again. I will keep you posted.
>>
>> Regards
>> JB
>>
>> Sanazj wrote:
>>> Hi JB,
>>>
>>> Thanks for the link; I've tried using two of the snap shots posted there:
>>> 2009.02-20091012.200809-12 dated Oct 12th and 2009.02-20091008.130308-11
>>> dated Oct 8th; but have had no luck with SCTT and the exchange message
>>> bug
>>> still seems to be there. Please find the attached log file. In addition I
>>> wanted to mention that for each of these snapshots I copied over the
>>> latest
>>> .Jar and schema files to
>>> C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib
>>> and C:\ServiceMix\apache-servicemix-3.3.1\schemas respectively.
>>>
>>> Again your help is greatly appreciated,
>>>
>>> Sanaz
>>> http://www.nabble.com/file/p25883006/servicemix.log servicemix.log
>>>
>>>
>>> Jean-Baptiste Onofré wrote:
>>>> Hi,
>>>>
>>>> You already have a servicemix-smpp snapshot dating from yesterday:
>>>> https://repository.apache.org/content/groups/snapshots-group/org/apache/servicemix/servicemix-smpp/2009.02-SNAPSHOT/
>>>>
>>>> The snapshots are built every night.
>>>>
>>>> Take a look into the repository location and you should be able to find
>>>> installer.zip and jar file of the SMPP component snapshot.
>>>>
>>>> Regards
>>>> JB
>>>>
>>>> Sanazj wrote:
>>>>> Hi JB,
>>>>>
>>>>> Thanks for pointing that out, I'm now able to do update and read from
>>>>> MySql
>>>>> table.
>>>>> I was wondering if you have a time estimate of when the SMPP snapshot
>>>>> will
>>>>> be built and ready to use.
>>>>>
>>>>> Thanks in advance,
>>>>>
>>>>> Sanaz
>>>>>
>>>>>
>>>>> Jean-Baptiste Onofré wrote:
>>>>>> Hi,
>>>>>>
>>>>>> You got a NullPointerException when trying to transform the in message
>>>>>> content into a SQL query.
>>>>>>
>>>>>> I think that the in message is null (or the content of the message is
>>>>>> null).
>>>>>>
>>>>>> Could you add some logs around the line 78 of the bean ? I guess that
>>>>>> the NullPointerException is raised by message.getContent() statement.
>>>>>>
>>>>>> Nota: I know that you're working with the SMPP component. I have
>>>>>> corrected a bug yesterday where the SMPP consumer endpoint didn't
>>>>>> really
>>>>>> send the exchange. I advice you to use the 2009.02-SNAPSHOT SMPP
>>>>>> component as soon as the snapshot had been built.
>>>>>>
>>>>>> Be careful, the message content has to be compliant with that the bean
>>>>>> expects. The bean is waiting for a message content that contains a tag
>>>>>> <query/>.
>>>>>>
>>>>>> Regards
>>>>>> JB
>>>>>>
>>>>>> Sanazj wrote:
>>>>>>> Hi,
>>>>>>>
>>>>>>> I'm fairly new to Service-Mix and been trying to use service-mix to
>>>>>>> update a
>>>>>>> MySql datatbase. I have been trying to do a sample MySql query from a
>>>>>>> servicemix bean that I have created using the code that posted online
>>>>>>> here:
>>>>>>> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>>>>>>>
>>>>>>> I have been unable to do a simple query, and attached you can all the
>>>>>>> files
>>>>>>> I'm using as well as the log file with the error messages that I get.
>>>>>>> The
>>>>>>> attached files are mu camel-su java source and camel-context, my
>>>>>>> bean-su
>>>>>>> java source and xbean file. In addition I have also attached my
>>>>>>> service-mix
>>>>>>> log file.
>>>>>>>
>>>>>>> I would greatly appreciate it if you could have a look and let me
>>>>>>> know
>>>>>>> what
>>>>>>> I'm doing wrong,
>>>>>>>
>>>>>>> Sanaz
>>>>>>>
>>>>>>> http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
>>>>>>> DatabaseQueryBean.java
>>>>>>> http://www.nabble.com/file/p25813908/MyRouteBuilder.java
>>>>>>> MyRouteBuilder.java
>>>>>>> http://www.nabble.com/file/p25813908/camel-context.xml
>>>>>>> camel-context.xml
>>>>>>> http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
>>>>>>> http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
>>>>>>>
>>
>
Re: Problems doing a query from Serivce Mix to MySql
Posted by Sanazj <sj...@aegismobility.com>.
Hi JB,
Following yesterday's email, I did a bit of experimentation with the various
Jar files and when using the 2009.02-20091008.130308-11 snap shot and it's
corresponding Jar file, if I remove servicemix-smpp-2009.01 from the
C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib
folder then I get a component not found error as can be seen in the attached
error log.
I'm still not sure what's causing this and why even when I have the
corresponding Jar file copied to
C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib,
servicemix still complains about the component not being present.
Sanaz
http://www.nabble.com/file/p25900442/servicemix.log servicemix.log
Jean-Baptiste Onofré wrote:
>
> Hi Sanaz,
>
> OK, let me check the component code again. I will keep you posted.
>
> Regards
> JB
>
> Sanazj wrote:
>> Hi JB,
>>
>> Thanks for the link; I've tried using two of the snap shots posted there:
>> 2009.02-20091012.200809-12 dated Oct 12th and 2009.02-20091008.130308-11
>> dated Oct 8th; but have had no luck with SCTT and the exchange message
>> bug
>> still seems to be there. Please find the attached log file. In addition I
>> wanted to mention that for each of these snapshots I copied over the
>> latest
>> .Jar and schema files to
>> C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib
>> and C:\ServiceMix\apache-servicemix-3.3.1\schemas respectively.
>>
>> Again your help is greatly appreciated,
>>
>> Sanaz
>> http://www.nabble.com/file/p25883006/servicemix.log servicemix.log
>>
>>
>> Jean-Baptiste Onofré wrote:
>>> Hi,
>>>
>>> You already have a servicemix-smpp snapshot dating from yesterday:
>>> https://repository.apache.org/content/groups/snapshots-group/org/apache/servicemix/servicemix-smpp/2009.02-SNAPSHOT/
>>>
>>> The snapshots are built every night.
>>>
>>> Take a look into the repository location and you should be able to find
>>> installer.zip and jar file of the SMPP component snapshot.
>>>
>>> Regards
>>> JB
>>>
>>> Sanazj wrote:
>>>> Hi JB,
>>>>
>>>> Thanks for pointing that out, I'm now able to do update and read from
>>>> MySql
>>>> table.
>>>> I was wondering if you have a time estimate of when the SMPP snapshot
>>>> will
>>>> be built and ready to use.
>>>>
>>>> Thanks in advance,
>>>>
>>>> Sanaz
>>>>
>>>>
>>>> Jean-Baptiste Onofré wrote:
>>>>> Hi,
>>>>>
>>>>> You got a NullPointerException when trying to transform the in message
>>>>> content into a SQL query.
>>>>>
>>>>> I think that the in message is null (or the content of the message is
>>>>> null).
>>>>>
>>>>> Could you add some logs around the line 78 of the bean ? I guess that
>>>>> the NullPointerException is raised by message.getContent() statement.
>>>>>
>>>>> Nota: I know that you're working with the SMPP component. I have
>>>>> corrected a bug yesterday where the SMPP consumer endpoint didn't
>>>>> really
>>>>> send the exchange. I advice you to use the 2009.02-SNAPSHOT SMPP
>>>>> component as soon as the snapshot had been built.
>>>>>
>>>>> Be careful, the message content has to be compliant with that the bean
>>>>> expects. The bean is waiting for a message content that contains a tag
>>>>> <query/>.
>>>>>
>>>>> Regards
>>>>> JB
>>>>>
>>>>> Sanazj wrote:
>>>>>> Hi,
>>>>>>
>>>>>> I'm fairly new to Service-Mix and been trying to use service-mix to
>>>>>> update a
>>>>>> MySql datatbase. I have been trying to do a sample MySql query from a
>>>>>> servicemix bean that I have created using the code that posted online
>>>>>> here:
>>>>>> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>>>>>>
>>>>>> I have been unable to do a simple query, and attached you can all the
>>>>>> files
>>>>>> I'm using as well as the log file with the error messages that I get.
>>>>>> The
>>>>>> attached files are mu camel-su java source and camel-context, my
>>>>>> bean-su
>>>>>> java source and xbean file. In addition I have also attached my
>>>>>> service-mix
>>>>>> log file.
>>>>>>
>>>>>> I would greatly appreciate it if you could have a look and let me
>>>>>> know
>>>>>> what
>>>>>> I'm doing wrong,
>>>>>>
>>>>>> Sanaz
>>>>>>
>>>>>> http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
>>>>>> DatabaseQueryBean.java
>>>>>> http://www.nabble.com/file/p25813908/MyRouteBuilder.java
>>>>>> MyRouteBuilder.java
>>>>>> http://www.nabble.com/file/p25813908/camel-context.xml
>>>>>> camel-context.xml
>>>>>> http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
>>>>>> http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
>>>>>>
>>>
>>
>
>
--
View this message in context: http://www.nabble.com/Problems-doing-a-query-from-Serivce-Mix-to-MySql-tp25813908p25900442.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: Problems doing a query from Serivce Mix to MySql
Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
Hi Sanaz,
OK, let me check the component code again. I will keep you posted.
Regards
JB
Sanazj wrote:
> Hi JB,
>
> Thanks for the link; I've tried using two of the snap shots posted there:
> 2009.02-20091012.200809-12 dated Oct 12th and 2009.02-20091008.130308-11
> dated Oct 8th; but have had no luck with SCTT and the exchange message bug
> still seems to be there. Please find the attached log file. In addition I
> wanted to mention that for each of these snapshots I copied over the latest
> .Jar and schema files to
> C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib
> and C:\ServiceMix\apache-servicemix-3.3.1\schemas respectively.
>
> Again your help is greatly appreciated,
>
> Sanaz
> http://www.nabble.com/file/p25883006/servicemix.log servicemix.log
>
>
> Jean-Baptiste Onofré wrote:
>> Hi,
>>
>> You already have a servicemix-smpp snapshot dating from yesterday:
>> https://repository.apache.org/content/groups/snapshots-group/org/apache/servicemix/servicemix-smpp/2009.02-SNAPSHOT/
>>
>> The snapshots are built every night.
>>
>> Take a look into the repository location and you should be able to find
>> installer.zip and jar file of the SMPP component snapshot.
>>
>> Regards
>> JB
>>
>> Sanazj wrote:
>>> Hi JB,
>>>
>>> Thanks for pointing that out, I'm now able to do update and read from
>>> MySql
>>> table.
>>> I was wondering if you have a time estimate of when the SMPP snapshot
>>> will
>>> be built and ready to use.
>>>
>>> Thanks in advance,
>>>
>>> Sanaz
>>>
>>>
>>> Jean-Baptiste Onofré wrote:
>>>> Hi,
>>>>
>>>> You got a NullPointerException when trying to transform the in message
>>>> content into a SQL query.
>>>>
>>>> I think that the in message is null (or the content of the message is
>>>> null).
>>>>
>>>> Could you add some logs around the line 78 of the bean ? I guess that
>>>> the NullPointerException is raised by message.getContent() statement.
>>>>
>>>> Nota: I know that you're working with the SMPP component. I have
>>>> corrected a bug yesterday where the SMPP consumer endpoint didn't really
>>>> send the exchange. I advice you to use the 2009.02-SNAPSHOT SMPP
>>>> component as soon as the snapshot had been built.
>>>>
>>>> Be careful, the message content has to be compliant with that the bean
>>>> expects. The bean is waiting for a message content that contains a tag
>>>> <query/>.
>>>>
>>>> Regards
>>>> JB
>>>>
>>>> Sanazj wrote:
>>>>> Hi,
>>>>>
>>>>> I'm fairly new to Service-Mix and been trying to use service-mix to
>>>>> update a
>>>>> MySql datatbase. I have been trying to do a sample MySql query from a
>>>>> servicemix bean that I have created using the code that posted online
>>>>> here:
>>>>> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>>>>>
>>>>> I have been unable to do a simple query, and attached you can all the
>>>>> files
>>>>> I'm using as well as the log file with the error messages that I get.
>>>>> The
>>>>> attached files are mu camel-su java source and camel-context, my
>>>>> bean-su
>>>>> java source and xbean file. In addition I have also attached my
>>>>> service-mix
>>>>> log file.
>>>>>
>>>>> I would greatly appreciate it if you could have a look and let me know
>>>>> what
>>>>> I'm doing wrong,
>>>>>
>>>>> Sanaz
>>>>>
>>>>> http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
>>>>> DatabaseQueryBean.java
>>>>> http://www.nabble.com/file/p25813908/MyRouteBuilder.java
>>>>> MyRouteBuilder.java
>>>>> http://www.nabble.com/file/p25813908/camel-context.xml
>>>>> camel-context.xml
>>>>> http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
>>>>> http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
>>>>>
>>
>
Re: Problems doing a query from Serivce Mix to MySql
Posted by Sanazj <sj...@aegismobility.com>.
Hi JB,
Thanks for the link; I've tried using two of the snap shots posted there:
2009.02-20091012.200809-12 dated Oct 12th and 2009.02-20091008.130308-11
dated Oct 8th; but have had no luck with SCTT and the exchange message bug
still seems to be there. Please find the attached log file. In addition I
wanted to mention that for each of these snapshots I copied over the latest
.Jar and schema files to
C:\ServiceMix\apache-servicemix-3.3.1\data\smx\components\servicemix-smpp\version_1\lib
and C:\ServiceMix\apache-servicemix-3.3.1\schemas respectively.
Again your help is greatly appreciated,
Sanaz
http://www.nabble.com/file/p25883006/servicemix.log servicemix.log
Jean-Baptiste Onofré wrote:
>
> Hi,
>
> You already have a servicemix-smpp snapshot dating from yesterday:
> https://repository.apache.org/content/groups/snapshots-group/org/apache/servicemix/servicemix-smpp/2009.02-SNAPSHOT/
>
> The snapshots are built every night.
>
> Take a look into the repository location and you should be able to find
> installer.zip and jar file of the SMPP component snapshot.
>
> Regards
> JB
>
> Sanazj wrote:
>> Hi JB,
>>
>> Thanks for pointing that out, I'm now able to do update and read from
>> MySql
>> table.
>> I was wondering if you have a time estimate of when the SMPP snapshot
>> will
>> be built and ready to use.
>>
>> Thanks in advance,
>>
>> Sanaz
>>
>>
>> Jean-Baptiste Onofré wrote:
>>> Hi,
>>>
>>> You got a NullPointerException when trying to transform the in message
>>> content into a SQL query.
>>>
>>> I think that the in message is null (or the content of the message is
>>> null).
>>>
>>> Could you add some logs around the line 78 of the bean ? I guess that
>>> the NullPointerException is raised by message.getContent() statement.
>>>
>>> Nota: I know that you're working with the SMPP component. I have
>>> corrected a bug yesterday where the SMPP consumer endpoint didn't really
>>> send the exchange. I advice you to use the 2009.02-SNAPSHOT SMPP
>>> component as soon as the snapshot had been built.
>>>
>>> Be careful, the message content has to be compliant with that the bean
>>> expects. The bean is waiting for a message content that contains a tag
>>> <query/>.
>>>
>>> Regards
>>> JB
>>>
>>> Sanazj wrote:
>>>> Hi,
>>>>
>>>> I'm fairly new to Service-Mix and been trying to use service-mix to
>>>> update a
>>>> MySql datatbase. I have been trying to do a sample MySql query from a
>>>> servicemix bean that I have created using the code that posted online
>>>> here:
>>>> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>>>>
>>>> I have been unable to do a simple query, and attached you can all the
>>>> files
>>>> I'm using as well as the log file with the error messages that I get.
>>>> The
>>>> attached files are mu camel-su java source and camel-context, my
>>>> bean-su
>>>> java source and xbean file. In addition I have also attached my
>>>> service-mix
>>>> log file.
>>>>
>>>> I would greatly appreciate it if you could have a look and let me know
>>>> what
>>>> I'm doing wrong,
>>>>
>>>> Sanaz
>>>>
>>>> http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
>>>> DatabaseQueryBean.java
>>>> http://www.nabble.com/file/p25813908/MyRouteBuilder.java
>>>> MyRouteBuilder.java
>>>> http://www.nabble.com/file/p25813908/camel-context.xml
>>>> camel-context.xml
>>>> http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
>>>> http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
>>>>
>>>
>>
>
>
--
View this message in context: http://www.nabble.com/Problems-doing-a-query-from-Serivce-Mix-to-MySql-tp25813908p25883006.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: Problems doing a query from Serivce Mix to MySql
Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
Hi,
You already have a servicemix-smpp snapshot dating from yesterday:
https://repository.apache.org/content/groups/snapshots-group/org/apache/servicemix/servicemix-smpp/2009.02-SNAPSHOT/
The snapshots are built every night.
Take a look into the repository location and you should be able to find
installer.zip and jar file of the SMPP component snapshot.
Regards
JB
Sanazj wrote:
> Hi JB,
>
> Thanks for pointing that out, I'm now able to do update and read from MySql
> table.
> I was wondering if you have a time estimate of when the SMPP snapshot will
> be built and ready to use.
>
> Thanks in advance,
>
> Sanaz
>
>
> Jean-Baptiste Onofré wrote:
>> Hi,
>>
>> You got a NullPointerException when trying to transform the in message
>> content into a SQL query.
>>
>> I think that the in message is null (or the content of the message is
>> null).
>>
>> Could you add some logs around the line 78 of the bean ? I guess that
>> the NullPointerException is raised by message.getContent() statement.
>>
>> Nota: I know that you're working with the SMPP component. I have
>> corrected a bug yesterday where the SMPP consumer endpoint didn't really
>> send the exchange. I advice you to use the 2009.02-SNAPSHOT SMPP
>> component as soon as the snapshot had been built.
>>
>> Be careful, the message content has to be compliant with that the bean
>> expects. The bean is waiting for a message content that contains a tag
>> <query/>.
>>
>> Regards
>> JB
>>
>> Sanazj wrote:
>>> Hi,
>>>
>>> I'm fairly new to Service-Mix and been trying to use service-mix to
>>> update a
>>> MySql datatbase. I have been trying to do a sample MySql query from a
>>> servicemix bean that I have created using the code that posted online
>>> here:
>>> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>>>
>>> I have been unable to do a simple query, and attached you can all the
>>> files
>>> I'm using as well as the log file with the error messages that I get. The
>>> attached files are mu camel-su java source and camel-context, my bean-su
>>> java source and xbean file. In addition I have also attached my
>>> service-mix
>>> log file.
>>>
>>> I would greatly appreciate it if you could have a look and let me know
>>> what
>>> I'm doing wrong,
>>>
>>> Sanaz
>>>
>>> http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
>>> DatabaseQueryBean.java
>>> http://www.nabble.com/file/p25813908/MyRouteBuilder.java
>>> MyRouteBuilder.java
>>> http://www.nabble.com/file/p25813908/camel-context.xml camel-context.xml
>>> http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
>>> http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
>>>
>>
>
Re: Problems doing a query from Serivce Mix to MySql
Posted by Sanazj <sj...@aegismobility.com>.
Hi JB,
Thanks for pointing that out, I'm now able to do update and read from MySql
table.
I was wondering if you have a time estimate of when the SMPP snapshot will
be built and ready to use.
Thanks in advance,
Sanaz
Jean-Baptiste Onofré wrote:
>
> Hi,
>
> You got a NullPointerException when trying to transform the in message
> content into a SQL query.
>
> I think that the in message is null (or the content of the message is
> null).
>
> Could you add some logs around the line 78 of the bean ? I guess that
> the NullPointerException is raised by message.getContent() statement.
>
> Nota: I know that you're working with the SMPP component. I have
> corrected a bug yesterday where the SMPP consumer endpoint didn't really
> send the exchange. I advice you to use the 2009.02-SNAPSHOT SMPP
> component as soon as the snapshot had been built.
>
> Be careful, the message content has to be compliant with that the bean
> expects. The bean is waiting for a message content that contains a tag
> <query/>.
>
> Regards
> JB
>
> Sanazj wrote:
>> Hi,
>>
>> I'm fairly new to Service-Mix and been trying to use service-mix to
>> update a
>> MySql datatbase. I have been trying to do a sample MySql query from a
>> servicemix bean that I have created using the code that posted online
>> here:
>> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>>
>> I have been unable to do a simple query, and attached you can all the
>> files
>> I'm using as well as the log file with the error messages that I get. The
>> attached files are mu camel-su java source and camel-context, my bean-su
>> java source and xbean file. In addition I have also attached my
>> service-mix
>> log file.
>>
>> I would greatly appreciate it if you could have a look and let me know
>> what
>> I'm doing wrong,
>>
>> Sanaz
>>
>> http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
>> DatabaseQueryBean.java
>> http://www.nabble.com/file/p25813908/MyRouteBuilder.java
>> MyRouteBuilder.java
>> http://www.nabble.com/file/p25813908/camel-context.xml camel-context.xml
>> http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
>> http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
>>
>
>
--
View this message in context: http://www.nabble.com/Problems-doing-a-query-from-Serivce-Mix-to-MySql-tp25813908p25829296.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: Problems doing a query from Serivce Mix to MySql
Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
Hi,
You got a NullPointerException when trying to transform the in message
content into a SQL query.
I think that the in message is null (or the content of the message is null).
Could you add some logs around the line 78 of the bean ? I guess that
the NullPointerException is raised by message.getContent() statement.
Nota: I know that you're working with the SMPP component. I have
corrected a bug yesterday where the SMPP consumer endpoint didn't really
send the exchange. I advice you to use the 2009.02-SNAPSHOT SMPP
component as soon as the snapshot had been built.
Be careful, the message content has to be compliant with that the bean
expects. The bean is waiting for a message content that contains a tag
<query/>.
Regards
JB
Sanazj wrote:
> Hi,
>
> I'm fairly new to Service-Mix and been trying to use service-mix to update a
> MySql datatbase. I have been trying to do a sample MySql query from a
> servicemix bean that I have created using the code that posted online here:
> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>
> I have been unable to do a simple query, and attached you can all the files
> I'm using as well as the log file with the error messages that I get. The
> attached files are mu camel-su java source and camel-context, my bean-su
> java source and xbean file. In addition I have also attached my service-mix
> log file.
>
> I would greatly appreciate it if you could have a look and let me know what
> I'm doing wrong,
>
> Sanaz
>
> http://www.nabble.com/file/p25813908/DatabaseQueryBean.java
> DatabaseQueryBean.java
> http://www.nabble.com/file/p25813908/MyRouteBuilder.java MyRouteBuilder.java
> http://www.nabble.com/file/p25813908/camel-context.xml camel-context.xml
> http://www.nabble.com/file/p25813908/xbean.xml xbean.xml
> http://www.nabble.com/file/p25813908/servicemix.log servicemix.log
>