Comment coupler Hibernate et Spring

**Philcmoi** · 11/07/2010, 11h58

En developpement web tout fonctionne sauf en client riche avec swing4
voici le code dans swing:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
Object source = arg0.getSource();
		if (source==jButton0) {
 
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		session.beginTransaction();
		User user = new User();
		user.setLoginUser(jTextField0.toString());
		user.setPasswordUser(jTextField1.toString());
		session.save(user);
 
		session.getTransaction().commit();
		HibernateUtil.getSessionFactory().close();

hibernate uti

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
package Util;
 
import org.hibernate.*;
import org.hibernate.cfg.*;
 
 
public class HibernateUtil {
private static final SessionFactory sessionFactory;
	static {
		try { sessionFactory = new Configuration().configure().buildSessionFactory();
		} catch (Throwable ex) {System.err.println("Echec operation SessionFactory" + ex);
		throw new ExceptionInInitializerError(ex);
		}
	}
 
	public static SessionFactory getSessionFactory() {
		return sessionFactory;}
	}

hibernate config

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<?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.bytecode.use_reflection_optimizer">false</property>
        <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
        <property name="hibernate.connection.password">L099339R</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/mabasse</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>
		<property name="current_session_context_class">thread</property>
		<property name="hibernate.show_sql">true</property>
        <mapping resource="Entite/User.hbm.xml" />
        <mapping resource="Entite/Course.hbm.xml" />
        <mapping resource="Entite/Entite2.hbm.xml" />
        <mapping resource="Entite/Applabsuser.hbm.xml" />
    </session-factory>
</hibernate-configuration>

la classe persistante

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
package Entite;
 
// default package
// Generated 8 juil. 2010 12:46:15 by Hibernate Tools 3.2.4.GA
 
/**
 * User generated by hbm2java
 */
public class User implements java.io.Serializable {
 
	private Integer idUser;
	private String loginUser;
	private String passwordUser;
 
	public User() {
	}
 
	public User(String loginUser, String passwordUser) {
		this.loginUser = loginUser;
		this.passwordUser = passwordUser;
	}
 
	public Integer getIdUser() {
		return this.idUser;
	}
 
	public void setIdUser(Integer idUser) {
		this.idUser = idUser;
	}
 
	public String getLoginUser() {
		return this.loginUser;
	}
 
	public void setLoginUser(String loginUser) {
		this.loginUser = loginUser;
	}
 
	public String getPasswordUser() {
		return this.passwordUser;
	}
 
	public void setPasswordUser(String passwordUser) {
		this.passwordUser = passwordUser;
	}
 
}

User.hbm.xml

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 8 juil. 2010 12:46:16 by Hibernate Tools 3.2.4.GA -->
<hibernate-mapping>
    <class name="Entite.User" table="user" catalog="mabasse">
        <id name="idUser" type="java.lang.Integer">
            <column name="id_user" />
            <generator class="identity" />
        </id>
        <property name="loginUser" type="string">
            <column name="login_user" length="25" not-null="true" />
        </property>
        <property name="passwordUser" type="string">
            <column name="password_user" length="25" not-null="true" />
        </property>
    </class>
</hibernate-mapping>

voici ceux qu'il y a sur la cosole

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
GRAVE: Data truncation: Data too long for column 'login_user' at row 1
Exception in thread "AWT-EventQueue-0" org.hibernate.exception.DataException: could not insert: [Entite.User]

Merci pour toute l'aide que vous pourrez me donner

**welcome_59** · 11/07/2010, 17h30

Je ne comprends pas ta question.

Si ton problème est l'exception que tu as postée, je pense que c'est plus lié au fait que tu as soumis à hibernate un login plus grand que 25 caractères (la longueur spécifiée dans ton fichier de mapping)

**tchize_** · 11/07/2010, 17h33

au passage, évite de faire:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

HibernateUtil.getSessionFactory().close();

ce sont les sessions que l'ont ferme, pas la factory, sauf cas exceptionnel.

**Philcmoi** · 11/07/2010, 18h09

j'aiessai d' utiliser swing avec hibernate
Merci pour toute aide
voici le code de la console

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
GRAVE: Could not synchronize database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)

**thebloodyman** · 11/07/2010, 20h04

Salut,

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
GRAVE: Could not synchronize database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)

Privilégie les stacktraces d'exceptions complètes. Y a toujours pleins d'infos utiles dans ces petits fruits qui se mangent à toutes les saisons

**Philcmoi** · 12/07/2010, 12h10

