Обсуждение: No suitable driver found
Greetings, I've been looking for a solution to this error for a few days now. Everything I've found says that the problem should be that I have a malformed url but I've gone over it dozens of times and I don't think that it's wrong (I wish it was). I'm trying to use hibernate tools to generate my database schema through the JDBC driver. Hibernate is pretty good at this. I've done it many times before in other databases (MySQL, MsSQL, Oracle, HSQLDB, etc...). I'm using, PostgreSQL server version 8.3.7 that I installed through the http://yum.pgsqlrpms.org/8.3/redhat yum repository. I'm using version 8.3-603.jdbc4 of the jdbc driver (I've tried several others including the 8.3-605 and the 8.4-701 all with the same error) I'm using JDK 1.6.0_13 (with 1.5 source/compile targets) I'm able to log into the database I'm getting the following stack trace, 11:09:45,533 INFO org.hibernate.tool.hbm2ddl.SchemaExport - Running hbm2ddl schema export 11:09:45,535 INFO org.hibernate.tool.hbm2ddl.SchemaExport - exporting generated schema to database 11:09:45,538 INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!) 11:09:45,538 INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20 11:09:45,538 INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false 11:09:45,540 INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/mydatabase 11:09:45,540 INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=myusername, password=****} 11:09:45,555 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:579) 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:904) 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 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.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351) at org.codehaus.classworlds.Launcher.main(Launcher.java:31) Any help would be greatly appreciated. Cheers! John
On Sat, 25 Jul 2009, John Dunlap wrote: > I've been looking for a solution to this error for a few days now. > Everything I've found says that the problem should be that I have a > malformed url but I've gone over it dozens of times and I don't think > that it's wrong (I wish it was). There are two likely causes of this problem. Failing to register the driver with Class.forName("org.postgresql.Driver"), or not having it available on your classpath. Kris Jurka
John Dunlap wrote: > I've been looking for a solution to this error for a few days now. > Everything I've found says that the problem should be that I have a > malformed url but I've gone over it dozens of times and I don't think > that it's wrong (I wish it was). I'm trying to use hibernate tools to > generate my database schema through the JDBC driver. > > I'm getting the following stack trace, > java.sql.SQLException: No suitable driver found for > jdbc:postgresql://localhost:5432/mydatabase > at java.sql.DriverManager.getConnection(DriverManager.java:602) [...] I don't know anything about Hibernate, but this error suggests that the system does not know the PostgreSQL JDBC driver. There are several ways to register it: - Use the class org.postgresql.Driver, for example with the statement Class.forName("org.postgresql.Driver"); - Start the Java Virtual Machine with the flag -Djdbc.drivers=org.postgresql.Driver You'll probably have to figure out how to do that in Hibernate, but it should work exactly as with other JDBC drivers. Yours, Laurenz Albe
This is my hibernate configuration (minus my entity definitions). You'll notice that the MySQL section has been commented out. If I uncomment the mysql config and comment out the postgresql config, hibernate generates the database schema perfectly. <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.show_sql">false</property> <property name="hibernate.format_sql">false</property> <property name="use_sql_comments">false</property> <property name="hibernate.current_session_context_class">org.hibernate.context.ThreadLocalSessionContext</property> <property name="hibernate.connection.driver_class">org.postgresql.Driver</property> <property name="hibernate.connection.url">jdbc:postgresql://localhost:5432/mydatabase</property> <property name="hibernate.connection.username">myusername</property> <property name="hibernate.connection.password">mypasswrd</property> <property name="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</property> <!-- <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mydatabase</property> <property name="hibernate.connection.username">myusername</property> <property name="hibernate.connection.password">mypasswrd</property> <property name="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property> --> </session-factory> </hibernate-configuration> If I comment out the mysql confg and uncomment the postgresql config, the schema generation fails with the following stack trace. As you can see, I am fully qualifying the driver class as "org.postgresql.Driver" and I can assure you that postgresql-8.3-603.jdbc4.jar is in my classpath (I can see it in eclipse under Maven Dependencies). 11:09:45,533 INFO org.hibernate.tool.hbm2ddl.SchemaExport - Running hbm2ddl schema export 11:09:45,535 INFO org.hibernate.tool.hbm2ddl.SchemaExport - exporting generated schema to database 11:09:45,538 INFO org.hibernate.connection.DriverManagerConnectionProvider - Using Hibernate built-in connection pool (not for production use!) 11:09:45,538 INFO org.hibernate.connection.DriverManagerConnectionProvider - Hibernate connection pool size: 20 11:09:45,538 INFO org.hibernate.connection.DriverManagerConnectionProvider - autocommit mode: false 11:09:45,540 INFO org.hibernate.connection.DriverManagerConnectionProvider - using driver: org.postgresql.Driver at URL: jdbc:postgresql://localhost:5432/mydatabase 11:09:45,540 INFO org.hibernate.connection.DriverManagerConnectionProvider - connection properties: {user=myusername, password=****} 11:09:45,555 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:579) 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:904) 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 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.plexus.classworlds.launcher.Launcher.launchEnhanced(Launcher.java:289) at org.codehaus.plexus.classworlds.launcher.Launcher.launch(Launcher.java:229) at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode(Launcher.java:408) at org.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:351) at org.codehaus.classworlds.Launcher.main(Launcher.java:31) Like I said in my last email. I've done this with many other databases in the past and this is the first database I've seen this error with (although I've seen a lot of other issues). Albe Laurenz wrote: > John Dunlap wrote: > > >> I've been looking for a solution to this error for a few days now. >> Everything I've found says that the problem should be that I have a >> malformed url but I've gone over it dozens of times and I don't think >> that it's wrong (I wish it was). I'm trying to use hibernate tools to >> generate my database schema through the JDBC driver. >> >> I'm getting the following stack trace, >> java.sql.SQLException: No suitable driver found for >> jdbc:postgresql://localhost:5432/mydatabase >> at java.sql.DriverManager.getConnection(DriverManager.java:602) >> > [...] > > I don't know anything about Hibernate, but this error suggests that > the system does not know the PostgreSQL JDBC driver. > > There are several ways to register it: > - Use the class org.postgresql.Driver, for example with the statement > Class.forName("org.postgresql.Driver"); > > - Start the Java Virtual Machine with the flag > -Djdbc.drivers=org.postgresql.Driver > > You'll probably have to figure out how to do that in Hibernate, > but it should work exactly as with other JDBC drivers. > > Yours, > Laurenz Albe >
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
Dave
This is the classpath that maven is using, [myusername@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@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@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@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 > >
Thanks for that shove in the right direction Dave. The problem had nothing to do with it being a web application (because you don't have to deploy it to generate a database schema) but you did put me onto the right train of thought. The problem was that although I had added the postgresql jdbc driver to my maven project as a dependency, I hadn't added it as a dependency for the hibernate3-maven-plugin. Dave Cramer wrote: > so when you extract the war where is the postgresql jar ? > > If this is a webapp then it has to be in a specific place. > > DAve > > On Mon, Jul 27, 2009 at 1:57 PM, John Dunlap <john.dunlap@exceter.com > <mailto:john.dunlap@exceter.com>> wrote: > > This is the classpath that maven is using, > > [myusername@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 > <http://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 > <http://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 > <http://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 > <http://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 > <http://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 > <http://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 > <http://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 > <http://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@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@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 <http://3.4.0.GA> > 13:40:27,350 INFO org.hibernate.cfg.Environment - Hibernate > 3.3.1.GA <http://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 <http://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@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 > > > > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org > <mailto:pgsql-jdbc@postgresql.org>) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc > >