[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - "Could not obtain connection metadata' when generating Hiber

[gbadavidson]

I am attempting to use Hibernate with JSF/Facelets on the JBoss AS. When the application attempts to build the Hibernate Session Factory an error is thrown "Could not obtain connection metadata", yet the driver is listed a few lines eariler in the log. Here is the relevent lines from the log and then the Hibernate configuration file. :



  | 
  | 10:13:20,146 INFO  [Configuration] configuring from resource: /hibernate.cfg.xml
  | 10:13:20,146 INFO  [Configuration] Configuration resource: /hibernate.cfg.xml
  | 10:13:20,209 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Phone.hbm.xml
  | 10:13:20,287 INFO  [HbmBinder] Mapping class: person.Phone -> phone
  | 10:13:20,302 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Personrolexref.hbm.xml
  | 10:13:20,302 INFO  [HbmBinder] Mapping class: person.Personrolexref -> personrolexref
  | 10:13:20,302 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Personaddressxref.hbm.xml
  | 10:13:20,334 INFO  [HbmBinder] Mapping class: person.Personaddressxref -> personaddressxref
  | 10:13:20,334 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Role.hbm.xml
  | 10:13:20,334 INFO  [HbmBinder] Mapping class: person.Role -> role
  | 10:13:20,334 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Person.hbm.xml
  | 10:13:20,349 INFO  [HbmBinder] Mapping class: person.Person -> person
  | 10:13:20,349 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Address.hbm.xml
  | 10:13:20,349 INFO  [HbmBinder] Mapping class: person.Address -> address
  | 10:13:20,349 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Personcoursexref.hbm.xml
  | 10:13:20,365 INFO  [HbmBinder] Mapping class: person.Personcoursexref -> personcoursexref
  | 10:13:20,365 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Personphonexref.hbm.xml
  | 10:13:20,365 INFO  [HbmBinder] Mapping class: person.Personphonexref -> personphonexref
  | 10:13:20,365 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Coursecategoryxref.hbm.xml
  | 10:13:20,365 INFO  [HbmBinder] Mapping class: course.Coursecategoryxref -> coursecategoryxref
  | 10:13:20,365 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Course.hbm.xml
  | 10:13:20,380 INFO  [HbmBinder] Mapping class: course.Course -> course
  | 10:13:20,380 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Courseprogresshistory.hbm.xml
  | 10:13:20,380 INFO  [HbmBinder] Mapping class: course.Courseprogresshistory -> courseprogresshistory
  | 10:13:20,380 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Category.hbm.xml
  | 10:13:20,396 INFO  [HbmBinder] Mapping class: course.Category -> category
  | 10:13:20,396 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Visibility.hbm.xml
  | 10:13:20,396 INFO  [HbmBinder] Mapping class: course.Visibility -> visibility
  | 10:13:20,396 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Slide.hbm.xml
  | 10:13:20,412 INFO  [HbmBinder] Mapping class: course.Slide -> slide
  | 10:13:20,412 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Rating.hbm.xml
  | 10:13:20,412 INFO  [HbmBinder] Mapping class: course.Rating -> rating
  | 10:13:20,412 INFO  [Configuration] Configured SessionFactory: null
  | 10:13:20,490 INFO  [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)
  | 10:13:20,490 INFO  [DriverManagerConnectionProvider] Hibernate connection pool size: 20
  | 10:13:20,490 INFO  [DriverManagerConnectionProvider] autocommit mode: false
  | 10:13:20,505 INFO  [DriverManagerConnectionProvider] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/MiracleMind
  | 10:13:20,505 INFO  [DriverManagerConnectionProvider] connection properties: {user=root, password=root}
  | 10:13:20,505 WARN  [SettingsFactory] Could not obtain connection metadata
  | java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/MiracleMind
  | 	at java.sql.DriverManager.getConnection(Unknown Source)
  | 	at java.sql.DriverManager.getConnection(Unknown Source)
  | 	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
  | 	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
  | 	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2063)
  | 	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1298)
  | 	at com.bellecrestsoftware.hibernate.HibernateSessionFactory.<clinit>(HibernateSessionFactory.java:31)
  | 	at com.bellecrestsoftware.hibernate.BaseHibernateDAO.getSession(BaseHibernateDAO.java:13)
  | 	at com.bellecrestsoftware.person.PersonDAO.findByProperty(PersonDAO.java:89)
  | 
  | 
  | 
  | 
  | <!DOCTYPE hibernate-configuration PUBLIC
  |           "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
  |           "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
  | 
  | <!-- Generated by MyEclipse Hibernate Tools.                   -->
  | <hibernate-configuration>
  | 
  | 	<session-factory>
  |         <property name="hibernate.connection.driver_class">org.gjt.mm.mysql.Driver</property>
  |         <property name="connection.username">root</property>
  | 		<property name="connection.url">
  | 			jdbc:mysql://localhost:3306/MiracleMind
  | 		</property>
  | 		<property name="dialect">
  | 			org.hibernate.dialect.MySQLDialect
  | 		</property>
  | 		<property name="myeclipse.connection.profile">
  | 			New MySQL
  | 		</property>
  | 		<property name="hbm2ddl.auto">update</property>
  | 		<property name="connection.password">root</property>
  | 		<property name="connection.driver_class">
  | 			com.mysql.jdbc.Driver
  | 		</property>
  | 		
  | 		<mapping resource="com/bellecrestsoftware/person/Phone.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/person/Personrolexref.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/person/Personaddressxref.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/person/Role.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/person/Person.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/person/Address.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/person/Personcoursexref.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/person/Personphonexref.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/course/Coursecategoryxref.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/course/Course.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/course/Courseprogresshistory.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/course/Category.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/course/Visibility.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/course/Slide.hbm.xml" />
  | 		<mapping resource="com/bellecrestsoftware/course/Rating.hbm.xml" />
  | 
  | 	</session-factory>
  | 
  | </hibernate-configuration>

View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4224073#4224073

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4224073