Re: No suitable driver found

This is the classpath that maven is using,

[myusername(at)myhostname myproject]$ mvn cpprinter:print
[INFO] Scanning for projects...
[INFO]
------------------------------------------------------------------------
[INFO] Building Unnamed - com.mysite:myproject:war:0.0.1-SNAPSHOT
[INFO] task-segment: [cpprinter:print] (aggregator-style)
[INFO]
------------------------------------------------------------------------
Downloading:
http://repo1.maven.org/maven2/opensymphony/quartz/1.6.3/quartz-1.6.3.pom
[INFO] Unable to find resource 'opensymphony:quartz:pom:1.6.3' in
repository central (http://repo1.maven.org/maven2)
[INFO] [cpprinter:print]

=================== RUNTIME CLASSPATH ====================
/home/myusername/workspace/myproject/target/classes
/home/myusername/.m2/repository/org/htmlparser/htmlparser/1.6/htmlparser-1.6.jar
/home/myusername/.m2/repository/org/slf4j/slf4j-jcl/1.5.6/slf4j-jcl-1.5.6.jar
/home/myusername/.m2/repository/org/slf4j/slf4j-api/1.5.6/slf4j-api-1.5.6.jar
/home/myusername/.m2/repository/commons-logging/commons-logging/1.1.1/commons-logging-1.1.1.jar
/home/myusername/.m2/repository/mysql/mysql-connector-java/5.1.6/mysql-connector-java-5.1.6.jar
/home/myusername/.m2/repository/org/springframework/spring-orm/2.5.6.SEC01/spring-orm-2.5.6.SEC01.jar
/home/myusername/.m2/repository/aopalliance/aopalliance/1.0/aopalliance-1.0.jar
/home/myusername/.m2/repository/org/springframework/spring-beans/2.5.6.SEC01/spring-beans-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-core/2.5.6.SEC01/spring-core-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-context/2.5.6.SEC01/spring-context-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-tx/2.5.6.SEC01/spring-tx-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/apache/tiles/tiles-api/2.0.6/tiles-api-2.0.6.jar
/home/myusername/.m2/repository/commons-logging/commons-logging-api/1.1/commons-logging-api-1.1.jar
/home/myusername/.m2/repository/org/apache/tiles/tiles-core/2.0.6/tiles-core-2.0.6.jar
/home/myusername/.m2/repository/commons-digester/commons-digester/1.8/commons-digester-1.8.jar
/home/myusername/.m2/repository/commons-beanutils/commons-beanutils/1.7.0/commons-beanutils-1.7.0.jar
/home/myusername/.m2/repository/org/apache/tiles/tiles-jsp/2.0.6/tiles-jsp-2.0.6.jar
/home/myusername/.m2/repository/org/hibernate/hibernate-annotations/3.4.0.GA/hibernate-annotations-3.4.0.GA.jar
/home/myusername/.m2/repository/org/hibernate/ejb3-persistence/1.0.2.GA/ejb3-persistence-1.0.2.GA.jar
/home/myusername/.m2/repository/org/hibernate/hibernate-commons-annotations/3.1.0.GA/hibernate-commons-annotations-3.1.0.GA.jar
/home/myusername/.m2/repository/org/hibernate/hibernate-core/3.3.0.SP1/hibernate-core-3.3.0.SP1.jar
/home/myusername/.m2/repository/antlr/antlr/2.7.6/antlr-2.7.6.jar
/home/myusername/.m2/repository/commons-collections/commons-collections/3.2/commons-collections-3.2.jar
/home/myusername/.m2/repository/dom4j/dom4j/1.6.1/dom4j-1.6.1.jar
/home/myusername/.m2/repository/xml-apis/xml-apis/1.0.b2/xml-apis-1.0.b2.jar
/home/myusername/.m2/repository/javax/transaction/jta/1.1/jta-1.1.jar
/home/myusername/.m2/repository/org/springframework/security/spring-security-core/2.0.4/spring-security-core-2.0.4.jar
/home/myusername/.m2/repository/org/springframework/spring-aop/2.0.8/spring-aop-2.0.8.jar
/home/myusername/.m2/repository/org/springframework/spring-support/2.0.8/spring-support-2.0.8.jar
/home/myusername/.m2/repository/commons-codec/commons-codec/1.3/commons-codec-1.3.jar
/home/myusername/.m2/repository/org/springframework/spring-web/2.5.6.SEC01/spring-web-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-webmvc/2.5.6.SEC01/spring-webmvc-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-context-support/2.5.6.SEC01/spring-context-support-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-dao/2.0.8/spring-dao-2.0.8.jar
/home/myusername/.m2/repository/org/springframework/spring-jdbc/2.5.6.SEC01/spring-jdbc-2.5.6.SEC01.jar
/home/myusername/.m2/repository/javassist/javassist/3.8.0.GA/javassist-3.8.0.GA.jar
/home/myusername/.m2/repository/opensymphony/quartz/1.6.3/quartz-1.6.3.jar
/home/myusername/.m2/repository/javax/mail/mail/1.4.1/mail-1.4.1.jar
/home/myusername/.m2/repository/javax/activation/activation/1.1/activation-1.1.jar
/home/myusername/.m2/repository/postgresql/postgresql/8.3-603.jdbc4/postgresql-8.3-603.jdbc4.jar
===========================================================

==================== TEST CLASSPATH ======================
/home/myusername/workspace/myproject/target/test-classes
/home/myusername/workspace/myproject/target/classes
/home/myusername/.m2/repository/org/htmlparser/htmlparser/1.6/htmlparser-1.6.jar
/home/myusername/.m2/repository/org/slf4j/slf4j-jcl/1.5.6/slf4j-jcl-1.5.6.jar
/home/myusername/.m2/repository/org/slf4j/slf4j-api/1.5.6/slf4j-api-1.5.6.jar
/home/myusername/.m2/repository/commons-logging/commons-logging/1.1.1/commons-logging-1.1.1.jar
/home/myusername/.m2/repository/mysql/mysql-connector-java/5.1.6/mysql-connector-java-5.1.6.jar
/home/myusername/.m2/repository/org/springframework/spring-orm/2.5.6.SEC01/spring-orm-2.5.6.SEC01.jar
/home/myusername/.m2/repository/aopalliance/aopalliance/1.0/aopalliance-1.0.jar
/home/myusername/.m2/repository/org/springframework/spring-beans/2.5.6.SEC01/spring-beans-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-core/2.5.6.SEC01/spring-core-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-context/2.5.6.SEC01/spring-context-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-tx/2.5.6.SEC01/spring-tx-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/apache/tiles/tiles-api/2.0.6/tiles-api-2.0.6.jar
/home/myusername/.m2/repository/commons-logging/commons-logging-api/1.1/commons-logging-api-1.1.jar
/home/myusername/.m2/repository/org/apache/tiles/tiles-core/2.0.6/tiles-core-2.0.6.jar
/home/myusername/.m2/repository/commons-digester/commons-digester/1.8/commons-digester-1.8.jar
/home/myusername/.m2/repository/commons-beanutils/commons-beanutils/1.7.0/commons-beanutils-1.7.0.jar
/home/myusername/.m2/repository/org/apache/tiles/tiles-jsp/2.0.6/tiles-jsp-2.0.6.jar
/home/myusername/.m2/repository/org/hibernate/hibernate-annotations/3.4.0.GA/hibernate-annotations-3.4.0.GA.jar
/home/myusername/.m2/repository/org/hibernate/ejb3-persistence/1.0.2.GA/ejb3-persistence-1.0.2.GA.jar
/home/myusername/.m2/repository/org/hibernate/hibernate-commons-annotations/3.1.0.GA/hibernate-commons-annotations-3.1.0.GA.jar
/home/myusername/.m2/repository/org/hibernate/hibernate-core/3.3.0.SP1/hibernate-core-3.3.0.SP1.jar
/home/myusername/.m2/repository/antlr/antlr/2.7.6/antlr-2.7.6.jar
/home/myusername/.m2/repository/commons-collections/commons-collections/3.2/commons-collections-3.2.jar
/home/myusername/.m2/repository/dom4j/dom4j/1.6.1/dom4j-1.6.1.jar
/home/myusername/.m2/repository/xml-apis/xml-apis/1.0.b2/xml-apis-1.0.b2.jar
/home/myusername/.m2/repository/javax/transaction/jta/1.1/jta-1.1.jar
/home/myusername/.m2/repository/org/springframework/security/spring-security-core/2.0.4/spring-security-core-2.0.4.jar
/home/myusername/.m2/repository/org/springframework/spring-aop/2.0.8/spring-aop-2.0.8.jar
/home/myusername/.m2/repository/org/springframework/spring-support/2.0.8/spring-support-2.0.8.jar
/home/myusername/.m2/repository/commons-codec/commons-codec/1.3/commons-codec-1.3.jar
/home/myusername/.m2/repository/org/springframework/spring-web/2.5.6.SEC01/spring-web-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-webmvc/2.5.6.SEC01/spring-webmvc-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-context-support/2.5.6.SEC01/spring-context-support-2.5.6.SEC01.jar
/home/myusername/.m2/repository/org/springframework/spring-dao/2.0.8/spring-dao-2.0.8.jar
/home/myusername/.m2/repository/org/springframework/spring-jdbc/2.5.6.SEC01/spring-jdbc-2.5.6.SEC01.jar
/home/myusername/.m2/repository/javassist/javassist/3.8.0.GA/javassist-3.8.0.GA.jar
/home/myusername/.m2/repository/opensymphony/quartz/1.6.3/quartz-1.6.3.jar
/home/myusername/.m2/repository/javax/mail/mail/1.4.1/mail-1.4.1.jar
/home/myusername/.m2/repository/javax/activation/activation/1.1/activation-1.1.jar
/home/myusername/.m2/repository/postgresql/postgresql/8.3-603.jdbc4/postgresql-8.3-603.jdbc4.jar
===========================================================

[INFO]
------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 1 second
[INFO] Finished at: Mon Jul 27 13:53:14 EDT 2009
[INFO] Final Memory: 15M/209M
[INFO]
------------------------------------------------------------------------
[myusername(at)myhostname myproject]$

I'm using maven for dependency management. If the postgresql artifact
needed other jars, maven would have automatically downloaded them and
put them into the classpath (unless the pom.xml file in the central
nexus repository is broken). Also, I get the same error when I run the
hibernate3:hbm2ddl goal on command line (IE: without eclipse):

[myusername(at)myhostname myproject]$ mvn clean package hibernate3:hbm2ddl
[INFO] Scanning for projects...
[INFO]
------------------------------------------------------------------------
[INFO] Building Unnamed - com.mysite:myproject:war:0.0.1-SNAPSHOT
[INFO] task-segment: [clean, package, hibernate3:hbm2ddl]
[INFO]
------------------------------------------------------------------------
[INFO] [clean:clean]
[INFO] Deleting directory /home/myusername/workspace/myproject/target
[INFO] [resources:resources]
[WARNING] Using platform encoding (UTF-8 actually) to copy filtered
resources, i.e. build is platform dependent!
[INFO] Copying 3 resources
Downloading:
http://repo1.maven.org/maven2/opensymphony/quartz/1.6.3/quartz-1.6.3.pom
[INFO] Unable to find resource 'opensymphony:quartz:pom:1.6.3' in
repository central (http://repo1.maven.org/maven2)
[INFO] [compiler:compile]
[INFO] Compiling 8 source files to
/home/myusername/workspace/myproject/target/classes
[INFO] [resources:testResources]
[WARNING] Using platform encoding (UTF-8 actually) to copy filtered
resources, i.e. build is platform dependent!
[INFO] Copying 0 resource
[INFO] [compiler:testCompile]
[INFO] Nothing to compile - all classes are up to date
[INFO] [surefire:test]
[INFO] Surefire report directory:
/home/myusername/workspace/myproject/target/surefire-reports

-------------------------------------------------------
T E S T S
-------------------------------------------------------
There are no tests to run.

Results :

Tests run: 0, Failures: 0, Errors: 0, Skipped: 0

[INFO] [war:war]
[INFO] Packaging webapp
[INFO] Assembling webapp[myproject] in
[/home/myusername/workspace/myproject/target/myproject-0.0.1-SNAPSHOT]
[INFO] Processing war project
[INFO] Copying webapp
resources[/home/myusername/workspace/myproject/src/main/webapp]
[INFO] Webapp assembled in[162 msecs]
[INFO] Building war:
/home/myusername/workspace/myproject/target/myproject-0.0.1-SNAPSHOT.war
[INFO] Preparing hibernate3:hbm2ddl
[INFO] [resources:resources]
[WARNING] Using platform encoding (UTF-8 actually) to copy filtered
resources, i.e. build is platform dependent!
[INFO] Copying 3 resources
[INFO] [hibernate3:hbm2ddl]
[INFO] Configuration XML file loaded:
file:/home/myusername/workspace/myproject/src/main/resources/hibernate.cfg.xml
13:40:27,339 INFO org.hibernate.cfg.annotations.Version - Hibernate
Annotations 3.4.0.GA
13:40:27,350 INFO org.hibernate.cfg.Environment - Hibernate 3.3.1.GA
13:40:27,353 INFO org.hibernate.cfg.Environment - hibernate.properties
not found
13:40:27,356 INFO org.hibernate.cfg.Environment - Bytecode provider
name : javassist
13:40:27,360 INFO org.hibernate.cfg.Environment - using JDK 1.4
java.sql.Timestamp handling
13:40:27,399 INFO org.hibernate.annotations.common.Version - Hibernate
Commons Annotations 3.1.0.GA
[INFO] Configuration XML file loaded:
file:/home/myusername/workspace/myproject/src/main/resources/hibernate.cfg.xml
13:40:27,400 INFO org.hibernate.cfg.Configuration - configuring from
url:
file:/home/myusername/workspace/myproject/src/main/resources/hibernate.cfg.xml
13:40:27,525 INFO org.hibernate.cfg.Configuration - Configured
SessionFactory: null
[INFO] No hibernate properties file loaded.
13:40:27,570 INFO org.hibernate.cfg.AnnotationBinder - Binding entity
from annotated class: com.mysite.entity.Batch
13:40:27,600 INFO org.hibernate.cfg.annotations.EntityBinder - Bind
entity com.mysite.entity.Batch on table BATCHES
13:40:27,671 INFO org.hibernate.cfg.AnnotationBinder - Binding entity
from annotated class: com.mysite.entity.Character
13:40:27,672 INFO org.hibernate.cfg.annotations.EntityBinder - Bind
entity com.mysite.entity.Character on table CHARACTERS
13:40:27,674 INFO org.hibernate.cfg.AnnotationBinder - Binding entity
from annotated class: com.mysite.entity.Sighting
13:40:27,674 INFO org.hibernate.cfg.annotations.EntityBinder - Bind
entity com.mysite.entity.Sighting on table SIGHTINGS
13:40:27,679 INFO org.hibernate.cfg.AnnotationBinder - Binding entity
from annotated class: com.mysite.entity.Area
13:40:27,679 INFO org.hibernate.cfg.annotations.EntityBinder - Bind
entity com.mysite.entity.Area on table AREAS
13:40:27,711 INFO org.hibernate.cfg.annotations.CollectionBinder -
Mapping collection: com.mysite.entity.Character.sightings -> SIGHTINGS
13:40:27,712 INFO org.hibernate.cfg.annotations.CollectionBinder -
Mapping collection: com.mysite.entity.Batch.sightings -> SIGHTINGS
13:40:27,714 INFO org.hibernate.cfg.AnnotationConfiguration - Hibernate
Validator not found: ignoring
13:40:27,722 INFO org.hibernate.dialect.Dialect - Using dialect:
org.hibernate.dialect.PostgreSQLDialect
13:40:27,742 INFO org.hibernate.tool.hbm2ddl.SchemaExport - Running
hbm2ddl schema export
13:40:27,742 INFO org.hibernate.tool.hbm2ddl.SchemaExport - exporting
generated schema to database
13:40:27,744 INFO
org.hibernate.connection.DriverManagerConnectionProvider - Using
Hibernate built-in connection pool (not for production use!)
13:40:27,744 INFO
org.hibernate.connection.DriverManagerConnectionProvider - Hibernate
connection pool size: 20
13:40:27,744 INFO
org.hibernate.connection.DriverManagerConnectionProvider - autocommit
mode: false
13:40:27,745 INFO
org.hibernate.connection.DriverManagerConnectionProvider - using driver:
org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/mydatabase
13:40:27,745 INFO
org.hibernate.connection.DriverManagerConnectionProvider - connection
properties: {user=myusername, password=****}
13:40:27,756 ERROR org.hibernate.tool.hbm2ddl.SchemaExport - schema
export unsuccessful
java.sql.SQLException: No suitable driver found for
jdbc:postgresql://localhost:5432/mydatabase
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
at
org.hibernate.tool.hbm2ddl.ManagedProviderConnectionHelper.prepare(ManagedProviderConnectionHelper.java:52)
at
org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.java:252)
at
org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.java:211)
at
org.codehaus.mojo.hibernate3.exporter.Hbm2DDLExporterMojo.doExecute(Hbm2DDLExporterMojo.java:112)
at
org.codehaus.mojo.hibernate3.HibernateExporterMojo.execute(HibernateExporterMojo.java:152)
at
org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:483)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:678)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeStandaloneGoal(DefaultLifecycleExecutor.java:553)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:523)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:371)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:332)
at
org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:181)
at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:356)
at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:137)
at org.apache.maven.cli.MavenCli.main(MavenCli.java:356)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
at
org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
[WARNING] 1 errors occurred while performing <hbm2ddl>.
[ERROR] Error #1: java.sql.SQLException: No suitable driver found for
jdbc:postgresql://localhost:5432/mydatabase
[INFO]
------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO]
------------------------------------------------------------------------
[INFO] Total time: 5 seconds
[INFO] Finished at: Mon Jul 27 13:40:27 EDT 2009
[INFO] Final Memory: 38M/336M
[INFO]
------------------------------------------------------------------------
[myusername(at)myhostname myproject]$

Dave Cramer wrote:
> When you run something in eclipse you should be able to see the entire
> classpath in the run string. It's undoubtedly something missing in
> the classpath.
>
> Dave
>
>