maven classpath - driver not found

[T Mishra]

I am trying to generate entities using hbm2java using maven. However I get this error, It is quiet evident that postgres driver jar is missing but its present in the maven repository. Setting the dependency scope as runtime too did not solve the problem.

java.sql.SQLException: No suitable driver found for jdbc:postgres:....

I've added the dependency under hibernate3-maven-plugin. What am I missing ?

			<plugin>
				<groupId>org.codehaus.mojo</groupId>
				<artifactId>hibernate3-maven-plugin</artifactId>
				<version>2.2</version>
				<configuration>
					<components>
						<component>
							<name>hbm2java</name>
							<outputDirectory>src/main/java</outputDirectory>
							<implementation>jdbcconfiguration</implementation>
						</component>
					</components>
					<componentProperties>
						<revengfile>src/main/resources/model.reveng.xml</revengfile>
						<propertyfile>src/main/resources/hibernate.properties</propertyfile>
						<packagename>com.user.management</packagename>
						<jdk5>true</jdk5>
						<ejb3>true</ejb3>
						<format>true</format>
						<haltonerror>true</haltonerror>
					</componentProperties>
				</configuration>
				<dependencies>
					<dependency>
						<groupId>postgresql</groupId>
						<artifactId>postgresql</artifactId>						
						<version>9.1-901-1.jdbc4</version>
						<scope>runtime</scope>
					</dependency>
					<dependency>
						<groupId>cglib</groupId>
						<artifactId>cglib-nodep</artifactId>
						<version>2.1_3</version>
					</dependency>
				</dependencies>             
			</plugin>

[Peter Johnson]

Which goal are you running for the hibernate plugin?

Anyway, I suspect that the issue has to do with the <scope> - I doubt that the hibernate goal is running as part of a phase that uses runtime scope. You should either remove the scope for the postgresql dependency, or change it to 'compile'. If that doesn't work, try moving the dependency to the project's dependency list.

[Jayesh A Lalwani]

Runtime dependencies are only added into test classpath. Maven doesn't add it to the compile classpath. Compile time plugins look at compile classpath.

You can do 1 of 2 things
a) Set the scope to of postgre driver to provided. This will include the jar in compile and and test, but the jar won't be packaged
b) You can add a dependency tag to a plugin to add a dependency just for that plugin. So, you can add a dependency to postgre driver inside the hibernate3-maven-plugin

[T Mishra]

Hi Peter,

Which goal are you running for the hibernate plugin?

I am running mvn hibernate3:hbm2java. It gets called during the phase generate-sources.

I tried running it with the default scope - compile. I also moved it to project dependency. However, I get the same error message

[ERROR] Failed to execute goal org.codehaus.mojo:hibernate3-maven-plugin:2.2:hbm
2java (default-cli) on project UserManagement: Execution default-cli of goal org
.codehaus.mojo:hibernate3-maven-plugin:2.2:hbm2java failed: Getting database met
adata: No suitable driver found for jdbc:postgres://localhost:5433/postgres -

Hi Jayesh,

Option a) does not allow to set scope as provided

  [ERROR]     'build.plugins.plugin[org.codehaus.mojo:hibernate3-maven-plugin].dep
endencies.dependency.scope' for postgresql:postgresql:jar must be one of [compil
e, runtime, system] but is 'provided'. @ line 59, column 14  

option b) I am not clear as to where it should be added ? At present, the dependency is already added for the plugin - hibernate3-maven-plugin

Thanks to both of you for looking into the problem.

- Tushar

[T Mishra]

Here's my POM

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<groupId>user.management</groupId>
	<artifactId>UserManagement</artifactId>
	<packaging>jar</packaging>
	<version>1.0-SNAPSHOT</version>
	<name>UserManagement</name>
	<url>http://maven.apache.org</url>
	
	<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.8.2</version>
			<scope>test</scope>
		</dependency>		
	</dependencies>
	<build>
        <plugins>
            <plugin>
            	<groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>2.5.1</version>
                <configuration>
	                <showWarnings>true</showWarnings>
    	            <showDeprecation>true</showDeprecation>
                    <source>1.6</source>
                    <target>1.6</target>
                </configuration>
            </plugin>
			<plugin>
				<groupId>org.codehaus.mojo</groupId>
				<artifactId>hibernate3-maven-plugin</artifactId>
				<version>2.2</version>
				<configuration>
					<components>
						<component>
							<name>hbm2java</name>
							<outputDirectory>src/main/java</outputDirectory>
							<implementation>jdbcconfiguration</implementation>
						</component>
					</components>
					<componentProperties>
						<revengfile>src/main/resources/model.reveng.xml</revengfile>
						<propertyfile>src/main/resources/hibernate.properties</propertyfile>
						<packagename>com.user.management</packagename>
						<jdk5>true</jdk5>
						<ejb3>true</ejb3>
						<format>true</format>
						<haltonerror>true</haltonerror>
					</componentProperties>
				</configuration>
				<dependencies>
					<dependency>
						<groupId>postgresql</groupId>
						<artifactId>postgresql</artifactId>						
						<version>9.1-901.jdbc4</version>
					</dependency>
					<dependency>
						<groupId>cglib</groupId>
						<artifactId>cglib-nodep</artifactId>
						<version>2.1_3</version>
					</dependency>
				</dependencies>             
			</plugin>
        </plugins>
    </build>
</project>

hibernate.properties

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
hibernate.connection.driver_class = org.postgresql.Driver
hibernate.connection.url = jdbc:postgres://localhost:5433/postgres
hibernate.connection.username = postgres
hibernate.connection.password = ****
hibernate.default_schema = postgres

[T Mishra]

I also referred to this link here

[Peter Johnson]

Run Maven with the -X option, then it should tell you how the classpath is set up for running that goal. Perhaps that will give a clue.

[Jayesh A Lalwani]

Ahh this is not a maven problem

Change hibernate.connection.url = jdbc:postgres://localhost:5433/postgres to hibernate.connection.url = jdbc:postgressql://localhost:5433/postgres

[T Mishra]

This worked . I'm such a fool.

Thanks Jayesh and Peter !!

[Jayesh A Lalwani]

No worries. Everyone has done a typo in JDBC URL atleast once in their life. And if you haven't you are way overdue