voila le stacktrace en entier

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
SLF4J: The requested version 1.6 by your slf4j binding is not compatible with [1.5.5, 1.5.6, 1.5.7, 1.5.8]
SLF4J: See http://www.slf4j.org/codes.html#version_mismatch for further details.
12 juil. 2010 12:09:36 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.5.2-Final
12 juil. 2010 12:09:36 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
12 juil. 2010 12:09:36 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : javassist
12 juil. 2010 12:09:36 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
12 juil. 2010 12:09:36 org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
12 juil. 2010 12:09:36 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
12 juil. 2010 12:09:36 org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : Entite/User.hbm.xml
12 juil. 2010 12:09:36 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: Entite.User -> user
12 juil. 2010 12:09:36 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
12 juil. 2010 12:09:36 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
12 juil. 2010 12:09:36 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
12 juil. 2010 12:09:36 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
12 juil. 2010 12:09:36 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/mabasse
12 juil. 2010 12:09:36 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****}
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 5.0.87-community-nt
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )
12 juil. 2010 12:09:37 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
12 juil. 2010 12:09:37 org.hibernate.engine.jdbc.JdbcSupportLoader useContextualLobCreation
INFO: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
12 juil. 2010 12:09:37 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
12 juil. 2010 12:09:37 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
12 juil. 2010 12:09:37 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory createRegionFactory
INFO: Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
12 juil. 2010 12:09:37 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Check Nullability in Core (should be disabled when Bean Validation is on): enabled
12 juil. 2010 12:09:37 org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
12 juil. 2010 12:09:37 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Hibernate: insert into mabasse.user (login_user, password_user) values (?, ?)
12 juil. 2010 12:09:37 org.hibernate.util.JDBCExceptionReporter logExceptions
ATTENTION: SQL Error: 0, SQLState: 22001
12 juil. 2010 12:09:37 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: Data truncation: Data too long for column 'login_user' at row 1
Exception in thread "AWT-EventQueue-0" org.hibernate.exception.DataException: could not insert: [Entite.User]
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2329)
	at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2836)
	at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:71)
	at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268)
	at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:321)
	at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:204)
	at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:130)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:210)
	at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:56)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:195)
	at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:50)
	at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:93)
	at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:705)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:693)
	at org.hibernate.impl.SessionImpl.save(SessionImpl.java:689)
	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:344)
	at $Proxy0.save(Unknown Source)
	at Essai.actionPerformed(Essai.java:39)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'login_user' at row 1
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2983)
	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:3283)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
	at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:94)
	at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:57)
	... 47 more

**tchize_** · 12/07/2010, 12h43

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'login_user' at row 1

welcome_59 t'as déjà répondu à cette erreur

tu met un login trop long dans ton bean.

**Philcmoi** · 12/07/2010, 15h02

voici user.hbm.xml
le login est bien de varchar(25)

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
<property name="loginUser" type="string">
            <column name="login_user" length="25" not-null="true" />
        </property>

Je n'y comprend rien

