[Débutant] ClassCastException après requête SQL

**tck-lt** · 06/12/2006, 16h16

Je continue d'avancer, j'ai créé mes getters et setters pour éviter les exceptions. je tente maintenant de récupérer des éléments dans ma base grâce au code test suivant :

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
 
public class Test {
 
	 public static void main(String[] args)
		throws HibernateException {
 
		 Session session = HibernateUtil.currentSession();		 
		 SQLQuery myQuery = session.createSQLQuery("select * from abonne");
 
		 System.out.println("-----------> TAILLE : "+myQuery.list().size());
		 for (int i=0;i<myQuery.list().size();i++) {
			 Abonne abonne = (Abonne) myQuery.list().get(i);
			 if (abonne != null) {
				 System.out.println(abonne.getNom());
			 } else {
				 System.out.println("L'enregistrement est vide");
			 }
		 }
 
		 HibernateUtil.closeSession();
 
	 }
}

Malheureusement une exception est encore levée, cette-fois-ci au moment où je caste mon objet contenu dans ma "List". Voici l'exception :

Code :

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

1
2
3
 
Exception in thread "main" java.lang.ClassCastException: [Ljava.lang.Object;
	at hibernate.Test.main(Test.java:25)

Je trouve très bizarre le nom de la classe qui n'arrive pas à caster pourquoi il y a-t-il "[L" dans le nom de la classe de type Object.
Pour rappel, j'utlise MySQL/Hibernate/Tomcat/JSP sur Windows avec Eclipse 3.1.

Merci d'avance de m'aider à supprimer cette exception.

**Janitrix** · 06/12/2006, 16h21

Et bien apparement c'est içi :

Code :

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

Abonne abonne = (Abonne) myQuery.list().get(i);

Il ne vaut mieux pas caster un objet comme ça, fait un test avant :

Code :

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

if(myQuery.list().get(i) instanceof Abonne) {/***}

Si tu sors un élément d'une base de donnée, je doute que se soit un objet Java. Créer plutôt un nouvel objet Abonne à partir des infos de la base de données.

**tck-lt** · 06/12/2006, 16h28

Merci pour ta réponse, mais dans ce cas-là avec Hibernate comment me conseilles-tu de récupérer mes éléments, car les logs Hibernate me donnent bien les informations contenues dans ma base (cf dans la partie code de la ligne 3454 à 3469 - j'en ai enlevé un bout) :

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
195
196
197
198
199
200
201
202
203
204
205
 
1000 [main] INFO org.hibernate.cfg.HbmBinder  - Mapping class: hibernate.Abonne -> abonne
1016 [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: id -> ABONNE_IDENT
1047 [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: nom -> nom
1047 [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: prenom -> prenom
1063 [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: mail -> mail
1063 [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: telephone -> telephone
1063 [main] DEBUG org.hibernate.cfg.HbmBinder  - Mapped property: competences -> competences
1063 [main] INFO org.hibernate.cfg.Configuration  - Configured SessionFactory: null
1063 [main] DEBUG org.hibernate.cfg.Configuration  - Preparing to build session factory with filters : {}
1063 [main] DEBUG org.hibernate.cfg.Configuration  - processing extends queue
1063 [main] DEBUG org.hibernate.cfg.Configuration  - processing collection mappings
1063 [main] DEBUG org.hibernate.cfg.Configuration  - processing native query and ResultSetMapping mappings
1063 [main] DEBUG org.hibernate.cfg.Configuration  - processing association property references
1063 [main] DEBUG org.hibernate.cfg.Configuration  - processing foreign key constraints
1313 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - Using Hibernate built-in connection pool (not for production use!)
1313 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - Hibernate connection pool size: 20
1313 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - autocommit mode: false
1329 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - using driver: org.gjt.mm.mysql.Driver at URL: jdbc:mysql://localhost/intranet_rennes
1329 [main] INFO org.hibernate.connection.DriverManagerConnectionProvider  - connection properties: {user=root}
1329 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
1329 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - opening new JDBC connection
1813 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - created connection to: jdbc:mysql://localhost/intranet_rennes, Isolation Level: 4
1813 [main] INFO org.hibernate.cfg.SettingsFactory  - RDBMS: MySQL, version: 4.1.9-max
1813 [main] INFO org.hibernate.cfg.SettingsFactory  - JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-3.1.8 ( $Date: 2005/04/14 20:36:13 $, $Revision: 1.27.4.64 $ )
1813 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
1891 [main] INFO org.hibernate.dialect.Dialect  - Using dialect: org.hibernate.dialect.MySQLDialect
1907 [main] INFO org.hibernate.transaction.TransactionFactoryFactory  - Using default transaction strategy (direct JDBC transactions)
1907 [main] INFO org.hibernate.transaction.TransactionManagerLookupFactory  - No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
1907 [main] INFO org.hibernate.cfg.SettingsFactory  - Automatic flush during beforeCompletion(): disabled
1907 [main] INFO org.hibernate.cfg.SettingsFactory  - Automatic session close at end of transaction: disabled
1907 [main] INFO org.hibernate.cfg.SettingsFactory  - JDBC batch size: 15
1907 [main] INFO org.hibernate.cfg.SettingsFactory  - JDBC batch updates for versioned data: disabled
1907 [main] INFO org.hibernate.cfg.SettingsFactory  - Scrollable result sets: enabled
1907 [main] DEBUG org.hibernate.cfg.SettingsFactory  - Wrap result sets: disabled
1907 [main] INFO org.hibernate.cfg.SettingsFactory  - JDBC3 getGeneratedKeys(): enabled
1922 [main] INFO org.hibernate.cfg.SettingsFactory  - Connection release mode: auto
1922 [main] INFO org.hibernate.cfg.SettingsFactory  - Maximum outer join fetch depth: 2
1922 [main] INFO org.hibernate.cfg.SettingsFactory  - Default batch fetch size: 1
1922 [main] INFO org.hibernate.cfg.SettingsFactory  - Generate SQL with comments: disabled
1922 [main] INFO org.hibernate.cfg.SettingsFactory  - Order SQL updates by primary key: disabled
1922 [main] INFO org.hibernate.cfg.SettingsFactory  - Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
1938 [main] INFO org.hibernate.hql.ast.ASTQueryTranslatorFactory  - Using ASTQueryTranslatorFactory
1938 [main] INFO org.hibernate.cfg.SettingsFactory  - Query language substitutions: {}
1938 [main] INFO org.hibernate.cfg.SettingsFactory  - Second-level cache: disabled
1938 [main] INFO org.hibernate.cfg.SettingsFactory  - Query cache: disabled
1938 [main] INFO org.hibernate.cfg.SettingsFactory  - Optimize cache for minimal puts: disabled
1954 [main] INFO org.hibernate.cfg.SettingsFactory  - Structured second-level cache entries: disabled
1954 [main] DEBUG org.hibernate.exception.SQLExceptionConverterFactory  - Using dialect defined converter
1969 [main] INFO org.hibernate.cfg.SettingsFactory  - Statistics: disabled
1969 [main] INFO org.hibernate.cfg.SettingsFactory  - Deleted entity synthetic identifier rollback: disabled
1969 [main] INFO org.hibernate.cfg.SettingsFactory  - Default entity-mode: pojo
2079 [main] INFO org.hibernate.impl.SessionFactoryImpl  - building session factory
2079 [main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Session factory constructed with filter configurations : {}
2079 [main] DEBUG org.hibernate.impl.SessionFactoryImpl  - instantiating session factory with properties: {java.runtime.name=Java(TM) 2 Runtime Environment, Standard Edition, sun.boot.library.path=D:\jre1.5.0_05\bin, java.vm.version=1.5.0_05-b05, hibernate.connection.username=root, java.vm.vendor=Sun Microsystems Inc., java.vendor.url=http://java.sun.com/, path.separator=;, java.vm.name=Java HotSpot(TM) Client VM, file.encoding.pkg=sun.io, user.country=FR, sun.os.patch.level=Service Pack 4, java.vm.specification.name=Java Virtual Machine Specification, user.dir=D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes, java.runtime.version=1.5.0_05-b05, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=D:\jre1.5.0_05\lib\endorsed, os.arch=x86, java.io.tmpdir=C:\DOCUME~1\NLETUR~1\LOCALS~1\Temp\, line.separator=
, java.vm.specification.vendor=Sun Microsystems Inc., user.variant=, os.name=Windows 2000, hibernate.cache.use_second_level_cache=false, sun.jnu.encoding=Cp1252, java.library.path=D:\jre1.5.0_05\bin;.;C:\WINNT\system32;C:\WINNT;D:\Perl\bin\;C:\PROGRA~1\Borland\Delphi5\Projects\Bpl;C:\PROGRA~1\Borland\Delphi5\Bin;D:\jre1.5.0_05\bin;D:\oracle\ora92\bin;.;%PATH_BURST_GENERATION%;d:\burst\dev\scripts;d:\burst\dev\commun\bin\debug;d:\burst\dev\serveur\bin\debug;d:\burst\dev\client\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Microsoft Visual Studio 6\Common\VSS\win32;C:\Program Files\Microsoft Visual Studio 6\Common\MSDev98\Bin;C:\Program Files\Microsoft Visual Studio 6\VB98;C:\mysql\bin;C:\Program Files\Microsoft Visual Studio 6\VC98\Bin;C:\Program Files\Microsoft Visual Studio 6\VC98\Include;C:\VXIpnp\WinNT\Bin;D:\cvsnt;C:\Program Files\Bitvise Tunnelier;C:\Program Files\Microsoft SQL Server\80\Tools\Binn\;C:\Program Files\UltraEdit, java.specification.name=Java Platform API Specification, java.class.version=49.0, cache.use_second_level_cache=false, sun.management.compiler=HotSpot Client Compiler, os.version=5.0, user.home=C:\Documents and Settings\nleturluer, user.timezone=, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=Cp1252, java.specification.version=1.5, hibernate.connection.driver_class=org.gjt.mm.mysql.Driver, java.class.path=D:\Tomcat 5.5\common\lib\commons-el.jar;D:\Tomcat 5.5\common\lib\jasper-compiler-jdt.jar;D:\Tomcat 5.5\common\lib\jasper-compiler.jar;D:\Tomcat 5.5\common\lib\jasper-runtime.jar;D:\Tomcat 5.5\common\lib\jsp-api.jar;D:\Tomcat 5.5\common\lib\naming-factory-dbcp.jar;D:\Tomcat 5.5\common\lib\naming-factory.jar;D:\Tomcat 5.5\common\lib\naming-resources.jar;D:\Tomcat 5.5\common\lib\servlet-api.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\bin;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\WebContent\WEB-INF\lib\mysql-connector-java-3.1.8-bin.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\ant-antlr-1.6.5.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\asm.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\asm-attrs.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\cglib-2.1.3.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\commons-collections-2.1.1.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\commons-logging-1.0.4.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\dom4j-1.6.1.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\hibernate3.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\jta.jar;D:\NLeTurluer\Sauvegarde\WorkSpace-Intranet\IntranetRennes\.deployables\IntranetRennes\WEB-INF\lib\log4j-1.2.11.jar, user.name=nleturluer, java.vm.specification.version=1.0, sun.arch.data.model=32, java.home=D:\jre1.5.0_05, hibernate.connection.url=jdbc:mysql://localhost/intranet_rennes, hibernate.dialect=org.hibernate.dialect.MySQLDialect, java.specification.vendor=Sun Microsystems Inc., user.language=fr, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, sharing, hibernate.cglib.use_reflection_optimizer=true, java.version=1.5.0_05, java.ext.dirs=D:\jre1.5.0_05\lib\ext, sun.boot.class.path=D:\jre1.5.0_05\lib\rt.jar;D:\jre1.5.0_05\lib\i18n.jar;D:\jre1.5.0_05\lib\sunrsasign.jar;D:\jre1.5.0_05\lib\jsse.jar;D:\jre1.5.0_05\lib\jce.jar;D:\jre1.5.0_05\lib\charsets.jar;D:\jre1.5.0_05\classes, java.vendor=Sun Microsystems Inc., file.separator=\, java.vendor.url.bug=http://java.sun.com/cgi-bin/bugreport.cgi, sun.cpu.endian=little, sun.io.unicode.encoding=UnicodeLittle, sun.desktop=windows, sun.cpu.isalist=}
2907 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  - Static SQL for entity: hibernate.Abonne
2922 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Version select: select ABONNE_IDENT from abonne where ABONNE_IDENT =?
2922 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Snapshot select: select abonne_.ABONNE_IDENT, abonne_.nom as nom0_, abonne_.prenom as prenom0_, abonne_.mail as mail0_, abonne_.telephone as telephone0_, abonne_.competences as competen6_0_ from abonne abonne_ where abonne_.ABONNE_IDENT=?
2922 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Insert 0: insert into abonne (nom, prenom, mail, telephone, competences, ABONNE_IDENT) values (?, ?, ?, ?, ?, ?)
2922 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Update 0: update abonne set nom=?, prenom=?, mail=?, telephone=?, competences=? where ABONNE_IDENT=?
2922 [main] DEBUG org.hibernate.persister.entity.AbstractEntityPersister  -  Delete 0: delete from abonne where ABONNE_IDENT=?
3001 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity hibernate.Abonne: select abonne0_.ABONNE_IDENT as ABONNE1_0_0_, abonne0_.nom as nom0_0_, abonne0_.prenom as prenom0_0_, abonne0_.mail as mail0_0_, abonne0_.telephone as telephone0_0_, abonne0_.competences as competen6_0_0_ from abonne abonne0_ where abonne0_.ABONNE_IDENT=?
3001 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity hibernate.Abonne: select abonne0_.ABONNE_IDENT as ABONNE1_0_0_, abonne0_.nom as nom0_0_, abonne0_.prenom as prenom0_0_, abonne0_.mail as mail0_0_, abonne0_.telephone as telephone0_0_, abonne0_.competences as competen6_0_0_ from abonne abonne0_ where abonne0_.ABONNE_IDENT=?
3001 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity hibernate.Abonne: select abonne0_.ABONNE_IDENT as ABONNE1_0_0_, abonne0_.nom as nom0_0_, abonne0_.prenom as prenom0_0_, abonne0_.mail as mail0_0_, abonne0_.telephone as telephone0_0_, abonne0_.competences as competen6_0_0_ from abonne abonne0_ where abonne0_.ABONNE_IDENT=? for update
3001 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for entity hibernate.Abonne: select abonne0_.ABONNE_IDENT as ABONNE1_0_0_, abonne0_.nom as nom0_0_, abonne0_.prenom as prenom0_0_, abonne0_.mail as mail0_0_, abonne0_.telephone as telephone0_0_, abonne0_.competences as competen6_0_0_ from abonne abonne0_ where abonne0_.ABONNE_IDENT=? for update
3047 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for action ACTION_MERGE on entity hibernate.Abonne: select abonne0_.ABONNE_IDENT as ABONNE1_0_0_, abonne0_.nom as nom0_0_, abonne0_.prenom as prenom0_0_, abonne0_.mail as mail0_0_, abonne0_.telephone as telephone0_0_, abonne0_.competences as competen6_0_0_ from abonne abonne0_ where abonne0_.ABONNE_IDENT=?
3047 [main] DEBUG org.hibernate.loader.entity.EntityLoader  - Static select for action ACTION_REFRESH on entity hibernate.Abonne: select abonne0_.ABONNE_IDENT as ABONNE1_0_0_, abonne0_.nom as nom0_0_, abonne0_.prenom as prenom0_0_, abonne0_.mail as mail0_0_, abonne0_.telephone as telephone0_0_, abonne0_.competences as competen6_0_0_ from abonne abonne0_ where abonne0_.ABONNE_IDENT=?
3047 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory  - initializing class SessionFactoryObjectFactory
3063 [main] DEBUG org.hibernate.impl.SessionFactoryObjectFactory  - registered: 4028e5820f581a70010f581a74e40000 (unnamed)
3063 [main] INFO org.hibernate.impl.SessionFactoryObjectFactory  - Not binding factory to JNDI, no JNDI name configured
3063 [main] DEBUG org.hibernate.impl.SessionFactoryImpl  - instantiated session factory
3063 [main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Checking 0 named HQL queries
3063 [main] DEBUG org.hibernate.impl.SessionFactoryImpl  - Checking 0 named SQL queries
3204 [main] DEBUG org.hibernate.impl.SessionImpl  - opened session at timestamp: 11654142661
3235 [main] DEBUG org.hibernate.engine.query.QueryPlanCache  - unable to locate native-sql query plan in cache; generating (select * from abonne)
3266 [main] DEBUG org.hibernate.impl.SessionImpl  - SQL query: select * from abonne
3266 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
3266 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - opening JDBC connection
3266 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
3266 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
3266 [main] DEBUG org.hibernate.SQL  - select * from abonne
3282 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - preparing statement
3297 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open ResultSet (open ResultSets: 0, globally: 0)
3313 [main] DEBUG org.hibernate.loader.Loader  - processing result set
3329 [main] DEBUG org.hibernate.loader.Loader  - result set row: 0
3329 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3329 [main] DEBUG org.hibernate.type.IntegerType  - returning '1' as column: ABONNE_IDENT
3329 [main] DEBUG org.hibernate.type.StringType  - returning 'LUCAS' as column: ABONNE_NOM
3329 [main] DEBUG org.hibernate.type.StringType  - returning 'REGIS' as column: ABONNE_PRENOM
3329 [main] DEBUG org.hibernate.type.StringType  - returning '0299558888' as column: ABONNE_TELEPHONE
3329 [main] DEBUG org.hibernate.type.StringType  - returning 'rlucas102@hotmail.com' as column: ABONNE_MAIL
3329 [main] DEBUG org.hibernate.type.StringType  - returning '.NET, PHP, Java' as column: ABONNE_COMPETENCES
3329 [main] DEBUG org.hibernate.loader.Loader  - result set row: 1
3329 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3329 [main] DEBUG org.hibernate.type.IntegerType  - returning '2' as column: ABONNE_IDENT
3329 [main] DEBUG org.hibernate.type.StringType  - returning 'JUIN' as column: ABONNE_NOM
3329 [main] DEBUG org.hibernate.type.StringType  - returning 'Leclerc' as column: ABONNE_PRENOM
3329 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_TELEPHONE
3344 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_MAIL
3344 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_COMPETENCES
3344 [main] DEBUG org.hibernate.loader.Loader  - result set row: 2
3344 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3344 [main] DEBUG org.hibernate.type.IntegerType  - returning '3' as column: ABONNE_IDENT
3344 [main] DEBUG org.hibernate.type.StringType  - returning 'xxxxxxxr' as column: ABONNE_NOM
3344 [main] DEBUG org.hibernate.type.StringType  - returning 'Nicolas' as column: ABONNE_PRENOM
3344 [main] DEBUG org.hibernate.type.StringType  - returning '06xxxxxxxx' as column: ABONNE_TELEPHONE
3344 [main] DEBUG org.hibernate.type.StringType  - returning 'nicolas.xxxxxxxxx@laposte.net' as column: ABONNE_MAIL
3344 [main] DEBUG org.hibernate.type.StringType  - returning 'Java et Réseaux' as column: ABONNE_COMPETENCES
3344 [main] DEBUG org.hibernate.loader.Loader  - done processing result set (3 rows)
3344 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close ResultSet (open ResultSets: 1, globally: 1)
3344 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3344 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing statement
3360 [main] DEBUG org.hibernate.engine.StatefulPersistenceContext  - initializing non-lazy collections
3360 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after autocommit
3360 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - aggressively releasing JDBC connection
3360 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
3360 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
-----------> TAILLE : 3
3376 [main] DEBUG org.hibernate.engine.query.QueryPlanCache  - located native-sql query plan in cache (select * from abonne)
3376 [main] DEBUG org.hibernate.impl.SessionImpl  - SQL query: select * from abonne
3376 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
3376 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - opening JDBC connection
3376 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
3391 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
3391 [main] DEBUG org.hibernate.SQL  - select * from abonne
3391 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - preparing statement
3391 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open ResultSet (open ResultSets: 0, globally: 0)
3391 [main] DEBUG org.hibernate.loader.Loader  - processing result set
3391 [main] DEBUG org.hibernate.loader.Loader  - result set row: 0
3391 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3407 [main] DEBUG org.hibernate.type.IntegerType  - returning '1' as column: ABONNE_IDENT
3407 [main] DEBUG org.hibernate.type.StringType  - returning 'LUCAS' as column: ABONNE_NOM
3407 [main] DEBUG org.hibernate.type.StringType  - returning 'REGIS' as column: ABONNE_PRENOM
3407 [main] DEBUG org.hibernate.type.StringType  - returning '0299558888' as column: ABONNE_TELEPHONE
3407 [main] DEBUG org.hibernate.type.StringType  - returning 'rlucas102@hotmail.com' as column: ABONNE_MAIL
3407 [main] DEBUG org.hibernate.type.StringType  - returning '.NET, PHP, Java' as column: ABONNE_COMPETENCES
3407 [main] DEBUG org.hibernate.loader.Loader  - result set row: 1
3407 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3407 [main] DEBUG org.hibernate.type.IntegerType  - returning '2' as column: ABONNE_IDENT
3407 [main] DEBUG org.hibernate.type.StringType  - returning 'JUIN' as column: ABONNE_NOM
3407 [main] DEBUG org.hibernate.type.StringType  - returning 'Leclerc' as column: ABONNE_PRENOM
3407 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_TELEPHONE
3407 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_MAIL
3407 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_COMPETENCES
3407 [main] DEBUG org.hibernate.loader.Loader  - result set row: 2
3407 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3422 [main] DEBUG org.hibernate.type.IntegerType  - returning '3' as column: ABONNE_IDENT
3422 [main] DEBUG org.hibernate.type.StringType  - returning 'xxxxxxxx' as column: ABONNE_NOM
3422 [main] DEBUG org.hibernate.type.StringType  - returning 'Nicolas' as column: ABONNE_PRENOM
3422 [main] DEBUG org.hibernate.type.StringType  - returning '06xxxxxxx' as column: ABONNE_TELEPHONE
3422 [main] DEBUG org.hibernate.type.StringType  - returning 'nicolas.xxxxxxxxxx@laposte.net' as column: ABONNE_MAIL
3422 [main] DEBUG org.hibernate.type.StringType  - returning 'Java et Réseaux' as column: ABONNE_COMPETENCES
3422 [main] DEBUG org.hibernate.loader.Loader  - done processing result set (3 rows)
3422 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close ResultSet (open ResultSets: 1, globally: 1)
3422 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3422 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing statement
3422 [main] DEBUG org.hibernate.engine.StatefulPersistenceContext  - initializing non-lazy collections
3422 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after autocommit
3422 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - aggressively releasing JDBC connection
3422 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
3422 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1
3422 [main] DEBUG org.hibernate.engine.query.QueryPlanCache  - located native-sql query plan in cache (select * from abonne)
3422 [main] DEBUG org.hibernate.impl.SessionImpl  - SQL query: select * from abonne
3422 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
3422 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - opening JDBC connection
3438 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - total checked-out connections: 0
3438 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
3438 [main] DEBUG org.hibernate.SQL  - select * from abonne
3438 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - preparing statement
3438 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to open ResultSet (open ResultSets: 0, globally: 0)
3454 [main] DEBUG org.hibernate.loader.Loader  - processing result set
3454 [main] DEBUG org.hibernate.loader.Loader  - result set row: 0
3454 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3454 [main] DEBUG org.hibernate.type.IntegerType  - returning '1' as column: ABONNE_IDENT
3454 [main] DEBUG org.hibernate.type.StringType  - returning 'LUCAS' as column: ABONNE_NOM
3454 [main] DEBUG org.hibernate.type.StringType  - returning 'REGIS' as column: ABONNE_PRENOM
3454 [main] DEBUG org.hibernate.type.StringType  - returning '0299558888' as column: ABONNE_TELEPHONE
3454 [main] DEBUG org.hibernate.type.StringType  - returning 'rlucas102@hotmail.com' as column: ABONNE_MAIL
3454 [main] DEBUG org.hibernate.type.StringType  - returning '.NET, PHP, Java' as column: ABONNE_COMPETENCES
3454 [main] DEBUG org.hibernate.loader.Loader  - result set row: 1
3454 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3454 [main] DEBUG org.hibernate.type.IntegerType  - returning '2' as column: ABONNE_IDENT
3454 [main] DEBUG org.hibernate.type.StringType  - returning 'JUIN' as column: ABONNE_NOM
3454 [main] DEBUG org.hibernate.type.StringType  - returning 'Leclerc' as column: ABONNE_PRENOM
3454 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_TELEPHONE
3454 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_MAIL
3469 [main] DEBUG org.hibernate.type.StringType  - returning null as column: ABONNE_COMPETENCES
3469 [main] DEBUG org.hibernate.loader.Loader  - result set row: 2
3469 [main] DEBUG org.hibernate.loader.Loader  - result row: 
3469 [main] DEBUG org.hibernate.type.IntegerType  - returning '3' as column: ABONNE_IDENT
3469 [main] DEBUG org.hibernate.type.StringType  - returning 'xxxxxxxx' as column: ABONNE_NOM
3469 [main] DEBUG org.hibernate.type.StringType  - returning 'Nicolas' as column: ABONNE_PRENOM
3469 [main] DEBUG org.hibernate.type.StringType  - returning '06xxxxxxx' as column: ABONNE_TELEPHONE
3469 [main] DEBUG org.hibernate.type.StringType  - returning 'nicolas.xxxxxxxxxx@laposte.net' as column: ABONNE_MAIL
3469 [main] DEBUG org.hibernate.type.StringType  - returning 'Java et Réseaux' as column: ABONNE_COMPETENCES
3469 [main] DEBUG org.hibernate.loader.Loader  - done processing result set (3 rows)
3469 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close ResultSet (open ResultSets: 1, globally: 1)
3469 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
3469 [main] DEBUG org.hibernate.jdbc.AbstractBatcher  - closing statement
3469 [main] DEBUG org.hibernate.engine.StatefulPersistenceContext  - initializing non-lazy collections
3469 [main] DEBUG org.hibernate.jdbc.JDBCContext  - after autocommit
3469 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - aggressively releasing JDBC connection
3469 [main] DEBUG org.hibernate.jdbc.ConnectionManager  - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
3469 [main] DEBUG org.hibernate.connection.DriverManagerConnectionProvider  - returning connection to pool, pool size: 1

**fr1man** · 06/12/2006, 16h48

Les différents .list() n'exécutent ils pas plusieurs fois la requête ?

J'aurais écrit ta méthode différemment :

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
 
Session session = HibernateUtil.currentSession();		 
SQLQuery myQuery = session.createSQLQuery("select * from abonne");
List liste =  myQuery.list();
 
System.out.println("-----------> TAILLE : "+ liste.size());
 
Iterator iter = liste.iterator();
while(iter.hasNext())
{
  Abonne abonne = (Abonne) iter.next();
  if (abonne != null)
  {
    System.out.println(abonne.getNom());
  }
  else
  {
    System.out.println("L'enregistrement est vide");			
  }
}
 
HibernateUtil.closeSession();

Vérifier la syntaxe, car j'ai écrit ça vite fait.

**BsT** · 06/12/2006, 16h49

Bonjour,

Lorsque sur le nom d'une classe tu as [L c'est que ta classe est un tableau;

Tu devrais plutot écrire

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
 
 
public class Test {
 
	 public static void main(String[] args)
		throws HibernateException {
 
		 Session session = HibernateUtil.currentSession();		 
		 Query myQuery = session.createQuery("From Abonne");
                 List result = myQuery.list();
		 System.out.println("-----------> TAILLE :  "result.size());
// j'utilise un iterator mais tu peux prendre result.get(i)
		 for (Iterator it = result.iterator(); it.hasNext();) {
			 Abonne abonne = (Abonne) it.next();
			 System.out.println(abonne.getNom());
// abonne est forcement != null
//			 if (abonne != null) {
//				 System.out.println(abonne.getNom());
//			 } else {
//				 System.out.println("L'enregistrement est vide");
//			 }
		 }
 
		 HibernateUtil.closeSession();
 
	 }
}

Edit : arf devancé

**tck-lt** · 06/12/2006, 16h57

Merci mais j'avais déjà essayé ça (j'aurais dû vous le préciser). Le problème avec cette requête en HQL (si j'ai bien compris) est que j'obitens l'exception suivante :

Code :

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

1
2
3
4
5
6
7
8
9
10
 
Exception in thread "main" java.lang.NoClassDefFoundError: antlr/ANTLRException
	at org.hibernate.hql.ast.ASTQueryTranslatorFactory.createQueryTranslator(ASTQueryTranslatorFactory.java:35)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:72)
	at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
	at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
	at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
	at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
	at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1583)
	at hibernate.Test.main(Test.java:21)

Faut-il que je fasse comme avec l'autre classe (cf post précédent) ?

**bouchette63** · 06/12/2006, 17h00

Bonjour,

il te manque apparemment la jar Ant dans ta bibliothèque.

**tck-lt** · 06/12/2006, 17h03

merci c'est que je viens de voir grâce à mon ami Google. C'est le bordel de reprendre un projet où chacun a mis son petit plug-in de son côté sur Eclipse.