Hibernate + MySQL problem
jpedroraraujo Jan 12, 2010 10:19 AMHi guys,
I've deployed Hibernate + MySQL bundles and all related dependencies from Spring Bundle Repository in Fuse ESB 4.1.0.2.
These two:
JBoss Hibernate Object-Relational Mapper (3.3.2.GA)
MySQL AB's JDBC Driver for MySQL (5.1.6)
I've created a bundle that its just a simple Spring application with a DAO class just to access the database via hibernate template. Everything works fine when i deploy it into Fuse ESB, the status of the bundle is "Active" and Spring is "Started", but i get this error in log file:
14:50:33,056 | INFO | xtenderThread-76 | HbmBinder |org.hibernate.cfg.HbmBinder 322 | Mapping class: com.bosch.seppo.hibernateTeste.model.Product -> Product
14:50:33,057 | INFO | xtenderThread-76 | LocalSessionFactoryBean | bernate3.LocalSessionFactoryBean 730 | Building new Hibernate SessionFactory
14:50:33,057 | INFO | xtenderThread-76 | ConnectionProviderFactory | ection.ConnectionProviderFactory 95 | Initializing connection provider: org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider
14:50:33,058 | WARN | xtenderThread-76 | JDBCExceptionReporter | rnate.util.JDBCExceptionReporter 100 | SQL Error: 0, SQLState: 08001
14:50:33,059 | ERROR | xtenderThread-76 | JDBCExceptionReporter | rnate.util.JDBCExceptionReporter 101 | No suitable driver found for jdbc:mysql://10.32.6.53:3306/seppo
14:50:33,059 | WARN | xtenderThread-76 | SettingsFactory | rg.hibernate.cfg.SettingsFactory 133 | Could not obtain connection to query metadata
java.sql.SQLException: No suitable driver found for jdbc:mysql://10.32.6.53:3306/seppo
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:111)
at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)
at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)
at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
In pom.xml i have:
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://10.32.6.53:3306/seppo"/>
when i try to persist something in the database i get the same type of error because JDBC connection can't be established... it's missing the driver? how is that possible?
I'm doing something wrong? I'm missing something?
Can anyone help me please?
Regards,
Pedro Araújo
Edited by: pedroprodigy on Jan 12, 2010 3:15 PM
Edited by: pedroprodigy on Jan 12, 2010 3:19 PM
Edited by: pedroprodigy on Jan 12, 2010 3:19 PM