I Need some help configuring apache tomee
Fernando <[email protected]> Sat, 1 Jun 2024 19:13:37 -0300
| Newsgroups | gmane.comp.java.openejb.user |
|---|---|
| Message-ID | <CAMzbw58bvE1E_YC=vLCER2+XBS5mJn=ABirAmw_21vuSAh_20A@mail.gmail.com> |
Hi,
I am trying to migrate an small application from payara community 5 to
Apache Tomee Plume 8.
I am working with Java 8 and postgresql 14 on windows and I am getting this
error message when I try to launch the application:
*javax.ejb.EJBException: The bean encountered a non-application exception;
nested exception is: javax.persistence.PersistenceException: Exception
[EclipseLink-4002] (Eclipse Persistence Services -
2.7.13.v20230724-7ffb888abf):
org.eclipse.persistence.exceptions.DatabaseExceptionInternal Exception:
java.sql.SQLSyntaxErrorException: usuario no tiene privilegios suficientes
o objeto no encontrado: CUENTAS in statement [SELECT ID, NOMBRE, TIPO FROM
cuentas ORDER BY NOMBRE]*
I am understand that said that the user have not enough privilege, but I the
user and password are correct!
In file context.xml under the META-INF of my project I set this:
*<Context path="/GastosJSP"> <Resource auth="Container"
driverClassName="org.postgresql.Driver" maxIdle="10"
maxTotal="20" maxWaitMillis="-1" name="jdbc/gastos"
password="unacontrasena" type="javax.sql.DataSource"
url="jdbc:postgresql://localhost:5432/GastosJ"
username="operador"/></Context>*
and in persistence.xml I have this configuration:
*<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence
<http://xmlns.jcp.org/xml/ns/persistence>"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance
<http://www.w3.org/2001/XMLSchema-instance>"
xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
<http://xmlns.jcp.org/xml/ns/persistence>
http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd
<http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd>">
<persistence-unit name="GastosPU" transaction-type="JTA">
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<jta-data-source>jdbc/gastos</jta-data-source>
</persistence-unit></persistence>*
Finally in Dao Class, where I have the error showed up, I have:
*@Statelesspublic class CuentaDaoImp implements CuentaDao {
@PersistenceContext(unitName = "GastosPU") private EntityManager em;*
Maybe I am not understanding something.... i am a little lost.....someone
could give me a hand?
Thanks in advance!
Fernando