problème hibernate oracle jdbc

Version imprimable

Bonjour,
je viens de tester une petite application (mapping hibernate) avec le connecteur mysql et eclipse et ca marché (création des tables, insertion...) trés bien lorsque j'ai changé de driver (classe12.jar et ojdbc14) et j'ai refais mon fichier de configuration d(hibernate il me retourne énormément d'erreurs les voilà :

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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
 
 
17:09:47,921  INFO Environment:479 - Hibernate 3.1
17:09:47,921  INFO Environment:509 - hibernate.properties not found
17:09:47,921  INFO Environment:525 - using CGLIB reflection optimizer
17:09:47,937  INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
17:09:48,015  INFO Configuration:1286 - configuring from resource: /hibernate.cfg.xml
17:09:48,015  INFO Configuration:1263 - Configuration resource: /hibernate.cfg.xml
17:09:48,171  INFO Configuration:468 - Reading mappings from resource: ma/corporate/planning/metier/Client.hbm.xml
17:09:48,375  INFO HbmBinder:265 - Mapping class: ma.corporate.planning.metier.Client -> CLIENTS
17:09:48,421  INFO Configuration:1397 - Configured SessionFactory: null
17:09:48,421  INFO Configuration:1022 - processing extends queue
17:09:48,421  INFO Configuration:1026 - processing collection mappings
17:09:48,421  INFO Configuration:1035 - processing association property references
17:09:48,421  INFO Configuration:1057 - processing foreign key constraints
17:09:48,515  INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
17:09:48,890  INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
17:09:48,890  INFO DriverManagerConnectionProvider:45 - autocommit mode: false
17:09:48,890 FATAL DriverManagerConnectionProvider:65 - JDBC Driver class not found: com.mysql.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:108)
	at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:61)
	at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
	at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
	at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
	at util.HibernateUtil.<clinit>(HibernateUtil.java:11)
	at ma.corporate.planning.metier.GestClient.addClient(GestClient.java:10)
	at ma.corporate.planning.metier.GestClient.main(GestClient.java:26)
Initial SessionFactory creation failed.org.hibernate.HibernateException: JDBC Driver class not found: com.mysql.jdbc.Driver
Exception in thread "main" java.lang.ExceptionInInitializerError
	at util.HibernateUtil.<clinit>(HibernateUtil.java:15)
	at ma.corporate.planning.metier.GestClient.addClient(GestClient.java:10)
	at ma.corporate.planning.metier.GestClient.main(GestClient.java:26)
Caused by: org.hibernate.HibernateException: JDBC Driver class not found: com.mysql.jdbc.Driver
	at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:66)
	at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:124)
	at org.hibernate.connection.ConnectionProviderFactory.newConnectionProvider(ConnectionProviderFactory.java:56)
	at org.hibernate.cfg.SettingsFactory.createConnectionProvider(SettingsFactory.java:366)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:60)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
	at util.HibernateUtil.<clinit>(HibernateUtil.java:11)
	... 2 more
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClass(Unknown Source)
	at java.lang.ClassLoader.loadClassInternal(Unknown Source)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:108)
	at org.hibernate.connection.DriverManagerConnectionProvider.configure(DriverManagerConnectionProvider.java:61)
	... 9 more

Mon fichier de configuration :

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
<?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">oracle.jdbc.driver.OracleDriver</property>
        <property name="hibernate.connection.url">jdbc:oracle:thin:@localhost:1521:DBoracle></property>
        <property name="hibernate.connection.username">ADMINDBORACLE</property>
        <property name="hibernate.connection.password">admindboracle</property>
 
        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>
 
        <!-- SQL dialect -->
        <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</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="ma/corporate/planning/metier/Client.hbm.xml"/>
 
    </session-factory>
</hibernate-configuration>

27/03/2008, 19h54
fr1man

ce ne sont pas des erreurs. Il y a info devant.
27/03/2008, 23h10
rdutertre

L'erreur :

Code:

Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

indique qu'un autre fichier de configuration est pris en compte avant celui que tu nous montres (la configuration pointe vers le driver MySQL).
28/03/2008, 10h44
fr1man

Désolé pour ma réponse erronée, je n'avais pas la fin des logs sur mon navigateur web.

