Hello All,
I have been trying to set up a Camel Route with ServiceMix and hibernate and
been running into some issues. I am going to document them here along with
some questions.
ServiceMix 4.3.0 doesn't ship with jpa-hibernate features, however fuse
does. To get hibernate working inside ServiceMix 4.3.0, I copied over the
features descriptor and the JDBC driver. Are there plans to add this
feature to the open source version:
<feature name="jpa-hibernate" version="4.3.0">
<bundle
dependency="true">mvn:org.apache.servicemix.specs/org.apache.servicemix.specs.java-persistence-api-1.1.1/1.8.0</bundle>
<bundle
dependency="true">mvn:org.springframework/spring-jdbc/3.0.5.RELEASE</bundle>
<bundle
dependency="true">mvn:org.apache.servicemix.bundles/org.apache.servicemix.bundles.dom4j/1.6.1_3</bundle>
<bundle
dependency="true">mvn:org.antlr/com.springsource.antlr/2.7.7</bundle>
<bundle
dependency="true">mvn:org.objectweb.asm/com.springsource.org.objectweb.asm/1.5.3</bundle>
<bundle
dependency="true">mvn:net.sourceforge.cglib/com.springsource.net.sf.cglib/2.2.0</bundle>
<bundle
dependency="true">mvn:org.jboss.javassist/com.springsource.javassist/3.9.0.GA</bundle>
<bundle>mvn:org.hibernate/com.springsource.org.hibernate.annotations.common/3.3.0.ga</bundle>
<bundle>mvn:org.hibernate/com.springsource.org.hibernate.annotations/3.4.0.GA</bundle>
<bundle>mvn:org.hibernate/com.springsource.org.hibernate.ejb/3.4.0.GA</bundle>
<bundle>mvn:org.hibernate/com.springsource.org.hibernate/3.3.2.GA</bundle>
<bundle>mvn:org.springframework/spring-orm/3.0.5.RELEASE</bundle>
<bundle>mvn:org.apache.commons/com.springsource.org.apache.commons.dbcp/1.2.2.osgi</bundle>
<bundle>mvn:org.springframework/spring-aop/3.0.5.RELEASE</bundle>
</feature>
<feature name="jdbc-drivers">
<bundle>mvn:com.mysql.jdbc/com.springsource.com.mysql.jdbc/5.1.6</bundle>
</feature>
I was also getting some strange errors about: SpringProxy is not visible
from class loader. To solve that, I added these import packages (also
showing the hibernate and driver imports):
org.springframework.aop,
org.springframework.aop.framework,
org.aopalliance.aop,
org.hibernate.jdbc,
com.mysql.jdbc,
*
Once I did that, the application started and was throwing errors :
Could not load driverClass com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
The JDBC drivers is imported and installed in ServiceMix. This seems to be
due to how c3p0 classes get loaded. According to Costin Leau: "For things
to work nicely inside OSGi you need to use the proper class loader.
Class.forName() w/o a classloader doesn't do that" Here's the link:
http://forum.springsource.org/showthread.php?59588-CNFE-when-loading-mysql-jdbc-driver&s=822a095d05cd327b315cc50a7eec4587
Has anyone been able to set up a c3p0 connection pool in ServiceMix? I went
ahead and switched to dbcp and that is working. It looks like the next
release of ServiceMix will have a dbcp feature included.
This next piece is probably a little off topic, but I will include it
anyway:
Up next I found a bug in the version of Hibernate that is OSGi packaged by
Spring Source. The issue is fixed in 3.5.4, however the OSGi package has
3.3.2. The bug didn't allow identify fields to be defined as BigInteger:
https://hibernate.onjira.com/browse/HHH-4905
This can be patched by updating a single class:
org/hibernate/id/IdentifierGeneratorFactory.java. I made this update in my
project and when I ran my camel route in Eclipse with camel:run, the patched
code was used. However, when I deploy to ServiceMix, it didn't use the
patched code. Is there anyway to explicitly tell ServiceMix which class to
use?
To solve this issue, I updated my existing code base to work with Hibernate
3.3.2. It would be nice if Hibernate distributed OSGi bundles for the
latest releases of their code.
Thanks,
Yogesh
--
View this message in context:
http://servicemix.396122.n5.nabble.com/Using-c3p0-and-hibernate-in-OSGi-bundle-in-ServiceMix-tp4690037p4690037.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
