Hi,
My comment inline
On 2011-8-12, at 上午12:04, ychawla wrote:
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:
No, we can't do it, because some bundle from jpa-hibernate features
doesn't use Apache compatible license
<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.
I think you hit a common issue when load jdbc drivers in OSGi
container, you may need take a look at similar discussion here[1]
[1]http://fusesource.com/forums/thread.jspa?messageID=9780☴
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.
I think you need create a new hibernate bundle which use 3.5.4
hibernate release.
Per the license issue I mentioned before, we can't do it here in
Servicemix.
Freeman
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.
---------------------------------------------
Freeman Fang
FuseSource
Email:[email protected]
Web: fusesource.com
Twitter: freemanfang
Blog: http://freemanfang.blogspot.com
