sql driver with hibernate

[Gopu Akraju]

Hi,

I am using hibernate to write data into mysql database. I get the following error.

org.hibernate.exception.JDBCConnectionException: Cannot open connection
 
Caused by: java.sql.SQLException: No suitable driver

I have used hibernate3.jar. I tried the following jars.

1. mysql-connector-java-3.1.11-bin.jar
2. mysql-connector-java-3.1.7-bin.jar
3. mysql-connector-java-3.0.17-ga-bin.jar

But all three of them failed? Do I need anything other jar file apart from hibernate3.jar and mysql connector jar? Please let me know.
Thanks.

[Gopu Akraju]

my hibernate.cfg.xml as follows.

<property name="connection.url">mysql.url=jdbc:mysql://DGDS03/test</property>
        <property name="connection.username">root</property>
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="connection.username">test</property>
        <property name="connection.password">test</property>

Anything wrong in the syntax? Thanks.

[Paul Sturrock]

<property name="connection.url">mysql.url=jdbc:mysql://DGDS03/test</property>

That looks suspicious. I've never seen a JDBC URL with an '=' symbol in it. Sure it shouldn't just be jdbc:mysql://DGDS03/test ?

[Gopu Akraju]

Thanks Paul. That worked.

My hbm.xml file is as follows:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >
<hibernate-mapping package="test.user">
    <class name="UserBean" table="test" >    
        
        
        
        <id name="selectRun"  column="testNum" type="string">
            <generator class="native"/>
        </id>        
        <property name="testLane" type="string" column="Control"></property>        
        
    </class>
    
</hibernate-mapping>

I get my exception as follows.

org.hibernate.MappingException: Unknown entity: java.lang.String

I am trying to add two strings (i.e, testNum and testLane) into my table test.

I have created a table test with two columns as RunNum and Control both of VARCHAR(30) datatype.


The place where I call commit in my java class is as follows:

public String populateAction() throws SQLException, NamingException{
        
        Transaction tx = null;
        
        
        Configuration cfg = new Configuration().configure("./hibernate.cfg.xml");
        cfg.addResource("./hibernate.cfg.xml");
        SessionFactory sessionFactory = cfg.buildSessionFactory();
        Session session = sessionFactory.openSession();
        
        
               
        //Session session = InitSessionFactory.getInstance().getCurrentSession();
        
        
        try {
            tx = session.beginTransaction();
            session.save(this.testRun);
            session.save(this.testLane);
            tx.commit();
            session.close();
            
        } catch (HibernateException e) {
            e.printStackTrace();
            if (tx != null && tx.isActive())
                tx.rollback();
        }
        
        
        return "test2" ;
    }
    

Why am I getting this exception? Thanks.
[ June 27, 2008: Message edited by: Gopu Akraju ]

[g wildin]

Maybeit appears because you are trying to save a String which does not have a mapping so Hibernate doesn't know how to save it.