Discussion :

[noooop]

Bonjour,

J'essaye d'utiliser OpenJPA avec TomEE (Tomcat) et une base MySQL 5.

Voici une partie de la stacktrace:

INFO: Starting OpenJPA 2.2.0
26 janv. 2013 17:42:39 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() for servlet [dispatcher] in context with path [/Exercice] threw exception [Request processing failed; nested exception is <openjpa-2.2.0-r422266:1244990 fatal user error> org.apache.openjpa.persistence.ArgumentException: A JDBC Driver or DataSource class name must be specified in the ConnectionDriverName property. Available properties in configuration are "org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl@fdaf18ee".] with root cause
<openjpa-2.2.0-r422266:1244990 fatal user error> org.apache.openjpa.persistence.ArgumentException: A JDBC Driver or DataSource class name must be specified in the ConnectionDriverName property. Available properties in configuration are "org.apache.openjpa.jdbc.conf.JDBCConfigurationImpl@fdaf18ee".
at org.apache.openjpa.jdbc.schema.DataSourceFactory.newDataSource(DataSourceFactory.java:72)

Et voici mon fichier persistence.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
19
<?xml version="1.0"  encoding="UTF-8"?>
<persistence  xmlns="http://java.sun.com/xml/ns/persistence" 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
version="1.0"  xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="databasedb">
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
<class>com.database.jpa.Agent</class>
<properties> 
<property name="openjpa.ConnectionURL" value="jdbc:mysql://localhost:3306/databaseDB"/>
<property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"/>
<property name="openjpa.ConnectionUserName" value="root"/>
<property name="openjpa.ConnectionPassword" value="ibm2database"/>
<property name="openjpa.ConnectionFactoryProperties" 
    value="PrettyPrint=true, PrettyPrintLineLength=80"/>
<property name="openjpa.Log" value="DefaultLevel=TRACE"/>   
</properties>
</persistence-unit>
</persistence>

Quelqu'un saurait-il m'indiquer d'où vient le problème ?

Merci d'avance pour votre aide.

[olivier.pitton]

Bonjour,

As-tu bien déployé le JAR de MySQL sur TomEE ? Puisque à priori tu utilises une application Web, as-tu mis le JAR dans WEB-INF/lib ?

[noooop]

Bonjour,

et d'abord merci pour ton aide.

Oui je viens de vérifier. il est bien dans /WEB-INF/lib.
L'url de la base MySQL est bien valide ainsi que user/password

Voici le contenu de la log opeJPA:

110 databasedb TRACE [localhost-startStop-1] openjpa.MetaData - Scanning directory "C:\database\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\Exercice" for persistent types.
130 databasedb TRACE [localhost-startStop-1] openjpa.MetaData - Skipping persistent type location association for location "file:/C:/database/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp1/wtpwebapps/Exercice/WEB-INF/classes/com/database/jpa/Agent.class" since it is a class, and will not need to be re-parsed later.
130 databasedb TRACE [localhost-startStop-1] openjpa.MetaData - Scan of "C:\database\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp1\wtpwebapps\Exercice" found persistent types [com.database.jpa.Agent].
130 databasedb TRACE [localhost-startStop-1] openjpa.MetaData - Scanning resource "META-INF/orm.xml" for persistent types.
130 databasedb TRACE [localhost-startStop-1] openjpa.MetaData - The persistent unit root url is "null"
130 databasedb TRACE [localhost-startStop-1] openjpa.MetaData - parsePersistentTypeNames() found [com.database.jpa.Agent].
130 databasedb TRACE [localhost-startStop-1] openjpa.MetaData - Found 1 classes with metadata in 40 milliseconds.