java.lang.UnsupportedOperationException: The user must supply a JDBC connection

[Varun Nambuthiri]

Hi,

I am having a little problem in Hibernate . I looked through the already given solutions and nothing seems to be working for me .

hibernate.cfg.xml file :

<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection_url">jdbc:mysql://localhost:3306/test</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.connection.password"></property> <!-- SQL Dialect --> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <!-- Enable Hibernate's Current Session Context --> <property name="current_session_context_class">thread</property> <!-- JDBC connection Pool ( use the built in ) --> <property name="connection.pool_size">2</property> <!-- Disable Second Level Cache --> <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property> <!-- Drop and recreate the Schema on startup --> <property name="hbm2ddl.auto">create</property> <!-- Echo all executed SQL to stdout --> <property name="show_sql">true</property> <!-- <mapping resource="org/hibernate/test/legacy/Simple.hbm.xml"/> <class-cache class="org.hibernate.test.legacy.Simple" region="Simple" usage="read-write"/> --> </session-factory> </hibernate-configuration>

and the code where error occurs TestLogin.java

package com.hibernate.chap1;

import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.tool.hbm2ddl.SchemaExport;

public class TestLogin 
{

	/**
	 * @param args
	 */
	public static void main(String[] args) 
	{
		// TODO Auto-generated method stub
		AnnotationConfiguration conf =  new AnnotationConfiguration();
		conf.addAnnotatedClass(Login.class);
		
		conf.configure("hibernate.cfg.xml");
		
		new SchemaExport(conf).create(true, true);
	}

}

and the stack trace is

java.lang.UnsupportedOperationException: The user must supply a JDBC connection
at org.hibernate.connection.UserSuppliedConnectionProvider.getConnection(UserSuppliedConnectionProvider.java:54)
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 com.hibernate.chap1.TestLogin.main(TestLogin.java:20)

First of all please explaination of that particular Exception is needed . So that if this happens again its easier to solve and then the if possible the solution .

Thanks and Regards
Varun

[Bill Gorder]

This looks like a typo

"hibernate.connection_url"

[Varun Nambuthiri]

Hi ,

Thank you !! I was brooding over it for a long time .. and just couldnt find out the error !

Thank you again !!
Regards
Varun