Hi Uli, there is Chris Schneider´s blog on this topic(s): http://www.liquid-reality.de/display/liquid/2012/07/20/Apache+Karaf+Tutorial+Part+7+-+Camel+JPA+and+JTA+transactions There is also a post on jdbc and how to install drivers, etc.
Basically for jdbc you need: - smx/karaf - camel-jdbc - an osgi-ified driver (mysqlxxx.jar, whatever) - most recent already contain manifest, etc. - a datasource.xml (naming is not relevant) where you configure your driver (I think this could also be included in the CamelContext but makes sense to externalize) - a CamelContext referencing your datasource.xml I did not try jpa, happy with plain jdbc. Don´t know about activemq-jdbc persistence: probably ask amq-mailinglist. I suppose there is documentation on that topic. Cheers, Thomas. -----Ursprüngliche Nachricht----- Von: UliSE [mailto:[email protected]] Gesendet: Freitag, 25. Juli 2014 13:21 An: [email protected] Betreff: Database (jdbc, jpa, XA, ...) setup in Servicemix 5.1.0 Hi, I´m trying to configure a servicemix (5.1.0) to the needs of a project I´m in. I´ve got some questions on database/persistence features doing so. First: I need to connect to databases (DB2, Oracle, Mysql, postgres) using camel-jpa (might be camel-jdbc as well) And I sometimes need XA transactions on this Second: I would like to change activeMQs persistence in production to a (jdbc) database The idea is to have reliable and clustered queues. Surfing up an down the communities on this brings up the picture that using a (jdbc) database is not really mainstream in OSGi environments. If there are any samples from 3rd parties (many thanks at all) I cannot figure out what the "servicemix way" of doing jdbc is. The servicemix web stated, that there is support for jpa, XA, ... but for me this is hard to setup because of missing hints (samples, ...). Is the conclusion to use activemq/camel without servicemix or in an other container if I want to connect to (might be several) jdbc databases? (Would be sad, because I love OSGi and karaf.) Is there a better way to use databases in servicemix than jdbc? Is there a "the osgi jdbc solution for servicemix" which I can adapt for both camel-jpa and activemq persistence? Many thank for some information, Uli -- View this message in context: http://servicemix.396122.n5.nabble.com/Database-jdbc-jpa-XA-setup-in-Servicemix-5-1-0-tp5721374.html Sent from the ServiceMix - User mailing list archive at Nabble.com.
