Hi,
I don't understand why you think that spagic jdbc will not work in
feature???
If you look at the code:
- the jdbc poller component is a standard binding component
- the jdbc service engine is implemented using the lw-container but the
code can esailiy be ported to use
servicemix-bean.
By the way if you think to write db code inside webmethod this code will
be only usable with
webservices.
If you think in term of reusable services, your jdbc services will be
usable for example with a JMS input
or other supported binding component
Regards
Andrea Zoppello
Erik Allais ha scritto:
Gert,
My first idea was to add the necessary code to access the DB directly in my
JSR-181 webmethod
But i wonder if there is another way to do that...
The JDBC component from spagic is great but i fear to use something that
will not (maybe) work in the future...
Regards,
Erik
Gert Vanthienen wrote:
Erik,
Is your message flow something like...
HTTP/SOAP -> JSR-181 SU --> RDBMS
If so, wouldn't it be an option to add the necessary code to access the
DB right there in your JSR-181 webmethod?
Gert
Erik Allais wrote:
Gert,
Can i use the logic implemented inside the servicemix-bean SU in my
webmethod (jsr-181)
My webservice must send query to my database
Regards,
Erik
Gert Vanthienen wrote:
Erik,
If you just want to create a SA that is able to access a database with
JDBC, you can consider the use of a servicemix-bean SU, in which you can
just write Java code to handle a message exchange (using JDBC or
whatever Java technology you want). This would probably be the easiest
solution for you.
You could also write your own JDBC SE, to add JDBC functionality to the
JBI container and afterwards build a SA that targets this new SE.
There is a tutorial on writing these on
http://incubator.apache.org/servicemix/hello-world-se.html, but be sure
to check out
http://incubator.apache.org/servicemix/should-i-create-my-own-jbi-components.html
first. BTW, this would be a very welcome addition to ServiceMix, so any
contributions would be appreciated...
Gert
Erik Allais wrote:
hi,
Where can i find some tutorial to make my own SA with jdbc support?
Regards,
Erik
Andrea Zoppello-2 wrote:
Yes right,
But this is referred to the JDBC Poller Binding component. If you need
the service engine
you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
SMX_HOME/lib/optional.
Andrea Zoppello
Erik Allais ha scritto:
Andrea Zoppello-2 wrote:
Here the instructions:
- For the JDBC poller just download
spagic-service-manager1.0.0-RC1.zip
<http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
and unzip it the jdbcpoller is in
/SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
