Hibernate + Save

Version imprimable

Hibernate + Save

Bonjour, :p

bon voila, je commence à utiliser hibernate ... j ai rencontré ce probleme:
erreur est coloré en rouge :)

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
Transaction tx = null;
 
try {
 
    tx = session.beginTransaction();
 
    session.flush(); 
 
    //    Vector<User> users = new Vector<User>(session.createQuery("from User").list());
    List<User> lusers = (List)(session.createQuery("from User").list());
 
    User usr = new User();
    while (it.hasNext())
    {
        usr = (User) it.next();
 
        System.out.println(usr.getLogin() + " , " + usr.getMdp());
    }
 
    User NewUser = new User();
    NewUser.setLogin("myname");
    NewUser.setMdp("mypassword");
 
    session.save(NewUser); // ici l'erreur
    session.flush(); 
 
    tx.commit(); 
 
} catch (Exception e) {
 
    if (tx != null)
        tx.rollback();
 
    try {
        throw e;
    } finally {
        HibernateUtil.getSessionFactory().close();
    } 
}

le code d'erreur est le suivant

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
Hibernate: select user0_.login as login0_, user0_.mdp as mdp0_ from user user0_
user1 , mdp1
user2 , mdp2
user3 , mdp3
user4 , mdp4
 
Hibernate: insert into user (login, mdp) values (null, ?)
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not insert: [com.hibernate.beans.User]
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:40)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
    at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
    at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
    at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
    at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
    at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
    at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
    at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
    at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
    at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.hibernate.context.ThreadLocalSessionContext$TransactionProtectionWrapper.invoke(ThreadLocalSessionContext.java:301)
    at $Proxy0.save(Unknown Source)
    at spring.Main.<init>(Main.java:46)
    at spring.Main.main(Main.java:17)
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'login' cannot be null
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1313)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1585)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1500)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1485)
    at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:73)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:33)
    ... 23 more

Hibernate ne voit pas les attributs de mon objet NewUser ... Help!

13/04/2009, 12h15
mOuLi

Etant donné la présence de la ligne

Code:

NewUser.setLogin("myname");

avant l'appel au save() le code semble OK mais il faudrait fournir le mapping (fichier XML ou annotations ?) pour vérifier que la colonne 'login' est bien associé à la propriété du même nom.

Citation:

Envoyé par mOuLi

Etant donné la présence de la ligne

Code:

NewUser.setLogin("myname");

avant l'appel au save() le code semble OK mais il faudrait fournir le mapping (fichier XML ou annotations ?) pour vérifier que la colonne 'login' est bien associé à la propriété du même nom.

Voila les fichiers que j'utilise:

le fichier hibernate.cfg.xml

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
 
<?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.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.password"></property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/spring</property>
        <property name="hibernate.connection.username">root</property>
         <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>
        <!-- SQL dialect -->
        <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>
        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
        <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">create</property>
 
 
		<mapping resource="com/hibernate/beans/User.hbm.xml"/>
 
 
 
 
    </session-factory>
</hibernate-configuration>

le fichier User.hbm.xml

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
	"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
 
<hibernate-mapping>
<class name="com.hibernate.beans.User" table="user">
 
	<id name="login" column="login">
		<generator class="native"/>
	</id>
	<property name="mdp" column="mdp"/>
 
</class>
</hibernate-mapping>

la classe User.java

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
 
package com.hibernate.beans;
 
public class User {
	private String login;
	private String mdp;
 
 
	public User(){}
	public User(String l,String m){
		login=l;
		mdp=m;
	}
 
 
	public String getLogin() {
		return login;
	}
	public void setLogin(String login) {
		this.login = login;
	}
	public String getMdp() {
		return mdp;
	}
	public void setMdp(String mdp) {
		this.mdp = mdp;
	}
 
}

la table user

Code:

1
2
3
4
5
6
 
CREATE TABLE `user` (
  `login` varchar(10) NOT NULL,
  `mdp` varchar(25) NOT NULL,
  PRIMARY KEY (`login`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Merci pour voter aide ^^

:yaisse2::yaisse2::yaisse2::yaisse2:

J ai trouvé l'erreur !! :P

c est la ligne suivante
<generator class="assigned"/>

le fichier User.hbm.xml
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 <?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.hibernate.beans.User" table="user"> <id name="login" column="login"> <generator class="native"/> </id> <property name="mdp" column="mdp"/> </class> </hibernate-mapping>