[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: Hibernate + JBoss problem

Fri Apr 3 16:15:20 EDT 2009

I am having the same problem here is the section from the console and I willfollow that with the hibernate config file.  It appears from the console output that the correct driver is in fact found. It also appears that the metadata is not being read yet I see the metatdata being displayed. 
Please note that I am able to access the database in both the database and hibernate perspectives. Please any help here will be greatly appreciated.

Thanks
Glenn

.......
15:35:09,234 INFO  [Environment] Hibernate 3.2.4.sp1.cp06
15:35:09,235 INFO  [Environment] hibernate.properties not found
15:35:09,235 INFO  [Environment] Bytecode provider name : javassist
15:35:09,266 INFO  [Environment] using JDK 1.4 java.sql.Timestamp handling
15:35:09,453 INFO  [Configuration] configuring from resource: /hibernate.cfg.xml
15:35:09,453 INFO  [Configuration] Configuration resource: /hibernate.cfg.xml
15:35:09,609 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Phone.hbm.xml
15:35:09,765 INFO  [HbmBinder] Mapping class: person.Phone -> phone
15:35:09,812 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Personrolexref.hbm.xml
15:35:09,828 INFO  [HbmBinder] Mapping class: person.Personrolexref -> personrolexref
15:35:09,828 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Personaddressxref.hbm.xml
15:35:09,843 INFO  [HbmBinder] Mapping class: person.Personaddressxref -> personaddressxref
15:35:09,843 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Role.hbm.xml
15:35:09,843 INFO  [HbmBinder] Mapping class: person.Role -> role
15:35:09,843 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Person.hbm.xml
15:35:09,859 INFO  [HbmBinder] Mapping class: person.Person -> person
15:35:09,859 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Address.hbm.xml
15:35:09,859 INFO  [HbmBinder] Mapping class: person.Address -> address
15:35:09,859 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Personcoursexref.hbm.xml
15:35:09,875 INFO  [HbmBinder] Mapping class: person.Personcoursexref -> personcoursexref
15:35:09,875 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/person/Personphonexref.hbm.xml
15:35:09,875 INFO  [HbmBinder] Mapping class: person.Personphonexref -> personphonexref
15:35:09,890 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Coursecategoryxref.hbm.xml
15:35:09,890 INFO  [HbmBinder] Mapping class: course.Coursecategoryxref -> coursecategoryxref
15:35:09,890 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Course.hbm.xml
15:35:09,906 INFO  [HbmBinder] Mapping class: course.Course -> course
15:35:09,906 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Courseprogresshistory.hbm.xml
15:35:09,921 INFO  [HbmBinder] Mapping class: course.Courseprogresshistory -> courseprogresshistory
15:35:09,921 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Category.hbm.xml
15:35:09,921 INFO  [HbmBinder] Mapping class: course.Category -> category
15:35:09,921 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Visibility.hbm.xml
15:35:09,937 INFO  [HbmBinder] Mapping class: course.Visibility -> visibility
15:35:09,937 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Slide.hbm.xml
15:35:09,937 INFO  [HbmBinder] Mapping class: course.Slide -> slide
15:35:09,937 INFO  [Configuration] Reading mappings from resource : com/bellecrestsoftware/course/Rating.hbm.xml
15:35:09,953 INFO  [HbmBinder] Mapping class: course.Rating -> rating
15:35:09,953 INFO  [Configuration] Configured SessionFactory: null
15:35:16,224 INFO  [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)
15:35:16,224 INFO  [DriverManagerConnectionProvider] Hibernate connection pool size: 20
15:35:16,224 INFO  [DriverManagerConnectionProvider] autocommit mode: false
15:35:16,225 INFO  [DriverManagerConnectionProvider] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/MiracleMind
15:35:16,225 INFO  [DriverManagerConnectionProvider] connection properties: {user=root, password=root}
15:35:16,225 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.(HibernateSessionFactory.java:31)
	at com.bellecrestsoftware.hibernate.BaseHibernateDAO.getSession(BaseHibernateDAO.java:13)
...........

The hibernate config file is:
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>

	<session-factory>
        org.gjt.mm.mysql.Driver
        root

			jdbc:mysql://localhost:3306/MiracleMind

			org.hibernate.dialect.MySQLDialect

			New MySQL

		update
		root

			com.mysql.jdbc.Driver

	</session-factory>

</hibernate-configuration>

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

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