ok merci, j'ai corrigé le problème, voilà ce qu'il me retourne maintenant :

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
48
49
50
51
52
53
54
55
56
10:11:19,171  INFO Environment:479 - Hibernate 3.1
10:11:19,171  INFO Environment:509 - hibernate.properties not found
10:11:19,187  INFO Environment:525 - using CGLIB reflection optimizer
10:11:19,187  INFO Environment:555 - using JDK 1.4 java.sql.Timestamp handling
10:11:19,265  INFO Configuration:1286 - configuring from resource: /hibernate.cfg.xml
10:11:19,265  INFO Configuration:1263 - Configuration resource: /hibernate.cfg.xml
10:11:19,406  INFO Configuration:468 - Reading mappings from resource: ma/corporate/planning/metier/Client.hbm.xml
10:11:19,562  INFO HbmBinder:265 - Mapping class: ma.corporate.planning.metier.Client -> CLIENTS
10:11:19,609  INFO Configuration:468 - Reading mappings from resource: ma/corporate/planning/metier/Projet.hbm.xml
10:11:19,656  INFO HbmBinder:265 - Mapping class: ma.corporate.planning.metier.Projet -> PROJETS
10:11:19,656  INFO Configuration:1397 - Configured SessionFactory: null
10:11:19,671  INFO Configuration:1022 - processing extends queue
10:11:19,671  INFO Configuration:1026 - processing collection mappings
10:11:19,703  INFO Configuration:1035 - processing association property references
10:11:19,703  INFO Configuration:1057 - processing foreign key constraints
10:11:19,828  INFO DriverManagerConnectionProvider:41 - Using Hibernate built-in connection pool (not for production use!)
10:11:19,828  INFO DriverManagerConnectionProvider:42 - Hibernate connection pool size: 1
10:11:19,828  INFO DriverManagerConnectionProvider:45 - autocommit mode: false
10:11:19,828  INFO DriverManagerConnectionProvider:80 - using driver: oracle.jdbc.driver.OracleDriver at URL: jdbc:oracle:thin:@localhost:1521:DBoracle
10:11:19,843  INFO DriverManagerConnectionProvider:86 - connection properties: {user=ADMINDBORACLE, password=****}
10:11:20,062  WARN SettingsFactory:103 - Could not obtain connection metadata
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:DBoracle
 
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:279)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:327)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:360)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:595)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at java.sql.DriverManager.getConnection(Unknown Source)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:72)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
	at util.HibernateUtil.<clinit>(HibernateUtil.java:11)
	at ma.corporate.planning.metier.GestClient.addClient(GestClient.java:10)
	at ma.corporate.planning.metier.Test.main(Test.java:11)
Initial SessionFactory creation failed.org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.Oracle10gDialect
Exception in thread "main" java.lang.ExceptionInInitializerError
	at util.HibernateUtil.<clinit>(HibernateUtil.java:15)
	at ma.corporate.planning.metier.GestClient.addClient(GestClient.java:10)
	at ma.corporate.planning.metier.Test.main(Test.java:11)
Caused by: org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.Oracle10gDialect
	at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:81)
	at org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:42)
	at org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:378)
	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:110)
	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:1859)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1152)
	at util.HibernateUtil.<clinit>(HibernateUtil.java:11)
	... 2 more

Merci pour votre aide !:cry:

28/03/2008, 13h44
fr1man

A priori, DBoracle n'est pas reconnu.
Est-ce un nom qui existe ?

De plus, il semble y avoir une erreur au niveau de ton dialect, à moins que ce soit lié à la première erreur.
28/03/2008, 14h14
JeitEmgie

Citation:

Envoyé par fr1man

A priori, DBoracle n'est pas reconnu.
Est-ce un nom qui existe ?

De plus, il semble y avoir une erreur au niveau de ton dialect, à moins que ce soit lié à la première erreur.

a priori les 2 erreurs sont indépendantes :

le SID est un problème de configuration ORACLE à vérifier avec le DBA…
(peut-être aussi un problème de config de TNS sur votre station de travail… dépend de votre OS… : testez la connection avec un autre outil… genre TOAD, jDeveloper, …)

Oracle10gDialect existe mais dans une des versions les plus récentes de Hibernate seulement, il se peut que vous ayez une version plus ancienne d'Hibernate dans le classpath…
28/03/2008, 15h34
newmar

j'ai le hibernate3 8O
28/03/2008, 17h07
JeitEmgie

Citation:

Envoyé par newmar

j'ai le hibernate3 8O

soyez plus précis…
de mémoire c'est à partir de la 3.2.5 que c'est apparu…
28/03/2008, 18h52
newmar

c'est le hibernate3.jar ????????????? :roll:
28/03/2008, 19h36
JeitEmgie

Citation:

Envoyé par newmar

c'est le hibernate3.jar ????????????? :roll:

le jar de toutes les versions 3 s'appelle hibernate3.jar…

cela ne dit pas si vous utilisez la 3.0, 3.1, 3.2, 3.2.4, etc.
31/03/2008, 18h27
newmar

Merci, j'ai résolu le problème en changeant les lib. Merci pour votre aiiiiiiiiiiiiiide :lol:
25/11/2008, 23h05
jovanovic

Hibernate _Oracle

tu peut me donner quel version de hibernate que tu as utilisé stppp.
je suis en galere avec hibernate - oracle .

Merci