>Caused by: java.sql.SQLException: No suitable driver Set Driver_class in hibernate.properties ?
hibernate.connection.driver_class com.mysql.jdbc.Driver ----- Original Message ----- From: "Renu Gupta" <[EMAIL PROTECTED]> To: "Maven Users List" <[email protected]> Sent: Monday, July 21, 2008 9:41 AM Subject: hibernate3 maven2 plugin problem Hi, While using hibernate3 maven2 plugin. I m getting this error: [INFO] [hibernate3:hbm2ddl] [DEBUG] Setting context classloader for plugin to: /plugins/org.codehaus.mojo:hibernate3-maven-plugin:[EMAIL PROTECTED]/thread:main (instance is: ClassRealm[/plugins/org.codehaus.mojo:hibernate3-maven-plugin:[EMAIL PROTECTED]/thread:main, parent: ClassRealm[plexus.core, parent: null]]) 13:00:20,800 INFO org.hibernate.cfg.Environment - Hibernate 3.2.0.cr5 13:00:20,800 INFO org.hibernate.cfg.Environment - loaded properties from resource hibernate.properties: {hibernate.dialect=org.hibernate.dialect.MySQLDialect, hibernate.bytecode.use_reflection_optimizer=false} 13:00:20,800 INFO org.hibernate.cfg.Environment - Bytecode provider name : cglib 13:00:20,815 INFO org.hibernate.cfg.Environment - using JDK 1.4 java.sql.Timestamp handling 13:00:20,894 INFO org.hibernate.cfg.Configuration - configuring from file: hibernate.cfg.xml [DEBUG] basedir: F:\Documents and Settings\rvgupta\eclipsemavenworkspace\trial-plugin [INFO] Configuration XML file loaded: F:\Documents and Settings\rvgupta\eclipsemavenworkspace\trial-plugin\src\main\resources\hibernate.cfg.xml 13:00:21,050 INFO org.hibernate.cfg.JDBCMetaDataConfiguration - Ignoring null mapping 13:00:21,050 INFO org.hibernate.cfg.Configuration - Configured SessionFactory: null [INFO] src/main/resources/database.properties not found within the project. Trying absolute path. [INFO] No hibernate properties file loaded. 13:00:21,097 INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!) 13:00:21,097 INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20 13:00:21,097 INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false 13:00:21,097 INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/firsthibernate 13:00:21,112 INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=root, password=****} 13:00:21,112 WARN org.hibernate.cfg.SettingsFactory - Could not obtain connection metadata java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:545) at java.sql.DriverManager.getConnection(DriverManager.java:140) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110) at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76) at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1929) at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:38) at org.codehaus.mojo.hibernate3.configuration.JDBCComponentConfiguration.doConfiguration(JDBCComponentConfiguration.java:67) at org.codehaus.mojo.hibernate3.configuration.AbstractComponentConfiguration.getConfiguration(AbstractComponentConfiguration.java:37) at org.codehaus.mojo.hibernate3.exporter.Hbm2DDLExporterMojo.doExecute(Hbm2DDLExporterMojo.java:87) at org.codehaus.mojo.hibernate3.HibernateExporterMojo.execute(HibernateExporterMojo.java:140) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:577) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:498) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegmentForProject(DefaultLifecycleExecutor.java:265) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:191) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:149) at org.apache.maven.DefaultMaven.execute_aroundBody0(DefaultMaven.java:223) at org.apache.maven.DefaultMaven.execute_aroundBody1$advice(DefaultMaven.java:304) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:1) at org.apache.maven.embedder.MavenEmbedder.execute_aroundBody2(MavenEmbedder.java:903) at org.apache.maven.embedder.MavenEmbedder.execute_aroundBody3$advice(MavenEmbedder.java:304) at org.apache.maven.embedder.MavenEmbedder.execute(MavenEmbedder.java:1) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:176) at org.apache.maven.cli.MavenCli.main(MavenCli.java:63) at org.apache.maven.cli.MavenCli.main(MavenCli.java:52) 13:00:21,144 INFO org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect 13:00:21,269 INFO org.hibernate.transaction.TransactionFactoryFactory - Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory 13:00:21,284 INFO org.hibernate.transaction.TransactionManagerLookupFactory - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended) 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Automatic flush during beforeCompletion(): disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Automatic session close at end of transaction: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Scrollable result sets: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - JDBC3 getGeneratedKeys(): disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Connection release mode: auto 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Maximum outer join fetch depth: 2 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Default batch fetch size: 1 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Generate SQL with comments: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Order SQL updates by primary key: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory 13:00:21,284 INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory - Using ASTQueryTranslatorFactory 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Query language substitutions: {} 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - JPA-QL strict compliance: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Second-level cache: enabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Query cache: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Cache provider: org.hibernate.cache.NoCacheProvider 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Optimize cache for minimal puts: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Structured second-level cache entries: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Echoing all SQL to stdout 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Statistics: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Deleted entity synthetic identifier rollback: disabled 13:00:21,284 INFO org.hibernate.cfg.SettingsFactory - Default entity-mode: pojo 13:00:21,347 INFO org.hibernate.connection.DriverManagerConnectionProvider - cleaning up connection pool: jdbc:mysql://localhost/firsthibernate Exception in thread "main" org.hibernate.exception.JDBCConnectionException: Getting database metadata at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74) at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:62) at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.caseForSearch(AbstractMetaDataDialect.java:157) at org.hibernate.cfg.reveng.dialect.JDBCMetaDataDialect.getTables(JDBCMetaDataDialect.java:22) at org.hibernate.cfg.reveng.JDBCReader.processTables(JDBCReader.java:446) at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:73) at org.hibernate.cfg.reveng.JDBCReader.readDatabaseSchema(JDBCReader.java:828) at org.hibernate.cfg.JDBCBinder.readDatabaseSchema(JDBCBinder.java:118) at org.hibernate.cfg.JDBCBinder.readFromDatabase(JDBCBinder.java:89) at org.hibernate.cfg.JDBCMetaDataConfiguration.readFromJDBC(JDBCMetaDataConfiguration.java:40) at org.codehaus.mojo.hibernate3.configuration.JDBCComponentConfiguration.doConfiguration(JDBCComponentConfiguration.java:67) at org.codehaus.mojo.hibernate3.configuration.AbstractComponentConfiguration.getConfiguration(AbstractComponentConfiguration.java:37) at org.codehaus.mojo.hibernate3.exporter.Hbm2DDLExporterMojo.doExecute(Hbm2DDLExporterMojo.java:87) at org.codehaus.mojo.hibernate3.HibernateExporterMojo.execute(HibernateExporterMojo.java:140) at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:577) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:498) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegmentForProject(DefaultLifecycleExecutor.java:265) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:191) at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:149) at org.apache.maven.DefaultMaven.execute_aroundBody0(DefaultMaven.java:223) at org.apache.maven.DefaultMaven.execute_aroundBody1$advice(DefaultMaven.java:304) at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:1) at org.apache.maven.embedder.MavenEmbedder.execute_aroundBody2(MavenEmbedder.java:903) at org.apache.maven.embedder.MavenEmbedder.execute_aroundBody3$advice(MavenEmbedder.java:304) at org.apache.maven.embedder.MavenEmbedder.execute(MavenEmbedder.java:1) at org.apache.maven.cli.MavenCli.doMain(MavenCli.java:176) at org.apache.maven.cli.MavenCli.main(MavenCli.java:63) at org.apache.maven.cli.MavenCli.main(MavenCli.java:52) Caused by: java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:545) at java.sql.DriverManager.getConnection(DriverManager.java:140) at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110) at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getConnection(AbstractMetaDataDialect.java:120) at org.hibernate.cfg.reveng.dialect.AbstractMetaDataDialect.getMetaData(AbstractMetaDataDialect.java:59) ... 26 more Anyone has any idea how to resolve it. Because I have added 1) Mysql connector to the library folder, 2) Added mysql connector dependency in pom 3) Added hibernate.properties and hibernate-mysql.properties files to the src/main/resources folder. Now, else is required to be done to resolve this error?????? Cheers! Renu