revoici le tasktrace

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
SLF4J: The requested version 1.6 by your slf4j binding is not compatible with [1.5.5, 1.5.6, 1.5.7, 1.5.8]
SLF4J: See http://www.slf4j.org/codes.html#version_mismatch for further details.
12 juil. 2010 15:04:15 org.hibernate.cfg.Environment <clinit>
INFO: Hibernate 3.5.2-Final
12 juil. 2010 15:04:15 org.hibernate.cfg.Environment <clinit>
INFO: hibernate.properties not found
12 juil. 2010 15:04:15 org.hibernate.cfg.Environment buildBytecodeProvider
INFO: Bytecode provider name : javassist
12 juil. 2010 15:04:15 org.hibernate.cfg.Environment <clinit>
INFO: using JDK 1.4 java.sql.Timestamp handling
12 juil. 2010 15:04:15 org.hibernate.cfg.Configuration configure
INFO: configuring from resource: /hibernate.cfg.xml
12 juil. 2010 15:04:15 org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: Configuration resource: /hibernate.cfg.xml
12 juil. 2010 15:04:15 org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : Entite/User.hbm.xml
12 juil. 2010 15:04:15 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: Entite.User -> user
12 juil. 2010 15:04:15 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
12 juil. 2010 15:04:15 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
12 juil. 2010 15:04:15 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
12 juil. 2010 15:04:15 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
12 juil. 2010 15:04:15 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/mabasse
12 juil. 2010 15:04:15 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****}
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: RDBMS: MySQL, version: 5.0.87-community-nt
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.0.8 ( Revision: ${svn.Revision} )
12 juil. 2010 15:04:16 org.hibernate.dialect.Dialect <init>
INFO: Using dialect: org.hibernate.dialect.MySQLDialect
12 juil. 2010 15:04:16 org.hibernate.engine.jdbc.JdbcSupportLoader useContextualLobCreation
INFO: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4
12 juil. 2010 15:04:16 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
INFO: Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
12 juil. 2010 15:04:16 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic flush during beforeCompletion(): disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Automatic session close at end of transaction: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch size: 15
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC batch updates for versioned data: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Scrollable result sets: enabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JDBC3 getGeneratedKeys(): enabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Connection release mode: auto
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Maximum outer join fetch depth: 2
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default batch fetch size: 1
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Generate SQL with comments: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL updates by primary key: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Order SQL inserts for batching: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
12 juil. 2010 15:04:16 org.hibernate.hql.ast.ASTQueryTranslatorFactory <init>
INFO: Using ASTQueryTranslatorFactory
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query language substitutions: {}
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: JPA-QL strict compliance: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Second-level cache: enabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Query cache: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory createRegionFactory
INFO: Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Optimize cache for minimal puts: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Structured second-level cache entries: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Echoing all SQL to stdout
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Statistics: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Deleted entity synthetic identifier rollback: disabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Default entity-mode: pojo
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Named query checking : enabled
12 juil. 2010 15:04:16 org.hibernate.cfg.SettingsFactory buildSettings
INFO: Check Nullability in Core (should be disabled when Bean Validation is on): enabled
12 juil. 2010 15:04:16 org.hibernate.impl.SessionFactoryImpl <init>
INFO: building session factory
12 juil. 2010 15:04:16 org.hibernate.impl.SessionFactoryObjectFactory addInstance
INFO: Not binding factory to JNDI, no JNDI name configured
Hibernate: select max(iduser) from user
Hibernate: insert into mabasse.user (login_, password, iduser) values (?, ?, ?)
12 juil. 2010 15:04:16 org.hibernate.util.JDBCExceptionReporter logExceptions
ATTENTION: SQL Error: 0, SQLState: 22001
12 juil. 2010 15:04:16 org.hibernate.util.JDBCExceptionReporter logExceptions
GRAVE: Data truncation: Data too long for column 'login_' at row 1
12 juil. 2010 15:04:16 org.hibernate.event.def.AbstractFlushingEventListener performExecutions
GRAVE: Could not synchronize database state with session
org.hibernate.exception.DataException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:375)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
	at Essai.actionPerformed(Essai.java:40)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'login_' at row 1
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 33 more
Exception in thread "AWT-EventQueue-0" org.hibernate.exception.DataException: Could not execute JDBC batch update
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
	at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
	at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
	at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
	at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
	at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:375)
	at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
	at Essai.actionPerformed(Essai.java:40)
	at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
	at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
	at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
	at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
	at java.awt.Component.processMouseEvent(Unknown Source)
	at javax.swing.JComponent.processMouseEvent(Unknown Source)
	at java.awt.Component.processEvent(Unknown Source)
	at java.awt.Container.processEvent(Unknown Source)
	at java.awt.Component.dispatchEventImpl(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
	at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
	at java.awt.Container.dispatchEventImpl(Unknown Source)
	at java.awt.Window.dispatchEventImpl(Unknown Source)
	at java.awt.Component.dispatchEvent(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
	at java.awt.EventDispatchThread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'login_' at row 1
	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1269)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:955)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 33 more

**tchize_** · 12/07/2010, 15h28

c'est devenu "login_" et plus login_user maintenant? Sinon, le problème n'est pas ta définition, mais la valeur réelle que tu a mis dans ton bean. Si t'as un doute, contente toi de l'afficher dans la console avant de faire le save et tu verra que le problème est qu'il fait plus de 25 caractères:

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
Object source = arg0.getSource();
		if (source==jButton0) {
 
		Session session = HibernateUtil.getSessionFactory().getCurrentSession();
		session.beginTransaction();
		User user = new User();
		user.setLoginUser(jTextField0.toString());
		user.setPasswordUser(jTextField1.toString());
                System.out.printf("saving user %s, login length is %d\n",user.getLoginUser(), user.getLoginUser().length());
		session.save(user);
 
		session.getTransaction().commit();
		HibernateUtil.getSessionFactory().close();

**Philcmoi** · 12/07/2010, 15h49

Merci à tous vous aviez raison
j'utilisai

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

user.setPassword(jTextField1.toString());

ce qui donnait une interminable de code swing
j'ai remplacai par jTextField.getTex(), et ca marche
encore merci à tous.

Comment coupler Hibernate et Spring

Hibernate Java

Discussions similaires

Partager

Partager