Hello to everybody, I am following the book from IBM redbooks "Experience JEE
for Websphere" and I am making a project where I have created two JPA
Entities. Everything is set up correctly in my Eclipse IEE application, the
drivers, server connections and rest of things. I have created a JUnit
tester to test the JPA Entities. The problem is that when I execute the
tester, I get this error message:
[EL Info]: 2009-12-21 09:24:32.462--ServerSession(1655333546)--EclipseLink,
version: Eclipse Persistence Services - 1.1.2.v20090612-r4475
[EL Severe]: 2009-12-21 09:24:32.478--ServerSession(1655333546)--Local
Exception Stack:
Exception [EclipseLink-4021] (Eclipse Persistence Services -
1.1.2.v20090612-r4475): org.eclipse.persistence.exceptions.DatabaseException
Exception Description: Unable to acquire a connection from driver [null],
user [null] and URL [null]. Verify that you have set the expected driver
class and URL. Check your login, persistence.xml or sessions.xml resource.
The jdbc.driver property should be set to a class that is compatible with
your database platform
at
org.eclipse.persistence.exceptions.DatabaseException.unableToAcquireConnectionFromDriverException(DatabaseException.java:375)
(....)
My persistence.xml file is as follows:
<<?xml version="1.0" encoding="UTF-8"?>
<persistence version="1.0" xmlns="http://java.sun.com/xml/ns/persistence"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">
<persistence-unit name="VacationUnit">
<class>vacation.entities.Employee</class>
<properties>
<property name="openjpa.url"
value="jdbc:derby://localhost:1527/Vacation"
/>
<property name="openjpa.driver"
value="org.apache.derby.jdbc.ClientDriver" />
<property name="openjpa.user" value="vacation" />
property name="openjpa.password" value="vacation" />
<property name="openjpa.Log" value="SQL=TRACE" />
</properties>
</persistence-unit>
</persistence>
If I add the line
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
I get this error instead:
Exception [EclipseLink-7060] (Eclipse Persistence Services -
1.1.2.v20090612-r4475):
org.eclipse.persistence.exceptions.ValidationException
Exception Description: Cannot acquire data source [VacationPool].
If I change the openjpa provider to
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider> and I
make the calls with this provider, it works fine so it shows that the
drivers and the data pools work correctly.
I want to use openJPA but it seems like It doesn't want to work, Does
anybody know wich could be the problem?
Thanks!
--
View this message in context:
http://n2.nabble.com/OpenJPA-not-connecting-the-database-tp4197138p4197138.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.